Re: Race condition in TransactionIdIsInProgress

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Konstantin Knizhnik <knizhnik(at)garret(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: Race condition in TransactionIdIsInProgress
Date: 2022-02-10 17:33:56
Message-ID: F7802520-2CB7-4B07-8221-1C2C3AE3B49E@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 10 Feb 2022, at 21:46, Konstantin Knizhnik <knizhnik(at)garret(dot)ru> wrote:
> As a result "t_xmin %u is uncommitted in tuple (%u,%u) to be updated in table"
> error is reported.

Wow, cool, that seem to be a solution to one more mysterious corruption thread - “reporting TID/table with corruption error" [0]. Thank you!

Now it’s obvious that this is not a real data corruption. Maybe let’s remove corruption error code from the error? I had been literally woken at night by this code few times in January.

And do you have a plan how to fix the actual issue?

Best regards, Andrey Borodin.

[0] https://www.postgresql.org/message-id/flat/202108191637.oqyzrdtnheir%40alvherre.pgsql

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-02-10 17:52:31 Re: [RFC] building postgres with meson
Previous Message Andrew Dunstan 2022-02-10 17:00:16 Re: [RFC] building postgres with meson