Re: BUG #15727: PANIC: cannot abort transaction 295144144, it wasalready committed

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #15727: PANIC: cannot abort transaction 295144144, it wasalready committed
Дата
Msg-id 20190402173554.ay7qejjg23ajfpce@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Жарков Роман
Дата:
Сообщение: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #15726: parallel queries failed ERROR: invalid name syntaxCONTEXT: parallel worker