View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000220 | Pgpool-II | Bug | public | 2016-07-17 22:08 | 2017-08-15 15:25 |
| Reporter | shanmu | Assigned To | t-ishii | ||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | Pgpool 3.5 stable | OS | FreeBSD | OS Version | 10.1 |
| Summary | 0000220: socket read failed with an error "No error: 0" (pgpool 3.5 stable) | ||||
| Description | HI Ishii, Issue 210 repeated again. I have deployed the 3.5 stable from the link you have provided. root@pgp1:~ # pgpool -v pgpool-II version 3.5.3 (ekieboshi) root@pgp1:~ # This is what the pgpool log shows ============================= Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 89672:ERROR: unable to read data from DB node 1 Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 89672:DETAIL: socket read failed with an error "No error: 0" Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 88735:ERROR: unable to read data from DB node 1 Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 88735:DETAIL: socket read failed with an error "No error: 0" Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 90097:ERROR: unable to read data from DB node 1 Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 90097:DETAIL: socket read failed with an error "No error: 0" Jul 17 17:50:51 pgp1 pgpool[90097]: [4448-2] 2016-07-17 17:50:51: pid 90097:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 17:50:51 pgp1 pgpool[89672]: [4154-2] 2016-07-17 17:50:51: pid 89672:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 17:50:51 pgp1 pgpool[88735]: [3520-2] 2016-07-17 17:50:51: pid 88735:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 90097:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 89672:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 17:50:51 pgp1 pgpool: 2016-07-17 17:50:51: pid 88735:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:02 pgp1 pgpool[87739]: [3056-1] 2016-07-17 18:11:02: pid 87739:ERROR: unable to read data from DB node 0 Jul 17 18:11:02 pgp1 pgpool[87739]: [3056-2] 2016-07-17 18:11:02: pid 87739:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:02 pgp1 pgpool[89219]: [3857-1] 2016-07-17 18:11:02: pid 89219:ERROR: unable to read data from DB node 0 Jul 17 18:11:02 pgp1 pgpool[89219]: [3857-2] 2016-07-17 18:11:02: pid 89219:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 87739:ERROR: unable to read data from DB node 0 Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 87739:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 89219:ERROR: unable to read data from DB node 0 Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 89219:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:02 pgp1 pgpool[89219]: [3858-2] 2016-07-17 18:11:02: pid 89219:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:02 pgp1 pgpool[87739]: [3057-2] 2016-07-17 18:11:02: pid 87739:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 89219:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:02 pgp1 pgpool: 2016-07-17 18:11:02: pid 87739:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:22 pgp1 pgpool[87401]: [2846-1] 2016-07-17 18:11:22: pid 87401:ERROR: unable to read data from DB node 0 Jul 17 18:11:22 pgp1 pgpool[90011]: [4403-1] 2016-07-17 18:11:22: pid 90011:ERROR: unable to read data from DB node 0 Jul 17 18:11:22 pgp1 pgpool[87401]: [2846-2] 2016-07-17 18:11:22: pid 87401:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:22 pgp1 pgpool[90011]: [4403-2] 2016-07-17 18:11:22: pid 90011:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 87401:ERROR: unable to read data from DB node 0 Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 87401:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 90011:ERROR: unable to read data from DB node 0 Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 90011:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:11:22 pgp1 pgpool[87401]: [2847-2] 2016-07-17 18:11:22: pid 87401:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:22 pgp1 pgpool[90011]: [4404-2] 2016-07-17 18:11:22: pid 90011:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 87401:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:11:22 pgp1 pgpool: 2016-07-17 18:11:22: pid 90011:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool[88976]: [3685-1] 2016-07-17 18:16:02: pid 88976:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool[90096]: [4445-1] 2016-07-17 18:16:02: pid 90096:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool[88976]: [3685-2] 2016-07-17 18:16:02: pid 88976:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool[90096]: [4445-2] 2016-07-17 18:16:02: pid 90096:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88976:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88976:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool[88897]: [3631-1] 2016-07-17 18:16:02: pid 88897:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool[88897]: [3631-2] 2016-07-17 18:16:02: pid 88897:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 90096:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 90096:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88897:ERROR: unable to read data from DB node 1 Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88897:DETAIL: socket read failed with an error "No error: 0" Jul 17 18:16:02 pgp1 pgpool[88976]: [3686-2] 2016-07-17 18:16:02: pid 88976:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88976:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool[90096]: [4446-2] 2016-07-17 18:16:02: pid 90096:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool[88897]: [3632-2] 2016-07-17 18:16:02: pid 88897:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 90096:DETAIL: do not failover because fail_over_on_backend_error is off Jul 17 18:16:02 pgp1 pgpool: 2016-07-17 18:16:02: pid 88897:DETAIL: do not failover because fail_over_on_backend_error is off ================ Regards Shanmu | ||||
| Tags | No tags attached. | ||||
|
|
PLEASE HELP. URGENT |
|
|
Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11157:FATAL: unable to flush data to backend Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11157:DETAIL: do not failover because fail_over_on_backend_error is off Jul 19 14:18:52 pgp1 pgpool[7629]: [2467-1] 2016-07-19 14:18:52: pid 7629:LOG: child process with pid: 11157 exits with status 256 Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 7629:LOG: child process with pid: 11157 exits with status 256 Jul 19 14:18:52 pgp1 pgpool[7629]: [2468-1] 2016-07-19 14:18:52: pid 7629:LOG: fork a new child process with pid: 11940 Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 7629:LOG: fork a new child process with pid: 11940 Jul 19 14:18:52 pgp1 pgpool[10524]: [1508-1] 2016-07-19 14:18:52: pid 10524:ERROR: unable to read data from DB node 0 Jul 19 14:18:52 pgp1 pgpool[10524]: [1508-2] 2016-07-19 14:18:52: pid 10524:DETAIL: socket read failed with an error "No error: 0" Jul 19 14:18:52 pgp1 pgpool[11192]: [1950-1] 2016-07-19 14:18:52: pid 11192:ERROR: unable to read data from DB node 0 Jul 19 14:18:52 pgp1 pgpool[11192]: [1950-2] 2016-07-19 14:18:52: pid 11192:DETAIL: socket read failed with an error "No error: 0" Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 10524:ERROR: unable to read data from DB node 0 Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 10524:DETAIL: socket read failed with an error "No error: 0" Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11192:ERROR: unable to read data from DB node 0 Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11192:DETAIL: socket read failed with an error "No error: 0" Jul 19 14:18:52 pgp1 pgpool[11192]: [1951-1] 2016-07-19 14:18:52: pid 11192:FATAL: unable to flush data to backend Jul 19 14:18:52 pgp1 pgpool[10524]: [1509-1] 2016-07-19 14:18:52: pid 10524:FATAL: unable to flush data to backend Jul 19 14:18:52 pgp1 pgpool[11192]: [1951-2] 2016-07-19 14:18:52: pid 11192:DETAIL: do not failover because fail_over_on_backend_error is off Jul 19 14:18:52 pgp1 pgpool[10524]: [1509-2] 2016-07-19 14:18:52: pid 10524:DETAIL: do not failover because fail_over_on_backend_error is off Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11192:FATAL: unable to flush data to backend Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 11192:DETAIL: do not failover because fail_over_on_backend_error is off Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 10524:FATAL: unable to flush data to backend Jul 19 14:18:52 pgp1 pgpool: 2016-07-19 14:18:52: pid 10524:DETAIL: do not failover because fail_over_on_backend_error is off |
|
|
So actually you did not try the patch I committed in bug 210since last year. Or this time the error occurs in different situation? If so what's the difference from bug 210? |
|
|
No feedback over 1 month. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-07-17 22:08 | shanmu | New Issue | |
| 2016-07-19 16:35 | shanmu | Note Added: 0000921 | |
| 2016-07-19 17:50 | shanmu | Note Added: 0000922 | |
| 2017-06-26 16:08 | t-ishii | Assigned To | => t-ishii |
| 2017-06-26 16:08 | t-ishii | Status | new => feedback |
| 2017-06-26 16:08 | t-ishii | Note Added: 0001544 | |
| 2017-08-15 15:25 | t-ishii | Note Added: 0001657 | |
| 2017-08-15 15:25 | t-ishii | Status | feedback => closed |
