Am 02.04.24 um 18:40 schrieb Rajesh
Kumar:
Hi
If I receive an alert for deadlock, what should I do? Like what analysis should I do? No way to find a root cause?Under pg_locks, what I can analyse?
If you receive an error with a deadlock, the current transaction is dead. You have to decide whether to try again.
Within the error message you find a hint which other (not aborted) transaction was involved in the deadlock. So you have all the information you need to find the culprit.
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
chat
with me on Signal messenger
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
