MIME-Version: 1.0
From: Cassandra Thrift <cssndrthrift@gmail.com>
Date: Tue, 8 Oct 2024 11:12:35 +0530
Message-ID: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
Subject: pg_dump throwing segfault error during backup
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a54ebd0623f09b4b"
Archived-At: <https://www.postgresql.org/message-id/CA%2BdsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb%3DC7f8XudsZm4g%40mail.gmail.com>
Precedence: bulk

--000000000000a54ebd0623f09b4b
Content-Type: text/plain; charset="UTF-8"

Hello Team,

We are facing a segfault issue while initiating backup with pg_dump.
This is for Postgresql community version 12.5 and rhel 7.4 (PostgreSQL 12.5
on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
4.8.5-39), 64-bit)

The below error is showing :

from /var/log/message

[root@USMS-PV-CRMDB2 log]# grep 'segfault' messages*
messages:Sep 24 00:15:56 USMS-PV-CRMDB2 kernel: postgres[1535]: segfault at
23c0000 ip 00007f272c91f61d sp 00007ffe22636718 error 6 in libc-2.17.so
[7f272c7d3000+1b8000]
messages:Sep 25 00:14:59 USMS-PV-CRMDB2 kernel: postgres[4245]: segfault at
23c0000 ip 00007f272c91f61d sp 00007ffe22636718 error 6 in libc-2.17.so
[7f272c7d3000+1b8000]
messages-20240923:Sep 21 00:07:13 USMS-PV-CRMDB2 kernel: postgres[14743]:
segfault at 23c0000 ip 00007f272c91f622 sp 00007ffe22636718 error 6 in
libc-2.17.so[7f272c7d3000+1b8000]
messages-20240923:Sep 22 00:06:53 USMS-PV-CRMDB2 kernel: postgres[392]:
segfault at 23c0000 ip 00007f272c91f61d sp 00007ffe22636718 error 6 in
libc-2.17.so[7f272c7d3000+1b8000]
messages-20240923:Sep 23 00:16:07 USMS-PV-CRMDB2 kernel: postgres[28843]:
segfault at 23c0000 ip 00007f272c91f622 sp 00007ffe22636718 error 6 in
libc-2.17.so[7f272c7d3000+1b8000]

From db log :

2024-09-26 00:47:05.312 +08 [9908] HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2024-09-26 00:47:05.306 +08 [10870] WARNING:  terminating connection
because of crash of another server process
2024-09-26 00:47:05.306 +08 [10870] DETAIL:  The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.

We fond the timing which shows database backup is getting invoked at the
time. So we had to stop backup (pg_backup)

we are manually taking table data currently.

Core dump also generated however RedHat refused to analyze this saying it
is third party product.

Kindly let us know if this is a bug for the version as it is too old and if
the core dump can be analyzed somehow as it is in binary.

Regards
Somraj Chakrabarty

--000000000000a54ebd0623f09b4b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello Team,<div><br></div><div>We are facing a segfault is=
sue while initiating backup with pg_dump.</div><div>This is for Postgresql =
community version 12.5 and rhel 7.4 (PostgreSQL 12.5 on x86_64-pc-linux-gnu=
, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit)</div><di=
v><br></div><div>The below error is showing :</div><div><br></div><div>from=
 /var/log/message</div><div><br></div><div><span dir=3D"ltr">[root@USMS-PV-=
CRMDB2 log]# grep &#39;segfault&#39; messages*<br>messages:Sep 24 00:15:56 =
USMS-PV-CRMDB2 kernel: postgres[1535]: segfault at 23c0000 ip 00007f272c91f=
61d sp 00007ffe22636718 error 6 in=C2=A0<a href=3D"http://libc-2.17.so/" ta=
rget=3D"_blank">libc-2.17.so</a>[7f272c7d3000+1b8000]<br>messages:Sep 25 00=
:14:59 USMS-PV-CRMDB2 kernel: postgres[4245]: segfault at 23c0000 ip 00007f=
272c91f61d sp 00007ffe22636718 error 6 in=C2=A0<a href=3D"http://libc-2.17.=
so/" target=3D"_blank">libc-2.17.so</a>[7f272c7d3000+1b8000]<br>messages-20=
240923:Sep 21 00:07:13 USMS-PV-CRMDB2 kernel: postgres[14743]: segfault at =
23c0000 ip 00007f272c91f622 sp 00007ffe22636718 error 6 in=C2=A0<a href=3D"=
http://libc-2.17.so/" target=3D"_blank">libc-2.17.so</a>[7f272c7d3000+1b800=
0]<br>messages-20240923:Sep 22 00:06:53 USMS-PV-CRMDB2 kernel: postgres[392=
]: segfault at 23c0000 ip 00007f272c91f61d sp 00007ffe22636718 error 6 in=
=C2=A0<a href=3D"http://libc-2.17.so/" target=3D"_blank">libc-2.17.so</a>[7=
f272c7d3000+1b8000]<br>messages-20240923:Sep 23 00:16:07 USMS-PV-CRMDB2 ker=
nel: postgres[28843]: segfault at 23c0000 ip 00007f272c91f622 sp 00007ffe22=
636718 error 6 in=C2=A0<a href=3D"http://libc-2.17.so/" target=3D"_blank">l=
ibc-2.17.so</a>[7f272c7d3000+1b8000]</span><br></div><div><span dir=3D"ltr"=
><br></span></div><div><span dir=3D"ltr">From db log :</span></div><div><br=
></div><div><span dir=3D"ltr">2024-09-26 00:47:05.312 +08 [9908] HINT:=C2=
=A0 In a moment you should be able to reconnect to the database and repeat =
your command.<br>2024-09-26 00:47:05.306 +08 [10870] WARNING:=C2=A0 termina=
ting connection because of crash of another server process<br>2024-09-26 00=
:47:05.306 +08 [10870] DETAIL:=C2=A0 The postmaster has commanded this serv=
er process to roll back the current transaction and exit, because another s=
erver process exited abnormally and possibly corrupted shared memory.</span=
><br></div><div><span dir=3D"ltr"><br></span></div><div><span dir=3D"ltr">W=
e fond the timing which shows database backup is getting invoked at the tim=
e. So we had to stop backup (pg_backup)</span></div><div><span dir=3D"ltr">=
<br></span></div><div>we are manually taking table data currently.</div><di=
v><br></div><div>Core dump also generated however RedHat refused to analyze=
 this saying it is third party product.</div><div><br></div><div>Kindly let=
 us know if this is a bug for the version as it is too old and if the core =
dump can be analyzed somehow as it is in binary.</div><div><br></div><div>R=
egards</div><div>Somraj Chakrabarty</div></div>

--000000000000a54ebd0623f09b4b--