hello sir, When iam using remote connection using h2 database i.e server and client process..which works perfectly in h2 database but suddenly...
iam getting this exception* Timeout trying to lock table error in the h2 database* I gave all the setting then also iam getting the same mvcc=true;lock_timeout=100000;lock_mode=0;auto_reconnect=true;auto_server=true;AUTOCOMMIT=OFF Only one single table is getting locked..the table with huge memory...the table is unable to read and write...and getting locked.....iam sure its a deadlock... Please help me how to avoid this exception... Thanks in advance... On Monday, December 5, 2011 1:59:24 PM UTC+5:30, Noel Grandin 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(JdbcPreparedStatement.java: > > 143) > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/MyOKUWK1XawJ. 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.
