#518 Error after upgrade to 3.15.00

[Anonymous]

Originally created by: RSCCD-JeremyCollins

After upgrade from 3.14.00 to 3.15.00 following the procedure in the release notes, I get a 503 error in the browser. The logs have a message "org.h2.mvstore.MVStoreException: The write format 2 is smaller than the supported format 3 [2.2.220/5]" which Google tells me is a H2 DB wrong version message. I'm guessing there was a H2 DB format change from in H2 between 2.1.210 and 2.2.220 that the bastillion-upgrade-4.00.01.jar isn't upgrading far enough to make version 2.2.220 work.

[Anonymous]

Originally posted by: skavanagh

Jeremy - There is a migration tool mentioned that you might want to try https://www.h2database.com/html/migration-to-v2.htmlSent from my iPhoneOn Aug 28, 2023, at 5:15 PM, RSCCD-JeremyCollins @.***> wrote:
After upgrade from 3.14.00 to 3.15.00 following the procedure in the release notes, I get a 503 error in the browser. The logs have a message "org.h2.mvstore.MVStoreException: The write format 2 is smaller than the supported format 3 [2.2.220/5]" which Google tells me is a H2 DB wrong version message. I'm guessing there was a H2 DB format change from in H2 between 2.1.210 and 2.2.220 that the bastillion-upgrade-4.00.01.jar isn't upgrading far enough to make version 2.2.220 work.

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

[Anonymous]

Originally posted by: tswestendorp

@RSCCD-JeremyCollins have you been able to fix the 503? If so, do you remember what you did to fix it?

[Anonymous]

Originally posted by: Vertganti

@skavanagh The H2 developers increased the database format version once more for H2 version 2.2.220+ (see the corresponding PR). Since the 3.15.00 release of Bastillion contains the update to H2 2.2.220, updating Bastillion will once again require a database migration. The bastillion-upgrade-4.00.01.jar only supports database migrations from write format 1 (H2 pre v2) to write format 2 (H2 2.0.X and 2.1.X). The page you linked only concerns updates from write format 1 to write format 2 too. The new write format is 3, as can be seen from the error message:

org.h2.mvstore.MVStoreException: The write format 2 is smaller than the supported format 3 [2.2.220/5]

The migration tool should support upgrading to the new write format, but I could not get it to work. Would it be possible for you to update the bastillion-upgrade tool to support upgrading to the new write format? As far as I understand the process should stay the same - export with old driver and import with new driver, right?

On another note: H2 2.2.220 apparently had a race condition which could cause DB corruption - this was fixed in 2.2.222. H2 2.2.222 had a performance regression fixed in 2.2.224. I don't know if these issues affect the Bastillion DB, but it might be better to update H2 to 2.2.224 to be on the safe side.