View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000472 | Pgpool-II | Bug | public | 2019-03-04 22:16 | 2019-05-21 16:16 |
| Reporter | ashoktiwari1972 | Assigned To | pengbo | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.0.3 | ||||
| Summary | 0000472: error where running java application and error in pgpool-ii crror log | ||||
| Description | Please help me how can i solve this issue , im using postgresql 11.2 and pgpool-ii v4 on CentOS Linux release 7.3.1611. 1. issune. org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) 2. issue ( pgpool-2) v4 log error. Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer" Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer" Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000] [ | ||||
| Tags | error | ||||
|
|
Could you show pgpool debug log? If pgpool is installed from RPM, edit /etc/sysconfig/pgpool as below to log pgpool debug. OPTS=" -d -n" |
|
|
--PFA |
|
|
Thank you for providing log file. --- Mar 8 17:53:49 pgpool-02 pgpool[3576]: [8974-1] 2019-03-08 17:53:49: pid 3576: ERROR: unable to read data from frontend Mar 8 17:53:49 pgpool-02 pgpool[3576]: [8974-2] 2019-03-08 17:53:49: pid 3576: DETAIL: socket read failed with an error "Connection reset by peer" Mar 8 17:53:49 pgpool-02 pgpool[3512]: [11589-1] 2019-03-08 17:53:49: pid 3512: ERROR: unable to read data from frontend Mar 8 17:53:49 pgpool-02 pgpool[3512]: [11589-2] 2019-03-08 17:53:49: pid 3512: DETAIL: socket read failed with an error "Connection reset by peer" --- It seems that the setting of application side cause this issue. Do you use connecting pooling in application side? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-03-04 22:16 | ashoktiwari1972 | New Issue | |
| 2019-03-04 22:16 | ashoktiwari1972 | Tag Attached: error | |
| 2019-03-07 09:11 | pengbo | Note Added: 0002423 | |
| 2019-03-07 09:12 | administrator | Assigned To | => pengbo |
| 2019-03-07 09:12 | administrator | Status | new => assigned |
| 2019-03-08 22:17 | ashoktiwari1972 | File Added: pool_log | |
| 2019-03-08 22:17 | ashoktiwari1972 | Note Added: 0002427 | |
| 2019-03-17 21:49 | pengbo | Note Added: 0002433 | |
| 2019-04-07 23:12 | pengbo | Status | assigned => feedback |
| 2019-05-21 16:16 | administrator | Status | feedback => closed |
