[Pgpool-general] Recovery problem in pgpool-II 2.2

[Łukasz Jagiełło]

Hi,

Got problem with on-line recovery mode at pgpool-II 2.2. Same config,
same db nodes at 2.1 works normal.

Simple start recovery process, with pcp_recovery node:

pgpool.log:
2009-03-18 22:51:37 LOG:   pid 12705: starting recovering node 1
2009-03-18 22:51:38 LOG:   pid 12705: CHECKPOINT in the 1st stage done
2009-03-18 22:51:38 LOG:   pid 12705: starting recovery command:
"SELECT pgpool_recovery('pgpool_recovery', '10.A.67.239',
'/var/lib/pgsql/data')"
2009-03-18 23:35:51 LOG:   pid 12705: 1st stage is done
2009-03-18 23:35:51 LOG:   pid 12705: starting 2nd stage
2009-03-18 23:35:54 LOG:   pid 12705: all connections from clients
have been closed
2009-03-18 23:35:55 LOG:   pid 12705: CHECKPOINT in the 2nd stage done
2009-03-18 23:35:55 LOG:   pid 12705: starting recovery command:
"SELECT pgpool_recovery('pgpool_recovery', '10.A.67.239',
'/var/lib/pgsql/data')"
2009-03-18 23:36:55 LOG:   pid 12705: 1 node restarted
2009-03-18 23:36:55 LOG:   pid 12705: send_failback_request: fail back
1 th node request from pid 12705
2009-03-18 23:36:55 LOG:   pid 12687: starting fail back. reconnect
host 10.A.67.239(5432)
2009-03-18 23:36:55 LOG:   pid 12687: failover_handler: set new master node: 0
2009-03-18 23:36:55 LOG:   pid 12687: failback done. reconnect host
10.A.67.239(5432)
2009-03-18 23:36:55 LOG:   pid 12705: recovery done
2009-03-18 23:36:55 ERROR: pid 12705: pcp_child: pcp_read() failed.
reason: Success
2009-03-18 23:36:55 ERROR: pid 22567: pcp_child: pcp_read() failed.
reason: Success
2009-03-18 23:36:55 ERROR: pid 22568: pcp_child: pcp_read() failed.
reason: Success

Everything was fine, recovery mode finish with success reconnect host.
At recovery node notice start postgresql, connections start working
but suddenly after that pgpool stop accept new connections. Solution
was stop all pgpool process and start it again. Any changes happened
with on-line recovery since 2.1 witch could do this ?

Not really sure is adding pgpool.conf here help since it was working
in 2.1. But if it's need I will send it.

Regards
-- 
Łukasz Jagiełło
System Administrator
G-Forces Web Management Polska sp. z o.o. (www.gforces.pl)

Ul. Kruczkowskiego 12, 80-288 Gdańsk
Spółka wpisana do KRS pod nr 246596 decyzją Sądu Rejonowego Gdańsk-Północ