View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000283 | Pgpool-II | Bug | public | 2017-02-05 18:07 | 2017-08-29 09:45 |
| Reporter | mmusenbr | Assigned To | pengbo | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | x86_64 | OS | RHEL | OS Version | 7.3 |
| Product Version | 3.5.5 | ||||
| Summary | 0000283: PGPool hangs in Master/Slave mode with Slony submodule | ||||
| Description | We have upgraded our PGPool installation from version 3.4.3 to 3.6.1 (first to 3.5.5). Since the upgrade our application (Java with Hibernate (tested with 4.3.11 and 4.2.7)) can't establish a connection via PGPool to our database. We have a setup with three nodes in Master/Slave mode with Slony in background. For debugging reasons, only the master is active, with no configured slaves. I also tried a connection via the simple pgpoolbug application provided in Bug 0000167, which shows the same behaviour as our application. If pgpoolbug connects to postgresql directly, everything works fine. If I disable the master_slave_mode, the connection works as well. The output of pgpoolbug is attached as pgpoolbug_jar.out. Additionally find the debug-output of pgpool attached (pgpoold.out) while pgpoolbug tries to connect. Same behavior for PGPool 3.5.5 and 3.6.1. System is a RHEL 7.3 (x86_64), PostgreSQL 9.2.19, Slony 2.1.4. (built with spec-file from pgrpms). | ||||
| Steps To Reproduce | * Create a Setup with one node in master/slave mode with slony as submodule. * Try to connect via the Debug-application (pgpoolbug.jar) described in Issue 0000167 * See the connection stuck at 'SET extra_float_digits = 3' | ||||
| Additional Information | The Bug seems to be related to issue 0000211. We applied the patch (pool_proto_module.diff) mentioned in 0000211:0000924 and afterwards the applications works fine. | ||||
| Tags | master slave | ||||
|
|
|
|
|
|
|
|
I think the bug is fixed in the latest version. Could you try the Pgpool-II 3.5.8 or Pgpool-II 3.6.4? http://pgpool.net/mediawiki/index.php/Downloads |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-02-05 18:07 | mmusenbr | New Issue | |
| 2017-02-05 18:07 | mmusenbr | File Added: pgpoold.out | |
| 2017-02-05 18:07 | mmusenbr | Tag Attached: master slave | |
| 2017-02-05 18:07 | mmusenbr | File Added: pgpoolbug_jar.out | |
| 2017-02-08 14:25 | t-ishii | Assigned To | => pengbo |
| 2017-02-08 14:25 | t-ishii | Status | new => assigned |
| 2017-06-07 10:07 | pengbo | Note Added: 0001532 | |
| 2017-06-13 13:01 | pengbo | Status | assigned => feedback |
| 2017-08-29 09:45 | pengbo | Status | feedback => closed |
