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

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Major
    • 1.8.2, 1.9.0 (alpha)
    • Affects Version/s: 1.6.8, 1.8, 1.8.1, 1.9.0 (alpha)
    • Component/s: None
    • None
    • Environment:
      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

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

              Created:
              Updated:
              Resolved: