Hi, We are getting Timeout trying to lock table error in the h2 database. Can anyone one please point us why it is coming ? ts=2011-12-02T03:28:09.555Z level=Excep class=gov.lbl.bdm.gsiftp.GsiFTPParallelBrowsing Timeout trying to lock table "SYS"; SQL statement:
insert into status_1 (dir_id, file_name, tgt_id, endpoint_id, size,status,statuscode,lastModificationTime,timestamp) values (?,?,?,?,?,?,?,?,?) [50200-159] org.h2.message.DbException.getJdbcSQLException(DbException.java:329) org.h2.message.DbException.get(DbException.java:169) org.h2.message.DbException.get(DbException.java:146) org.h2.table.RegularTable.doLock(RegularTable.java:506) org.h2.table.RegularTable.lock(RegularTable.java:440) org.h2.engine.Database.removeMeta(Database.java:733) org.h2.engine.Database.update(Database.java:1359) org.h2.schema.Sequence.flush(Sequence.java:127) org.h2.schema.Sequence.getNext(Sequence.java:92) org.h2.expression.SequenceValue.getValue(SequenceValue.java:30) org.h2.table.Column.validateConvertUpdateSequence(Column.java:268) org.h2.table.Table.validateConvertUpdateSequence(Table.java:679) org.h2.command.dml.Insert.insertRows(Insert.java:120) org.h2.command.dml.Insert.update(Insert.java:84) org.h2.command.CommandContainer.update(CommandContainer.java:71) org.h2.command.Command.executeUpdate(Command.java:212) org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java: 143) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
