pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFailover but master is running
5+ messages / 2 participants
[nested] [flat]
* Failover but master is running
@ 2017-02-23 21:08 Lazaro Garcia <lazaro3487@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Lazaro Garcia @ 2017-02-23 21:08 UTC (permalink / raw)
To: pgpool-general@pgpool.net; 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)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgpool-general: 5345] Failover but master is running
@ 2017-02-23 22:14 Tatsuo Ishii <ishii@sraoss.co.jp>
parent: Lazaro Garcia <lazaro3487@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Tatsuo Ishii @ 2017-02-23 22:14 UTC (permalink / raw)
To: lazaro3487@gmail.com; +Cc: pgpool-general@pgpool.net; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgpool-general: 5345] Failover but master is running
@ 2017-02-24 14:12 Lazaro Garcia <lazaro3487@gmail.com>
parent: Tatsuo Ishii <ishii@sraoss.co.jp>
1 sibling, 0 replies; 5+ messages in thread
From: Lazaro Garcia @ 2017-02-24 14:12 UTC (permalink / raw)
To: 'Tatsuo Ishii' <ishii@sraoss.co.jp>; +Cc: pgpool-general@pgpool.net; pgsql-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgpool-general: 5345] Failover but master is running
@ 2017-02-24 17:15 Lazaro Garcia <lazaro3487@gmail.com>
parent: Tatsuo Ishii <ishii@sraoss.co.jp>
1 sibling, 1 reply; 5+ messages in thread
From: Lazaro Garcia @ 2017-02-24 17:15 UTC (permalink / raw)
To: 'Tatsuo Ishii' <ishii@sraoss.co.jp>; +Cc: pgpool-general@pgpool.net; pgsql-admin
Could be possible to use retries upon Streaming Replication Check for
preventing failover when connections to master fails?
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgpool-general: 5345] Failover but master is running
@ 2017-02-28 02:36 Tatsuo Ishii <ishii@sraoss.co.jp>
parent: Lazaro Garcia <lazaro3487@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tatsuo Ishii @ 2017-02-28 02:36 UTC (permalink / raw)
To: lazaro3487@gmail.com; +Cc: pgpool-general@pgpool.net; pgsql-admin
Retrying is not possible, but by setting fail_over_on_backend_error to
off, you can avoid failover.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Could be possible to use retries upon Streaming Replication Check for
> preventing failover when connections to master fails?
>
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-02-28 02:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-02-23 21:08 Failover but master is running Lazaro Garcia <lazaro3487@gmail.com>
2017-02-23 22:14 ` Tatsuo Ishii <ishii@sraoss.co.jp>
2017-02-24 14:12 ` Lazaro Garcia <lazaro3487@gmail.com>
2017-02-24 17:15 ` Lazaro Garcia <lazaro3487@gmail.com>
2017-02-28 02:36 ` Tatsuo Ishii <ishii@sraoss.co.jp>
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