[Pgpool-general] Stale idle connections on pgpool after query failure

[Nimesh Satam]

Hi,

We are currently using pgpool-3.0.1 and postgres 9.01. One of the java
application used by us is facing problem with stale idle connection on
pgpool. When we looked into this further we noticed that after the query
fails the pgpool child process stays in a idle state and does not free up
the connection.

If this same scenario is tried bypassing pgpool the connection is closed
properly and we dont see any stale connections. Can anybody let us know what
might be wrong here. Let us know what all information is required here.

Following are the pgpool logs:

2011-02-08 06:35:02 DEBUG: pid 21228: Parse: waiting for master completing
the query
2011-02-08 06:35:02 DEBUG: pid 21228: wait_for_query_response: waiting for
backend 0 completing the query
2011-02-08 06:35:02 LOG:   pid 21228: pool_send_and_wait: Error or notice
message from backend: : DB node id: 0 backend pid: 25137 statement:
message: missing FROM-clause entry for table "test"
2011-02-08 06:35:02 DEBUG: pid 21228: detect_error: kind: E
2011-02-08 06:35:02 LOG:   pid 21228: Parse: Error or notice message from
backend: : DB node id: 0 backend pid: 25137 statement: [FAILED QUERY]
message: missing FROM-clause entry for table "test"
2011-02-08 06:35:02 DEBUG: pid 21228: read_kind_from_backend: read kind from
0 th backend E NUM_BACKENDS: 2
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessBackendResponse: kind from
backend: E
2011-02-08 06:35:02 DEBUG: pid 21228: pool_unset_query_in_progress: done
2011-02-08 06:35:02 DEBUG: pid 21228: pool_set_ignore_till_sync: done
2011-02-08 06:35:02 DEBUG: pid 21228: pool_unset_query_in_progress: done
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessFrontendResponse: kind from
frontend B(42)
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessFrontendResponse: kind from
frontend D(44)
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessFrontendResponse: kind from
frontend E(45)
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessFrontendResponse: kind from
frontend S(53)
2011-02-08 06:35:02 DEBUG: pid 21228:
pool_unset_doing_extended_query_message: done
2011-02-08 06:35:02 DEBUG: pid 21228: pool_set_doing_extended_query_message:
done
2011-02-08 06:35:02 DEBUG: pid 21228: pool_unset_ignore_till_sync: done
2011-02-08 06:35:02 DEBUG: pid 21228: pool_set_query_in_progress: done
2011-02-08 06:35:02 DEBUG: pid 21228: read_kind_from_backend: read kind from
0 th backend Z NUM_BACKENDS: 2
2011-02-08 06:35:02 DEBUG: pid 21228: ProcessBackendResponse: kind from
backend: Z
2011-02-08 06:35:02 DEBUG: pid 21228: pool_read_message_length: slot: 0
length: 5

Regards,
Nimesh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110209/4ccbd608/attachment.html>