Feedback-ID: i0c21471d:Fastmail
MIME-Version: 1.0
Date: Thu, 01 Aug 2024 15:09:15 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: "Pradeep Kumar" <spradeepkumar29@gmail.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: "Andres Freund" <andres@anarazel.de>, "Erik Rijkers" <er@xs4all.nl>
Message-Id: <e0209c4e-dc9d-484c-a869-4168a6cae4b5@app.fastmail.com>
In-Reply-To: 
 <CAJ4xhP=3a4w_-zaU8p0YNZHOZC3nF=L0ERHrXiaM_G0QQA-3ZA@mail.gmail.com>
References: 
 <CAJ4xhPnNB6C=XcrLp_q-=MWzwTcKC9OyhXtpswxrm_UMvCj_PA@mail.gmail.com>
 <CAJ4xhP=3a4w_-zaU8p0YNZHOZC3nF=L0ERHrXiaM_G0QQA-3ZA@mail.gmail.com>
Subject: Re: rare crash - FailedAssertion snapbuild.c Line: 580
Content-Type: multipart/alternative;
 boundary=e961965abbdf45bf81905ac246d4ff19
Archived-At: <https://www.postgresql.org/message-id/e0209c4e-dc9d-484c-a869-4168a6cae4b5%40app.fastmail.com>
Precedence: bulk

--e961965abbdf45bf81905ac246d4ff19
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Thu, Aug 1, 2024, at 6:59 AM, Pradeep Kumar wrote:
> Any update on this?

Are you using version 11? This version is obsolete and is not supported
anymore. Consider a supported version [1].

Per the following commit (in version 16), this Assert was replaced by
elog.

commit: 240e0dbacd390a8465552e27c5af11f67d747adb
author: Amit Kapila <akapila@postgresql.org>
date: Mon, 21 Nov 2022 08:54:43 +0530
committer: Amit Kapila <akapila@postgresql.org>
date: Mon, 21 Nov 2022 08:54:43 +0530
Add additional checks while creating the initial decoding snapshot.

As per one of the CI reports, there is an assertion failure which
indicates that we were trying to use an unenforced xmin horizon for
decoding snapshots. Though, we couldn't figure out the reason for
assertion failure these checks would help us in finding the reason if the
problem happens again in the future.

Author: Amit Kapila based on suggestions by Andres Freund
Reviewd by: Andres Freund
Discussion: https://postgr.es/m/CAA4eK1L8wYcyTPxNzPGkhuO52WBGoOZbT0A73Le=ZUWYAYmdfw@mail.gmail.com

According to this discussion, there isn't a clue about the root cause.
If you have a test case, share it (mainly if you are observing it in
version 16+ that exposes some data which may be useful for analysis).


[1] https://www.postgresql.org/support/versioning/


--
Euler Taveira
EDB   https://www.enterprisedb.com/

--e961965abbdf45bf81905ac246d4ff19
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div>On Thu, Aug 1, =
2024, at 6:59 AM, Pradeep Kumar wrote:<br></div><blockquote type=3D"cite=
" id=3D"qt" style=3D""><div dir=3D"ltr"><div>Any update&nbsp;on this?<br=
></div></div></blockquote><div><br></div><div>Are you using version 11? =
This version is obsolete and is not supported<br></div><div>anymore. Con=
sider a supported version [1].<br></div><div><br></div><div>Per the foll=
owing commit (in version 16), this Assert was replaced by<br></div><div>=
elog.<br></div><div><br></div><div>commit: 240e0dbacd390a8465552e27c5af1=
1f67d747adb<br></div><div>author: Amit Kapila &lt;<a href=3D"mailto:akap=
ila@postgresql.org">akapila@postgresql.org</a>&gt;<br></div><div>date: M=
on, 21 Nov 2022 08:54:43 +0530<br></div><div>committer: Amit Kapila &lt;=
<a href=3D"mailto:akapila@postgresql.org">akapila@postgresql.org</a>&gt;=
<br></div><div>date: Mon, 21 Nov 2022 08:54:43 +0530<br></div><div>Add a=
dditional checks while creating the initial decoding snapshot.<br></div>=
<div><br></div><div>As per one of the CI reports, there is an assertion =
failure which<br></div><div>indicates that we were trying to use an unen=
forced xmin horizon for<br></div><div>decoding snapshots. Though, we cou=
ldn't figure out the reason for<br></div><div>assertion failure these ch=
ecks would help us in finding the reason if the<br></div><div>problem ha=
ppens again in the future.<br></div><div><br></div><div>Author: Amit Kap=
ila based on suggestions by Andres Freund<br></div><div>Reviewd by: Andr=
es Freund<br></div><div>Discussion: <a href=3D"https://postgr.es/m/CAA4e=
K1L8wYcyTPxNzPGkhuO52WBGoOZbT0A73Le=3DZUWYAYmdfw@mail.gmail.com">https:/=
/postgr.es/m/CAA4eK1L8wYcyTPxNzPGkhuO52WBGoOZbT0A73Le=3DZUWYAYmdfw@mail.=
gmail.com</a><br></div><div><br></div><div>According to this discussion,=
 there isn't a clue about the root cause.<br></div><div>If you have a te=
st case, share it (mainly if you are observing it in<br></div><div>versi=
on 16+ that exposes some data which may be useful for analysis).<br></di=
v><div><br></div><div><br></div><div>[1] <a href=3D"https://www.postgres=
ql.org/support/versioning/">https://www.postgresql.org/support/versionin=
g/</a><br></div><div><br></div><div><br></div><div id=3D"sig112409080"><=
div class=3D"signature">--<br></div><div class=3D"signature">Euler Tavei=
ra<br></div><div class=3D"signature">EDB&nbsp;&nbsp; <a href=3D"https://=
www.enterprisedb.com/">https://www.enterprisedb.com/</a><br></div></div>=
<div><br></div></body></html>
--e961965abbdf45bf81905ac246d4ff19--