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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.8, 1.8, 1.8.1, 1.9.0 (alpha)
    • Fix Version/s: 1.8.2, 1.9.0 (alpha)
    • Component/s: None
    • Labels:
      None
    • Environment:
      Zabbix Server version 1.6.8: Linux

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: