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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Google Groups by Marco Willemart, 6 months ago
; 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
via Stack Overflow by Fanilo
, 2 years ago
StatementCallback; uncategorized SQLException for SQL [truncate table "schema_batch_01"."table_batch_donnees_massives"]; SQL state [3F000]; error code [-4850]; invalid schema name: schema_batch_01; nested exception is java.sql.SQLException: invalid schema name: schema_batch_01
via Stack Overflow by dimas
, 8 months ago
CallableStatementCallback; uncategorized SQLException for SQL [{call dbo.rp_report()}]; SQL state [S0004]; error code [201]; Procedure or function 'rp_report' expects parameter '@StartDate', which was not supplied.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function 'rp_report' expects parameter '@StartDate', which was not supplied.
via Atlassian JIRA by Mick Nassette [Atlassian], 1 year ago
Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
via atlassian.com by Unknown author, 1 year ago
Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
via novell.com by Unknown author, 1 year ago
Hibernate operation: could not execute update query; uncategorized SQLException for SQL [update SS_ChangeLogs set owningBinderKey=?, owningBinderId=? where (entityId in (? , ?)) and entityType=?]; SQL state [HY000]; error code [1206]; The total
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.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:216)
at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704)
at org.h2.command.dml.Insert.insertRows(Insert.java:156)
at org.h2.command.dml.Insert.update(Insert.java:114)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.command.Command.filterConcurrentUpdate(Command.java:307)
at org.h2.command.Command.executeUpdate(Command.java:260)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:431)
at com.querydsl.sql.spring.SpringExceptionTranslator.translate(SpringExceptionTranslator.java:49)
at com.querydsl.sql.Configuration.translate(Configuration.java:459)
at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:445)
at com.skalup.common.infrastructure.persistence.event.JdbcEventStore.appendToStream(JdbcEventStore.java:132)

Users with the same issue

Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 6 months ago
5 times, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
150 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.