| From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
|---|---|
| To: | 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, feichanghong <feichanghong(at)qq(dot)com> |
| Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: BUG #18280: logical decoding build wrong snapshot for subtransactions |
| Date: | 2024-01-23 12:33:32 |
| Message-ID: | TY3PR01MB9889CBEB553A06C8F4526DE2F5742@TY3PR01MB9889.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Dear hackers,
Thanks for reporting the bug. I could reproduce the issue with your reproducer.
I agreed your point.
> Thanks, your analysis sounds correct to me. BTW, I think this should
> occur only in 15 and 14 because in prior branches we didn't check if
> the xact has catalog changes before marking its subxacts. From 16
> onwards, we already accurately serialize the xacts and subxacts that
> have made any catalog changes, so this problem shouldn't be there. Can
> you please once verify the same?
I tested PG16-PG13 and got below result. As you said, only the ERROR happened
only on PG14 and PG15.
PG16 not happen
PG15 happen
PG14 happen
PG13 not happen
Also, proposed fix could be applied atop REL_14_STABLE and pass the test.
Best Regards,
Hayato Kuroda
FUJITSU LIMITED
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2024-01-23 12:45:20 | BUG #18306: Slow SQL query Postgresql 15 Debian family linux. |
| Previous Message | feichanghong | 2024-01-23 12:27:59 | Re: BUG #18280: logical decoding build wrong snapshot for subtransactions |