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

count() function in trigger expression doesn't work when item value type is ITEM_VALUE_TYPE_LOG, ITEM_VALUE_TYPE_STR or ITEM_VALUE_TYPE_TEXT.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.2, 1.9.0 (alpha)
    • 1.6.8, 1.8, 1.8.1, 1.9.0 (alpha)
    • None
    • None
    • Zabbix Server version 1.6.8: Linux

      When I use following expression, it doesn't work.

      {HOSTNAME:log[c:\out.log].count(600,ERROR)}

      >0

      Because Zabbix executes like following SQL when the item value type is ITEM_VALUE_TYPE_LOG, ITEM_VALUE_TYPE_STR or ITEM_VALUE_TYPE_TEXT.
      "select count(value) from history_log where itemid=23060 and clock>1266479747 and value like 'ERROR'"
      The 'ERROR' should be '%ERROR%'.

      I checked this bug in version 1.6.8, but as far as I read the trunk(r10230) and latest 1.8 branch, it still exists.

        1. zabbix-r10230-fix_count_str_function.patch
          0.5 kB
          Takanori Suzuki

            Unassigned Unassigned
            tsuzuki Takanori Suzuki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: