| From: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION |
| Date: | 2023-11-24 11:35:00 |
| Message-ID: | CANhcyEWxjwHXka+A+9PLJqpvEa5fZXD5Du1cW1QqzAxjdBhrmg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Deadlock-when-apply-worker-tablesync-worker-and-c.patch | application/octet-stream | 2.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikita Malakhov | 2023-11-24 11:40:14 | Re: Patch: Global Unique Index |
| Previous Message | Magnus Hagander | 2023-11-24 11:17:56 | Re: [HACKERS] pg_upgrade vs vacuum_cost_delay |