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)