Ensure "still waiting on lock" message is logged only once per wait.
When log_lock_waits is enabled, the "still waiting on lock" message is normally emitted only once while a session continues waiting. However, if the wait is interrupted, for example by wakeups from client_connection_check_interval, SIGHUP for configuration reloads, or similar events, the message could be emitted again each time the wait resumes. For example, with very small client_connection_check_interval values (e.g., 100 ms), this behavior could flood the logs with repeated messages, making them difficult to use. To prevent this, this commit guards the "still waiting on lock" message so it is reported at most once during a lock wait, even if the wait is interrupted. This preserves the intended behavior when no interrupts occur. Author: Fujii Masao <[email protected]> Reviewed-by: Chao Li <[email protected]> Reviewed-by: Hüseyin Demir <[email protected]> Discussion: https://postgr.es/m/cahgqgwhzumg+r4kmcpyt_z-txxvx+cjjhfra+qemxkxvaxy...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/fd6ecbfa75ff0316f17c75d3931f20eb4f6e1231 Modified Files -------------- src/backend/storage/lmgr/proc.c | 30 ++++++++++++++++++++++++------ 1 file changed, 24 insertions(+), 6 deletions(-)
