[pgpool-general: 1978] pgpool 3.3.0 RC1 master/master - reset when on db is down

Jakub Krzemiński krzeminski at arise.pl
Fri Aug 2 03:02:02 JST 2013


Hello,
i'm trying set up two pgpool in a master/master ( active/active) configuration, etch pgpool is in replication mode with two postgresql db 9.0.10.
pgpool1 in replication mode with postgres_A nad postgres_B
pgpool2 in replication mode with postgres_A nad postgres_B
( pgpool1 is on one server with postgres_A and  on other server i have pgpool2 with postgres_B both are virtual server Ubuntu 12.04 64bit LTS) 


my case is when one node or db or both is down - second one is serving sql  

now my problem is that: when i kill one of db or pgpool node the second one restarting all sql session 
( witch is very bad for me because external services connected to pgpool cant reconnect ) 

In log file have( i hope it is right part) :


Aug  1 19:12:20 waw1-pgpool1test pgpool[1901]: detect_error: kind: E
Aug  1 19:12:20 waw1-pgpool1test pgpool[1901]: detect_postmaster_down_error: receive admin shutdown error from a node.
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: detect_error: kind: E
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: detect_error: kind: E
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: detect_postmaster_down_error: receive admin shutdown error from a node.
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: postmaster on DB node 1 was shutdown by administrative command
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: degenerate_backend_set: 1 fail over request from pid 1900
Aug  1 19:12:20 waw1-pgpool1test pgpool[1901]: postmaster on DB node 1 was shutdown by administrative command
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: wd_recv_packet: recv failed
Aug  1 19:12:20 waw1-pgpool1test pgpool[1900]: degenerate_backend_set: failover request from pid 1900 is canceled by other pgpool
Aug  1 19:12:20 waw1-pgpool1test pgpool[1901]: degenerate_backend_set: 1 fail over request from pid 1901
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: wd_unlock: send unlock request: 1
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler called
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: starting to select new master node
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: wd_start_interlock: start interlocking
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: wd_assume_lock_holder: become a new lock holder
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: wd_unlock: send unlock request: 0
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: starting degeneration. shutdown host 192.168.89.53(5433)
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: Restart all children
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: kill 1870
Aug  1 19:12:20 waw1-pgpool1test pgpool[1870]: child received shutdown request signal 3
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: kill 1871
Aug  1 19:12:20 waw1-pgpool1test pgpool[1871]: child received shutdown request signal 3
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: kill 1872
Aug  1 19:12:20 waw1-pgpool1test pgpool[1872]: child received shutdown request signal 3
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: kill 1873
Aug  1 19:12:20 waw1-pgpool1test pgpool[1873]: child received shutdown request signal 3
Aug  1 19:12:20 waw1-pgpool1test pgpool[1857]: failover_handler: kill 1874
Aug  1 19:12:20 waw1-pgpool1test pgpool[1874]: child received shutdown request signal 3






More information about the pgpool-general mailing list