Add “FOR UPDATE NOWAIT” lock details to the log.

From: Seino Yuki <seinoyu(at)oss(dot)nttdata(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Add “FOR UPDATE NOWAIT” lock details to the log.
Date: 2024-09-13 11:49:36
Message-ID: 411280a186cc26ef7034e0f2dfe54131@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I would like to add the information of the PID that caused the failure
when acquiring a lock with "FOR UPDATE NOWAIT".

When "FOR UPDATE" is executed and interrupted by lock_timeout,
xid and PID are output in the logs, but in the case of "FOR UPDATE
NOWAIT",
no information is output, making it impossible to identify the cause of
the lock failure.
Therefore, I would like to output information in the logs in the same
way as
when "FOR UPDATE" is executed and interrupted by lock_timeout.

The patch is attached as well.

Regards,
--
Yuki Seino
NTT DATA CORPORATION

Attachment Content-Type Size
add_loginfo_nowait.patch text/x-diff 5.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2024-09-13 11:51:55 Re: Why don't we consider explicit Incremental Sort?
Previous Message Srirama Kucherlapati 2024-09-13 11:49:24 RE: AIX support