RE: BUG #18280: logical decoding build wrong snapshot for subtransactions - Mailing list pgsql-bugs

From Hayato Kuroda (Fujitsu)
Subject RE: BUG #18280: logical decoding build wrong snapshot for subtransactions
Date
Msg-id TY3PR01MB9889CBEB553A06C8F4526DE2F5742@TY3PR01MB9889.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: BUG #18280: logical decoding build wrong snapshot for subtransactions  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: BUG #18280: logical decoding build wrong snapshot for subtransactions  (Amit Kapila <amit.kapila16@gmail.com>)
List 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


pgsql-bugs by date:

Previous
From: feichanghong
Date:
Subject: Re: BUG #18280: logical decoding build wrong snapshot for subtransactions
Next
From: PG Bug reporting form
Date:
Subject: BUG #18306: Slow SQL query Postgresql 15 Debian family linux.