Cannot get MySQL var character_set_server

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello!!

After I updated the server packages to percona-toolkit-3.5.5-1.el8.x86_64 I am not start the pt-kill daemon.

I am getting this error:

Cannot get MySQL var character_set_server: DBD::mysql::db selectrow_array failed: Native table ‘performance_schema’.‘session_variables’ has the wrong structure [for Statement “SHOW VARIABLES LIKE ‘character_set_server’”] at /usr/bin/pt-kill line 2165.

This is all the packages:
percona-toolkit-3.5.5-1.el8.x86_64
percona-release-1.0-27.noarch
Percona-XtraDB-Cluster-shared-57-5.7.43-31.65.1.el8.x86_64
Percona-XtraDB-Cluster-57-5.7.43-31.65.1.el8.x86_64
percona-xtrabackup-24-2.4.28-1.el8.x86_64
Percona-XtraDB-Cluster-client-57-5.7.43-31.65.1.el8.x86_64
Percona-XtraDB-Cluster-server-57-5.7.43-31.65.1.el8.x86_64

Any help about it ?

Thank you.

2

You need to run mysql_upgrade to fix the tables and then restart MySQL. Looks like you upgraded MySQL recently and forgot to run this required tool.

3

Hi @matthewb.
Please explain:

  • this command must be run in each node running XtraDB or can it be in just one?
  • after do that, restart all instances?
    Thank you.
4

Best practice: Shut down all but 1 node. mysql_upgrade 1 node. Restart node. Start other node, letting it SST/IST. Start last node.