[Pgpool-general] Pgpool-general Digest, Vol 52, Issue 26

[DM]

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, <pgpool-general-request at pgfoundry.org>wrote:

> Send Pgpool-general mailing list submissions to
>        pgpool-general at pgfoundry.org
>
> 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
>        pgpool-general-request at pgfoundry.org
>
> You can reach the person managing the list at
>        pgpool-general-owner at pgfoundry.org
>
> 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 <lukasz.jagiello at gforces.pl>
> Subject: [Pgpool-general] Recovery problem in pgpool-II 2.2
> To: Pgpool-general <pgpool-general at pgfoundry.org>
> Message-ID:
>        <de899fb00903191317w297c422j50803afb217524b1 at mail.gmail.com>
> 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 <jsabater at gmail.com>
> Subject: Re: [Pgpool-general] Recovery problem in pgpool-II 2.2
> To: ?ukasz Jagie??o <lukasz.jagiello at gforces.pl>
> Cc: Pgpool-general <pgpool-general at pgfoundry.org>
> Message-ID:
>        <3786f7bb0903200433k280d2c3fj5af8601f2459ba36 at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> 2009/3/19 ?ukasz Jagie??o <lukasz.jagiello at gforces.pl>:
>
> > "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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>
> End of Pgpool-general Digest, Vol 52, Issue 26
> **********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090322/7ef99ec2/attachment.html