1.4.196 and older versions have a problem with some constraints. This issue was fixed in 1.4.197, but the fix isn't fully compatible with older databases. Execution of DDL command in 1.4.197 in the database that was initially created by some older version may corrupt a database. This issue was fixed for default MVStore engine and wasn't fixed for legacy PageStore engine (there is a separate issue on GitHub for it).
I suggest you to use the recommended way to upgrade your databases. 1. Execute a SCRIPT TO 'filename.sql' command with old version of H2. 2. Create a new empty database with a new version of H2 and execute a RUNSCRIPT FROM 'filename.sql' You can also use the Java tools as described in the documentation: https://h2database.com/html/tutorial.html#upgrade_backup_restore Usually it's not really required and database can be used as it, but due to large amount of changes in recent releases it's much safer to use the recommended way. If you don't have a backup copy you can add SET_EVENT_LISTENER parameter to the connection URL: https://h2database.com/html/commands.html#set_database_event_listener The listener must implement org.h2.api.DatabaseEventListener interface. With such listener some exceptions can be ignored. You need to check a content of the database with H2 Console and fix the problems. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/7d35d455-f1ae-4a77-8c59-d5740b0c92f1%40googlegroups.com.
