Getting h2 error while upgrading 6.2.10 to latest version (MAGNOLIA-8638)

[MAGNOLIA-8643] Investigate issue Created: 21/Nov/22  Updated: 22/Nov/22  Resolved: 21/Nov/22

Status: Completed
Project: Magnolia
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Sub-task Priority: Neutral
Reporter: Federico Grilli Assignee: Federico Grilli
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Template:
Team: Foundation

 Description   
2022-11-21 16:56:33,309 ERROR org.apache.jackrabbit.core.RepositoryImpl         : failed to start Repository: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.H2PersistenceManager
javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.pool.H2PersistenceManager
[...]

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unsupported database file version or invalid file header in file "/Users/fgrilli/devel/throwaway/update-magnolia/magnolia-dx-core-demo-6.2.10/apache-tomcat-9.0.43/webapps/magnoliaAuthor/repositories/magnolia/version/db.mv.db" [90048-214])

I can confirm the issue with h2 db version 2.1.214 coming with JackRabbit (see BUILD-936) when updating from an earlier Magnolia version. Not detected by migration tests as they use the embedded derby db.
h2 embedded db isn't meant for production, still it is used for development (and evaluation) purposes, so perhaps we'd better not introduce this potentially breaking change, especially for devs, in an incremental release.
I would therefore revert the update, at least in 6.2 release branch.


Generated at Mon Feb 12 04:34:30 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.