Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. GeneralStatement.executeUpdate() has thrown a SQLTransactionRollbackException
    Unsorted
    0
    0
    0
  2. EmbedConnection.prepareStatement() has thrown a SQLTransactionRollbackException
    Apache Derby Database Engine and Embedded JDBC Driver
    0
    0
    0

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (5,15) Waiting XID : {153691294, S} , APP, INSERT INTO MESSAGE (ID, SERVER_ID, CHANNEL_ID, SOURCE, TYPE, DATE_CREATED, VERSION, IS_ENCRYPTED, STATUS, RAW_DATA, RAW_DATA_PROTOCOL, TRANSFORMED_DATA, TRANSFORMED_DATA_PROTOCOL, ENCODED_DATA, ENCODED_DATA_PROTOCOL, CONNECTOR_NAME, ERRORS, CORRELATION_ID, CONNECTOR_MAP, CHANNEL_MAP, RESPONSE_MAP, ATTACHMENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Granted XID : {153627442, S} Lock : ROW, SYSCONGLOMERATES, (5,14) Waiting XID : {153627442, X} , APP, alter table "APP"."MESSAGE" compress Granted XID : {153627442, S} , {153691294, S} . The selected victim is XID : 153691294.
20 matching frames hidden
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)

External results for this pattern (1)

  1. joe tilleyvia Mirth Project2 years ago
    A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SYSCONGLOMERATES, (5,15) Waiting XID : {153691294, S} , APP, INSERT INTO MESSAGE (ID, SERVER_ID, CHANNEL_ID, SOURCE, TYPE, DATE_CREATED, VERSION, IS_ENCRYPTED, STATUS, RAW_DATA, RAW_DATA_PROTOCOL, TRANSFORMED_DATA, TRANSFORMED_DATA_PROTOCOL, ENCODED_DATA, ENCODED_DATA_PROTOCOL, CONNECTOR_NAME, ERRORS, CORRELATION_ID, CONNECTOR_MAP, CHANNEL_MAP, RESPONSE_MAP, ATTACHMENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Granted XID : {153627442, S} Lock : ROW, SYSCONGLOMERATES, (5,14) Waiting XID : {153627442, X} , APP, alter table "APP"."MESSAGE" compress Granted XID : {153627442, S} , {153691294, S} . The selected victim is XID : 153691294.
    Show stack trace