[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.pgpool.net/pipermail/pgpool-general/attachments/20140403/e42ec809/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140403/e42ec809/attachment.vcf>
More information about the pgpool-general
mailing list