load data error if use OceanBase as zabbix DB backend

XMLWordPrintable

    • Type: Problem report
    • Resolution: Fixed
    • Priority: Trivial
    • None
    • Affects Version/s: 6.2.3
    • Component/s: Installation (I)
    • None
    • Environment:
      zabbix 6.2.3 + OceanBase 4.0

      Steps to reproduce:

      • Load schema.sql into zabbix database use mysql;
      • When creating trigger `hosts_insert` in line 2119, get errorĀ 

      • But create another trigger `items_insert` is ok

      • Final I find because `hosts` is a keyword in oceanbase

      Expected:

      • Change this table name

        1. error1.jpg
          error1.jpg
          59 kB
        2. error2.jpg
          error2.jpg
          48 kB
        3. error3.jpg
          error3.jpg
          128 kB

            Assignee:
            Zabbix Support Team
            Reporter:
            zhangxin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: