Unable to upgrade Confluence from 5.7 to 6.7

[Andrew Striletskyi]

Hello everyone. I have some problems with upgrade my Confluence application. All problems with database. We use MySQL 5.7.* . And also I have the following problem

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@dcc4d8b failed during the SCHEMA_UPGRADE phase due to: null

[AnnWorley]

Hi Andrew,

The error you posted is similar to the one in this article: Upgrading to Confluence 5.9.x or higher version fails with error 'failed during the SCHEMA_UPGRADE phase due to: null'

Basically a foreign key constraint is missing so the upgrade task is seeing "null" where that constraint is expected. The article has some SQL queries that should fix it.

Please:

1. Restore the database and home directory from backup so your previous instance is back online.
2. Add the foreign key constraint.
3. Try the upgrade again.

Thanks,

Ann