<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0"></p>
<p style="box-sizing: border-box; margin-bottom: 16px; color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">
Hi, all</p>
<p style="box-sizing: border-box; margin-bottom: 16px; color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">
I'm using pgpool2 with below version:</p>
<pre style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; margin-top: 0px; margin-bottom: 16px; word-wrap: normal; padding: 16px; overflow: auto; line-height: 1.45; background-color: rgb(246, 248, 250); border-radius: 3px; color: rgb(36, 41, 46);"><code style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; padding: 0px; margin: 0px; background: transparent; border-radius: 3px; word-break: normal; border: 0px; display: inline; overflow: visible; line-height: inherit; word-wrap: normal;">Installed-Size: 3392
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Architecture: amd64
Version: 3.7.5-1.pgdg16.04+1
</code></pre>
<p style="box-sizing: border-box; margin-bottom: 16px; color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">
And my PostgreSQL is 9.6.4. I enabled ssl on pgpool2 with self-signed certificates, on client side, the setting is</p>
<pre style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; margin-top: 0px; margin-bottom: 16px; word-wrap: normal; padding: 16px; overflow: auto; line-height: 1.45; background-color: rgb(246, 248, 250); border-radius: 3px; color: rgb(36, 41, 46);"><code style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; padding: 0px; margin: 0px; background: transparent; border-radius: 3px; word-break: normal; border: 0px; display: inline; overflow: visible; line-height: inherit; word-wrap: normal;">spring.datasource.url=jdbc:postgresql://mypgpool2server:9999/mydb?currentSchema=myschema&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
</code></pre>
<p style="box-sizing: border-box; margin-bottom: 16px; color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">
But, everything looks fine except the logs as below, plenty of logs generated in a short time so the disk size increases very fast, please help, thanks a lot.</p>
<pre style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; margin-top: 0px; margin-bottom: 16px; word-wrap: normal; padding: 16px; overflow: auto; line-height: 1.45; background-color: rgb(246, 248, 250); border-radius: 3px; color: rgb(36, 41, 46);"><code style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; padding: 0px; margin: 0px; background: transparent; border-radius: 3px; word-break: normal; border: 0px; display: inline; overflow: visible; line-height: inherit; word-wrap: normal;">Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15086: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15086: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15238: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15238: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15238: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17525: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17525: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17525: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17670: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17670: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 17670: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14950: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14950: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14950: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14968: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14968: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14968: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15174: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15174: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 15174: DETAIL: socket read failed with an error "Success"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14932: LOG: pool_ssl: "SSL_read": "no SSL error reported"
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14932: ERROR: unable to read data from frontend
Sep 3 20:02:07 server pgpool[14880]: 2018-09-03 20:02:07: pid 14932: DETAIL: socket read failed with an error "Success"
</code></pre>
<p style="box-sizing: border-box; margin-bottom: 16px; color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">
>From PostgreSQL nodes, there're also lots of below logs:</p>
<pre style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; margin-top: 0px; word-wrap: normal; padding: 16px; overflow: auto; line-height: 1.45; background-color: rgb(246, 248, 250); border-radius: 3px; color: rgb(36, 41, 46); margin-bottom: 0px !important;"><code style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; padding: 0px; margin: 0px; background: transparent; border-radius: 3px; word-break: normal; border: 0px; display: inline; overflow: visible; line-height: inherit; word-wrap: normal;">2018-09-03 20:14:51 CST [29538-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29539-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29540-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29541-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29542-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29543-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29544-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29545-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29546-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29547-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29548-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29549-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29550-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29551-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29552-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29553-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29554-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29555-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29556-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29557-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29558-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29559-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29560-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29561-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29562-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29563-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29564-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29565-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29566-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29568-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29567-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29569-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29570-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29571-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
2018-09-03 20:14:51 CST [29572-1] postgres@[unknown] LOG: could not receive data from client: Connection reset by peer
</code></pre>
<div><code style="box-sizing: border-box; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 11.9px; padding: 0px; margin: 0px; background: transparent; border-radius: 3px; word-break: normal; border: 0px; display: inline; overflow: visible; line-height: inherit; word-wrap: normal;"><br>
</code></div>
<br>
<p></p>
</div>
</body>
</html>