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]> 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]. 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]. 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.
