| From: | shveta malik <shveta(dot)malik(at)gmail(dot)com> |
|---|---|
| To: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org, Ajin Cherian <itsajin(at)gmail(dot)com>, imchifan8(at)gmail(dot)com, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, shveta malik <shvetamalik(at)gmail(dot)com> |
| Subject: | Re: BUG #19864: pg_get_publication_tables() gets cache lookup error after concurrent DROP PUBLICATION |
| Date: | 2026-11-13 10:10:08 |
| Message-ID: | CAJpy0uDjyEXNXZcoQ9_77vC5Ysh9pBrSFkAhqynctRd_R5SMLg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Nov 13, 2026 at 3:01 PM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:
>
> Hello
>
> There's still another remaining issue with the above patches, pointed
> out by claude: a missing pg_publication_rel entry while the
> publication still exists isn't always the partition-via-parent case,
> the table could also have been removed from the publication
> concurrently.
Okay, thanks for reporting. I agree with the problem. It seems like
another variation of commit 63e7a0d2c3 (due to DROP TABLE part), but
it's also related to current thread because the publication is
concurrently 'altered' (similar to original concurrent 'drop
publication'). Therefore, I'm okay with incorporating the fix into the
current patch. I have attached the fix as 003.
v4-0001 is same as Ajin's v3-0001.
v4-0002 fixes the wrong column list and filter for the last fetched
table in a concurrently dropped publication.
v4-0003 fixes the wrong column list and row filter for concurrently
altered publication that drops a table.
thanks
Shveta
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Fix-cache-lookup-failure-in-pg_get_publication_ta.patch | application/octet-stream | 8.9 KB |
| v4-0002-Do-not-return-wrong-column-list-and-row-filter-fo.patch | application/octet-stream | 2.0 KB |
| v4-0003-Skip-rows-for-tables-concurrently-removed-from-th.patch | application/octet-stream | 2.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nisha Moond | 2026-11-13 11:32:34 | Re: BUG #19892: Logical replication skips UPDATE/DELETE of rows with NULL in a hash-indexed subscriber column |
| Previous Message | Andrey Borodin | 2026-11-13 09:33:46 | Re: BUG #19896: transaction_timeout misbehaves after ROLLBACK TO SAVEPOINT and after errors |