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+hUKG+uRkCpVCfrUb0rTMyEBLhfpsDuW91d9XNT1d-cxEJenQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-bugs
On Wed, Jul 28, 2021 at 5:02 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Wed, Jul 28, 2021 at 9:00 AM Alexander Lakhin <exclusion@gmail.com> wrote:
> > (Except for read-only-anomaly-3, that causes another
> > assertion fail but I believe that it's not related to the initial issue
> > and deserves another bug report.)
>
> Huh.  I tried and failed to find that one with concurrent runs.  I'll
> wait for your next report before I do anything, just in case there's a
> connection.

This is indeed an unrelated issue, and much older.  After many
kilowatt hours, I reproduced it here and worked out that it comes from
GetSafeSnapshot() not expecting possibleUnsafeConflicts to be empty
when WritableSxactCount == 0.  More soon.



pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Next
From: PG Bug reporting form
Date:
Subject: BUG #17128: minimum numeric 'integer' is -2147483647 not -2147483648 as documented