Ad Widget

Collapse

Zabbix server 1.4.3 dies (postgres problem?)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • theologu
    Junior Member
    • Dec 2007
    • 23

    #1

    Zabbix server 1.4.3 dies (postgres problem?)

    Hello again folks!

    I am running Zabbix for couple of months and I really like it, although I have many things to learn or to do to thinks right.

    Yesterday I have configured an item for some windows servers to collect EventLog problems like this:

    Description: EventLog
    Type: Zabbix Agent (active)
    Key: eventlog[System]
    Type of information: Log

    and a trigger with a key like this:

    {Template_Windows:eventlog[System].logseverity(4)}=4


    The problem is that the Zabbix server died after some time (first time in couple of moths), and keeps dieing until I disabled the EventLog Item. In the log there is the reason:

    Code:
    1666:20080227:101646 Query::insert into history_log (id,clock,itemid,timestamp,value,source,severity) values (144,1204100206,21453,1170012793,'Time Provider NtpClient: No valid response has been received from 
    manually configured peer aaadc1.examplechild.example.org,0x1 after 8 attempts to contact it. This peer will be
    discarded as a time source and NtpClient will attempt to discover a new peer 
    with this DNS name.  
    ','W32Time',2)
      1666:20080227:101646 Query failed:PGRES_FATAL_ERROR:ERROR:  value too long for type character varying(255)
     
      1666:20080227:101646 Query::update items set lastlogsize=1201 where itemid=21453
      1666:20080227:101646 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     
      1666:20080227:101646 Query::update items set nextcheck=1204100266,prevvalue=lastvalue,lastvalue='Time Provider NtpClient: No valid response has been received from 
    manually configured peer aaadc1.examplechild.example.org,0x1 after 8 attempts to contact it. This peer will be
    discarded as a time source and NtpClient will attempt to discover a new peer 
    with this DNS name.  
    ',lastclock=1204100206 where itemid=21453
      1666:20080227:101646 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     
      1666:20080227:101646 Query::select distinct function,parameter,itemid,lastvalue from functions where itemid=21453
      1666:20080227:101646 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     
      1652:20080227:101646 One child process died. Exiting ...
      1652:20080227:101648 ZABBIX Server stopped

    So, please advice me how to put to work EventLog monitoring. Can I extend the limit of 255 characters on Postgres? How?

    Thank you!
Working...