[pgpool-general: 5963] wrong arguments for online recovery script

Benjamin Firl bf at wisit.com
Thu Mar 1 22:57:52 JST 2018


Hallo,


our script for online recovery stage1 seems to get wrong arguments
sometimes and thus is failing.

We log the arguments, so on a successful run it prints something like
that on the master node:

recovery_1st_stage.sh
all args: /var/lib/postgresql/9.5/main 10.0.1.25
/var/lib/postgresql/9.5/main 5432
data: /var/lib/postgresql/9.5/main
recovery target: 10.0.1.25
recovery data: /var/lib/postgresql/9.5/main


If recovery fails, we get this:

recovery_1st_stage.sh
all args: /var/lib/postgresql/9.5/main localhost 5432
data: /var/lib/postgresql/9.5/main
recovery target: localhost
recovery data: 5432
unable to recover myself....exiting
2018-03-01 14:31:59 CET [10517-1] postgres at template1 ERROR: 
pgpool_recovery failed
2018-03-01 14:31:59 CET [10517-2] postgres at template1 STATEMENT:  SELECT
pgpool_recovery('recovery_1st_stage.sh', 'localhost', '', '5432')


This seems to happen, if the new node has a lower id than the master
node. But normally adding a new node with lower id should not be a
problem, am I correct? 
We are using PostgreSQL 9.5.10 and pgpool-II version 3.7.2 (amefuriboshi).
Thanks for your help.


Kind regards
Benjamin Firl




-- 
+++++++++++++++++++++++++++++++++++++++++++++++++

+++ Jetzt neu Wissensmanagement für Netzwerke +++

+++             www.knodge.de                 +++

+++++++++++++++++++++++++++++++++++++++++++++++++

 

--

www.wisit.com

www.knodge.de

 

 

wisit media GmbH

Ehrenbergstr. 11

D-98693 Ilmenau

---------------------------------------------------------------------------

-

wisit media GmbH, Ehrenbergstr. 11, D-98693 Ilmenau

Registergericht Jena HRB 512472

Geschaeftsfuehrung: Dipl. Ing. Markus Duelli

 

 

Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich

erhalten haben, informieren Sie bitte sofort den Absender und vernichten

Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe

dieser E-Mail ist nicht gestattet. 



More information about the pgpool-general mailing list