Re: rare crash - FailedAssertion snapbuild.c Line: 580

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(at)postgresql(dot)org>
date: Mon, 21 Nov 2022 08:54:43 +0530
committer: Amit Kapila <akapila(at)postgresql(dot)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/