Confluence 7.4.8 to 7.13.2 upgrading failed

Question

Confluence 7.4.8 to 7.13.2 failed to upgrade, please support.
After the upgrade, the message was successful, but the page could not be accessed.

Thank you.

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.DenormalisedSpacePermissionsUpgradeTask@4b355b4c failed during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [CREATE TRIGGER denormalised_space_trigger_on_update AFTER UPDATE ON SPACES FOR EACH ROW sp: BEGIN DECLARE isServiceDisabled BOOL DEFAULT TRUE; CALL space_procedure_for_denormalised_permissions(isServiceDisabled); IF (isServiceDisabled) THEN LEAVE sp; END IF; IF (NEW.LOWERSPACEKEY = OLD.LOWERSPACEKEY) THEN LEAVE sp; END IF; INSERT INTO DENORMALISED_SPACE_CHANGE_LOG(SPACE_ID) VALUES (NEW.SPACEID); END;]; SQL state [HY000]; error code [1419]; You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable); nested exception is java.sql.SQLException: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Fabian Lim · Accepted Answer

Hi @Alex

I would recommend to open a support ticket with atlassian instead for a faster response and follow up.  Link: https://support.atlassian.com/contact/

Regards

Cihan_3qchfs · Accepted Answer

Hello @Alex ,

If you are using MySQL, the error message may be related to the following:

*  Install/Upgrade Confluence 7.11+ fails with error - You do not have the SUPER privilege and binary logging is enabled - Confluence - Atlassian Documentation

The reason for this is that since Confluence 7.11 the following is required:

Confluence database user is not allowed to create and alter stored functions, because the parameter log_bin_trust_function_creators = 1 is missing from the [mysqld] section of the my.cnf file, as described in Database Setup For MySQL documentation.

The KB article above provides steps for you to fix this in both standalone MySQL or AWS RDS. Kindly review the document, and perform the changes needed, before attempting a new upgrade.

Regards,