<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 28, 2015 at 7:22 AM, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi Usama,<br>
<br>
I have add a description about the problem into the documents of<br>
3.2, 3.3. and 3.4.<br>
<br>
<a href="http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=68cbdd88477f8294cab0324d627f8cff213df958" rel="noreferrer" target="_blank">http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=68cbdd88477f8294cab0324d627f8cff213df958</a><br>
<br>
Do you know whether this problem occurs in watchdog of 3.5? If so,<br>
I'll commit the same to master.<br></blockquote><div><br></div><div>The new watchdog takes care of this situation when multiple pgpool-II nodes are started simultaneously, So I think we are good and do not need to commit this message in the master branch</div><div><br></div><div>Thanks</div><div>Best regards</div><div>Muhammad Usama</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
Begin forwarded message:<br>
<br>
Date: Fri, 25 Dec 2015 13:13:43 +0900<br>
From: pgpool Bug Tracker <<a href="mailto:bugtracker@pgpool.net">bugtracker@pgpool.net</a>><br>
To: <a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a><br>
Subject: [pgpool-II 0000162]: To start watchdog pgpool nodes simultaneously is not safe<br>
<br>
<br>
<br>
The following issue has been ASSIGNED.<br>
======================================================================<br>
<a href="http://www.pgpool.net/mantisbt/view.php?id=162" rel="noreferrer" target="_blank">http://www.pgpool.net/mantisbt/view.php?id=162</a><br>
======================================================================<br>
Reported By: harukat<br>
Assigned To: nagata<br>
======================================================================<br>
Project: pgpool-II<br>
Issue ID: 162<br>
Category: Bug<br>
Reproducibility: always<br>
Severity: minor<br>
Priority: normal<br>
Status: assigned<br>
======================================================================<br>
Date Submitted: 2015-12-20 20:28 JST<br>
Last Modified: 2015-12-25 13:13 JST<br>
======================================================================<br>
Summary: To start watchdog pgpool nodes simultaneously is not<br>
safe<br>
Description:<br>
To start watchdog pgpool nodes simultaneously is not safe.<br>
There is the case that the following happens.<br>
<br>
- "FATAL: failed to initialize watchdog, delegate_IP "x.x.x.x" already exists"<br>
- Master nodes more than two are born<br>
- The recognitions of the invalid node are not consistent.<br>
<br>
There are not robust initial coordination logic.<br>
So I think that we describe clearly "must start it one by one" to the manual.<br>
<br>
<br>
Steps to Reproduce:<br>
Tested version: pgpool2-V3_4_STABLE-3d2093e (snapshot@2015-12-20) + patch<br>
<br>
The patch file improves 'DETAIL: connect() reports failure "Success"',<br>
but it isn't related to this main issue.<br>
<br>
I set up the following watchdog cluster and started 4 pgpools simultaneously.<br>
(pg1, pg2 ... are hostname in my test environment)<br>
<br>
[pg1 (pgpool)] ---------+- [pg3 (PostgreSQL)]<br>
[pg2 (pgpool)] ---------+<br>
[pgpool1 (pgpool)] -----+<br>
[pgpool2 (pgpool)] -----+<br>
<br>
======================================================================<br>
<br>
Issue History<br>
Date Modified Username Field Change<br>
======================================================================<br>
2015-12-20 20:28 harukat New Issue<br>
2015-12-20 20:28 harukat File Added: pgpool_conf_and_patch.zip<br>
<br>
2015-12-25 13:13 t-ishii Assigned To => nagata<br>
2015-12-25 13:13 t-ishii Status new => assigned<br>
2015-12-25 13:13 t-ishii Description Updated<br>
2015-12-25 13:13 t-ishii Steps to Reproduce Updated<br>
======================================================================<br>
<span class=""><font color="#888888"><br>
<br>
<br>
--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
</font></span></blockquote></div><br></div></div>