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

[Tatsuo Ishii]

Still I suspect the bug is only with 3.7.2.  Recently we releasd a
fixed version of 3.7.2 RPM (actually we just reverted a commit which
caused the bug). If you like, you could try the RPM.

Or you install from the source code, you could patch 3.7.2 with this commit:
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04

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

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