org.springframework.jdbc.UncategorizedSQLException

; uncategorized SQLException for SQL [insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VE RSION) values (?, ?, ?, ?, ?)]; SQL state [HYT00]; error code [50200]; Timeout trying to lock table ; SQL statement: insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VERSION) values (?, ?, ?, ?, ?) [50200-193]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VERSION) values (?, ?, ?, ?, ?) [50200-193]

Samebug tips1

Check if you're not creating unused SQL entities, as it might cause this exception.


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web851

  • via Unknown by Marco Willemart,
  • Stack trace

    • org.springframework.jdbc.UncategorizedSQLException: ; uncategorized SQLException for SQL [insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VE RSION) values (?, ?, ?, ?, ?)]; SQL state [HYT00]; error code [50200]; Timeout trying to lock table ; SQL statement: insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VERSION) values (?, ?, ?, ?, ?) [50200-193]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VERSION) values (?, ?, ?, ?, ?) [50200-193] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)[spring-jdbc-4.3.7.RELEASE.jar!/:4.3.7.RELEASE] at com.querydsl.sql.spring.SpringExceptionTranslator.translate(SpringExceptionTranslator.java:49)[querydsl-sql-spring-4.1.4.jar!/:na] at com.querydsl.sql.Configuration.translate(Configuration.java:459)[querydsl-sql-4.1.4.jar!/:na] at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:445)[querydsl-sql-4.1.4.jar!/:na] at com.skalup.common.infrastructure.persistence.event.JdbcEventStore.appendToStream(JdbcEventStore.java:132)[common-event-1.0.0-SNAPSHOT.jar!/:1.0.0-SNAPSHOT] Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: insert into EVENT_STORE (EVENT_BODY, EVENT_TYPE, OCCURRED_ON, STREAM_NAME, STREAM_VERSION) values (?, ?, ?, ?, ?) [50200-193] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[h2-1.4.193.jar!/:na] at org.h2.message.DbException.get(DbException.java:168)[h2-1.4.193.jar!/:na] at org.h2.command.Command.filterConcurrentUpdate(Command.java:307)[h2-1.4.193.jar!/:na] at org.h2.command.Command.executeUpdate(Command.java:260)[h2-1.4.193.jar!/:na] at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)[h2-1.4.193.jar!/:na] at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)[h2-1.4.193.jar!/:na] at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:431)[querydsl-sql-4.1.4.jar!/:na] ... 5 more Caused by: org.h2.jdbc.JdbcSQLException: Concurrent update in table "EVENT_STORE": another transaction has updated or deleted the same row [90131-193] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[h2-1.4.193.jar!/:na] at org.h2.message.DbException.get(DbException.java:179)[h2-1.4.193.jar!/:na] at org.h2.message.DbException.get(DbException.java:155)[h2-1.4.193.jar!/:na] at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:216)[h2-1.4.193.jar!/:na] at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704)[h2-1.4.193.jar!/:na] at org.h2.command.dml.Insert.insertRows(Insert.java:156)[h2-1.4.193.jar!/:na] at org.h2.command.dml.Insert.update(Insert.java:114)[h2-1.4.193.jar!/:na] at org.h2.command.CommandContainer.update(CommandContainer.java:98)[h2-1.4.193.jar!/:na] at org.h2.command.Command.executeUpdate(Command.java:258)[h2-1.4.193.jar!/:na] ... 12 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    tvrmsmithtvrmsmith
    Once,
    Andreas HäberAndreas Häber
    Once,
    Victor_ITVictor_IT
    3 times, last one
    batwalrus76batwalrus76
    3 times, last one
    andyglickandyglick
    4 times, last one
    143 more bugmates