Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,767
Community Members
 
Community Events
165
Community Groups

Error after upgrading to 7.13.7 from 7.4.11

Hi. 

After upgrading we get this message below. Any suggestions what to do?

We have updated all files needed, server.xml etc, and the server seems to be ok. The database is hosted on another server, Mysql. Connection to this on is ok, using 8.0.18 connector.

Error:

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@6d913f37 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)

Thanks for any suggestions!

Best Regards
Frode Aasegaard
Senior Adviser IT
Norsk Helsearkiv ARKIVVERKET
IT og Helsearkivregisteret
mobile: 922 17 650
www.norskhelsearkiv.no

 

 

2 answers

2 accepted

1 vote
Answer accepted

This looks like the database user you are using does not have the rights it needs to do the upgrade, or that your database is incorrectly configured.

Traffic seems to run as expected from app-server to db-server. But the rights for the db user is something we need to check. 

Thanks!

0 votes
Answer accepted

Yes, I found this yesterday, and it seems like the same issue. 

It worked fine after adding the  SUPER privilege to the user.

Thanks!

Like Srinatha T likes this
Srinatha T Atlassian Team Jun 13, 2022

Glad to hear that its resolved after adding super user privilege. I also want to share a KB article which has some troubleshooting steps .

Error-you-do-not-have-the-super-privilege-and-binary-logging-is-enabled 

Thanks,

Srinath T

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

956 views 15 27
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you