org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [UPDATE user_info SET user_id = ? , user_name = ? , user_email = ? , recom_id = ? , update_date = now()where user_num = ?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

GitHub | JHHJYJ | 3 months ago
  1. 0

    GitHub comment 13#245859913

    GitHub | 3 months ago | JHHJYJ
    org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [UPDATE user_info SET user_id = ? , user_name = ? , user_email = ? , recom_id = ? , update_date = now()where user_num = ?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  2. 0

    사용자 업데이트 관련

    GitHub | 3 months ago | JHHJYJ
    org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [UPDATE user_info SET user_id = ? , user_name = ? , user_email = ? , recom_id = ? , update_date = now()where user_num = ?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  3. 0

    Hibernate transaction always be active

    Stack Overflow | 2 years ago | Dozer
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 993#130316764

    GitHub | 1 year ago | latusaki
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  6. 0

    Operations timeout in Hibernate

    Stack Overflow | 2 years ago | NoobEditor
    org.hibernate.exception.LockTimeoutException: could not execute statement

  1. kid 2 times, last 4 weeks 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:1084)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
    10 frames
  3. Spring Framework
    JdbcTemplate.update
    1. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:916)
    2. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909)
    3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
    4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
    5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
    6. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
    6 frames
  4. com.eclues.ringcatcher
    JSONController.registerUser
    1. com.eclues.ringcatcher.dao.UserInfoDAOImpl.update(UserInfoDAOImpl.java:60)
    2. com.eclues.ringcatcher.ctrl.JSONController.registerUser(JSONController.java:177)
    2 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  6. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    2 frames
  7. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
    8 frames
  8. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    1 frame
  9. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
    1 frame
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    1 frame
  11. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    10 frames
  12. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
    3 frames
  13. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames