[pgpool-general: 4667] Re: ERROR: unable to read data from frontend

Yugo Nagata nagata at sraoss.co.jp
Mon May 9 12:22:49 JST 2016


On Thu, 5 May 2016 13:17:05 +0000
Wolf Schwurack <wolf at uen.org> wrote:

> We been getting this error "ERROR: unable to read data from frontend" I did a search on the error it shows that it was bug in version 3.4.0 but that it's been fixed.
> 
> We are on version pgpool II version 3.4.4 Should the fix be in this version? When the error happens we are getting TIME_WAIT on the application server. We had up to 170 TIME_WAIT's in a minute's time.
> 
> We have two pgpool servers and two PostgreSQL servers running streaming replication
> 
> Servers: Ubuntu 14.04.4
> PostgreSQL: 9.5.2
> Pgpool: 3.4.4

Do you use extended protocol (JDBC) or simple protocol? 
And, do you use in-memory query cache?

If possible, could you please provide pgpool log file.

> 
> 
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf at uen.org
> 
> 
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>


More information about the pgpool-general mailing list