search

pgpool / pgpool2

This is the official mirror of git://git.postgresql.org/git/pgpool2.git. Note that this is just a *mirror* - we don't work with pull requests on github. Please subscribe to pgpool-hackers mailing list from our website and submit your patch to this mailing list.
https://www.pgpool.net
Other
305 stars 87 forks source link

Large number of ssl error logs #16

Closed yongzhang closed 5 years ago

yongzhang commented 5 years ago

Hi,

I'm using pgpool2 with below version:

Installed-Size: 3392
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@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
yongzhang commented 5 years ago

Found the cause, please ignore.

jgj1018 commented 5 years ago

Could I ask what the cause was? We are facing similar problem "Connection reset by peer" from pgpool 4.0