RE: test_decoding assertion failure for the loss of top-sub transaction relationship - Mailing list pgsql-hackers

From kuroda.hayato@fujitsu.com
Subject RE: test_decoding assertion failure for the loss of top-sub transaction relationship
Date
Msg-id TYAPR01MB5866A08C386164701F6EE1B9F57A9@TYAPR01MB5866.jpnprd01.prod.outlook.com
Whole thread Raw
In response to test_decoding assertion failure for the loss of top-sub transaction relationship  ("osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>)
Responses Re: test_decoding assertion failure for the loss of top-sub transaction relationship
Re: test_decoding assertion failure for the loss of top-sub transaction relationship
List pgsql-hackers
Hi Hackers,

> Therefore, this leads to the failure for the assert that can check
> the consistency that when one sub transaction modifies the catalog,
> its top transaction should be marked so as well.
>
> I feel we need to remember the relationship between top transaction and sub
> transaction
> in the serialized snapshot even before changing catalog at decoding
> RUNNING_XACT,
> so that we can keep track of the association after the restart. What do you think ?

PSA patch that fixes the failure.
This adds pairs of sub-top transactions to the SnapBuild, and it will be serialized and restored.
The pair will be checked when we mark the ReorderBufferTXN as RBTXN_HAS_CATALOG_CHANGES.

Thanks to off-list discussion with Osumi-san.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED


Attachment

pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: PostgreSQL 15 release announcement draft
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: PostgreSQL 15 release announcement draft