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

Item prototypes with LowID are not shown when creating a graph prototype

    XMLWordPrintable

Details

    Description

      Client had a number of graph prototypes with HighID.
      The node-based system (2.0) was converted to nodeless (2.2.4).
      Client added new item prototype with LowID.

      When trying to create a graph prototype, the newly added item prototype is not shown in the list.

      Debug shows the following query:

      SQL (0.207164): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status IN (0,1,3) AND g.groupid BETWEEN 100000000000000 AND 199999999999999
      popup.php:388 ? CPageFilter->__construct() ? CPageFilter->_initGroups() ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHostGroup->get() ? DBselect() in /slpzxs03/appli/ihs/data/web/apache2_zabbix_php/crt.2.2.4/api/classes/CHostGroup.php:351
      
      
      SQL (0.003619): SELECT DISTINCT id.parent_itemid,i.* FROM items i,item_discovery id WHERE i.flags=2 AND id.parent_itemid='100100001519846' AND i.itemid=id.itemid AND i.value_type IN ('0','3') AND i.itemid BETWEEN 100000000000000 AND 199999999999999
      popup.php:1282 ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CItemPrototype->get() ? DBselect() in /slpzxs03/appli/ihs/data/web/apache2_zabbix_php/crt.2.2.4/api/classes/CItemPrototype.php:247
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            filipp.sudanov Filipp Sudanov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: