[pgpool-general: 6221] Large number of ssl error logs

[Yong Zhang]

Hi, all

I'm using pgpool2 with below version:

Installed-Size: 3392
Maintainer: Debian PostgreSQL Maintainers <team+postgresql at tracker.debian.org>
Architecture: amd64
Version: 3.7.5-1.pgdg16.04+1


And my PostgreSQL is 9.6.4. I enabled ssl on pgpool2 with self-signed certificates, on client side, the setting is

spring.datasource.url=jdbc:postgresql://mypgpool2server:9999/mydb?currentSchema=myschema&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory


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.

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"



>From PostgreSQL nodes, there're also lots of below logs:

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180903/2676008b/attachment.html>