MIME-Version: 1.0
References: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
In-Reply-To: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 9 Oct 2024 10:25:16 -0400
Message-ID: <CANzqJaAkaUfz0tnt9ey1vpg3nt43oTDs39FNQpZ37wSmhnJhOw@mail.gmail.com>
Subject: Re: pg_dump throwing segfault error during backup
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007b832b06240c06f0"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAkaUfz0tnt9ey1vpg3nt43oTDs39FNQpZ37wSmhnJhOw%40mail.gmail.com>
Precedence: bulk

--0000000000007b832b06240c06f0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Oct 9, 2024 at 4:08=E2=80=AFAM Cassandra Thrift <cssndrthrift@gmail=
.com>
wrote:

> 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 Ha=
t
> 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.s=
o
> [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.s=
o
> [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, becaus=
e
> 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.
>

PG 12.5 is missing *four years* of patches, and RHEL 7.4 is also far behind
the current 7.9.

https://www.postgresql.org/docs/release/ tells you what's been done to v12
in every patch release.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Oct 9, 2024 at 4:08=E2=80=AFAM Ca=
ssandra Thrift &lt;<a href=3D"mailto:cssndrthrift@gmail.com">cssndrthrift@g=
mail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello Team,<div><br></d=
iv><div>We are facing a segfault issue while initiating backup with pg_dump=
.</div><div>This is for Postgresql community version 12.5 and rhel 7.4 (Pos=
tgreSQL 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><div><br></div><div>The below error is show=
ing :</div><div><br></div><div>from /var/log/message</div><div><br></div><d=
iv><span dir=3D"ltr">[root@USMS-PV-CRMDB2 log]# grep &#39;segfault&#39; mes=
sages*<br>messages:Sep 24 00:15:56 USMS-PV-CRMDB2 kernel: postgres[1535]: s=
egfault 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>[7f272c7=
d3000+1b8000]<br>messages:Sep 25 00:14:59 USMS-PV-CRMDB2 kernel: postgres[4=
245]: segfault at 23c0000 ip 00007f272c91f61d sp 00007ffe22636718 error 6 i=
n=C2=A0<a href=3D"http://libc-2.17.so/" target=3D"_blank">libc-2.17.so</a>[=
7f272c7d3000+1b8000]<br>messages-20240923:Sep 21 00:07:13 USMS-PV-CRMDB2 ke=
rnel: postgres[14743]: segfault at 23c0000 ip 00007f272c91f622 sp 00007ffe2=
2636718 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-20240923:Sep 22 00:06:53 =
USMS-PV-CRMDB2 kernel: postgres[392]: segfault at 23c0000 ip 00007f272c91f6=
1d sp 00007ffe22636718 error 6 in=C2=A0<a href=3D"http://libc-2.17.so/" tar=
get=3D"_blank">libc-2.17.so</a>[7f272c7d3000+1b8000]<br>messages-20240923:S=
ep 23 00:16:07 USMS-PV-CRMDB2 kernel: postgres[28843]: segfault at 23c0000 =
ip 00007f272c91f622 sp 00007ffe22636718 error 6 in=C2=A0<a href=3D"http://l=
ibc-2.17.so/" target=3D"_blank">libc-2.17.so</a>[7f272c7d3000+1b8000]</span=
><br></div><div><span dir=3D"ltr"><br></span></div><div><span dir=3D"ltr">F=
rom db log :</span></div><div><br></div><div><span dir=3D"ltr">2024-09-26 0=
0:47:05.312 +08 [9908] HINT:=C2=A0 In a moment you should be able to reconn=
ect to the database and repeat your command.<br>2024-09-26 00:47:05.306 +08=
 [10870] WARNING:=C2=A0 terminating connection because of crash of another =
server process<br>2024-09-26 00:47:05.306 +08 [10870] DETAIL:=C2=A0 The pos=
tmaster has commanded this server process to roll back the current transact=
ion and exit, because another server process exited abnormally and possibly=
 corrupted shared memory.</span><br></div><div><span dir=3D"ltr"><br></span=
></div><div><span dir=3D"ltr">We fond the timing which shows database backu=
p is getting invoked at the time. So we had to stop backup (pg_backup)</spa=
n></div><div><span dir=3D"ltr"><br></span></div><div>we are manually taking=
 table data currently.</div><div><br></div><div>Core dump also generated ho=
wever 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 bin=
ary.</div><div></div></div></blockquote></div><div><br></div><div>PG 12.5 i=
s missing <b>four years</b>=C2=A0of patches,=C2=A0and RHEL 7.4 is also far =
behind the current 7.9.</div><div><br></div><div><a href=3D"https://www.pos=
tgresql.org/docs/release/">https://www.postgresql.org/docs/release/</a> tel=
ls you what&#39;s been done to v12 in every patch release.<br></div><div><b=
r></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"lt=
r" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, an=
d butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&l=
t;Redacted&gt; crustacean!</div></div></div></div></div></div>

--0000000000007b832b06240c06f0--