[pgpool-general: 8865] pgpool sub-processes get terminated by segment fault
Zhaoxun Yan
yan.zhaoxun at gmail.com
Wed Jul 5 13:03:29 JST 2023
Hi guys!
Is it a bug? I started local postgres as backend_hostname0 = '172.17.0.2'
And it is visitable:
# psql -h 172.17.0.2 -p 5432 -U checker template1
Password for user checker:
psql (13.10)
Type "help" for help.
template1=> \q
Although pgpool is listening on 9999:
# ss -tlnp
State Recv-Q Send-Q Local Address:Port
Peer Address:Port Process
LISTEN 0 244 0.0.0.0:5432
0.0.0.0:* users:(("postgres",pid=8680,fd=6))
LISTEN 0 64 127.0.0.1:9898
0.0.0.0:*
users:(("pgpool",pid=8780,fd=11),("pgpool",pid=8773,fd=11),("pgpool",pid=8720,fd=11))
LISTEN 0 64 0.0.0.0:9999
0.0.0.0:*
users:(("pgpool",pid=8780,fd=5),("pgpool",pid=8773,fd=5),("pgpool",pid=8754,fd=5),("pgpool",pid=8753,fd=5),("pgpool",pid=8752,fd=5),("pgpool",pid=8751,fd=5),("pgpool",pid=8750,fd=5),("pgpool",pid=8749,fd=5),("pgpool",pid=8748,fd=5),("pgpool",pid=8747,fd=5),("pgpool",pid=8746,fd=5),("pgpool",pid=8745,fd=5),("pgpool",pid=8744,fd=5),("pgpool",pid=8742,fd=5),("pgpool",pid=8741,fd=5),("pgpool",pid=8740,fd=5),("pgpool",pid=8739,fd=5),("pgpool",pid=8738,fd=5),("pgpool",pid=8737,fd=5),("pgpool",pid=8736,fd=5),("pgpool",pid=8735,fd=5),("pgpool",pid=8734,fd=5),("pgpool",pid=8733,fd=5),("pgpool",pid=8732,fd=5),("pgpool",pid=8731,fd=5),("pgpool",pid=8730,fd=5),("pgpool",pid=8729,fd=5),("pgpool",pid=8728,fd=5),("pgpool",pid=8727,fd=5),("pgpool",pid=8726,fd=5),("pgpool",pid=8724,fd=5),("pgpool",pid=8723,fd=5),("pgpool",pid=8720,fd=5))
LISTEN 0 128 0.0.0.0:22
0.0.0.0:* users:(("sshd",pid=1395,fd=3))
LISTEN 0 244 [::]:5432
[::]:* users:(("postgres",pid=8680,fd=7))
LISTEN 0 64 [::1]:9898
[::]:*
users:(("pgpool",pid=8780,fd=10),("pgpool",pid=8773,fd=10),("pgpool",pid=8720,fd=10))
LISTEN 0 64 [::]:9999
[::]:*
users:(("pgpool",pid=8780,fd=6),("pgpool",pid=8773,fd=6),("pgpool",pid=8754,fd=6),("pgpool",pid=8753,fd=6),("pgpool",pid=8752,fd=6),("pgpool",pid=8751,fd=6),("pgpool",pid=8750,fd=6),("pgpool",pid=8749,fd=6),("pgpool",pid=8748,fd=6),("pgpool",pid=8747,fd=6),("pgpool",pid=8746,fd=6),("pgpool",pid=8745,fd=6),("pgpool",pid=8744,fd=6),("pgpool",pid=8742,fd=6),("pgpool",pid=8741,fd=6),("pgpool",pid=8740,fd=6),("pgpool",pid=8739,fd=6),("pgpool",pid=8738,fd=6),("pgpool",pid=8737,fd=6),("pgpool",pid=8736,fd=6),("pgpool",pid=8735,fd=6),("pgpool",pid=8734,fd=6),("pgpool",pid=8733,fd=6),("pgpool",pid=8732,fd=6),("pgpool",pid=8731,fd=6),("pgpool",pid=8730,fd=6),("pgpool",pid=8729,fd=6),("pgpool",pid=8728,fd=6),("pgpool",pid=8727,fd=6),("pgpool",pid=8726,fd=6),("pgpool",pid=8724,fd=6),("pgpool",pid=8723,fd=6),("pgpool",pid=8720,fd=6))
LISTEN 0 128 [::]:22
[::]:* users:(("sshd",pid=1395,fd=4))
It is not visitable:
# psql -h 127.0.0.1 -p 9999 -U checker template1
psql: error: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Checking out the log, any pgpool subprocess is killed by segment fault.
And I run it again using debug mode, the same thing happens.
Attached is the pgpool log. Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230705/93341b0a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pp2023-07-05.log
Type: application/octet-stream
Size: 24920 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230705/93341b0a/attachment.obj>
More information about the pgpool-general
mailing list