View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000260 | Pgpool-II | Bug | public | 2016-11-10 16:27 | 2017-08-15 15:27 |
| Reporter | supp_k | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Platform | x86 64 | OS | CentOS | OS Version | 6.8 |
| Product Version | 3.5.4 | ||||
| Summary | 0000260: Issue #248 reproduced in "pgpool-II version 3.6beta2 (subaruboshi)" | ||||
| Description | The issue 0000248 was reproduced in pgpool-II version 3.6beta2 (subaruboshi). Probably it was not released yet, but I think it is better to notify about before hand. http://www.pgpool.net/mantisbt/view.php?id=248 | ||||
| Tags | No tags attached. | ||||
|
|
Not reproduced here. I have created 3 DB nodes configuration by using pgpool_setup. t-ishii@localhost: psql -p 11000 -c "show pool_version" test Pager usage is off. pool_version ------------------------ 3.6beta2 (subaruboshi) (1 row) t-ishii@localhost: pg_ctl -D data2 -m f stop waiting for server to shut down.... done server stopped t-ishii@localhost: psql -p 11000 -c "show pool_nodes" test Pager usage is off. node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+----------+-------+--------+-----------+---------+------------+-------------------+------------------- 0 | /tmp | 11002 | up | 0.333333 | primary | 0 | true | 0 1 | /tmp | 11003 | up | 0.333333 | standby | 0 | false | 0 2 | /tmp | 11004 | down | 0.333333 | standby | 0 | false | 0 (3 rows) t-ishii@localhost: pg_ctl -D data1 -m f stop waiting for server to shut down.... done server stopped t-ishii@localhost: psql -p 11000 -c "show pool_nodes" test Pager usage is off. node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+----------+-------+--------+-----------+---------+------------+-------------------+------------------- 0 | /tmp | 11002 | up | 0.333333 | primary | 0 | true | 0 1 | /tmp | 11003 | down | 0.333333 | standby | 0 | false | 0 2 | /tmp | 11004 | down | 0.333333 | standby | 0 | false | 0 (3 rows) t-ishii@localhost: pg_ctl -D data0 -m f stop waiting for server to shut down.... done server stopped t-ishii@localhost: psql -p 11000 -c "show pool_nodes" test psql: ERROR: pgpool is not accepting any new connections DETAIL: all backend nodes are down, pgpool requires at least one valid node HINT: repair the backend nodes and restart pgpool t-ishii@localhost: pg_ctl -D data0 start server starting t-ishii@localhost: 13300 2016-11-10 17:05:03 JST LOG: redirecting log output to logging collector process 13300 2016-11-10 17:05:03 JST HINT: Future log output will appear in directory "pg_log". t-ishii@localhost: pcp_attach_node -p 11001 0 Password: pcp_attach_node -- Command Successful t-ishii@localhost: psql -p 11000 -c "show pool_nodes" test Pager usage is off. node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+----------+-------+--------+-----------+---------+------------+-------------------+------------------- 0 | /tmp | 11002 | up | 0.333333 | primary | 0 | true | 0 1 | /tmp | 11003 | down | 0.333333 | standby | 0 | false | 0 2 | /tmp | 11004 | down | 0.333333 | standby | 0 | false | 0 (3 rows) |
|
|
Sometimes it works, sometimes not. Please see the attached log. Also if all backends are down and the "show pool_nodes" command is executed I see the error: psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. |
|
|
Please try with the latest version of Pgpool-II. |
|
|
No feedback from the reporter over 1 month. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-11-10 16:27 | supp_k | New Issue | |
| 2016-11-10 16:44 | t-ishii | Assigned To | => t-ishii |
| 2016-11-10 16:44 | t-ishii | Status | new => assigned |
| 2016-11-10 17:08 | t-ishii | Note Added: 0001160 | |
| 2016-11-10 17:08 | t-ishii | Status | assigned => feedback |
| 2016-11-10 19:07 | supp_k | File Added: attach_node.log | |
| 2016-11-10 19:07 | supp_k | Note Added: 0001161 | |
| 2016-11-10 19:07 | supp_k | Status | feedback => assigned |
| 2017-05-09 14:45 | t-ishii | Note Added: 0001497 | |
| 2017-05-09 14:45 | t-ishii | Status | assigned => feedback |
| 2017-08-15 15:26 | t-ishii | Note Added: 0001658 | |
| 2017-08-15 15:27 | t-ishii | Status | feedback => closed |
