No special connection parameters:
DELETE FROM ALARM_HISTORY;
Timeout trying to lock table ; SQL statement:
DELETE FROM ALARM_HISTORY [50200-192] HYT00/50200 (Hilfe)
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement:
DELETE FROM ALARM_HISTORY [50200-192]
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.server.TcpServerThread.process(TcpServerThread.java:344)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Row not found when trying to
delete from index "PUBLIC.IDX_ALARM_HISTORY_ACCOUNTALARMDATE: ( /* key:23
*/ 7653, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 1 Alarm ({NoUserText})',
TIMESTAMP '2016-09-02 09:45:36.822')" [90112-192]
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.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:234)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:336)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:245)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:192)
at org.h2.table.RegularTable.removeRow(RegularTable.java:389)
at org.h2.command.dml.Delete.update(Delete.java:95)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
... 3 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:624)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:191)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at org.h2.server.web.WebApp.getResult(WebApp.java:1388)
at org.h2.server.web.WebApp.query(WebApp.java:1061)
at org.h2.server.web.WebApp$1.next(WebApp.java:1023)
at org.h2.server.web.WebApp$1.next(WebApp.java:1010)
at org.h2.server.web.WebThread.process(WebThread.java:164)
at org.h2.server.web.WebThread.run(WebThread.java:89)
at java.lang.Thread.run(Unknown Source)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
