View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000646 | Pgpool-II | General | public | 2020-08-31 17:57 | 2020-09-14 14:36 |
| Reporter | fario98 | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | feedback | Resolution | open | ||
| Product Version | 4.1.3 | ||||
| Summary | 0000646: After kill the primary failover not works and if i turn on again the prymary i have 3 standby | ||||
| Description | After kill the primary failover not works and if i turn on again the prymary i have 3 standby node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change ---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+--------------------- 0 | small1 | 5432 | up | 0.333333 | standby | 0 | true | 0 | | | 2020-08-31 12:56:03 1 | small2 | 5432 | up | 0.333333 | standby | 0 | false | 0 | | | 2020-08-31 12:56:03 2 | small3 | 5432 | up | 0.333333 | standby | 0 | false | 0 | | | 2020-08-31 12:56:03 | ||||
| Tags | No tags attached. | ||||
|
|
You need to configure "failover_command". Below is a configuration example: https://www.pgpool.net/docs/latest/en/html/example-cluster.html |
|
|
I have already set the failover command on all three node : failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S' But now i have 3 standby. |
|
|
Could you share your config file "pgpool.conf" and pgpool log file? I need to confirm the configuration and log messages. |
|
|
I enclose the two files required, the .conf is the same for all 3 servers, I'm waiting for news |
|
|
I found watchdog is shutdown in pgpool.log. How did you kill the primary? Did you kill postgresql primary server or pgpool? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-08-31 17:57 | fario98 | New Issue | |
| 2020-08-31 21:41 | pengbo | Note Added: 0003547 | |
| 2020-08-31 21:41 | pengbo | Assigned To | => pengbo |
| 2020-08-31 21:41 | pengbo | Status | new => feedback |
| 2020-08-31 21:51 | fario98 | Note Added: 0003548 | |
| 2020-08-31 21:51 | fario98 | Status | feedback => assigned |
| 2020-09-01 09:14 | pengbo | Note Added: 0003550 | |
| 2020-09-01 09:15 | pengbo | Status | assigned => feedback |
| 2020-09-01 16:11 | fario98 | File Added: pgpool.rar | |
| 2020-09-01 16:11 | fario98 | Note Added: 0003556 | |
| 2020-09-01 16:11 | fario98 | Status | feedback => assigned |
| 2020-09-14 14:36 | pengbo | Note Added: 0003563 | |
| 2020-09-14 14:36 | pengbo | Status | assigned => feedback |
