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.
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
