Not the answer you need?
Register and ask your own question!

pmp-check-mysql-status vs. percona-xtradb-cluster-57 = ERROR 1682

serser EntrantInactive User Role Beginner
Hi, I am not able to get results from monitoring. How can I fix it?

# /usr/lib64/nagios/plugins/pmp-check-mysql-status -x wsrep_cluster_size -C '<=' -w 2 -c 1
ERROR 1682 (HY000) at line 1: Native table 'performance_schema'.'global_variables' has the wrong structure
UNK could not get MySQL status/variables.

# dpkg -l|grep perc
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
ii percona-nagios-plugins 1.1.7-2.xenial all Percona Monitoring Plugins for Nagios
ii percona-release 0.1-4.xenial all Package to install Percona gpg key and APT repo
ii percona-xtrabackup-24 2.4.7-2.xenial amd64 Open source backup tool for InnoDB and XtraDB
hi percona-xtradb-cluster-57 5.7.18-29.20-1.xenial amd64 Percona XtraDB Cluster with Galera
hi percona-xtradb-cluster-client-5.7 5.7.18-29.20-1.xenial amd64 Percona XtraDB Cluster database client binaries
hi percona-xtradb-cluster-common-5.7 5.7.18-29.20-1.xenial amd64 Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
hi percona-xtradb-cluster-server-5.7 5.7.18-29.20-1.xenial amd64 Percona XtraDB Cluster database server binaries

Yes, I had run mysql_upgrade.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.