pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (4+ messages)

Message-ID: <87zham5cxn.fsf@credativ.de>
Permalink:  ../87zham5cxn.fsf@credativ.de/
Also on:    postgresql.org/message-id/87zham5cxn.fsf@credativ.de

 · 

reply

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