New Topic
CommunityTopicProblemAdministration
Following
photo
David Registro
APAC SD Team
Assigned
Properties
Category Administration

java.sql.SQLException: Transaction was deadlocked

Guest shared this problem 7 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.

1 The same problem 0  
Leave a Comment
 
Attach a file