Thanks for the response. Our system supports exporting (and subsequently importing) a "subsystem" including its database in either raw or SQL formats. So I did this and that does resolve the issue. But I must add that importing a subsystem that was exported in SQL format automatically results in a MVStore database. So by doing this I silently converted the PageStore database to a MVStore one.
HOWEVER: our production environments consist of tens to hundreds of subsystems (users create these from the application by copying template definitions) with databases ranging from a couple of MBs totens of GBs. That means it is not practically feasible to do conversions across all databases. That is why backward compatibility is extremely important to us. H2 automagically recognizes and correctly handles old PageStore databases while allowing us to use MVStore databases for all new definitions (we converted most templates to MVStore). Swapping out the H2 versions is now no longer possible if it requires converting. That will take hours at least. We can not do it lazily since we need to provide sub-second responsiveness. Can this be narrowed down to a more specific subset like affected column types or so? Anything that makes a conversion batch more manageable? Kind regards, Silvio On Wednesday, 22 August 2018 13:49:59 UTC+2, Evgenij Ryazanov wrote: > > For information: > > The only one reliable way to upgrade from 1.4.196 to a more recent version > is to run SCRIPT TO 'filename.sql' in this version, then create a new empty > database in a new version and finally run RUNSCRIPT FROM 'filename.sql'. > > Script tool from 1.4.196 and RunScript from 1.4.197 can be also used, > result will be the same: > http://h2database.com/html/tutorial.html#upgrade_backup_restore > > Not all old databases are affected. The common source of problems is ALTER > TABLE command that was used in 1.4.196 or in an older version. > > > Your problem, however, may be unrelated. > -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
