mariadb10.1 to percona 5.7 upgrade failed

[Proskurin Kirill]

Hello,

Scenario:
mariadb-10.1.14 upgrade to Percona-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

Related: https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/48583-column-count-of-mysql-user-is-wrong-expected-45-found-48

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-2008