[pgpool-general: 8865] pgpool sub-processes get terminated by segment fault

[Zhaoxun Yan]

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-0001.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-0001.obj>