[pgpool-general: 5968] Re: wrong arguments for online recovery script
Benjamin Firl
bf at wisit.com
Fri Mar 2 17:33:35 JST 2018
We have seen problems with online recovery in pgpool-II version 3.6.7
(subaruboshi). But we updated to 3.7.2 before we ware able to reproduce
and analyze it. So I suspect the same thing happened in 3.6.7, but I am
not 100% sure.
Adding a new lowest node id is a relatively rare case in our setup.
Kind regards
Benjamin Firl
On 03/02/2018 12:16 AM, Tatsuo Ishii wrote:
> 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
--
+++++++++++++++++++++++++++++++++++++++++++++++++
+++ 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