org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]]

Terracotta | nkrendel | 5 years ago
  1. 0

    Deadlocks processing many misfired triggers at once Quartz 1.6.4 and JobStoreCMT

    Terracotta | 5 years ago | nkrendel
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]]
  2. 0

    ProcessAccessException occurred inside Setter with Hibernate Search

    Stack Overflow | 3 years ago | Wasif Kirmani
    org.hibernate.PropertyAccessException: Exception occurred inside setter of com.bo.Sample.logEvents
  3. 0

    Quartz connection error

    terracotta.org | 12 months ago
    org.quartz.JobPersistenceException: Failure identifying failed instances when checking-in: Read timed out [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Deadlock problems with Hibernate/Spring/MS-SQL (Object Relational Mapping forum at Coderanch)

    coderanch.com | 5 months ago
    someproject.common.exceptions.DaoException: org.hibernate.exception.SQLGrammarException: could not execute query

  1. muffinmannen 2 times, last 5 months ago
37 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerPreparedStatement.executeQuery
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
    3. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
    4. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
    9. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
    9 frames
  3. JBoss Application Server Connector
    WrappedPreparedStatement.executeQuery
    1. org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
    2. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
    2 frames
  4. quartz
    QuartzSchedulerThread.run
    1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:2160)
    2. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1555)
    3. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1549)
    4. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2768)
    5. org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2733)
    6. org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:244)
    7. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3665)
    8. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2730)
    9. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
    9 frames