[Pgpool-general] disconnects
Adrian Moisey
adrian at careerjunction.co.za
Thu Jan 3 08:07:02 UTC 2008
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
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 8117:
do_child: exits with status 1 due to error
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8951:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8951:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 8951:
do_child: exits with status 1 due to error
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8559:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8559:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 8559:
do_child: exits with status 1 due to error
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8558:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8558:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 8558:
do_child: exits with status 1 due to error
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8982:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8982:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 8982:
do_child: exits with status 1 due to error
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 9378:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 9378:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 LOG: pid 9378:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 6453:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 6453:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 6453:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8545:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8545:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8545:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8984:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8984:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8984:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8534:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8534:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8534:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8955:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8955:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8955:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8959:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8959:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8959:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 7720:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 7720:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 7720:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 7719:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 7719:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 7719:
do_child: exits with status 1 due to error
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8532:
pool_read: read failed (Connection reset by peer)
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 ERROR: pid 8532:
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
Jan 3 08:00:32 ips01 pgpool: 2008-01-03 08:00:32 LOG: pid 8532:
do_child: exits with status 1 due to error
postgres logs:
2008-01-03 08:00:29 SAST [17053]: [196.34.89.196] LOG: could not
receive data from client: Connection reset by peer
2008-01-03 08:00:29 SAST [17407]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17044]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17053]: [196.34.89.196] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17413]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17412]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17415]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:29 SAST [17408]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [16997]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17405]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17393]: [196.34.89.195] LOG: could not
receive data from client: Connection reset by peer
2008-01-03 08:00:32 SAST [17393]: [196.34.89.195] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17039]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17037]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17420]: [196.34.89.195] LOG: could not
receive data from client: Connection reset by peer
2008-01-03 08:00:32 SAST [17420]: [196.34.89.195] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17046]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17404]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17785]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17394]: [196.34.89.201] LOG: unexpected EOF
on client connection
2008-01-03 08:00:32 SAST [17020]: [196.34.89.201] LOG: unexpected EOF
on client connection
--
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
More information about the Pgpool-general
mailing list