Re: PostgreSql: Canceled on conflict out to old pivot

Поиск
Список
Период
Сортировка
От Ilya Kosmodemiansky
Тема Re: PostgreSql: Canceled on conflict out to old pivot
Дата
Msg-id EA2D97DA-68E7-44E4-BDD3-061826B6C583@dataegret.com
обсуждение исходный текст
Ответ на PostgreSql: Canceled on conflict out to old pivot  ("Wirch, Eduard" <eduard.w@smart-host.com>)
Список 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 по дате отправления:

Предыдущее
От: "Wirch, Eduard"
Дата:
Сообщение: PostgreSql: Canceled on conflict out to old pivot
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: BackgroundPsql's set_query_timer_restart() may not work