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

[Bo Peng]

Hi,

I tested 4.4.3 and it should not happen normally.
Could you share your pgpool.conf?

On Wed, 5 Jul 2023 12:03:29 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:

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


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/