Hi, Well the error message says timeout, are sure it is not a timeout?
Regards, Thomas On Tuesday, January 27, 2015, <art...@gmail.com> wrote: > I am using the H2 1.4.185. > > The url is jdbc:h2:tcp:// > 127.0.0.1/activiti?TRACE_LEVEL_FILE=4;WRITE_DELAY=100000;CACHE_SIZE=4096;MAX_COMPACT_TIME=5000 > ; > > ### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Timeout > trying to lock table ; SQL statement: > delete from ACT_RU_JOB where ID_ = ? and REV_ = ? [50200-185] > 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:301) > at org.h2.command.Command.executeUpdate(Command.java:256) > 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: Concurrent update in table > "ACT_RU_JOB": another transaction has updated or deleted the same row > [90131-185] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:168) > at org.h2.mvstore.db.MVSecondaryIndex.remove(MVSecondaryIndex.java:249) > at org.h2.mvstore.db.MVTable.removeRow(MVTable.java:610) > at org.h2.command.dml.Delete.update(Delete.java:94) > at org.h2.command.CommandContainer.update(CommandContainer.java:78) > at org.h2.command.Command.executeUpdate(Command.java:254) > ... 3 more > Caused by: java.lang.IllegalStateException: Entry is locked [1.4.185/101] > at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) > at > org.h2.mvstore.db.TransactionStore$TransactionMap.set(TransactionStore.java:1012) > at > org.h2.mvstore.db.TransactionStore$TransactionMap.remove(TransactionStore.java:970) > at org.h2.mvstore.db.MVSecondaryIndex.remove(MVSecondaryIndex.java:243) > ... 7 more > > The MVCC mode is enabled by default, but it didn't work. > > -- > 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 h2-database+unsubscr...@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to h2-database@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
