View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000197 | Pgpool-II | Bug | public | 2016-05-13 04:30 | 2016-06-16 05:08 |
| Reporter | rlarranaga | Assigned To | Muhammad Usama | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | VMware | OS | Centos 7 | OS Version | 3.10.0-327.13.1. |
| Summary | 0000197: pgpool hangs connections to database when interface of standby/second backend | ||||
| Description | I have a 2 node pgpool cluster. each node runs one pgpool instance and one postgres instance. I am running postgresql 9.5 and pgpool 3.5.2 Both the two nodes and all clients are on the same subnet. I am running the system in streaming replication with load balancing. Once the cluster is properly established, node 1 is Watchdog MASTER and postgres Primary. If i shut down the interface in node 2 (the interface that has the fixed ip that connects to pgpool), after the backend that resides in node 2 is not marked as Dead (3) and connections to pgpool hang. | ||||
| Steps To Reproduce | 1)Configure and start postgresql nodes to have node 1 being primary and node 2 streaming slave. 2)Start pgpool in node 1. Let it become the master 3) Start pgpool in node 2. Let it become the slave. 4)Shut down the interface in node 2 (i.e.: ifconfig ens32 down) 5) Try to connect to pgpool with psql from the primary node or any of the clients (i.e: psql --port=9999 --host=virtual_ip --user= postgres) The connection will hang. This situation remains like this for a long time, even though in the logs is possible to see that the node gets marked as down. If you bring the interface up the connections start working again and you can check that show pool_nodes; shows node to as still working. | ||||
| Additional Information | the attached file has the two configuration files concatenated with a separator. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
I have found the problem and pushed the fix http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=6ae42e74d48391b8cfaa97927e00bd65aec68fe8 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-05-13 04:30 | rlarranaga | New Issue | |
| 2016-05-13 04:30 | rlarranaga | File Added: pgpool_nodes_configuration.txt | |
| 2016-05-21 05:17 | t-ishii | Assigned To | => Muhammad Usama |
| 2016-05-21 05:17 | t-ishii | Status | new => assigned |
| 2016-06-16 05:08 | Muhammad Usama | Note Added: 0000859 | |
| 2016-06-16 05:08 | Muhammad Usama | Status | assigned => resolved |
| 2016-06-16 05:08 | Muhammad Usama | Resolution | open => fixed |
