Re: deadlock-hard flakiness

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: deadlock-hard flakiness
Дата
Msg-id 20230208221528.4w7ecvgcua4hbpom@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: deadlock-hard flakiness  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On 2023-02-08 14:11:45 -0800, Andres Freund wrote:
> On 2023-02-07 17:10:21 -0800, Andres Freund wrote:
> I don't really understand how GetSafeSnapshotBlockingPids() can end up finding
> deadlock-hard's sessions being blocked by a safe snapshot. Afaict nothing uses
> serializable in that test. How can SXACT_FLAG_DEFERRABLE_WAITING be set for
> the sxact of a backend that never did serializable? Are we possibly forgetting
> to clear it or such?
> 
> 
> I don't think it should affect the reports here, but I did break something
> when removing SHMQueue - GetSafeSnapshotBlockingPids() doesn't check
> output_size anymore. Will fix.  Thomas, any chance you could do a pass through
> 96003717645 to see if I screwed up other things? I stared a lot at that
> change, but I obviously did miss at least one thing.

Argh, it's actually caused by 96003717645 as well: Previously loop iteration
without finding a matching pid ends with sxact == NULL, now it doesn't.

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: deadlock-hard flakiness
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Support logical replication of DDLs