View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000124 | Pgpool-II | Bug | public | 2014-12-17 04:50 | 2015-08-21 19:49 |
| Reporter | ravazzolo | Assigned To | Muhammad Usama | ||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | resolved | Resolution | fixed | ||
| Platform | Intel | OS | Linux | OS Version | Debian 3.2.63-2 |
| Summary | 0000124: Stuck connections - Same as issue 0000107 but with pgPool 3.4.0 | ||||
| Description | root 22897 16000 0 13:28 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(56842) DISCARD root 24041 16000 0 Dez15 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(56647) DISCARD root 24043 16000 0 Dez15 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(39493) DISCARD root 24310 16000 0 14:01 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(56855) DISCARD root 24338 16000 0 14:02 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(39659) DISCARD root 26434 16000 0 02:06 ? 00:00:00 pgpool: user_updt portoalegre 10.10.2.48(39562) DISCARD | ||||
| Additional Information | I would like to know if I can apply the same patches of issue 0000107 in version 3.4.0 of pgPool. Thanks! Ricardo Ravazzolo | ||||
| Tags | No tags attached. | ||||
|
|
In my understanding, those patches have been already applied to 3.4.0. So there might be another code path which could cause the problem. Do you have any idea how to reproduce the bug? |
|
|
|
|
|
I can't reproduce the bug, it occurs eventually, but it's occurring every day. I started debbuging pgPool and in the uploaded file "Stuck Connections Logs" there are some informations that maybe can help you. The file contains: 1 - STUCKED Processes 2 - PCP Info PID 3083 and PID 11449 3 - PostgreSQL Processes 4 - pgPool Log 4.1 - PID 3083 STUCKED 4.2 - PID 446 NOT STUCKED 4.3 - PID 11449 STUCKED Thanks, Ricardo Ravazzolo. |
|
|
I hava a similar phenomenon in my system. OS CentOS 6.6 pgpool-II 3.4.2 It sometimes occuered coused by "can't read data from frontend" or "unable to read data". Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24454: ERROR: unable to read data from frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24454: DETAIL: EOF encountered with frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24455: ERROR: unable to read data from frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24455: DETAIL: EOF encountered with frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 25149: ERROR: unable to read data from frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 25149: DETAIL: EOF encountered with frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24343: ERROR: unable to read data from frontend Jul 29 10:55:41 pgpool: 2015-07-29 10:55:41: pid 24343: DETAIL: EOF encountered with frontend Jul 29 12:50:23 pgpool: 2015-07-29 12:50:23: pid 31926: ERROR: unable to read data Jul 29 12:50:23 pgpool: 2015-07-29 12:50:23: pid 31926: DETAIL: child connection forced to terminate due to client_idle_limit:1800 is reached root 13868 1748 0 04:56 ? 00:00:00 pgpool: test1 test1 172.16.XX.XX(53568) DISCARD root 24455 1750 0 10:55 ? 00:00:01 pgpool: test2 test2 172.16.XX.XX(37315) DISCARD root 25482 1750 0 11:26 ? 00:00:00 pgpool: test2 test2 172.16.XX.XX(54540) DISCARD root 26055 1748 0 Jul28 ? 00:00:00 pgpool: test1 test1 172.16.XX.XX(44655) DISCARD root 31926 1750 0 Jul28 ? 00:00:04 pgpool: test2 test2 172.16.17.84(45584) DISCARD |
|
|
Hi, Thanks for the report. I have committed the fix in master and 3.4 branches. http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=9b8a909c5558268851685e96c49ae831438e330d Best regards! |
|
|
Fix committed to master and 3.4 branches. http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=9b8a909c5558268851685e96c49ae831438e330d [^] |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-12-17 04:50 | ravazzolo | New Issue | |
| 2014-12-21 19:04 | t-ishii | Assigned To | => t-ishii |
| 2014-12-21 19:04 | t-ishii | Status | new => assigned |
| 2014-12-21 19:04 | t-ishii | Additional Information Updated | |
| 2014-12-21 19:06 | t-ishii | Note Added: 0000503 | |
| 2014-12-26 22:49 | ravazzolo | File Added: Stuck Connections Logs.txt | |
| 2014-12-26 22:50 | ravazzolo | Note Added: 0000505 | |
| 2015-07-29 14:29 | jormiya | Note Added: 0000548 | |
| 2015-08-04 10:00 | t-ishii | Assigned To | t-ishii => Muhammad Usama |
| 2015-08-21 19:47 | Muhammad Usama | Note Added: 0000559 | |
| 2015-08-21 19:49 | Muhammad Usama | Note Added: 0000560 | |
| 2015-08-21 19:49 | Muhammad Usama | Status | assigned => resolved |
| 2015-08-21 19:49 | Muhammad Usama | Resolution | open => fixed |
