The order of queues in row lock is changed (not FIFO)

From: "Ryo Yamaji (Fujitsu)" <yamaji(dot)ryo(at)fujitsu(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: The order of queues in row lock is changed (not FIFO)
Date: 2023-03-01 08:12:46
Message-ID: TYAPR01MB607370A5022B8854EFDC1BA58AAD9@TYAPR01MB6073.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi all,

In pgql-general, I reported that the queue order changed in
the following cases. [1]
・Multiple sessions request row locks for the same tuple
・Update occurs for target tuple

I would like to hear the opinion of experts on whether it is a
specification or a bug.
I think row locking is a FIFO specification, using tuple header
and lock managers. Therefore, I think that the above is a bug.

[1]
https://www.postgresql.org/message-id/TYAPR01MB6073506ECCD7B8F51DA807F68A0F9@TYAPR01MB6073.jpnprd01.prod.outlook.com

Regerds.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-03-01 08:15:56 Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()
Previous Message Harinath Kanchu 2023-03-01 08:06:45 Re: LOG: invalid record length at <LSN> : wanted 24, got 0