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,296,603
Community Members
 
Community Events
165
Community Groups

cannot edit/create page anymore after upgrading to recent version

error:
content_procedure_for_denormalised_permissions does not exist

3 comments

context?

when click Create. it is ok to read existing pages, but not for editing, cannot save.

Capture.PNG

OK, you've run into a known problem in upgrading MySQL, and there's a one-off fix - see https://confluence.atlassian.com/confkb/confluence-mysql-database-migration-causes-content_procedure_for_denormalised_permissions-does-not-exist-error-1072474724.html

In the question you linked to, there's actually a second problem, in that the posters are mostly talking about Mariadb - while that mostly tends to work ok, it is not supported and should not be used for Confluence.  It often causes unfixable problems, especially during upgrades, and can lead people in circles when errors like this one happen, as they spend ages trying to use MySQL fixes which don't quite apply to Maria and hence don't work.

Hi, Nic,

Thanks for the info. I read that solution before, but I don't have old back up any more.
question:
- any way/script to fix the procedure issue?

- if I do the site backup, and restore to a new instance, is it ok?

Jing

It's not the application that is failing here, it's the database not meeting the needs of the application.  The database is also technically fine, it's just not capable of supporting the application in its current format.

You don't need a backup, you've got a perfectly valid database.  As the doc says, dump that out, and restore it, then reconnect Confluence.

why the solution(create procedures) delete?

or atlassian provide the way to re-create those missing procedures.

Because it's the database that is missing stuff, not the application.  Atlassian can't do it, the application needs the database to be reconfigured to support it and the data rebuilt to match the new configurations (restoring from the backup does that rebuild)

You can create the 5 missing procedures by executing this:

Note1: It has to be executed by a privileged user (root)

Note2: Replace my_user with your confluence database user

 

DELIMITER ;;
CREATE DEFINER=`my_user`@`%` PROCEDURE `content_permission_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `content_perm_set_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `content_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `space_permission_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `space_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

Like # people like this

I ran into this exact problem today and the above worked perfectly. Thanks @jblanco

Comment

Log in or Sign up to comment
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 . 🙋‍♀️ ...

1,038 views 18 28
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