Hi, > The version of H2 is 1.3.168, we updated it about 1 month ago
No, actually you are still using version 1.3.160, because the build number is in the error code: > ... NOT PERSISTENT [50200-160] The "[...-160]" means build # 160. Regards, Thomas On Sunday, March 31, 2013, 刘辉 wrote: > Hi, > Thomas, Thank you for your reply. > > The version of H2 is 1.3.168, we updated it about 1 month ago. the > newest is 1.3.171, which was updated on 2013-03-17. > Is really this to cause the problem? But in the change history, I > didn't find any infomation that was related to this. > > And I must correct a mistake in my last email, we use H2 in server mode, > using /IPTCP. In my system, Our App server generates a thread to server a > request, in the thread, we get a connection from H2, create, insert, > update, delete, drop and close connection, And at the same time, > maybe there are many threads these are all working. > > The stack trace is below, all are similar, these happen when executing > 'CREATE' or 'DROP' sql. > > Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table > "SYS"; SQL statement: > CREATE MEMORY LOCAL TEMPORARY TABLE MemTableList(tablename > varchar(1000),isReturn varchar(50),PRIMARY KEY(tablename)) NOT PERSISTENT > [50200-160] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > at org.h2.message.DbException.get(DbException.java:169) > at org.h2.message.DbException.get(DbException.java:146) > at org.h2.table.RegularTable.doLock(RegularTable.java:500) > at org.h2.table.RegularTable.lock(RegularTable.java:434) > at org.h2.engine.Database.lockMeta(Database.java:748) > at org.h2.engine.Database.removeMeta(Database.java:762) > at org.h2.table.Table.removeChildrenAndResources(Table.java:469) > at > org.h2.table.RegularTable.removeChildrenAndResources(RegularTable.java:656) > at org.h2.engine.Session.removeLocalTempTable(Session.java:230) > at org.h2.engine.Database.removeSchemaObject(Database.java:1574) > at org.h2.command.ddl.CreateTable.update(CreateTable.java:188) > at org.h2.command.CommandContainer.update(CommandContainer.java:73) > at org.h2.command.Command.executeUpdate(Command.java:219) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:300) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) > at java.lang.Thread.run(Unknown Source) > at org.h2.engine.SessionRemote.done(SessionRemote.java:538) > at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183) > at > org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:181) > org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS"; SQL > statement: > drop TABLE T1; [50200-160] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > at org.h2.message.DbException.get(DbException.java:169) > at org.h2.message.DbException.get(DbException.java:146) > at org.h2.table.RegularTable.doLock(RegularTable.java:500) > at org.h2.table.RegularTable.lock(RegularTable.java:434) > at org.h2.engine.Database.lockMeta(Database.java:748) > at org.h2.command.ddl.DropTable.executeDrop(DropTable.java:102) > at org.h2.command.ddl.DropTable.update(DropTable.java:113) > at org.h2.command.CommandContainer.update(CommandContainer.java:73) > at org.h2.command.Command.executeUpdate(Command.java:219) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:300) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) > at java.lang.Thread.run(Unknown Source) > at org.h2.engine.SessionRemote.done(SessionRemote.java:538) > at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183) > at > org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:181) > > Regards, > Liu > > > > > At 2013-03-29 06:18:22,"Thomas Mueller" > <[email protected]<javascript:_e({}, 'cvml', > '[email protected]');>> > wrote: > > Hi, > > Maybe you are using an old version of H2? Could you post the complete > error message and the complete stack trace please? > > Regards, > Thomas > > > On Thursday, March 28, 2013, wrote: > >> My app uses H2 in this way: Every request in a unique thread, gets a new >> connection from h2 engine, to create memory local temporary table, insert, >> update and drop table, then closes the connection in finally code block. >> not always the error happens. Who can help me ? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:_e({}, > 'cvml', '[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
