| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | 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 |
| 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 |