Hi Thomas, It takes time to reproduce this error. Only when the database size is too large etc. So, it is related to H2 ? Thanks. Viji
On Mon, Dec 5, 2011 at 11:20 AM, Thomas Mueller < [email protected]> wrote: > 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]> 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. >> >> -- > 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. > -- 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.
