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

From: Жарков Роман <r(dot)zharkov(at)postgrespro(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Date: 2019-04-02 17:35:47
Message-ID: 2BD617B6-CC34-42EF-8D79-4669C5DFB8D1@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 3 апр. 2019 г., в 0:13, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>
> r(dot)zharkov(at)postgrespro(dot)ru writes:
>> I made the new core file:
>
> Thanks, but this isn't much help --- it just shows what we already
> know, ie the "cannot abort transaction" error occurs after some other
> error was thrown.
>
> What would be more helpful would be to adjust the places that
> can throw the "unexpected table_lock_tuple status" error text to be
> PANIC rather than ERROR, so that the core dump would show a stack
> trace showing how we got to whichever of those places this is.
> Or, run the test with a higher log verbosity, so that you can find
> out which of those places is throwing the error to begin with;
> then just PANIC-ize that one.
>
> FWIW, I see six potential candidates, not two:
>
> pgsql/src/backend/commands/trigger.c: 3380: elog(ERROR, "unexpected table_lock_tuple status: %u", test);
> pgsql/src/backend/executor/nodeLockRows.c: 232: elog(ERROR, "unexpected table_lock_tuple status: %u",
> pgsql/src/backend/executor/nodeModifyTable.c: 881: elog(ERROR, "unexpected table_lock_tuple status: %u",
> pgsql/src/backend/executor/nodeModifyTable.c: 1384: elog(ERROR, "unexpected table_lock_tuple status: %u",
> pgsql/src/backend/executor/execReplication.c: 211: elog(ERROR, "unexpected table_lock_tuple status: %u", res);
> pgsql/src/backend/executor/execReplication.c: 375: elog(ERROR, "unexpected table_lock_tuple status: %u", res);
>
>
> regards, tom lane

Ok. I will made it tomorrow morning.

regards,
Roman Zharkov

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-04-02 17:35:54 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
Previous Message Tom Lane 2019-04-02 17:30:56 Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed