Failover but master is running

From: "Lazaro Garcia" <lazaro3487(at)gmail(dot)com>
To: <pgpool-general(at)pgpool(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Failover but master is running
Date: 2017-02-23 21:08:20
Message-ID: 001a01d28e18$fbf76720$f3e63560$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tatsuo Ishii 2017-02-23 22:14:22 Re: [pgpool-general: 5345] Failover but master is running
Previous Message Gone, Sajan 2017-02-23 18:15:18 Re: postgresql admin