Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20254

Zabbix problem with Percona XtraDB Cluster

    XMLWordPrintable

Details

    • Problem report
    • Resolution: Duplicate
    • Trivial
    • None
    • 5.4.6
    • None

    Description

      Hi,

      I'm trying to use latest version of Zabbix with Percona XtraDB Cluster for MySQL 5.7.x.
      To my regret, such a combination does not work. Since percona as well as some other cluster systems when working in enforcing mode require that all tables have primary keys, and that is not case with Zabbix.

      2021-11-22T12:44:39.893391Z 56545 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits use of DML command on a table (zabbix.history) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
      2021-11-22T12:44:39.894436Z 56546 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits use of DML command on a table (zabbix.history_uint) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER

      Would adding artificial primary keys to these tables affect the operation of Zabbix, also does Zabbix have some solution for this?

      Something for other software I have found on other forum:
      This problem affects any type of MySQL cluster, not only Percona. Galera (default for MariaDB) or MySQLCluster are also affected. Products Like SkySQL or managed DBs like DigitalOcean, Scaleway, etc, all cluster based, are problematic.

      So please Zabbix crew add primary keys to all tables.

      Attachments

        Issue Links

          Activity

            People

              zabbix.support Zabbix Support Team
              zemzema zemzema
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: