Ad Widget

Collapse

FreeBSD 6.2, PostgreSQL 8.1 and ZABBIX 1.4.4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ben.suffolk
    Junior Member
    • Jan 2008
    • 1

    #1

    FreeBSD 6.2, PostgreSQL 8.1 and ZABBIX 1.4.4

    I have just started to look at using ZABBIX, and how no previous experience of it. I'm currently using Nagios.

    Once I got it all running on the monitoring host, I thought it was time to add in a second host. I fired up the zabbix_agentd on the host and added it.

    When I added the host into zabbix, and set it to use the Tempalte_FreeBSD the Zabbix server process dies with this error :-

    Code:
     69728:20080111:154117 Query::insert into trends (clock,itemid,num,value_min,value_avg,value_max) values (1200063600,19952,1,9223372036854775808.000000,9223372036854775808.000000,9223372036854775808.000000)
     69728:20080111:154117 Query failed:PGRES_FATAL_ERROR:ERROR:  numeric field overflow
    DETAIL:  The absolute value is greater than or equal to 10^18 for field with precision 16, scale 4.
    
     69728:20080111:154117 Query::update items set nextcheck=1200067352,prevvalue=lastvalue,lastvalue='9223372036854775807',lastclock=1200066077 where itemid=19952
     69728:20080111:154117 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
    
     69728:20080111:154117 Query::select distinct function,parameter,itemid,lastvalue from functions where itemid=19952
     69728:20080111:154117 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
    
     69723:20080111:154117 One child process died. Exiting ...
     69723:20080111:154119 ZABBIX Server stopped
    Any thoughts about how I might diagnose what's causing the problem?

    and a second issue I have not been abel to figure out it when I try to use system.cpu.util[,wait,avg1] from the template I get an error

    zabbix_agentd -t "system.cpu.util[,wait,avg1]"

    system.cpu.util[,wait,avg1] [m|Collector is not started!]

    But I see the collector starting in the logs :-

    Code:
     53965:20080111:123522 ZABBIX Agent stopped
     54601:20080111:123524 zabbix_agentd started. ZABBIX 1.4.4.
     54602:20080111:123524 zabbix_agentd collector started
    However I don't see anything claiming to be a collector running.

    ps -auxwww | grep zabbix_agent

    Code:
    zabbix  54603  0.1  0.1  2700  1444  ??  SN   12:35PM   0:30.17 zabbix_agentd: processing request (zabbix_agentd)
    zabbix  54601  0.0  0.1  2700  1312  ??  IN   12:35PM   0:00.00 zabbix_agentd: main process (zabbix_agentd)
    zabbix  54602  0.0  0.1  2700  1336  ??  SN   12:35PM   0:00.21 zabbix_agentd: main process (zabbix_agentd)
    zabbix  54604  0.0  0.1  2700  1444  ??  SN   12:35PM   0:26.08 zabbix_agentd: processing request (zabbix_agentd)
    zabbix  54605  0.0  0.1  2700  1444  ??  SN   12:35PM   0:28.96 zabbix_agentd: processing request (zabbix_agentd)
    zabbix  54606  0.0  0.1  2828  1340  ??  SN   12:35PM   0:00.04 zabbix_agentd: poller [sleeping for 60 seconds] (zabbix_agentd)
    So any thoughts on this one also would be greatly appreciated.

    Regards

    Ben
Working...