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

[Benjamin Firl]

Hi,


is there any news on this topic? Any information that I can provide to help?
Thanks again for your help.


Kind regards
Benjamin Firl





On 03/02/2018 09:33 AM, Benjamin Firl wrote:
> 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.