From: Lazaro Garcia <lazaro3487@gmail.com>
To: 'Tatsuo Ishii' <ishii@sraoss.co.jp>
Cc: pgpool-general@pgpool.net
Cc: pgsql-admin@postgresql.org
Subject: Re: [pgpool-general: 5345] Failover but master is running
Date: Fri, 24 Feb 2017 09:12:57 -0500
Message-ID: <000a01d28ea8$1c371eb0$54a55c10$@gmail.com> (raw)
In-Reply-To: <20170224.071422.3019405485733787.t-ishii@sraoss.co.jp>
References: <001a01d28e18$fbf76720$f3e63560$@gmail.com>
<20170224.071422.3019405485733787.t-ishii@sraoss.co.jp>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Thank you very much for the answer.
Regards.
-----Mensaje original-----
De: Tatsuo Ishii [mailto:ishii@sraoss.co.jp]
Enviado el: jueves, 23 de febrero de 2017 05:14 p. m.
Para: lazaro3487@gmail.com
CC: pgpool-general@pgpool.net; pgsql-admin@postgresql.org
Asunto: Re: [pgpool-general: 5345] Failover but master is running
Yes, it seems process 5479 hit the max_connections of PostgreSQL while
connecting to it.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp> Hello everyone in the list, testing pgpool a failover is triggered but
> the master is running. The pgpool version is 3.5.5. This is the log
> reported by pgpool.
>
>
>
> Could anybody help me to clarify this error?
>
>
>
> The reason could be postgresql server has reached max_connections?
>
>
>
> Regards.
>
> 2017-02-23 14:18:58: pid 5303: ERROR: unable to read data
>
> 2017-02-23 14:18:58: pid 5303: DETAIL: child connection forced to
> terminate due to client_idle_limit:300 is reached
>
> 2017-02-23 14:25:31: pid 5479: LOG: pool_read_kind: error message
> from 1 th backend:sorry, too many clients already
>
> 2017-02-23 14:25:31: pid 5479: ERROR: unable to read message kind
>
> 2017-02-23 14:25:31: pid 5479: DETAIL: kind does not match between
> master(52) slot[1] (45)
>
> 2017-02-23 14:25:36: pid 5287: ERROR: failed to authenticate
>
> 2017-02-23 14:25:36: pid 5287: DETAIL: invalid authentication message
> response type, Expecting 'R' and received 'E'
>
> 2017-02-23 14:25:41: pid 55651: ERROR: failed to authenticate
>
> 2017-02-23 14:25:41: pid 55651: DETAIL: invalid authentication
> message response type, Expecting 'R' and received 'E'
>
> 2017-02-23 14:25:41: pid 55651: ERROR: failed to authenticate
>
> 2017-02-23 14:25:41: pid 55651: DETAIL: invalid authentication
> message response type, Expecting 'R' and received 'E'
>
> 2017-02-23 14:25:41: pid 55651: LOG: setting backend node 1 status to
> NODE DOWN
>
> 2017-02-23 14:25:41: pid 55651: LOG: received degenerate backend
> request for node_id: 1 from pid [55651]
>
> 2017-02-23 14:25:41: pid 55651: LOG: starting degeneration. shutdown
> host
> 192.168.5.19(5432)
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lazaro3487@gmail.com, ishii@sraoss.co.jp, pgpool-general@pgpool.net
Subject: Re: [pgpool-general: 5345] Failover but master is running
In-Reply-To: <000a01d28ea8$1c371eb0$54a55c10$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox