Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction

Thomas Munro <thomas.munro@gmail.com>

From: Thomas Munro <thomas.munro@gmail.com>

To: Alexander Lakhin <exclusion@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2021-07-23T12:56:22Z

Lists: pgsql-bugs

On Thu, Jul 22, 2021 at 11:23 PM PG Bug reporting form
<noreply@postgresql.org> wrote:           '.
> Program terminated with signal SIGABRT, Aborted.
> #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
> 50      ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
> (gdb) bt
> #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
> #1  0x00007f21de1dd859 in __GI_abort () at abort.c:79
> #2  0x0000555e1740b1ac in ExceptionalCondition (
>     conditionName=conditionName@entry=0x555e17581ce8
> "!TransactionIdIsValid(serialControl->tailXid) || TransactionIdFollows(xid,
> serialControl->tailXid)", errorType=errorType@entry=0x555e17466028
> "FailedAssertion",
>     fileName=fileName@entry=0x555e17581789 "predicate.c",
> lineNumber=lineNumber@entry=1056) at assert.c:67

Thanks.  Repro'd here.  Not immediately sure what's happening here,
but I will look into it next week.

Commits

Fix race in SERIALIZABLE READ ONLY.
- d1c0f81e7273 11.20 landed
- e30fd0942493 12.15 landed
- ae632f7a3147 13.11 landed
- d811d74be353 14.8 landed
- af397c6c27b7 15.3 landed
- 65e388d4182a 16.0 landed
Fix assert failures in parallel SERIALIZABLE READ ONLY.
- afa122e41c65 12.15 landed
- a0f55fc86ab7 13.11 landed
- e9051ecd58e9 14.8 landed
- 055990904a17 15.3 landed
- 47c0accbe05b 16.0 landed
Fix SxactGlobalXmin tracking.
- 47a338cfcd67 12.0 cited
There's a small window wherein a transaction is committed but not yet
- bdaabb9b22ca 9.2.0 cited