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

[Shay Cohavi]

Thanks for your replay...
I'll check it..

Thanks,
ShayC

On Wednesday, March 30, 2016, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > *(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".
>
> find_primary_node() first connects to the primary node (host0)'s
> postgres database as user = sr_check_user and password =
> sr_check_password. Can you make sure that psql can connect to the
> host0's postgres database with the user and password?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160330/d5a948cd/attachment.html>