[MAGNOLIA-8638] Getting h2 error while upgrading 6.2.10 to latest version Created: 17/Nov/22  Updated: 08/Dec/22  Resolved: 22/Nov/22

Status: Closed
Project: Magnolia
Component/s: None
Affects Version/s: 6.2.27
Fix Version/s: None

Type: Bug Priority: Blocker
Reporter: Lam Nguyen Bao Assignee: Federico Grilli
Resolution: Resolved Votes: 0
Labels: None
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: Not Specified Time Spent: Not Specified
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: HTML File error    
Issue Links:
dependency
is depended upon by CONTEDIT-487 MigrateBlockToIntermediateParentTask ... Closed
relation
is related to MAGNOLIA-8307 Upgrade from H2 1.4 to 2.1 throws Jdb... Closed
is related to BUILD-960 Update h2 db to version 2.1.x Closed
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MAGNOLIA-8643 Investigate issue Sub-task Completed Federico Grilli  
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[X]* Steps to reproduce, expected, and actual results filled
[X]* Affected version filled
Date of First Response:
Team: Foundation

 Description   

Steps to reproduce

  • Start fresh install using dx-core demo 6.2.10 
  • Try to upgrade to latest version (6.2-SNAPSHOT) 

Expected results

Able to start the instance without errors

Actual results

Errors cause and can not start



 Comments   
Comment by Mikaël Geljić [ 21/Nov/22 ]

via GitHub issue #3214

The best, in fact the only way, is to export your database into a SQL script using version 1.4.200 (or whatever version you were using), then create a new database using version 2.0.202 and run that SQL script in there.

The only supported way was always the same:
https://h2database.com/html/tutorial.html#upgrade_backup_restore

=> Backup:

java org.h2.tools.Script -url jdbc:h2:~/test -user sa -script test.zip -options compression zip

Restore (with file coming from 1.4.200 or lower):

java org.h2.tools.RunScript -url jdbc:h2:~/test -user sa -script test.zip -options compression zip variable_binary
Comment by Richard Gange [ 21/Nov/22 ]

Maybe this MAGNOLIA-8307

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