Hi, From: Adrian Moisey <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
