[pgpool-general: 9203] Segmentation fault during shutdown

[Emond Papegaaij]

Hi,

One of our test runs this weekend hit another segmentation fault. This
crash seems to happen when pgpool is shutdown. This happens at the end of
the testcase that reverts a cluster back to a single node setup. At that
moment, 172.29.30.2 is already shutdown and removed from the cluster and
172.29.30.3 is shutdown. The configuration is updated and pgpool on
172.29.30.1 is restarted. The crash seems to happen at the moment ppgool on
172.29.30.1 is shutdown to be restarted. I've got the feeling that the
simultaneous loss of .3 and the shutdown is causing this crash.

Below is the backtrace. Please not we've switched from Debian to Alpine
based images.

#0  0x000055fe4225f0ab in close_all_backend_connections () at
protocol/pool_connection_pool.c:1078
#1  0x000055fe422917ef in proc_exit_prepare (code=-1) at
../../src/utils/error/elog.c:2707
#2  0x00007ff1af359da7 in __funcs_on_exit () at src/exit/atexit.c:34
#3  0x00007ff1af35108f in exit (code=code at entry=0) at src/exit/exit.c:29
#4  0x000055fe4224d4d2 in child_exit (code=0) at protocol/child.c:1378
#5  die (sig=3) at protocol/child.c:1174
#6  <signal handler called>
#7  memset () at src/string/x86_64/memset.s:55
#8  0x000055fe4225d2ed in memset (__n=<optimized out>, __c=0,
__d=<optimized out>) at /usr/include/fortify/string.h:75
#9  pool_init_cp () at protocol/pool_connection_pool.c:83
#10 0x000055fe4224f5f0 in do_child (fds=fds at entry=0x7ff1a6aabae0) at
protocol/child.c:222
#11 0x000055fe42223ebe in fork_a_child (fds=0x7ff1a6aabae0, id=11) at
main/pgpool_main.c:863
#12 0x000055fe42229d90 in exec_child_restart (node_id=0,
failover_context=0x7ffcd98e8c50) at main/pgpool_main.c:4684
#13 failover () at main/pgpool_main.c:1739
#14 0x000055fe42228cd9 in sigusr1_interrupt_processor () at
main/pgpool_main.c:1507
#15 0x000055fe4222900f in check_requests () at main/pgpool_main.c:4934
#16 0x000055fe4222ce53 in PgpoolMain (discard_status=discard_status at entry=0
'\000', clear_memcache_oidmaps=clear_memcache_oidmaps at entry=0 '\000') at
main/pgpool_main.c:649
#17 0x000055fe42222713 in main (argc=<optimized out>, argv=<optimized out>)
at main/main.c:365

Best regards,
Emond
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240916/98c766be/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: container.log.gz
Type: application/gzip
Size: 415176 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240916/98c766be/attachment-0002.gz>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: core.pgpool.208.bd1693e2a5e64f2a8b545d5d5d2fd91c.173784.1726299562000000.gz
Type: application/gzip
Size: 2333537 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240916/98c766be/attachment-0003.gz>