| From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
|---|---|
| To: | 'Alexander Lakhin' <exclusion(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Euler Taveira <euler(at)eulerto(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Subject: | RE: Logical Replication of sequences |
| Date: | 2026-01-20 03:08:55 |
| Message-ID: | OS7PR01MB145594DAC6544508FDBD88099F589A@OS7PR01MB14559.jpnprd01.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear Alexander,
> FWIW, this issue is not reproduced at 7a485bd64~1, maybe this should be
> taken into account.
To confirm, are you saying that the issue cannot be reproduced before 7a485bd64
right? I think it's because try_relation_open() is used in pg_get_sequence_data().
Before the commit we forcibly open the relation and raise an ERROR if it fails.
The sequencesync worker exits and tries again - everything is OK.
After the commit, however, we allow to fail opening and the SQL function returns
NULL - this can cause the assertion failure.
Best regards,
Hayato Kuroda
FUJITSU LIMITED
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-01-20 03:14:45 | Re: Row pattern recognition |
| Previous Message | Rob Moore | 2026-01-20 02:33:23 | Proposal: Add backup start time to pg_stat_progress_basebackup |