Duplicate key violation with Zabbix 1.5

[Doomshammer]

Hi,

this morning my Zabbix 1.5 test instance crashed with a duplicate key violation and it won't start anymore because of the same issue. Any ideas what's wrong/how to fix it?



29205:20080410:034817 **** Enabled features ****
29205:20080410:034817 SNMP monitoring: YES
29205:20080410:034817 WEB monitoring: YES
29205:20080410:034817 Jabber notifications: NO
29205:20080410:034817 ODBC: NO
29205:20080410:034817 IPv6 support: NO
29205:20080410:034817 **************************
29205:20080410:034818 ZABBIX semaphores already exist, trying to recreate.
29265:20080410:034818 server #7 started [Trapper]
29269:20080410:034818 server #11 started [ICMP pinger]
29264:20080410:034818 server #6 started [Trapper]
29268:20080410:034818 server #10 started [Trapper]
29267:20080410:034818 server #9 started [Trapper]
29271:20080410:034818 server #13 started [Housekeeper]
29271:20080410:034818 Executing housekeeper
29272:20080410:034818 server #14 started [Timer]
29282:20080410:034818 server #17 started [HTTP Poller]
29205:20080410:034818 server #0 started [Watchdog]
29205:20080410:034818 In main_watchdog_loop()
29286:20080410:034818 server #19 started [DB Syncer]
29266:20080410:034818 server #8 started [Trapper]
29270:20080410:034818 server #12 started [Alerter]
29274:20080410:034818 server #16 started [Node watcher. Node ID:0]
29259:20080410:034818 server #2 started [Poller. SNMP:YES]
29261:20080410:034818 server #3 started [Poller. SNMP:YES]
29258:20080410:034818 server #1 started [Poller. SNMP:YES]
29262:20080410:034818 server #4 started [Poller. SNMP:YES]
29273:20080410:034818 server #15 started [Poller for unreachable hosts. SNMP:YES]
29263:20080410:034818 server #5 started [Poller. SNMP:YES]
29285:20080410:034818 server #18 started [Discoverer. SNMP:YES]
29273:20080410:034818 Enabling host [tomcat]
29273:20080410:034818 Query::insert into ids (nodeid,table_name,field_name,nextid) values (0,'alerts','alertid',0)
29273:20080410:034818 Query failed:PGRES_FATAL_ERROR:ERROR: duplicate key violates unique constraint "ids_pkey"

29273:20080410:034818 Query::select nextid from ids where nodeid=0 and table_name='alerts' and field_name='alertid'
29273:20080410:034818 Query failed:PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end
of transaction block

29205:20080410:034818 One child process died. Exiting ...

[Sasha]

Thanks for your report!
Problem fixed in rev. 5607.

[Doomshammer]

Thanks for fixing so quickly. Where is the new version avail.?

[Sasha]

Get it by executing:
svn checkout svn:/svn.zabbix.com/trunk
... or please wait nightly build and download tomorrow from http://www.zabbix.com/next.php