[pgpool-general: 1513] reset_query_list DISCARD ALL queries getting stuck

Gavin Harcourt gh at tucasi.com
Wed Mar 20 00:31:19 JST 2013


I've been trying to find any mention of this particular problem but it
doesn't seem to have popped up before so I was hoping someone on this list
might be able to help shed some light on it.

I'm running pg-pool 3.2.3 with Postgresql 9.2.3 in load balancing and
connection pooling modes to 2 servers (using the postgres hot standby
replication between them). I've got the requests being load balanced
correctly with read only requests going to the standby server and write
requests going to the primary server. Whenever a connection is closed to
pgpool the DISCARD ALL command issued by pg_pool (as defined in
reset_query_list in the pgpool.conf) is getting stuck and never completing.
I can see no errors in the log files  for either Postgresql server and no
resource usage on the servers. If I submit the command myself it completes
immediately as you'd expect.

This is causing a problem as the sessions to the database never complete
meaning that I can never reuse that connection or perform a DROP DATABASE
command. Does anyone have any suggestions on where to even start looking
with this?

Gavin Harcourt

More information about the pgpool-general mailing list