[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