Data roll back

[ZhaoChunsheng]

I encountered an error during the upgrade from 7.19.12 to 8.5. During the upgrade process, I made a backup of the files according to the upgrade prompt, but I did not make a backup of the database. I now want to roll back to 7.19.12 as soon as possible and restore the service as soon as possible. How can I achieve this?

The following files were automatically backed up during the installation process:

/opt/atlassian/confluence
/var/atlassian/application-data/confluence

And, this is error log:

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.DenormalisedPermissionsTriggersUpgradeTask@25a5e7bb failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [DROP PROCEDURE IF EXISTS space_permission_procedure_for_denormalised_permissions;]; nested exception is java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ZhaoChunsheng]

Solved:

grant system_user on confluence_db.* to 'confluenceuser'@'localhost';