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

linking templates creates a bad database structure

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.0.0
    • 1.9.3 (alpha)
    • Frontend (F)

      Create template T2, template T1, and host H. Link T1 to H. Create an item on T2. Link T2 to T1. Observe a bad database structure.

      mysql> select h.hostid, h.host, itemid, i.name, key_, templateid from hosts h, items i where key_='agent.version' and h.hostid=i.hostid;
      ---------------------------------------------------------------------------------------------------+

      hostid host itemid name key_ templateid

      ---------------------------------------------------------------------------------------------------+

      20 Another Template Level 1 85 agent version agent.version 84
      19 Another Template Level 2 84 agent version agent.version NULL
      21 Another Template Linking Host 86 agent version agent.version 84

      ---------------------------------------------------------------------------------------------------+
      3 rows in set (0.00 sec)

      Note that both H's (hostid=21) and T1's (hostid=20) items refers to T2's (hostid=19) item in "templateid" column.

            Unassigned Unassigned
            asaveljevs Aleksandrs Saveljevs
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: