mariadb10.1 to percona 5.7 upgrade failed
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
New
|
Undecided
|
Muhammad Irfan | ||
Bug Description
Hello,
Scenario:
mariadb-10.1.14 upgrade to Percona-
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
| affects: | percona-server → percona-xtradb-cluster |
| Changed in percona-xtradb-cluster: | |
| assignee: | nobody → Muhammad Irfan (muhammad-irfan) |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/