[pgpool-general: 4567] Re: find_primary_node failed ...

[Tatsuo Ishii]

PDF log file is hard to invest. I will convert it into plain text and
look into the problem when I have time. Currently I'm busy with
customer issues.

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

> Hi,
> This scenario had reproduce....again..
> it seams that the "search_primary_node_timeout = 0" doesn't works as
> expected.. pgpool doesn't find the primary .
> 
> 
> Please advice....
> thanks,
> cohavisi
> 
> On Tue, Mar 22, 2016 at 12:49 PM, Shay Cohavi <cohavisi at gmail.com> wrote:
> 
>> Hi,
>> Thanks .... reattach as PDF
>>
>> On Tue, Mar 22, 2016 at 12:43 PM, Tatsuo Ishii <ishii at postgresql.org>
>> wrote:
>>
>>> Can you please do not post in rtf format files? I cannot read them.
>>>
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>>
>>> > Hi,
>>> >
>>> > *(pgpool 3.4.2 and postgresql 9.3.5)*
>>> >
>>> > During stress tests on my setup, PGpool has failed to find_primary node
>>> > after a failover!
>>> > the primary node has started but pgpool keep searched for it.
>>> > (pgpool has be restarted in order find the primary)
>>> >
>>> > can you please review the log (2016-03-22 03:03:XX) and advise why the
>>> > primary node has been been detected??
>>> >
>>> > scenario:
>>> >
>>> > 1. killing the primary node.
>>> > 2. pgpool performed a failover.
>>> > 3. pgpool performs "follow master command".
>>> >
>>> >
>>> > Thanks,
>>> > cohavisi
>>>
>>
>>