[Pgpool-general] disconnects

[Adrian Moisey]

Hi

>> 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)?

We're using IIS with a postgres ODBC driver :/

-- 
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian at careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842