java.sql.SQLException: General error, message from server: "Lock wait timeout exceeded; Try restarting transaction"

Oracle Community | 3004 | 1 decade ago
  1. 0

    Lock timeout in MySQL when using OptimisticLocking

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: General error, message from server: "Lock wait timeout exceeded; Try restarting transaction"
  2. 0

    Kodo generating dodgy SQL

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(JDOCLASSX, JDOIDX, JDOLOCKX, contact, name, password, stat"
  3. 0

    How to setup Spring/HIbernate JPA @Entiry to create a auto incrementing column (none id)

    Stack Overflow | 5 months ago | ALM
    org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL logging error

    GitHub | 3 years ago | kfleischmann
    org.apache.logging.log4j.core.appender.AppenderLoggingException: Failed to insert record for log event in JDBC manager: Incorrect string value: '\xF0\x9F\x92\x99\xF0\x9F...' for column 'message' at row 1
  6. 0

    dbname in the jdbc url not reconginized

    GitHub | 2 years ago | hepin1989
    java.sql.SQLException: No database selected
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

    General error, message from server: "Lock wait timeout exceeded; Try restarting transaction"

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:1874)
    5. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569)
    6 frames
  3. com.solarmetric.datasource
    PreparedStatementWrapper.executeUpdate
    1. com.solarmetric.datasource.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:111)
    1 frame
  4. com.solarmetric.kodo
    PersistenceManagerImpl.commit
    1. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatementNonBatch(SQLExecutionManagerImpl.java:454)
    2. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatement(SQLExecutionManagerImpl.java:423)
    3. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeInternal(SQLExecutionManagerImpl.java:381)
    4. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.flush(SQLExecutionManagerImpl.java:255)
    5. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:514)
    6. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:730)
    7. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:455)
    7 frames
  5. com.ewarna.pdm
    SoapServiceXFSImpl$20.execute
    1. com.ewarna.pdm.soap.xfs.SoapServiceXFSImpl$20.execute(SoapServiceXFSImpl.java:1235)
    1 frame
  6. com.ewarna.managers
    JDOCallBackExecutor.execute
    1. com.ewarna.managers.JDOCallBackExecutor.execute(JDOCallBackExecutor.java:48)
    1 frame
  7. com.ewarna.pdm
    SoapServiceXFSImpl.saveAll
    1. com.ewarna.pdm.soap.AbstractSoapService.execute(AbstractSoapService.java:194)
    2. com.ewarna.pdm.soap.xfs.SoapServiceXFSImpl.saveAll(SoapServiceXFSImpl.java:1239)
    2 frames
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  9. org.apache.soap
    RPCRouterServlet.doPost
    1. org.apache.soap.server.RPCRouter.invoke(RPCRouter.java:146)
    2. org.apache.soap.providers.RPCJavaProvider.invoke(RPCJavaProvider.java:129)
    3. org.apache.soap.server.http.RPCRouterServlet.doPost(RPCRouterServlet.java:354)
    3 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    2 frames
  11. Glassfish Core
    ContainerBase.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
    4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    11. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
    12. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
    13. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    14. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
    15. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    16. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
    17. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    18. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    19. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    20. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
    21. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    23 frames
  12. org.apache.coyote
    CoyoteAdapter.service
    1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    1 frame
  13. Grizzly HTTP
    TcpWorkerThread.runIt
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
    3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
    3 frames
  14. Tomcat Util
    ThreadPool$ControlRunnable.run
    1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
    1 frame
  15. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:536)
    1 frame