[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