DB2 Error Code 1213 – General error: Deadlock found when trying to get lock; Try restarting transaction

In this post, you’ll learn about the DB2 error 1213-General error: Deadlock found when trying to get lock; Try restarting transaction and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

1213 – General error: Deadlock found when trying to get lock; Try restarting transaction

Reason for the Error & Solution

A deadlock occured during a datastore transaction. This can occur when transaction TRANS1 locks table TABLE1, transaction TRANS2 locks table TABLE2, TRANS1 lines up to get a lock on TABLE2, and then TRANS2 lines up to get a lock on TABLE1. Deadlock prevention is the responsibility of the application, or the application server in which it runs. For more details, see the MySQL deadlock documentation.