Unknown error: MySQLTransactionRollbackException 1213

Question

I getting the exception MySQLTransactionRollbackException (error 1213) when I try to do a select query.

The exception has the following message:

"Deadlock found when trying to get lock; try restarting transaction"

How can I restart transaction in Java?

Possible duplicate: http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-transa — mindas, Mar 18 '11 at 21:58

score 0 · Accepted Answer · answered Mar 19 '11 at 03:46

0

Looks like you are using innoDB and you are having issues with row level locking.

answered Mar 19 '11 at 03:46

1 Answers1