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

Tatsuo Ishii ishii at sraoss.co.jp
Fri Mar 2 08:16:53 JST 2018


I suspect it's a bug with 3.7.2. Have you seen similar issue with
other Pgpool-II versions?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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. 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list