Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Alexander Lakhin <exclusion(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction
Date: 2023-03-09 04:39:24
Message-ID: CA+hUKG+Y96oENFj_boGCw6cBiUhM5wA=kiNReodZFLmsBtfwRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Pushed, without that test.

I realised that the test would not be stable in the build farm. If we
made the lock timeout high, the test would be slow, but if we made it
low, then there would be two possible outputs depending on a race, and
10ms as you had it seems -- I guess? -- likely to be unstable under
valgrind or an RPi2 or something. There is probably some clever way
to write a different test schedule, but the new code is exercised by
existing tests, and the assertion has been failing once every couple
of days on CI since I started collecting that data a few weeks ago, so
we have some kind of coverage, at least for master.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2023-03-09 09:00:00 Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction
Previous Message Thomas Munro 2023-03-08 20:50:08 Re: BUG #17368: Assert failed in GetSafeSnapshot() for SERIALIZABLE READ ONLY DEFERRABLE transaction