Hello.
I've got a bunch of hosts monitored by zabbix (~150).
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.
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
Suppose it is a bug; where should i file one to be fixed?
zabbix 1.4.2, postgresql 8.0.14.
Comment