View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000312 | Pgpool-II | Bug | public | 2017-05-24 17:58 | 2017-07-19 17:06 |
| Reporter | etiennej | Assigned To | t-ishii | ||
| Priority | normal | Severity | block | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.5.7 | ||||
| Summary | 0000312: Node stays at 0 on pgpool | ||||
| Description | Hello, I've got two pgpool connected to two postgresql Nodes. First pgpool = version 3.4.5 cssi=# show pool_nodes; node_id | hostname | port | status | lb_weight | role ---------+--------------+------+--------+-----------+-------- 0 | 192.168.3.22 | 5432 | 2 | 0.500000 | master 1 | 192.168.3.23 | 5432 | 2 | 0.500000 | slave Second pgpool = version 3.5.7 cssi=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt ---------+--------------+------+--------+-----------+--------+------------ 0 | 192.168.3.22 | 5432 | 2 | 0.500000 | master | 0 1 | 192.168.3.23 | 5432 | 0 | 0.500000 | slave | 0 The second node is on status 0 and there is no way I can change it. I tried a "create table test()" which didn't replicate. I tried restarting pgpool, rebooting my server, re-installing pgpool and postgresql. | ||||
| Steps To Reproduce | I have no idea how i got there or how to reproduct the problem :( | ||||
| Additional Information | Centos 6 selinux = permissive iptables = off postgresql-server = 9.4.4 postgresql-client = 8.4.20 (on both nodes) packet installed on defective node is : pgpool-II-94.x86_64 3.5.7-1.rhel6 @pgdg94 | ||||
| Tags | No tags attached. | ||||
|
|
For information i just got it on a fresh install of pgpool 3.5.7 |
|
|
I suspect there are steal status data (pgpool_status) remained. Please restart pgpool with "-D" option. |
|
|
No feedback over 1 month. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-05-24 17:58 | etiennej | New Issue | |
| 2017-05-29 20:00 | etiennej | Note Added: 0001524 | |
| 2017-06-07 14:28 | t-ishii | Note Added: 0001536 | |
| 2017-06-07 14:29 | t-ishii | Status | new => feedback |
| 2017-06-13 13:04 | t-ishii | Assigned To | => t-ishii |
| 2017-06-13 13:04 | t-ishii | Status | feedback => assigned |
| 2017-06-13 13:12 | t-ishii | Status | assigned => feedback |
| 2017-07-19 17:06 | t-ishii | Note Added: 0001595 | |
| 2017-07-19 17:06 | t-ishii | Status | feedback => closed |
