[pgpool-general: 2696] existing connections did not close in 0 sec

Sean Hogan sean at compusult.net
Thu Apr 3 20:13:33 JST 2014


Can someone tell me what the following logging means?

2014-04-02 17:05:05 LOG:   pid 9415: 1st stage is done
2014-04-02 17:05:05 LOG:   pid 9415: starting 2nd stage
2014-04-02 17:05:05 LOG:   pid 12418: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12418: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12154: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12154: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12813: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12813: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
*2014-04-02 17:05:05 ERROR: pid 9415: wait_connection_closed: existing 
connections did not close in 0 sec.**
**2014-04-02 17:05:05 ERROR: pid 9415: start_recovery: timeover for 
waiting connection closed*
2014-04-02 17:05:05 LOG:   pid 9662: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
2014-04-02 17:05:05 LOG:   pid 12641: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1
...
2014-04-02 17:05:05 LOG:   pid 17997: pool_process_query: child 
connection forced to terminate due to client_idle_limitis -1

I don't see any parameter set to 0 that would control how long pgpool 
waits for existing connections to be closed.  Here are the Online 
Recovery parameters from pgpool.conf:

recovery_user = 'postgres'
                                    # Online recovery user
recovery_password = ''
                                    # Online recovery password
recovery_1st_stage_command = 'do-base-backup.sh'
                                    # Executes a command in first stage
recovery_2nd_stage_command = 'pgpool_recovery_pitr.sh'
                                    # Executes a command in second stage
recovery_timeout = 120
                                    # Timeout in seconds to wait for the
                                    # recovering node's postmaster to 
start up
                                    # 0 means no wait
client_idle_limit_in_recovery = -1
                                    # Client is disconnected after being 
idle
                                    # for that many seconds in the 
second stage
                                    # of online recovery
                                    # 0 means no disconnection
                                    # -1 means immediate disconnection

Thanks,
Sean
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140403/e42ec809/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140403/e42ec809/attachment.vcf>


More information about the pgpool-general mailing list