[h2] Re: Table not found after ALTER table - leftover "_COPY_" table

2021-03-01 Thread jackp...@gmail.com
Hi, just wondered if there were any more thoughts? On Thursday, 4 February 2021 at 16:04:58 UTC jackp...@gmail.com wrote: > Apologies, I had already tried this in the environment the database was > created with, using H2 1.4.199 and got the following error: > 2021-01-25 14:57:04,226 E

[h2] Re: Table not found after ALTER table - leftover "_COPY_" table

2021-02-04 Thread jackp...@gmail.com
Apologies, I had already tried this in the environment the database was created with, using H2 1.4.199 and got the following error: 2021-01-25 14:57:04,226 ERROR main h2database - mydatabase:database opening mydatabase org.h2.message.DbException: Table "FRUITS" not found [42102-199] at

[h2] Table not found after ALTER table - leftover "_COPY_" table

2021-02-04 Thread jackp...@gmail.com
I have an application that uses H2 v1.4.199, with versioning provided by Flyway. For roughly 25% of the users, this migration ends up in an unusual state. The migration is performing a number ALTER TABLE commands (typically dropping columns) on one database (lets call the table "fruits"). When