Zabbix agent 2 mysql plugin use old syntax for replication checking

XMLWordPrintable

    • Type: Problem report
    • Resolution: Duplicate
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: Agent2 plugin (G)
    • None

      Steps to reproduce:

      use zabbix with mysql 8.4 and run

      zabbix_agent2 -t mysql.replication.get_slave_status

      Result:
      mysql.replication.get_slave_status            [m|ZBX_NOTSUPPORTED] [Cannot fetch data: Cannot fetch data: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1.]

      Expected:

      'show slave status' deprecated ( https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/show-replica-status.html ) and removed in mysql 8.4. Plugin should use 'show replica status' for mysql 8.0 or recent.

            Assignee:
            Zabbix Development Team
            Reporter:
            Neo Lip
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: