Hi Noel, Please let me what information is missing here. The complete insert statement ? thanks. Viji
On Dec 5, 12:29 am, Noel Grandin <[email protected]> wrote: > 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(JdbcPreparedStateme > > nt.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.
