Ad Widget

Collapse

Problem with an item

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SMB
    Member
    • Sep 2007
    • 30

    #1

    Problem with an item

    I have a SNMPv1 item in a template monitoring Squid. One of the items returns a percentage so as such never exceeds 100. I created the item as a Numeric (64 bit Integer) that is supposed to be updated every minute.

    Now, randomly, I have zabbix crashing with the following error -

    4081:20081105:151017 Query::insert into history_uint (clock,itemid,value) values (1225915817,28277,18446744073709551604)
    4081:20081105:151017 Query failed:PGRES_FATAL_ERROR:ERROR: bigint out of range

    Item ID is the integer I created. It never returns more then 100 so where is this '18446744073709551604' coming from?

    This happens using Zabbix 1.6.0 and 1.6.1.
  • SMB
    Member
    • Sep 2007
    • 30

    #2
    Any ideas at all? I'm having to alter tables to accept Numeric instead of Int datatypes.

    Comment

    • titan
      Junior Member
      • Apr 2009
      • 4

      #3
      The same problem was when I connected FreeBSD amd64 via zabbix_agent 1.4.4. I changed some items in postgres base on numeric(24,4). When I checked data from this server I was very surprise - zabbix_agent sent info about Free/Total(and some other) Memory and it was ~167000000T lol Real RAM 4G. So I think zabbix agent hasn't work correct with build amd64 FreeBSD 7.1.

      ZabbixServer 1.6.2
      Postgres 8.3
      ZabbixAgent 1.4.4

      Comment

      Working...