I have a DB created with older version 1.4.96 and we've upgraded to 1.4.99. When altering a table to drop a column, it cause table to be renamed, to something like <table>_COPY_##_## where ## is a number. Once this happens, it get DB to a corrupted state and it is no longer usable. Is this a known issue? Is there a workaround?
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "DEPLOYMENT_SPEC" not found; SQL statement: ALTER TABLE deployment_spec DROP COLUMN vlan_pool_fk [42102-199] at org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.get(DbException.java:205) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.get(DbException.java:181) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.tableIfTableExists(Parser.java:7497) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parseAlterTable(Parser.java:7307) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parseAlter(Parser.java:6546) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parsePrepared(Parser.java:828) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parse(Parser.java:788) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parse(Parser.java:760) ~[factory.jar:sxrel2.0] at org.h2.command.CommandContainer.recompileIfRequired(CommandContainer.java:108) ~[factory.jar:sxrel2.0] at org.h2.command.CommandContainer.update(CommandContainer.java:128) ~[factory.jar:sxrel2.0] at org.h2.command.Command.executeUpdate(Command.java:267) ~[factory.jar:sxrel2.0] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233) ~[factory.jar:sxrel2.0] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205) ~[factory.jar:sxrel2.0] -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f4a9a286-5773-4034-a3d3-3cbd8feb6e92%40googlegroups.com.
