View Issue Details

IDProjectCategoryView StatusLast Update
0000441Pgpool-IIBugpublic2018-11-20 11:41
Reporterralph.wiggumsAssigned Topengbo 
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
Product Version3.4.3 
Target VersionFixed in Version 
Summary0000441: Could not receive data from client: Connection reset by peer.
DescriptionMy postgresql.log file is being flooded with `could not receive data from client: connection reset by peer`. I'm noticing it's happening when SSL is enabled and when the connection is made via pgpool.

How can I go about troubleshooting this?

Steps To ReproduceEnable ssl on both postgres and pgpool.
For instance: client -> no ssl -> pgpool -> ssl -> postgres
Additional Informationpostgres.log:
Nov 2 19:15:06 servername postgres[30265]: [7-1] < 2018-11-02 19:15:06.653 UTC serviceuser uv3 30265 127.0.0.1(50124) [unknown] 2018-11-02 19:14:50 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:15:07 servername postgres[30309]: [7-1] < 2018-11-02 19:15:07.150 UTC serviceuser uv3 30309 127.0.0.1(50348) [unknown] 2018-11-02 19:15:06 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:15:11 servername postgres[30289]: [7-1] < 2018-11-02 19:15:11.917 UTC serviceuser uv3 30289 127.0.0.1(50206) [unknown] 2018-11-02 19:14:56 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:15:12 servername postgres[30312]: [7-1] < 2018-11-02 19:15:12.846 UTC serviceuser uv3 30312 127.0.0.1(50416) [unknown] 2018-11-02 19:15:11 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:15:17 servername postgres[30330]: [7-1] < 2018-11-02 19:15:17.788 UTC serviceuser uv3 30330 127.0.0.1(50484) [unknown] 2018-11-02 19:15:16 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:16:57 servername postgres[30395]: [7-1] < 2018-11-02 19:16:57.257 UTC serviceuser uv3 30395 127.0.0.1(51422) [unknown] 2018-11-02 19:16:57 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:24:53 servername postgres[30630]: [7-1] < 2018-11-02 19:24:53.498 UTC serviceuser uv3 30630 127.0.0.1(55894) [unknown] 2018-11-02 19:24:53 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:24:58 uv87 postgres[30639]: [7-1] < 2018-11-02 19:24:58.526 UTC serviceuser uv3 30639 127.0.0.1(55902) [unknown] 2018-11-02 19:24:53 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:03 uv87 postgres[30660]: [7-1] < 2018-11-02 19:25:03.570 UTC serviceuser uv3 30660 127.0.0.1(55964) [unknown] 2018-11-02 19:24:58 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:08 uv87 postgres[30659]: [7-1] < 2018-11-02 19:25:08.730 UTC serviceuser uv3 30659 127.0.0.1(55962) [unknown] 2018-11-02 19:24:58 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:13 uv87 postgres[30687]: [7-1] < 2018-11-02 19:25:13.629 UTC serviceuser uv3 30687 127.0.0.1(56142) [unknown] 2018-11-02 19:25:11 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:14 uv87 postgres[30689]: [7-1] < 2018-11-02 19:25:14.789 UTC serviceuser uv3 30689 127.0.0.1(56178) [unknown] 2018-11-02 19:25:13 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:18 servername postgres[30671]: [7-1] < 2018-11-02 19:25:18.650 UTC serviceuser uv3 30671 127.0.0.1(56016) [unknown] 2018-11-02 19:25:02 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:20 servername postgres[30709]: [7-1] < 2018-11-02 19:25:20.908 UTC serviceuser uv3 30709 127.0.0.1(56240) [unknown] 2018-11-02 19:25:18 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:23 servername postgres[30658]: [7-1] < 2018-11-02 19:25:23.676 UTC serviceuser uv3 30658 127.0.0.1(55956) [unknown] 2018-11-02 19:24:58 UTC >LOG: could not receive data from client: Connection reset by peer
Nov 2 19:25:28 servername postgres[30662]: [7-1] < 2018-11-02 19:25:28.703 UTC serviceuser uv3 30662 127.0.0.1(55968) [unknown] 2018-11-02 19:24:58 UTC >LOG: could not receive data from client: Connection reset by peer
TagsNo tags attached.

Activities

pengbo

2018-11-10 23:19

developer   ~0002242

Last edited: 2018-11-10 23:51

View 2 revisions

"could not receive data from client: Connection reset by peer" message shows that client connection disconnected unexpectedly.
Could you check if some network errors occurred?

I could not reproduce this issue. Could you share pgpool.conf and pool_hba.conf?

Issue History

Date Modified Username Field Change
2018-11-03 04:36 ralph.wiggums New Issue
2018-11-10 23:19 pengbo Note Added: 0002242
2018-11-10 23:51 pengbo Note Edited: 0002242 View Revisions
2018-11-20 11:41 pengbo Assigned To => pengbo
2018-11-20 11:41 pengbo Status new => feedback