[pgpool-general: 2085] Fwd: node failover

Armin Nesiren armin.nesiren at intera.si
Thu Aug 29 19:57:49 JST 2013


Hello,

I'm having problem with failover triggering every night because for me
unknown reason. I have latest pgpool-3.3.0 version with postgresql 9.0
nodes.

I have streaming replication and load balance, without watchdog.
I have enabled healt check with this paremeters:

health_check_period = 5
health_check_timeout = 20
health_check_user = 'postgres'
health_check_max_retries = 1
health_check_retry_delay = 1


Here is my pgpool.log with debug option enabled:

2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: auth kind: 0
2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: backend key data received
2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: transaction state: I
2013-08-28 05:15:23 DEBUG: pid 10079: health check: clearing alarm
2013-08-28 05:15:23 DEBUG: pid 10079: health check: clearing alarm
2013-08-28 05:15:28 DEBUG: pid 10079: starting health checking
2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm
2013-08-28 05:15:28 DEBUG: pid 10079: health_check: 0 th DB node status: 2
2013-08-28 05:15:28 DEBUG: pid 10079: pool_ssl: SSL requested but SSL
support is not available
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: auth kind: 0
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: backend key data received
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: transaction state: I
2013-08-28 05:15:28 DEBUG: pid 10079: health_check: 1 th DB node status: 2
2013-08-28 05:15:28 DEBUG: pid 10079: pool_ssl: SSL requested but SSL
support is not available
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: auth kind: 0
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: backend key data received
2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: transaction state: I
2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm
2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm
2013-08-28 05:15:29 ERROR: pid 15210: pool_read: read failed (Connection
timed out)
2013-08-28 05:15:29 LOG:   pid 15210: degenerate_backend_set: 0 fail over
request from pid 15210
2013-08-28 05:15:29 ERROR: pid 15210: pool_flush_it: write failed to
backend (0). reason: Broken pipe offset: 0 wlen: 5
2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler called
2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: starting to select
new master node
2013-08-28 05:15:29 LOG:   pid 10079: starting degeneration. shutdown host
intrix-c1(5432)
2013-08-28 05:15:29 LOG:   pid 10079: Restart all children
2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 18940
2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 10507
2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 2139

-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130829/eb9c9f39/attachment.html>


More information about the pgpool-general mailing list