Can't edit my pages or edit any thing! Emergency help!

Question

I have updated my confluence to 7.11.0

Collaborative editing is on!

Everything work ok! But I can't edit my pages; I get this problem!

Cause

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute statement; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE confluence.content_procedure_for_denormalised_permissions does not exist
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)

caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE confluence.content_procedure_for_denormalised_permissions does not exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Please help me how to solve the problem because I need to change sensitive information on my site otherwise it will cost me alot if not changed!

Jing Kang · Answer

solution -->

https://community.atlassian.com/t5/Confluence-discussions/cannot-edit-create-page-anymore-after-upgrading-to-recent/td-p/1777465#U1777901

Jing Kang · Answer

please provide a way to recreate the procedure.

Netset_7s02o1 · Answer

Note: If I upgrade from 7.10.2 to 7.11.0 with mariadb (not in docker) it works fine.

If I take backup  from the upgraded version from mariadb and restore it to mysql (in docker)

then confluence 7.11.0 works fine (Confluence with DB in mysql docker)