From: Andreas Seltenreich <andreas.seltenreich@credativ.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16393: PANIC: cannot abort transaction, it was already committed
Date: Tue, 05 May 2020 22:44:52 +0200
Message-ID: <87zham5cxn.fsf@credativ.de> (raw)
In-Reply-To: <5057.1587991042@sss.pgh.pa.us>
References: <16393-0f4393a709445302@postgresql.org>
<5057.1587991042@sss.pgh.pa.us>
Tom Lane writes:
> PG Bug reporting form <noreply@postgresql.org> writes:
>> One of our customers recently experienced the following PANIC with
>> PostgreSQL 11.5 on AIX:
>> PANIC: cannot abort transaction 1234567890, it was already committed
>
> That's probably just a side-effect of some other problem. There's
> no strong reason to think that it's the same thing as #15727.
> Can you provide a reproducer by any chance?
I did inquire about getting my hands on the schema or a shell to a test
instance of the database for further analysis, but it's difficult as the
system is highly guarded by our customer. I'm afraid I won't be able to
contribute more info until then.
Andres Freund writes:
> On 2020-04-27 09:19:05 +0000, PG Bug reporting form wrote:
>> There is a striking similarity to BUG #15727 from 2019 where this
>> PANIC also occured during error handling. Archive link to the old
>> bug: https://postgr.es/m/15727-0be246e7d852d229@postgresql.org
> It doesn't immediately see that similar to me. What makes you think it
> is?
That was just my superficial impression after looking at recipe and
backtrace of #15727 (IIRC an error occures during error handling leading
to the same panic). I communicated to the customer that it's not clear
to me whether they are actually related but somehow I worded the bug
report with more prejudice than I intended, probably out of hope for a
quick backport fix. Your not seeing it squashed that though :-)
thanks,
Andreas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: andreas.seltenreich@credativ.de, tgl@sss.pgh.pa.us, andres@anarazel.de, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16393: PANIC: cannot abort transaction, it was already committed
In-Reply-To: <87zham5cxn.fsf@credativ.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox