| From: | Paveł Tyślacki <pavel(dot)tyslacki(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #19365: postgres 18 pg_dump fails whan drop sequence concurrently |
| Date: | 2026-01-09 22:56:38 |
| Message-ID: | CAL6gfQbG10ocO6iqTBKxkQu-PQqna+dVMEy8iAmP1qdgAQWOwQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I have a simple test `pg_get_sequence_data(0)` that works fine with patch,
concurrent pg_dump works fine for my case too.
Thanks
Pavel
On Fri, 9 Jan 2026 at 16:19, Nathan Bossart <nathandbossart(at)gmail(dot)com>
wrote:
> On Mon, Dec 29, 2025 at 12:28:07PM -0500, Tom Lane wrote:
> > PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> >> In postgres 18, I started getting random errors from `pg_dump`:
> >> pg_dump: error: query failed: ERROR: could not open relation with OID
> 16741
> >> pg_dump: detail: Query was: SELECT seqrelid, format_type(seqtypid,
> NULL),
> >> seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value,
> >> is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data(seqrelid)
> ORDER
> >> BY seqrelid;
> >
> > Thanks for the report. I posted an analysis here:
> >
> > https://www.postgresql.org/message-id/2885944.1767029161%40sss.pgh.pa.us
>
> I've committed the following in an attempt to fix this:
>
> https://postgr.es/c/7a485bd641 (master)
> https://postgr.es/c/39d5555766 (v18)
>
> Could you please verify that it fixes your use-case?
>
> --
> nathan
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2026-01-10 00:56:32 | Re: BUG #19360: Bug Report: Logical Replication initial sync fails with "conflict=update_origin_differs" PG12 toPG18 |
| Previous Message | Nathan Bossart | 2026-01-09 16:19:35 | Re: BUG #19365: postgres 18 pg_dump fails whan drop sequence concurrently |