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

[Shay Cohavi]

Thanks....

On Wed, Mar 23, 2016 at 5:55 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> 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
> >>>
> >>
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160323/94b1d4cc/attachment.html>