I saw the following exceptions from my code:
nested exception is org.springframework.dao.CannotAcquireLockException:
### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Timeout
trying to lock table ; SQL statement:
DELETE FROM `audit`
WHERE `time` < ? [50200-191]
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:345)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Row not found when trying to
delete from index "PUBLIC.AUDIT_TIME_INDEX: ( /* key:974 */ TIMESTAMP
'2015-11-02 15:30:14.784', 'admin:10.80.3.24',
'method=webcommands.hst, engineKey=BUYSIDE, args=[localhost, 8001, guest,
084e0343a0486ff05530df6c705c8bb4, 2]')" [90112-191]
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:243)
at org.h2.table.RegularTable.removeRow(RegularTable.java:389)
at org.h2.command.dml.Delete.update(Delete.java:94)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
... 3 more
The "cause" is reported as "row not found when deleting from index' What's
going on here.
--
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.
