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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 2.2.4
    • Fix Version/s: 2.2.7rc1
    • Component/s: Frontend (F)
    • Labels:

      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

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

              Dates

              • Created:
                Updated:
                Resolved: