Horton

Re: SKIP LOCKED assert triggered

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: "Bossart, Nathan" <bossartn@amazon.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-01-04T16:13:23Z
Lists: pgsql-hackers 
On 2022-Jan-04, Alvaro Herrera wrote:

> On 2022-Jan-03, Alvaro Herrera wrote:
> 
> > What I don't understand is why hasn't this been reported already: this
> > bug is pretty old.  My only explanation is that nobody runs sufficiently-
> > concurrent load with SKIP LOCKED in assert-enabled builds.
> 
> Pushed, thanks Simon for reporting this problem.

Wow, what an embarrassing problem this fix has.

-- 
Álvaro Herrera           39°49'30"S 73°17'W  —  https://www.EnterpriseDB.com/
"Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
sólo le suma el nuevo terror de la locura" (Perelandra, C.S. Lewis)

Commits

  1. Allow special SKIP LOCKED condition in Assert()