[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    single-row deadlock
From:       guntiso () latnet ! lv
Date:       2021-07-27 0:53:25
Message-ID: 2fcd64476bfaf1ca62f768508325825f () latnet ! lv
[Download RAW message or body]

Hi,

After upgrading from PostgreSQL 9.6 to 13 we started to experience 
locking issues once per week or two.
Replacing exclusive table lock with helper table row lock did not help.
Now it seems like a single-row deadlocks can occur, which should not be 
possible (audit_data_lock table contains one row):

blocked_pid,blocking_pid,blocked_statement,current_statement_in_blocking_process,blocked_application,blocking_application
 6752,6577,update audit_data_lock set locks_used = locks_used + 1,update 
audit_data_lock set locks_used = locks_used + 1,PostgreSQL JDBC 
Driver,PostgreSQL JDBC Driver
6577,6752,update audit_data_lock set locks_used = locks_used + 1,update 
audit_data_lock set locks_used = locks_used + 1,PostgreSQL JDBC 
Driver,PostgreSQL JDBC Driver

Is this a known issue? It seems like 
https://postgrespro.com/list/thread-id/1231581. Are there any 
workarounds?


[prev in list] [next in list] [prev in thread] [next in thread]