nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

problem after upgrade from 6.15.2 to 7.13.7

Miodrag Vlahović_p5ggau

Hello,

So, we did the upgrade of Confluence from version 6.15.2 to 7.13.7 according to documentation with installer. After the upgrade we can't access our confluence instance anymore. We are using CentOS7 with MySQL version 5.7.38.

Instead of seeing login screen we are getting this 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@475dfaba failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [DROP PROCEDURE IF EXISTS space_permission_procedure_for_denormalised_permissions;]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: alter routine command denied to user 'user'@'localhost' for routine 'confluencedb.space_permission_procedure_for_denormalised_permissions'

We have checked the grants on the database and the user has all grants on confluence database.

Can You help us resolve this issue, what could be the problem? We will provide any other info which could help solving this problem.

Regards!

Accepted answers

Fabio Racobaldo _Catworkx_

Hi @Miodrag Vlahović ,

welcome to the Atlassian community!

Please, could you specify the DBMS used by your Confluence? Are u sure that that DBMS is a supported one as specified in this article https://confluence.atlassian.com/conf713/supported-platforms-1077914838.html ?

Fabio

All comments

Fabio Racobaldo _Catworkx_

Hi @Miodrag Vlahović ,

welcome to the Atlassian community!

Fabio

Miodrag Vlahović_p5ggau

Hi @Fabio Racobaldo _Catworkx_

By DBMS you mean which database we use? As I specified in the first post, we are using mysql 5.7.38, and mysql 5.7 has a green check so i think we are good here.

I have to say, we migrated from mariadb to mysql due to mariadb being unsupported, but after database migration the confluence was running normally (we could see the login page without the error). Everything was fine until the upgrade of confluence to new LTS version.

Regards!

Fabio Racobaldo _Catworkx_

Sorry @Miodrag Vlahović , I missed that information.

It seems an issue at grants level.

Please try :

<span style="border: 0px; margin: 0px; padding: 0px;">GRANT</span> <span style="border: 0px; margin: 0px; padding: 0px;">ALL</span> <span style="border: 0px; margin: 0px; padding: 0px;">ON</span> <span style="border: 0px; margin: 0px; padding: 0px;">*</span>.<span style="border: 0px; margin: 0px; padding: 0px;">*</span> <span style="border: 0px; margin: 0px; padding: 0px;">TO</span> <span style="border: 0px; margin: 0px; padding: 0px;">'user'</span>@<span style="border: 0px; margin: 0px; padding: 0px;">'localhost'</span> IDENTIFIED <span style="border: 0px; margin: 0px; padding: 0px;">BY</span> <span style="border: 0px; margin: 0px; padding: 0px;">'YOUR_USER_PWD_HERE'</span>;
FLUSH PRIVILEGES;

Please let me know if you already performed this check.

Fabio

Miodrag Vlahović_p5ggau

We did this steps already but on the confluence database only, here is the output:

mysql> grant all privileges on confluencedb.* to 'user'@'localhost' identified by 'xxxxxxxxxxx';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for 'user'@'localhost'
-> ;
+--------------------------------------------------------------------+
| Grants for user@localhost |
+--------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user'@'localhost' |
| GRANT ALL PRIVILEGES ON `confluencedb`.* TO 'user'@'localhost' |
+--------------------------------------------------------------------+
2 rows in set (0.00 sec)

Still no luck after that. Do You think it is necessary to grant all privileges on all databases?

Regards!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

upgrade

database