View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000368 | Pgpool-II | Bug | public | 2017-11-20 17:11 | 2017-12-08 11:36 |
| Reporter | marcellus | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | random |
| Status | closed | Resolution | open | ||
| Summary | 0000368: show pool_nodes from client-node and pgpool-node different? | ||||
| Description | Hi, I am already apply watchdog method for pgpool HA but i have some issue about the pool_nodes query. The result from client-node is different and sometime not update with the node where the pgpool is install FROM client-node : [root@Dev-PostgreHRD1 ~]# psql -h 10.20.18.125 -p 9999 -U postgres -d postgres -c 'show pool_nodes;' node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+--------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | | 0 | unused | 0.000000 | standby | 0 | false | 0 1 | 10.20.18.102 | 5432 | down | 0.500000 | standby | 8 | false | 0 2 | 10.20.18.124 | 5432 | up | 0.500000 | primary | 0 | true | 0 ===================================== FROM pgpool-NODE : [root@localhost ~]# psql -h 10.20.18.125 -p 9999 -U postgres -d postgres -c 'show pool_nodes;' node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+--------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | 10.20.18.123 | 5432 | up | 0.333333 | primary | 219 | true | 0 1 | 10.20.18.102 | 5432 | down | 0.333333 | standby | 94 | false | 0 2 | 10.20.18.124 | 5432 | up | 0.333333 | standby | 198 | false | 0 (3 rows) ====================================================== Is any lib or extension for client to query ? so client will get the same query. with this i attached the pgpool.conf for this watchdog method. Thanks a lot. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Please fill in "Product Version". |
|
|
Hi, this is is my mistake the virtual IP already use on another node. Now is solved after i remove the virtual IP and check the conf. thanks. |
|
|
Can we close this issue? |
|
|
Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-11-20 17:11 | marcellus | New Issue | |
| 2017-11-20 17:11 | marcellus | File Added: pgpool.conf | |
| 2017-11-20 22:28 | t-ishii | Note Added: 0001837 | |
| 2017-11-21 12:26 | marcellus | Note Added: 0001838 | |
| 2017-11-23 09:09 | t-ishii | Assigned To | => t-ishii |
| 2017-11-23 09:09 | t-ishii | Status | new => assigned |
| 2017-11-23 09:09 | t-ishii | Note Added: 0001839 | |
| 2017-11-23 09:09 | t-ishii | Status | assigned => feedback |
| 2017-12-08 11:36 | t-ishii | Note Added: 0001853 | |
| 2017-12-08 11:36 | t-ishii | Status | feedback => closed |
