From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: r.zharkov@postgrespro.ru, Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Date: Tue, 2 Apr 2019 10:35:54 -0700
Message-ID: <20190402173554.ay7qejjg23ajfpce@alap3.anarazel.de> (raw)
In-Reply-To: <2120.1554226256@sss.pgh.pa.us>
References: <30650.1554219866@sss.pgh.pa.us>
<20190402155108.GA17787@alvherre.pgsql>
<20190402161320.o5wkbp7evuzqe4c2@alap3.anarazel.de>
<b5d89910ec01a657530d1a49ff0e05dc@postgrespro.ru>
<1492.1554225238@sss.pgh.pa.us>
<20190402171714.6mlldbvm32w727lk@alap3.anarazel.de>
<2120.1554226256@sss.pgh.pa.us>
Hi,
On 2019-04-02 13:30:56 -0400, Tom Lane wrote:
> But it's hardly plausible that that runs post-commit.
Yea, one surely would hope that that's not happening. I suspect it's
possible it's running pre-commit and somehow the failure handling is
screwed up leading to the 'already committed' error.
> So now I'm thinking that what we really need to know is why a
> TM_Invisible result was returned. That's going to be a bit harder ...
Yea. I re-skimmed through the code and can't immediately see anything
wrong - not that such subtle issues would necessarily be noticed without
more information.
I wonder, is there a chance that you're using an extension with xact
hooks, or a modified version of postgres? Could you show us the exact
schema used, and the config?
Greetings,
Andres Freund
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: andres@anarazel.de, tgl@sss.pgh.pa.us, alvherre@2ndquadrant.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
In-Reply-To: <20190402173554.ay7qejjg23ajfpce@alap3.anarazel.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