Confluence backup Fail

[Erich Mauerböck]

I seem to be stuck with the h2 database which is already ~3GB. I wanted to migrate to a MS SQL database, but the backup fails:

2019-04-26 17:17:50,194 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Backward compatibility for export: Checking...
2019-04-26 17:17:50,196 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7400: "Upgrade to build number: 7400" - Ok
2019-04-26 17:17:50,197 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7202: "Remove the legacy Plugin License Storage plugin from the user installed plugins" - Ok
2019-04-26 17:17:50,198 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7201: "Upgrade to build number: 7201" - Ok
2019-04-26 17:17:50,198 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7110: "Reindex all blogs." - Ok
2019-04-26 17:17:50,199 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7109: "Drop and update some low performance indexes on EVENTS table for Synchrony" - Ok
2019-04-26 17:17:50,199 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7108: "Update index sp_comp_idx when the definition is not correct" - Ok
2019-04-26 17:17:50,200 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7106: "Drop the hibernate 2 constraints in preparation for them to be re-created in the hibernate 5 naming style" - Ok
2019-04-26 17:17:50,201 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7105: "Drop or update some low performance indexes on CONTENT" - Ok
2019-04-26 17:17:50,201 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7104: "Set the mime type for csv files to text/csv" - Ok
2019-04-26 17:17:50,202 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7101: "Migrate over Documentation theme settings to Custom Page Settings in the default theme" - Ok
2019-04-26 17:17:50,205 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6439: "Reindexes all PersonalInformation objects, creating them for any users that do not have one." - Ok
2019-04-26 17:17:50,205 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6430: "Upgrade to build number: 6430" - Ok
2019-04-26 17:17:50,208 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6424: "Adds missing multi-column unique constraints to the Crowd database tables" - Ok
2019-04-26 17:17:50,211 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6423: "Cleaning data that violates constraints we want to add in the next migration task" - Ok
2019-04-26 17:17:50,212 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6422: "Upgrade to build number: 6422" - Ok
2019-04-26 17:17:50,216 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6412: "Delete all FileStore IDs" - Ok
2019-04-26 17:17:50,217 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6406: "Reindex all spaces" - Ok
2019-04-26 17:17:50,218 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6403: "Upgrade to build number: 6403" - Ok
2019-04-26 17:17:50,218 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6193: "Rebuild the Confluence favourites index" - Ok
2019-04-26 17:17:50,219 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6193: "Rebuild the Confluence favourites index" - Ok
2019-04-26 17:17:50,219 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6189: "Upgrade to build number: 6189" - Ok
2019-04-26 17:17:50,222 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6180: "Adds a multi-column index to content table that speeds up many common queries." - Ok
2019-04-26 17:17:50,222 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6175: "Upgrade to build number: 6175" - Ok
2019-04-26 17:17:50,223 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6169: "Upgrade to build number: 6169" - Not Ok
2019-04-26 17:17:50,223 INFO [http-nio-8090-exec-5] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Backward compatibility for export: "Upgrade to build number: 6169" prevents compatibility before 6169
2019-04-26 17:17:55,057 ERROR [http-nio-8090-exec-5] [engine.jdbc.spi.SqlExceptionHelper] logExceptions General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
select auditrecor0_.AUDITRECORDID as col_0_0_ from AUDITRECORD auditrecor0_ [50000-176]
-- url: /admin/dobackup.action | traceId: 44e93ac1a111cee1 | userName: XXXXXXX | referer: https://XXXXXXX/admin/backup.action | action: dobackup
2019-04-26 17:17:55,119 ERROR [http-nio-8090-exec-5] [confluence.importexport.impl.AbstractXmlExporter] backupEntities Couldn't backup database data.
-- url: /admin/dobackup.action | traceId: 44e93ac1a111cee1 | userName: XXXXXXX | referer: https://XXXXXXX/admin/backup.action | action: dobackup
org.springframework.orm.hibernate.HibernateSystemException: Transaction was marked for rollback only; cannot commit; nested exception is net.sf.hibernate.TransactionException: Transaction was marked for rollback only; cannot commit

Previous working backups could not be restored correctly, spaces were missing afterwards.

Any chance to not lose my content?

Erich