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

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Summary

Upon installing or upgrading your Confluence server to 7.11+, using MySQL 8, the installation/upgrade fails with the following error:

atlassian-confluence.log
2021-02-06 20:58:24,363 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DenormalisedSpacePermissionsUpgradeTask@c8e620 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;You do not have the SUPER privilege and binary logging is enabled 
   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)
com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DenormalisedSpacePermissionsUpgradeTask@c8e620 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)


Environment

  • Confluence Server or Data Center 7.11+
  • MySQL 8

Diagnosis

On the import of the function or trigger to MySQL database, the following error arises:

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)

Cause

The cause is still unclear and we’re working to provide additional details about it

Solution

To allow the installation/upgrade to complete successfully, we need to specify the following parameter under the [mysqld] section of the my.cnf file, as follows:

  1. Stop Confluence
  2. Stop the MySQL database
  3. Specify the below parameter under [mysqld] in your my.cnf file:

    log-bin-trust-function-creators = 1
  4. Start the MySQL database again.
  5. Start Confluence again.
Last modified on May 4, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.