Hi, > Timeout trying to lock table SYS [HYT00-60]
That would mean you are using H2 version 1.0.60, from 2007-10-20. I suggest to update to a recent version of H2. Regards, Thomas On Monday, June 25, 2012, Ryan wrote: > Hello, > > I'm trying to add an ID column to my database without creating a new > database (because it's a user database for an MMO, which has lots of users > registered). I had one before, but I deleted it because it wasn't going in > order (instead of 1,2,3, it went 1,003,930,etc.) but I need to add another > one. My code is: > > ALTER TABLE USERS > ADD COLUMN ID INT IDENTITY(1,1) NOT NULL; > > But I keep getting this error: > > > Timeout trying to lock table SYS [HYT00-60] > org.h2.jdbc.JdbcSQLException: Timeout trying to lock table SYS [HYT00-60] > at org.h2.message.Message.getSQLException(Message.java:84) > at org.h2.message.Message.getSQLException(Message.java:88) > at org.h2.message.Message.getSQLException(Message.java:66) > at org.h2.table.TableData.lock(TableData.java:357) > at org.h2.engine.Database.removeMeta(Database.java:650) > at org.h2.engine.Database.update(Database.java:1022) > at org.h2.schema.Sequence.flush(Sequence.java:95) > at org.h2.schema.Sequence.getNext(Sequence.java:79) > at org.h2.expression.SequenceValue.getValue(SequenceValue.java:27) > at org.h2.table.Column.validateConvertUpdateSequence(Column.java:161) > at org.h2.table.Table.validateConvertUpdateSequence(Table.java:313) > at org.h2.command.dml.Insert.update(Insert.java:110) > at > org.h2.command.ddl.AlterTableAlterColumn.execute(AlterTableAlterColumn.java:326) > > at > org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:274) > > at > org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:121) > > at org.h2.command.CommandContainer.update(CommandContainer.java:64) > at org.h2.command.Command.executeUpdate(Command.java:123) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156) > at org.h2.server.web.WebThread.getResult(WebThread.java:1387) > at org.h2.server.web.WebThread.query(WebThread.java:1049) > at org.h2.server.web.WebThread.process(WebThread.java:375) > at org.h2.server.web.WebThread.processRequest(WebThread.java:131) > at org.h2.server.web.WebThread.run(WebThread.java:158) > > Any help is appreciated. > > -- > 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/-/NdJA91pkLMwJ. > 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.
