View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000321 | Pgpool-II | Bug | public | 2017-07-17 22:56 | 2017-12-08 11:34 |
| Reporter | avi | Assigned To | t-ishii | ||
| Priority | high | Severity | block | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.6.4 | ||||
| Summary | 0000321: If pgpool is running on another machine than the application some queries hand for good | ||||
| Description | Our architecture has two database servers with postgres 9.6 and pgpool 3.6.5 each. Pgpool watchdog is enabled and the VIP is given to one of the database servers where its pgpool is considered master. When we call pgproto in a loop, pgpool will get stuck if the master pgpool is not on the same machine as the script that runs pgproto calls. If pgproto loop script is running on the same machine as the master pgpool than all goes well an no queries get stuck. When it got stuck it printed one the following sequences: 2017-07-16 07:48:48: <= BE DataRow 2017-07-16 07:48:48: <= BE (a) OR 2017-07-16 07:59:22: <= BE DataRow 2017-07-16 07:59:22: <= BE (f) 2017-07-16 07:59:22: <= BE (f) | ||||
| Steps To Reproduce | Run the following batch file that calls pgproto in a loop #!/bin/bash for ((n=0; n<50000; n++)) do echo "iteration $n " pgproto -f /tmp/pgproto/trunk/bug.data -p 9999 -h my_vip_address -u postgres -d postgres; done ------------ The bug.data file is # # 'Q' "SET statement_timeout = '4s'" # Receive response from backend 'Y' 'P' "S1" "SELECT count(*) from pg_tables" 0 'B' "" "S1" 0 0 0 'E' "" 0 'C' 'S' "S1" 'P' "S2" "SELECT * from pg_tables" 0 'B' "" "S2" 0 0 0 'E' "" 0 'C' 'S' "S2" # Issue Sync message 'S' # Receive response from backend 'Y' # Send terminate message 'X' | ||||
| Tags | No tags attached. | ||||
|
|
Please try the patch. |
|
|
I also posted additional patch to the mailing list because the reporter asked about the issue by an email. https://www.pgpool.net/pipermail/pgpool-general/2017-August/005755.html I don't know if the reporter still wishes to continue to use this forum though. |
|
|
If you still have problems even with 3.6.6, please let me know. |
|
|
No response since 2017/09/13. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-07-17 22:56 | avi | New Issue | |
| 2017-07-19 14:14 | t-ishii | Assigned To | => t-ishii |
| 2017-07-19 14:14 | t-ishii | Status | new => feedback |
| 2017-07-19 14:14 | t-ishii | File Added: pgpool-hung.diff | |
| 2017-07-19 14:14 | t-ishii | Note Added: 0001585 | |
| 2017-08-15 15:22 | t-ishii | Note Added: 0001656 | |
| 2017-08-15 15:22 | t-ishii | Note Edited: 0001656 | |
| 2017-09-13 14:44 | t-ishii | Note Added: 0001708 | |
| 2017-12-08 11:34 | t-ishii | Note Added: 0001850 | |
| 2017-12-08 11:34 | t-ishii | Status | feedback => closed |
