Re: PostgreSql: Canceled on conflict out to old pivot - Mailing list pgsql-hackers

From Ilya Kosmodemiansky
Subject Re: PostgreSql: Canceled on conflict out to old pivot
Date
Msg-id EA2D97DA-68E7-44E4-BDD3-061826B6C583@dataegret.com
Whole thread Raw
In response to PostgreSql: Canceled on conflict out to old pivot  ("Wirch, Eduard" <eduard.w@smart-host.com>)
List pgsql-hackers
Hi,

> On 28. Nov 2023, at 06:41, Wirch, Eduard <eduard.w@smart-host.com> wrote:
>
> 
>
> :
>
> ERROR: could not serialize access due to read/write dependencies among transactions
>   Detail: Reason code: Canceled on identification as a pivot, with conflict out to old committed transaction
61866959.
>
> There is a variation of the error:
>
> PSQLException: ERROR: could not serialize access due to read/write dependencies among transactions
>   Detail: Reason code: Canceled on conflict out to old pivot 61940806.

Could you show explain analyze output for those queries which fail with such errors?


>
>



pgsql-hackers by date:

Previous
From: "Wirch, Eduard"
Date:
Subject: PostgreSql: Canceled on conflict out to old pivot
Next
From: Bharath Rupireddy
Date:
Subject: Re: BackgroundPsql's set_query_timer_restart() may not work