org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute statement; SQL [n/a]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

GitHub | snebel29 | 2 months ago
  1. 0

    Deadlock when deleting project

    GitHub | 2 months ago | snebel29
    org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute statement; SQL [n/a]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  2. 0

    how to map Many to Many with composite key

    Stack Overflow | 10 months ago | user2529173
    org.hibernate.exception.LockTimeoutException: could not execute statement
  3. 0

    Operations timeout in Hibernate

    Stack Overflow | 2 years ago | NoobEditor
    org.hibernate.exception.LockTimeoutException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Create a simple jdbc transaction inside hibernate transaction

    Stack Overflow | 3 years ago | user2365199
    org.hibernate.exception.GenericJDBCException: could not execute update query
  6. 0

    Lock wait timeout exceeded; try restarting transaction in spring_Hibernate_Mysql

    Stack Overflow | 3 years ago | Selvam R
    org.hibernate.exception.GenericJDBCException: could not insert: [A] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

  1. kid 2 times, last 1 month ago
  2. kuldeep 4 times, last 2 months ago
  3. mortalman7 1 times, last 5 months ago
32 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. 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:998)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)
    10 frames
  3. rundeck.services
    ProjectService$_deleteProject_closure27.doCall
    1. rundeck.services.ProjectService$_deleteProject_closure27_closure65.doCall(ProjectService.groovy:1000)
    2. rundeck.services.ProjectService$_deleteProject_closure27.doCall(ProjectService.groovy:999)
    2 frames
  4. Grails GORM
    GormStaticApi.withTransaction
    1. org.grails.datastore.gorm.GormStaticApi.withTransaction(GormStaticApi.groovy:815)
    2. org.grails.datastore.gorm.GormStaticApi.withTransaction(GormStaticApi.groovy:715)
    2 frames
  5. rundeck.services
    ProjectService.deleteProject
    1. rundeck.services.ProjectService.deleteProject(ProjectService.groovy:995)
    1 frame
  6. rundeck.controllers
    ProjectController.apiProjectDelete
    1. rundeck.controllers.ProjectController.apiProjectDelete(ProjectController.groovy:622)
    1 frame
  7. Jetty
    ServletHandler$CachedChain.doFilter
    1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
    2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360)
    2 frames
  8. grails.plugin.cache
    AbstractFilter.doFilter
    1. grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
    2. grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
    2 frames
  9. Jetty
    ServletHandler$CachedChain.doFilter
    1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    3. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    4. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    5. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
    6. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    7. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:539)
    8. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
    9. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
    10. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
    11. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
    12. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
    13. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    14. org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:288)
    15. org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115)
    16. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    17. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    18. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    18 frames
  10. com.codahale.metrics
    AbstractInstrumentedFilter.doFilter
    1. com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
    1 frame
  11. Jetty
    AsyncHttpConnection.handle
    1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
    3. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
    4. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
    5. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:499)
    6. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
    7. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
    8. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
    9. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
    10. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
    11. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    12. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
    13. org.eclipse.jetty.server.Server.handle(Server.java:349)
    14. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449)
    15. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910)
    16. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)
    17. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)
    18. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)
    18 frames
  12. GWT dev
    SelectChannelEndPoint$1.run
    1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)
    2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)
    2 frames
  13. Jetty
    QueuedThreadPool$3.run
    1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)
    2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)
    2 frames
  14. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame