[pgpool-general: 8030] PgPool-II 4.2.7: several segfaults on CentOS 8

shacky shacky83 at gmail.com
Wed Mar 2 01:39:01 JST 2022


Hi,
I am experiencing many segfaults on PgPool-II 4.2.7 installed on two
different environments (production and test).

Each environment is composed by three different PgPool-II nodes configured
in a PgPool-II watchdog cluster, and I am experiencing segfaults on every 6
PgPool-II nodes.

The 6 PgPool-II nodes are distributed on 4 different physical servers, so
it's very unlikely that it's due to some hardware problems.

These are the snippets of the segfaults notifications:
===================================================================================================
DEV root at proxy1-dev ~# dmesg|grep pgpool
[   15.970081] pgpool[834]: segfault at 8 ip 00007fb6069f5d8a sp
00007fff848e7448 error 4 in libc-2.28.so[7fb60695c000+1bc000]
[   17.672642] pgpool[1336]: segfault at 8 ip 00007fb6069f5d8a sp
00007fff848e73e8 error 4 in libc-2.28.so[7fb60695c000+1bc000]

DEV root at proxy2-dev ~# dmesg|grep pgpool
[ 2109.530239] pgpool[848]: segfault at 8 ip 00007f372d024d8a sp
00007ffe5126c7d8 error 4 in libc-2.28.so[7f372cf8b000+1bc000]
[ 4752.698303] pgpool[22406]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f298 error 4 in libc-2.28.so[7fe9b705a000+1bc000]
[ 4761.219745] pgpool[22450]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f238 error 4 in libc-2.28.so[7fe9b705a000+1bc000]
[7089616.463274] pgpool[22568]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f208 error 4 in libc-2.28.so[7fe9b705a000+1bc000]
[7090394.285732] pgpool[661708]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f208 error 4 in libc-2.28.so[7fe9b705a000+1bc000]
[7090504.438435] pgpool[661929]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f208 error 4 in libc-2.28.so[7fe9b705a000+1bc000]
[7090528.565248] pgpool[661991]: segfault at 8 ip 00007fe9b70f3d8a sp
00007ffdb575f238 error 4 in libc-2.28.so[7fe9b705a000+1bc000]

DEV root at proxy3-dev ~# dmesg|grep pgpool
[ 2085.795853] pgpool[879]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6678 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7088526.747095] pgpool[20105]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d65e8 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7088528.639860] pgpool[946407]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089324.627060] pgpool[946415]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089384.787587] pgpool[946506]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089580.047313] pgpool[946521]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089591.340077] pgpool[946547]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089597.788270] pgpool[946556]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7089614.064323] pgpool[946565]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7090492.104936] pgpool[946574]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d65e8 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]
[7090575.965820] pgpool[946743]: segfault at 8 ip 00007f9f45e57d8a sp
00007ffc605d6618 error 4 in libc-2.28.so[7f9f45dbe000+1bc000]

PROD root at proxy1-prod ~# dmesg|grep pgpool
[    6.631205] pgpool[814]: segfault at 8 ip 00007fe9729dbd8a sp
00007ffe7174ae88 error 4 in libc-2.28.so[7fe972942000+1bc000]
[   17.054962] pgpool[1288]: segfault at 8 ip 00007fe9729dbd8a sp
00007ffe7174ae28 error 4 in libc-2.28.so[7fe972942000+1bc000]
[868124.710835] pgpool[1415]: segfault at 8 ip 00007fe9729dbd8a sp
00007ffe7174ae28 error 4 in libc-2.28.so[7fe972942000+1bc000]
[868127.082112] pgpool[1632535]: segfault at 8 ip 00007fe9729dbd8a sp
00007ffe7174ae28 error 4 in libc-2.28.so[7fe972942000+1bc000]

PROD root at proxy2-prod ~# dmesg|grep pgpool
[   16.783629] pgpool[835]: segfault at 8 ip 00007f5f87877d8a sp
00007ffe3d47eb08 error 4 in libc-2.28.so[7f5f877de000+1bc000]
[   21.012660] pgpool[1381]: segfault at 8 ip 00007f5f87877d8a sp
00007ffe3d47eaa8 error 4 in libc-2.28.so[7f5f877de000+1bc000]
[ 1978.102123] pgpool[1400]: segfault at 8 ip 00007f5f87877d8a sp
00007ffe3d47eaa8 error 4 in libc-2.28.so[7f5f877de000+1bc000]

PROD root at proxy3-prod ~# dmesg|grep pgpool
[   13.567572] pgpool[826]: segfault at 8 ip 00007f4359c84d8a sp
00007fff04ddf008 error 4 in libc-2.28.so[7f4359beb000+1bc000]
[   15.559884] pgpool[1384]: segfault at 8 ip 00007f4359c84d8a sp
00007fff04ddefa8 error 4 in libc-2.28.so[7f4359beb000+1bc000]
[1094174.197742] pgpool[1398]: segfault at 8 ip 00007f4359c84d8a sp
00007fff04ddef78 error 4 in libc-2.28.so[7f4359beb000+1bc000]
===================================================================================================

The operating system is CentOS 8 (fully updated) with these PgPool-II
packages installed:
===================================================================================================
PROD root at proxy3 ~# rpm -qa|grep -i pgpool
pgpool-II-pg12-4.2.7-1pgdg.rhel8.x86_64
pgpool-II-release-4.2-1.noarch
===================================================================================================

Could you help me to understand what's going on, please?

Thank you very much!
Bye
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220301/8b56796a/attachment.htm>


More information about the pgpool-general mailing list