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

[Bo Peng]

Hi,

Thank you for sharing the configuration file.

You are using "dynamic process management mode".
It seems if max_spare_children is greater than num_init_children,
segment fault occurs.

I think it is a bug of pgpool.
I will share your report with the developer who is in charge of dynamic process management mode.

On Wed, 5 Jul 2023 13:39:51 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:

> On Wed, Jul 5, 2023 at 1:00 PM Bo Peng <pengbo at sraoss.co.jp> wrote:
> 
> > 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/
> >


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