Hi, It looks like the table is still locked by some other thread (similar to a deadlock). Do you have a reproducible test case? If yes, could you post it? Maybe a full thread dump would help:
jps -l jstack -l <pid> Regards, Thomas On Monday, December 5, 2011, Viji wrote: > 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] <javascript:;>> > 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]<javascript:;> > . > To unsubscribe from this group, send email to > [email protected] <javascript:;>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- 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.
