Hi Ukasz I had the same issue while recovering the second node. (This happened only when there were some parallel database activities going)
Node 1 & Node 2 Test 1 - a) Node 2 is down, b) I was executing an update statement on a 40000 rows of data using pgpool (which is only updating node 1) (in progress) c) executed pcp_recovery_node command to recover Node 2. d) Update finished successfully and both the nodes has the same data. --Left saw that one moment the update stopped and both nodes came back and the pgpool restarted. Test2 - Test 1 - a) Node 2 is down, b) I was executing an update statement on a 40000 rows of data using pgpool (which is only updating node 1) (in progress) c) executed pcp_recovery_node command to recover Node 2. (in progress) d) logged into db using pgpool port 9999 - psql -p 9999 (performed an update manually on a separate table) (did repeatedly) e) step b - the update stopped, f) i exited from step d g) pcp_recovery_node said the statements (Node 2 could not start) I only tested recovery in 2.2 so i dont know if it worked in 2.1. let me know if we any solution for this. Thanks Deepak On Fri, Mar 20, 2009 at 5:00 AM, <[email protected]>wrote: > Send Pgpool-general mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://pgfoundry.org/mailman/listinfo/pgpool-general > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Pgpool-general digest..." > > > Today's Topics: > > 1. Recovery problem in pgpool-II 2.2 (?ukasz Jagie??o) > 2. Re: Recovery problem in pgpool-II 2.2 (Jaume Sabater) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 19 Mar 2009 21:17:19 +0100 > From: ?ukasz Jagie??o <[email protected]> > Subject: [Pgpool-general] Recovery problem in pgpool-II 2.2 > To: Pgpool-general <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > 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 > > > ------------------------------ > > Message: 2 > Date: Fri, 20 Mar 2009 12:33:23 +0100 > From: Jaume Sabater <[email protected]> > Subject: Re: [Pgpool-general] Recovery problem in pgpool-II 2.2 > To: ?ukasz Jagie??o <[email protected]> > Cc: Pgpool-general <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > 2009/3/19 ?ukasz Jagie??o <[email protected]>: > > > "SELECT pgpool_recovery('pgpool_recovery', '10.A.67.239', > > '/var/lib/pgsql/data')" > > I don't suppose this "A" in the IP address is a typo, is it? > > -- > Jaume Sabater > http://linuxsilo.net/ > > "Ubi sapientas ibi libertas" > > > ------------------------------ > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > End of Pgpool-general Digest, Vol 52, Issue 26 > ********************************************** >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
