Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction
Date
Msg-id CA+hUKGKT1RCYcy_p8RKGs0C5-8c2=J38xMOcYTxsPL=x6sr-cA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-bugs
On Tue, Mar 7, 2023 at 12:39 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> Scratch that.  I like the more ambitious idea better.  I originally
> thought it would be less back-patchable, but that's nonsense -- this
> was a straight up thinko in ancient commit bdaabb9b and we should just
> fix it properly.  That is, we should treat this case as a
> generalisation of the the PredXact->WritableSxactCount == 0 case, it's
> just that we had to do more work to figure that out.  Here's a patch
> like that.

Here's a better version.  I plan to push this tomorrow if there are no
objections.

Attachment

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: pg_basebackup fails with Could not stat file or directory "./.pg_hba.conf.un~"
Next
From: Tom Lane
Date:
Subject: Re: pg_basebackup fails with Could not stat file or directory "./.pg_hba.conf.un~"