java.sql.SQLException: Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Severity 13, State 50, Procedure 'DEVN TS01 null', Line 1

Oracle Community | 3004 | 2 decades ago
  1. 0

    TRANSACTION_SERIALIZABLE  SQLException problem

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Severity 13, State 50, Procedure 'DEVN TS01 null', Line 1
  2. 0

    DeadLock

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: Your transaction (process ID #12) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Severity 13, State 50, Procedure 'ICASHOUT null', Line 1 at weblogic.jdbcbase.mssqlserver4.TdsStatement.processWarning(TdsStatement.java, Compiled Code)
  3. 0

    Your transaction was deadlocked with ...

    jtds | 1 decade ago | mhilpert
    java.sql.SQLException: Your transaction (process ID #17) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When doing a JIRA upgrade, UpgradeTask_Build70108 can cause a deadlock and JIRA to fail. Stacktrace might resemble something like this {code} c.a.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.atlassian.jira.upgrade.util.UpgradeUtils.doColumnsOrTablesExist(UpgradeUtils.java:316) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build70108.doUpgrade(UpgradeTask_Build70108.java:63) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:698) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:589) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:473) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:415) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:359) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:825) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:731) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:60) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:838) at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:149) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1032) at net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getColumns(JtdsDatabaseMetaData.java:422) at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218) at com.atlassian.jira.upgrade.util.UpgradeUtils.doColumnsOrTablesExist(UpgradeUtils.java:297) ... 19 more {code}

    Atlassian JIRA | 11 months ago | Emiliano Sala [Atlassian]
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  6. 0

    database deadlock in wso2 bps when creating human task

    Stack Overflow | 1 year ago | richard
    java.sql.SQLException: Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    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. java.sql.SQLException

      Your transaction (process ID #10) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Severity 13, State 50, Procedure 'DEVN TS01 null', Line 1

      at weblogic.jdbcbase.mssqlserver4.TdsStatement.processWarning()
    2. weblogic.jdbcbase.mssqlserver4
      TdsStatement.parseMsWarning
      1. weblogic.jdbcbase.mssqlserver4.TdsStatement.processWarning(TdsStatement.java:1207)
      2. weblogic.jdbcbase.mssqlserver4.TdsStatement.parseMsWarning(TdsStatement.java:1129)
      2 frames