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.
