Ad Widget

Collapse

avg function bug or database corruption??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alj
    Senior Member
    • Aug 2006
    • 188

    #1

    avg function bug or database corruption??

    Code:
    025604:20070104:173703 Evaluation of expression [{19851}>200] failed [Unable to get value for functionid [19851]]
    025604:20070104:173703 Expression [{19851}>200] cannot be evaluated [Unable to get value for functionid [19851]]
    Code:
    mysql> select * from functions where functionid = 19851;
    +------------+--------+-----------+-----------+----------+-----------+
    | functionid | itemid | triggerid | lastvalue | function | parameter |
    +------------+--------+-----------+-----------+----------+-----------+
    |      19851 |  30843 |     18010 | NULL      | avg      | 300       |
    +------------+--------+-----------+-----------+----------+-----------+
    1 row in set (0.00 sec)
    Code:
    mysql> select * from items where itemid = 30843;
    +--------+------+----------------+-----------------------------------------+-----------+--------+--------------+---------------+-------+---------+--------+------------+-----------+------------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
    | itemid | type | snmp_community | snmp_oid                                | snmp_port | hostid | description  | key_          | delay | history | trends | nextcheck  | lastvalue | lastclock  | prevvalue | status | value_type | trapper_hosts | units | multiplier | delta | prevorgvalue | snmpv3_securityname | snmpv3_securitylevel | snmpv3_authpassphrase | snmpv3_privpassphrase | formula | error | lastlogsize | logtimefmt | templateid | valuemapid |
    +--------+------+----------------+-----------------------------------------+-----------+--------+--------------+---------------+-------+---------+--------+------------+-----------+------------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
    |  30843 |    5 | public         | interfaces.ifTable.ifEntry.ifInOctets.1 |       161 |  10024 | Zabbix Queue | zabbix[queue] |    60 |       7 |    365 | 1167961743 | 2         | 1167961683 | 12        |      0 |          3 |               |       |          0 |     0 |         NULL |                     |                    0 |                       |                       | 1       |       |           0 |            |      30842 |          0 |
    +--------+------+----------------+-----------------------------------------+-----------+--------+--------------+---------------+-------+---------+--------+------------+-----------+------------+-----------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+-------+-------------+------------+------------+------------+
    1 row in set (0.00 sec)
    Code:
    mysql> select * from triggers where triggerid=18010;
    +-----------+-------------+--------------------------------------------------------------+-----+--------+-------+----------+------------+-----------+-----------------------------------------------------------------------+-------+------------+
    | triggerid | expression  | description                                                  | url | status | value | priority | lastchange | dep_level | comments                                                              | error | templateid |
    +-----------+-------------+--------------------------------------------------------------+-----+--------+-------+----------+------------+-----------+-----------------------------------------------------------------------+-------+------------+
    |     18010 | {19851}>200 | Zabbix queue is too high (possibly monitoring server choke). |     |      0 |     2 |        1 | 1167710043 |         0 | Usually half-dead agent bacjks up the queue, check zabbix server log. |       |      18009 |
    +-----------+-------------+--------------------------------------------------------------+-----+--------+-------+----------+------------+-----------+-----------------------------------------------------------------------+-------+------------+
    1 row in set (0.02 sec)
    (zabbix 1.1.4, Debian, etch)
Working...