[pgpool-general: 5345] Failover but master is running

Lazaro Garcia lazaro3487 at gmail.com
Fri Feb 24 06:08:20 JST 2017


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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170223/1fd9ea7d/attachment.html>


More information about the pgpool-general mailing list