[pgpool-general: 8868] Re: pgpool sub-processes get terminated by segment fault
Bo Peng
pengbo at sraoss.co.jp
Wed Jul 5 14:00:15 JST 2023
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/
More information about the pgpool-general
mailing list