[Pgpool-general] disconnects

[Yoshiyuki Asaba]

Hi,

From: Adrian Moisey <adrian at careerjunction.co.za>
Subject: [Pgpool-general] disconnects
Date: Thu, 03 Jan 2008 10:07:02 +0200

> We have a single postgres server that was under load.  To try help with 
> the load I stuck pgpool in front of postgres (using connection caching)
> 
> But every few hours everything seems to go pear shaped.  pgpool seems to 
> get "Connection reset by peer" and postgres gets some errors and kills 
> all its sessions then starts again.
> 
> Here are the logs:
> 
> Jan  3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8117: 
> pool_read: read failed (Connection reset by peer)
> Jan  3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8117: 
> ProcessFrontendResponse: failed to read kind from frontend. fronend 
> abnormally exited

It seems that a client program call exit() before doing PQfinish().
Do you use persistent connection (pconnect() in PHP)?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp