[DOCU-2634] DOC: Add known issue page for H2 upgrade difficulties for 6.2.27 Created: 28/Dec/22  Updated: 28/Dec/22  Resolved: 28/Dec/22

Status: Closed
Project: Documentation
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Neutral
Reporter: Adrian Brooks Assignee: Adrian Brooks
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Template:
Acceptance criteria:
Empty
Task DoR:
Empty

 Description   

Problem: Upgrading doesn't work exactly as per the H2 official upgrade documentation here.

Fix: Document Mika's finding here on a known issues page for 6.2.27. In particular:

  • the JDBC URL is relative to workspace home, so there is one DB per workspace to backup/restore
    jdbc:h2:~/Downloads/tmp-h2/apache-tomcat/webapps/magnoliaAuthor/repositories/magnolia/workspaces/website/db
    
  • the Jackrabbit version DB needs to be included as well
  • Use Mika's groovy scripts to iterate over workspaces + version db, see https://gist.github.com/mkgl/4c7b99426393f19843b8e36dd784293e
  • Or Rico's bash version here

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