[pgpool-hackers: 1743] Re: [pgpool-II 0000227]: failover not performed by stanby node
Tatsuo Ishii
ishii at postgresql.org
Tue Aug 2 10:30:06 JST 2016
Usama,
Can you please take care of this.
This is a watchdog issue.
Peng,
Please add this to the Pgpool-II development wiki.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From: pgpool Bug Tracker <bugtracker at pgpool.net>
Subject: [pgpool-II 0000227]: failover not performed by stanby node
Date: Sat, 30 Jul 2016 09:19:10 +0900
Message-ID: <4c533aa24439373c6c87c210ff0739b0 at www.pgpool.net>
>
> The following issue has been SUBMITTED.
> ======================================================================
> http://www.pgpool.net/mantisbt/view.php?id=227
> ======================================================================
> Reported By: supp_k
> Assigned To:
> ======================================================================
> Project: pgpool-II
> Issue ID: 227
> Category: Bug
> Reproducibility: random
> Severity: major
> Priority: immediate
> Status: new
> ======================================================================
> Date Submitted: 2016-07-30 09:19 JST
> Last Modified: 2016-07-30 09:19 JST
> ======================================================================
> Summary: failover not performed by stanby node
> Description:
> In my production environment the following case not always leads to failover
> procedure.
>
> I have 2 pgpool nodes and watchdog cluster. Every pgpool node server also has
> PostgreSQL instance running. Sometimes we are facing network troubles and the
> server where the master pgpool and master postgresql are hosted becomes
> unavailable. In this case standby pgpool node switching into Master and it is
> ok. But the problem here is that it doesnt trigger failover command. I see the
> pgpool standby is promoted into master but it doesnt trigger his failover
> command.
>
> Why? The case is reproduced randomly.
>
> Steps to Reproduce:
> Setup environment (2 server):
> 1) pgpool + postgres
> 2) pgpool + postgres
>
> Make the pgpool in the server 1 master and the postgres master as well. Postgres
> should perform sync replication onto 2nd server;
>
> Unplug network cable at 1st server.
>
> Result: 2nd pgpool switched into Master but it doesn't trigger failover
> procedure which in my scenario should promote 2nd postgres into master.
>
> Please consider the issue, to me it very critical.
>
> Additional Information:
> Configuration of the 1st pgpool server is attached. 2nd's server configuration
> is identical.
> ======================================================================
>
> Issue History
> Date Modified Username Field Change
> ======================================================================
> 2016-07-30 09:19 supp_k New Issue
> 2016-07-30 09:19 supp_k File Added: pgpool.conf
> ======================================================================
>
More information about the pgpool-hackers
mailing list