java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionError Code: 1205 Call:UPDATE shipaction SET direction = ?, time_seen = ?, current_pos = ?, course_over_ground = ?, true_heading = ? WHERE (shipaction_id = ?) bind => [2, 2006-11-28 09:43:08.0, [B@14d4c3b, 188.2, 184.0, 62139] Query:UpdateObjectQuery(com.vesseltracker.entity.Shipaction@1d85a68)

Oracle Community | bachst | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Database Deadlock makes glassfish die

    Oracle Community | 1 decade ago | bachst
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionError Code: 1205 Call:UPDATE shipaction SET direction = ?, time_seen = ?, current_pos = ?, course_over_ground = ?, true_heading = ? WHERE (shipaction_id = ?) bind => [2, 2006-11-28 09:43:08.0, [B@14d4c3b, 188.2, 184.0, 62139] Query:UpdateObjectQuery(com.vesseltracker.entity.Shipaction@1d85a68)

    Root Cause Analysis

    1. java.sql.SQLException

      Lock wait timeout exceeded; try restarting transactionError Code: 1205 Call:UPDATE shipaction SET direction = ?, time_seen = ?, current_pos = ?, course_over_ground = ?, true_heading = ? WHERE (shipaction_id = ?) bind => [2, 2006-11-28 09:43:08.0, [B@14d4c3b, 188.2, 184.0, 62139] Query:UpdateObjectQuery(com.vesseltracker.entity.Shipaction@1d85a68)

      at oracle.toplink.essentials.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.essentials
      StatementQueryMechanism.updateObject
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
      2. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
      3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
      4. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
      5. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
      6. oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
      7. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
      8. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
      9. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:684)
      10. oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:437)
      10 frames