java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

JBoss Issue Tracker | Sergiy Karpenko | 7 years ago
  1. 0

    Create a simple jdbc transaction inside hibernate transaction

    Stack Overflow | 3 years ago | user2365199
    org.hibernate.exception.GenericJDBCException: could not execute update query
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    MySQL Bugs: #51204: Lock wait timeout exceeded; try restarting transaction

    mysql.com | 11 months ago
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  4. 0

    Lock wait timeout exceeded; try restarting transaction

    terracotta.org | 11 months ago
    org.quartz.JobPersistenceException: Couldn't update states of blocked triggers: Lock wait timeout exceeded; try restarting transaction [See nested exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting 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

    Lock wait timeout exceeded; try restarting transaction

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
    5. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
    6. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
    7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
    8. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
    11. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
    11 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    1 frame
  4. org.exoplatform.services
    SessionImpl.save
    1. org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.SingleDbJDBCConnection.addNodeRecord(SingleDbJDBCConnection.java:280)
    2. org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.MySQLSingleDbJDBCConnection.addNodeRecord(MySQLSingleDbJDBCConnection.java:91)
    3. org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:366)
    4. org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:655)
    5. org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:386)
    6. org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:164)
    7. org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.access$101(CacheableWorkspaceDataManager.java:51)
    8. org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.action(CacheableWorkspaceDataManager.java:254)
    9. org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.txAction(TxIsolatedOperation.java:92)
    10. org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.txAction(CacheableWorkspaceDataManager.java:260)
    11. org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:210)
    12. org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:485)
    13. org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.save(ACLInheritanceSupportedWorkspaceDataManager.java:216)
    14. org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:235)
    15. org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:357)
    16. org.exoplatform.services.jcr.impl.core.SessionDataManager.commit(SessionDataManager.java:1294)
    17. org.exoplatform.services.jcr.impl.core.ItemImpl.save(ItemImpl.java:676)
    18. org.exoplatform.services.jcr.impl.core.SessionImpl.save(SessionImpl.java:934)
    18 frames
  5. org.exoplatform.jcr
    JCRDriver.run
    1. org.exoplatform.jcr.benchmark.usecases.AddNtFileWithMetadataTestCleanDBOracle.doRun(AddNtFileWithMetadataTestCleanDBOracle.java:95)
    2. org.exoplatform.jcr.benchmark.JCRDriver.run(JCRDriver.java:116)
    2 frames
  6. com.sun.japex
    JapexDriverBase.call
    1. com.sun.japex.JapexDriverBase.run(JapexDriverBase.java:256)
    2. com.sun.japex.JapexDriverBase.call(JapexDriverBase.java:315)
    2 frames
  7. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    5. java.lang.Thread.run(Thread.java:619)
    5 frames