Incorrect definition of table mysql.proc

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Restoring all databases from MariaDB 10 to Percona Xtradb Cluster, I saw an error on mysql.log on one of db nodes as below

[ERROR] Incorrect definition of table mysql.proc: expected column ‘definer’ at position 11 to have type char(77), found type char(141).

percona-xtradb-cluster-galera-3.x
3.9.3494.trusty

Do I simply change char(77) to char(141) on one of the node or there’s a few extra steps?

2

Hi umarzuki,
It seems like MariaDB’s system tables are not compatible with Percona XtraDB Cluster. I would advise instead to reload your dump of all the data from mysqldump, but do not include the mysql database.

3

How do I do that?

Delete mysql db then restore from mysql db backup from another percona server?

4

You can either create a new dump taken from the MariaDB 10 cluster node excluding the ‘mysql’ database. Use either of the following workaround:
[url]http://datacharmer.blogspot.com/2012/04/few-hacks-to-simulate-mysqldump-ignore.html[/url]
[url]http://ronaldbradford.com/blog/i-want-a-mysqldump-ignore-database-option-2012-04-18/[/url]

OR

Using your existing mysqldump file (if you have the latest one), use an open source tool - mysqldumpsplitter, to ‘split’ the dump file and only extract the databases you need to reload to the new cluster.
[url]https://github.com/kedarvj/mysqldumpsplitter[/url]

You could try to do an ALTER TABLE on mysql.proc and see if that works.