Buy Percona ServicesBuy Now!

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    Thank you for sharing
    Trang chủ Công ty xuất khẩu lao động Nhật Bản uy tín hàng đầu Việt Nam với 10 năm kinh nghiệm- LƯƠNG CAO, xuất cảnh NHANH, KHÔNG phí môi giới

    Comment

    Working...
    X