java.sql.SQLException: Transaction was deadlocked

Anonymous shared this problem 3 years ago
Resolved

The below fix should help resolve this error if you encounter it:

YF:2016-07-23 17:33:03: ERROR (DBAction:doSelect) - Error occured

selecting data: java.sql.SQLException: Transaction was

deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

This one doesn't pop up very often, but here is a forum post that should help clear this up!


SQL Exception: Deadlocked


The short of it is, running the following SQL against your configuration database should resolve this (back up the DB first!):


  1. ALTER DATABASE <DATABASENAME>
  2. SET ALLOW_SNAPSHOT_ISOLATION ON


  1. ALTER DATABASE <DATABASENAME>
  2. SET READ_COMMITTED_SNAPSHOT ON
  3. WITH ROLLBACK IMMEDIATE


Where <Database> is the name of the Yellowfin database.


Please note. You will need to restart YF after making this change.