Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction
Date
Msg-id CA+hUKGKNQc9q+bUMyYWVKAuKgtrS-aY-AW0V1vzYm6FkMnYFqQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction
List pgsql-bugs
On Tue, Jul 27, 2021 at 8:00 AM Alexander Lakhin <exclusion@gmail.com> wrote:
> Thanks! I'm not sure, whether this is related to the fix, but my
> parallel installcheck script (attached) catches another assert with the
> patch applied:

> #2  0x000055b16d72aa32 in ExceptionalCondition (
>     conditionName=conditionName@entry=0x55b16d89ccd0
> "!SxactIsPartiallyReleased(MySerializableXact)",
>     errorType=errorType@entry=0x55b16d78301d "FailedAssertion",
> fileName=fileName@entry=0x55b16d89bbc9 "predicate.c",
>     lineNumber=lineNumber@entry=4859) at assert.c:67

Reproduced here using a similar approach.  It doesn't fail with this
new draft patch.  The main thing I have learned is that
serializable-parallel-2.sql isn't really testing a very interesting
code path.  I'll try to come up with a better test.

Attachment

pgsql-bugs by date:

Previous
From: "Andrey V. Lepikhov"
Date:
Subject: Re: The case when AsyncAppend exists also in the qual of Async ForeignScan
Next
From: Orishich Aleksey
Date:
Subject: RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes