RE: BUG #18280: logical decoding build wrong snapshot for subtransactions

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: BUG #18280: logical decoding build wrong snapshot for subtransactions
Дата
Msg-id TY3PR01MB9889CBEB553A06C8F4526DE2F5742@TY3PR01MB9889.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: BUG #18280: logical decoding build wrong snapshot for subtransactions  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: BUG #18280: logical decoding build wrong snapshot for subtransactions  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: feichanghong
Дата:
Сообщение: Re: BUG #18280: logical decoding build wrong snapshot for subtransactions
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18306: Slow SQL query Postgresql 15 Debian family linux.