[pgpool-general: 4886] Re: Online recovery: existing connections did not close in 90 sec.

Tatsuo Ishii ishii at sraoss.co.jp
Tue Aug 9 11:53:51 JST 2016


> *> What version of pgpool-II is this?*
> *>*
> 
> It's 3.3.6

Sorry for late reply. I couldn't reproduce the problem by using 3.3.11
(it's the latest release of 3.3 series). If you still have the same
problem with 3.3.11, please let me know.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> El 24/03/2016 00:54, "Tatsuo Ishii" <ishii at postgresql.org> escribió:
> 
>> What version of pgpool-II is this?
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Hello!
>> >
>> > I was doing online recovery with 2 PSQL nodes and Pgpool configured with
>> > "replication_mode = on".
>> >
>> > Every test I made recovering one PSQL node was succesful, but now I tried
>> > to recover a bigger database (20 GB).
>> >
>> > 1st stage was made OK:
>> >
>> >    - Put active psql node with WAL archiving.
>> >    - Send pg_start_backup
>> >    - Compress all PGDATA
>> >    - Send pg_stop_backup
>> >    - Remove WAL archiving
>> >    - Transfer tar.gz to failed node (3 GB size)
>> >
>> > pid 12936: 1st stage is done
>> > pid 12936: starting 2nd stage
>> >
>> >    - Now pgpool closes connections without waiting to finish queries (I
>> >    configured that way).
>> >
>> > pid 12728: pool_process_query: child connection forced to terminate due
>> to
>> > client_idle_limitis -1
>> > ...
>> > ...
>> > pid 12817: pool_process_query: child connection forced to terminate due
>> to
>> > client_idle_limitis -1
>> >
>> > And then:
>> >
>> > ERROR: pid 12936: wait_connection_closed: existing connections did not
>> > close in 90 sec.
>> > ERROR: pid 12936: start_recovery: timeover for waiting connection closed
>> >
>> >
>> > Why pgpool couldn't close a PSQL connection ?
>> >
>> >
>> > Thanks.
>>


More information about the pgpool-general mailing list