From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "kamalvarun2004@gmail.com" <kamalvarun2004@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17007: server process (PID XXXX) was terminated by signal
 11: Segmentation fault
In-reply-to: 
 <CAKFQuwYSfeUGJeDvxUpjiCdqkCuWSL8LYJicOhZuP1E8F_dZOw@mail.gmail.com>
References: <17007-7b2eddada8ea1bd6@postgresql.org>
 <CAKFQuwYSfeUGJeDvxUpjiCdqkCuWSL8LYJicOhZuP1E8F_dZOw@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Thu, 13 May 2021 07:41:03 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1518253.1620920484.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 13 May 2021 11:41:24 -0400
Message-ID: <1518254.1620920484@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1518254.1620920484%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, May 13, 2021, PG Bug reporting form <noreply@postgresql.org=
>
> wrote:
>> PostgreSQL version: 12.2
>> We are facing an issue once in 2 days that Postgres instance crashes wi=
th
>> following error

> You need to upgrade to a supported version (12.7 in your major version
> line).

Yeah, that would certainly be the first thing to try.  If the problem is
still there, we'd really need quite a bit more information to diagnose
it.  A stack trace from the point of the crash would be quite helpful:

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_=
backend

Even better would be if you can reduce the problem to a self-contained
test case, though I realize that might be hard.

			regards, tom lane