org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Transaction (Process ID 62) 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 62) 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 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]]

Terracotta | kowstubh | 3 years ago
  1. 0

    Deadlock ocurring in Quartz 1.8.5 with SQL Server 2008 R2

    Terracotta | 3 years ago | kowstubh
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Transaction (Process ID 62) 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 62) 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 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]]
  2. 0

    Why is my datetime parameter for a stored procedure being rejected?

    Stack Overflow | 5 years ago | Avi Flax
    com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting date and/or time from character string.
  3. 0

    [cas-user] CAS 3.5.2 - SQL Deadlocks - Not cleanup related

    Google Groups | 2 years ago | Geoff Whittaker
    javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: Transaction (Process ID 138) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC Connection to SQL Server 2000 reset randomly on Solaris server

    Stack Overflow | 7 years ago | karlgrz
    com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
  6. 0

    TSQL: Arithmetic overflow error converting expression to data type datetime

    Stack Overflow | 2 years ago | nishant
    com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic overflow error converting expression to data type datetime. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

    9 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 62) 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
      SQLServerResultSet.next
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
      2. com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
      3. com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onEOF(SQLServerResultSet.java:4692)
      4. com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
      5. com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4758)
      6. com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682)
      7. com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:983)
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyResultSet.next
      1. com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
      1 frame
    4. quartz
      QuartzSchedulerThread.run
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:2114)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1558)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1552)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2772)
      5. org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2737)
      6. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3768)
      7. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2733)
      8. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:264)
      8 frames