Details
-
Bug
-
Status: Done
-
Low
-
Resolution: Invalid
-
None
-
None
-
None
Description
**Reported in Launchpad by Proskurin Kirill last update 13-10-2017 05:46:52
Hello,
Scenario:
mariadb-10.1.14 upgrade toPercona-XtraDB-Cluster-5.7.19-rel17-29.22.1
Both deployed via tars, not packages. OS: Centos 7.3 x64
1) Shutdown Maria
2) Deploy Percona
3) Start Percona
4) Run mysql_ugrade
5) Get the following error
"mysql_upgrade: (non fatal) [ERROR] 1728: Cannot load from mysql.proc. The table is probably corrupted
mysql_upgrade: (non fatal) [ERROR] 1545: Failed to open mysql.event"
6) Restart Percona
7) Try to do some user manipulations(in my case - remove test user via ansible) and get the
"Column count of mysql.user is wrong. Expected 45, found 48."
Additionally, "sys" database can't be created via mysql_upgrade, with the following error:
"Upgrading the sys schema.
mysql_upgrade: [ERROR] 1136: Column count doesn't match value count at row 1"
Probably because the same problem with mysql.user