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:03:38Z
Lists: pgsql-hackers 
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.


> [1] https://www.postgresql.org/message-id/flat/CADLWmXUvd5Z%2BcFczi6Zj1WcTrXzipgP-wj0pZOWSaRUy%3DF0omQ%40mail.gmail.com

Heh, I deleted a paragraph from my previous email and forgot to remove
the footnote that it referenced.

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/
"I love the Postgres community. It's all about doing things _properly_. :-)"
(David Garamond)

Commits

  1. Allow special SKIP LOCKED condition in Assert()