View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000066 | Pgpool-II | Bug | public | 2013-08-02 18:45 | 2015-01-08 16:15 |
| Reporter | nagata | Assigned To | nagata | ||
| Priority | normal | Severity | minor | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.3 | ||||
| Target Version | 3.3 | ||||
| Summary | 0000066: [pgpool-general: 1978] pgpool 3.3.0 RC1 master/master - reset when on db is down | ||||
| Description | 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 | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-08-02 18:45 | nagata | New Issue | |
| 2013-08-02 18:45 | nagata | Status | new => assigned |
| 2013-08-02 18:45 | nagata | Assigned To | => nagata |
| 2013-09-10 17:30 | nagata | Note Added: 0000326 | |
| 2013-09-10 17:31 | nagata | Status | assigned => feedback |
| 2015-01-08 16:15 | nagata | Status | feedback => closed |
| 2015-01-08 16:15 | nagata | Resolution | open => fixed |
