<div dir="ltr"><div><div><div><div><div><div><div><div><div>Hi,<br><br></div>we are encountering an issue in our labs in which some pgpool connections are stuck until reboot to the machine or the pgpool service.<br><br></div><div>this issue has occurred at least 4 times so far in our labs in 3 different setups.<br><br></div>this is from the logs (the same lines several times):<br>..<br><i>2017-01-05 22:35:18: pid 1729: ERROR: unable to read data from frontend<br>2017-01-05 22:35:18: pid 1729: DETAIL: EOF encountered with frontend</i><br>...<br><br></div>another occurrence (the same lines several times):<br>...<br><p class="MsoNormal"><i>2017-01-05 22:18:47: pid 11860: DETAIL: EOF encountered with frontend<br></i></p><p class="MsoNormal"><i>2017-01-05 22:18:47: pid 21006: ERROR: unable to read data from frontend<br></i></p><p class="MsoNormal"><i>2017-01-05 22:18:47: pid 21006: DETAIL: EOF encountered with frontend</i></p><i>
</i><p class="MsoNormal"><i>2017-01-05 22:18:47: pid 14895: LOG: failback event detected</i></p><i>
2017-01-05 22:18:47: pid 14895: DETAIL: restarting myself</i><br>...<br><br></div>In our labs pgpool and postgres is running on the same machine.<br><br></div><div>after this issue occurred, although we brought down the application, we could see processes in the following state: "pgpool: idle in transaction" (until we restarted pgpool)<br><br></div>pgpool version: 3.6.1<br></div>PostgreSQL version: 9.5.4<br></div>OS: CentOS 6.5<br><br></div>Thanks in advance,<br></div>Rolan.<br></div>