Can you give the full stack-trace, that one is missing information. Viji wrote: > 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.
