[pgpool-general: 5841] node recovery failed, waiting connection closed in the other pgpools timeout?

Sebastian Benoit benoit-lists at fb12.de
Wed Dec 20 14:41:32 JST 2017


(sorry, now with subject)

Hi,

i'm running pgpool 3.6.6, in replication mode and with
client_idle_limit_in_recovery = -1

During recovery, stage one finishes, then all connections
are terminated 

Dec 20 04:30:54 lb1 [72677]: [448129-1] 2017-12-20 04:30:54: pid 72677: LOG:
node recovery, 1s
t stage is done
Dec 20 04:30:54 lb1 [72677]: [448130-1] 2017-12-20 04:30:54: pid 72677: LOG:
node recovery, starting 2nd stage
Dec 20 04:30:54 lb1 [39894]: [463316-1] 2017-12-20 04:30:54: pid 39894:
ERROR:  connection terminated due to online recovery
[...]
Dec 20 04:30:55 lb1 [35035]: [462034-2] 2017-12-20 04:30:55: pid 35035:
DETAIL:  child connection forced to terminate due to client_idle_limitis:-1
Dec 20 04:34:16 lb1 [72677]: [448131-1] 2017-12-20 04:34:16: pid 72677: LOG:
wait_connection_closed: existing connections did not close in 200 sec.
Dec 20 04:34:16 lb1 [72677]: [448132-1] 2017-12-20 04:34:16: pid 72677:
ERROR:  node recovery failed, waiting connection closed in the other pgpools
timeout

But then recovery stops because aparently wait_connection_closed() never
gets to return 0:
                if (Req_info->conn_counter == 0)
                        return 0;

Any ideas how i can debug this?

/Benno


More information about the pgpool-general mailing list