Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION

Поиск
Список
Период
Сортировка
От Shlok Kyal
Тема Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION
Дата
Msg-id CANhcyEWxjwHXka+A+9PLJqpvEa5fZXD5Du1cW1QqzAxjdBhrmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION  (Shlok Kyal <shlok.kyal.oss@gmail.com>)
Ответы Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hi,

> I tried to reproduce the issue and was able to reproduce it with
> scripts shared by Tomas.
> I tried testing it from PG17 to PG 11. This issue is reproducible for
> each version.
>
> Next I would try to test with the patch in the thread shared by Amit.

I have created the v1 patch to resolve the issue. Have tested the
patch on HEAD to PG12.
The same patch applies to all the versions. The changes are similar to
the one posted in the thread
https://www.postgresql.org/message-id/1412708.1674417574%40sss.pgh.pa.us

Thanks and Regards,
Shlok Kyal

Вложения

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [HACKERS] pg_upgrade vs vacuum_cost_delay
Следующее
От: Nikita Malakhov
Дата:
Сообщение: Re: Patch: Global Unique Index