From: Lazaro Garcia <lazaro3487@gmail.com>
To: pgpool-general@pgpool.net
To: pgsql-admin@postgresql.org
Subject: Failover but master is running
Date: Thu, 23 Feb 2017 16:08:20 -0500
Message-ID: <001a01d28e18$fbf76720$f3e63560$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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)
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, pgpool-general@pgpool.net
Subject: Re: Failover but master is running
In-Reply-To: <001a01d28e18$fbf76720$f3e63560$@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