Ad Widget

Collapse

1.4.2 postgresql problems

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • thresh
    Junior Member
    • Jan 2007
    • 8

    #1

    1.4.2 postgresql problems

    Hello.

    I've got a bunch of hosts monitored by zabbix (~150).
    Code:
    Zabbix server dies all the time with something like this:
     28112:20071203:163835 Query::insert into trends (clock,itemid,num,value_min,value_avg,value_max) values (1196686800,22041,1,1.000000,1.000000,1.000000)
     28112:20071203:163835 Query failed:PGRES_FATAL_ERROR:ERROR:  duplicate key violates unique constraint "trends_pkey"
    
     28112:20071203:163835 Query::update items set nextcheck=1196689145,prevvalue=lastvalue,lastvalue='1',lastclock=1196689115 where itemid=22041
     28112:20071203:163835 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
    
     28112:20071203:163835 Query::select distinct function,parameter,itemid,lastvalue from functions where itemid=22041
     28112:20071203:163835 Query failed:PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
    
     28078:20071203:163835 One child process died. Exiting ...
     28078:20071203:163837 ZABBIX Server stopped
    I've tried deleting all the data from trends table, still the same.

    Suppose it is a bug; where should i file one to be fixed?

    zabbix 1.4.2, postgresql 8.0.14.
  • thresh
    Junior Member
    • Jan 2007
    • 8

    #2
    I've also posted a bug to bug tracking system, still no reply... anyone ?

    Comment

    Working...