We've performed provided steps. The database is clear now, but we still can not
move 'hung' events to the history. Looks like it is another problem.
2009-02-12 15:49:27 ERROR zen.ZenActions: unexpected exception
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 498, in
runCycle
self.mainbody()
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 489, in
mainbody
self.maintenance(zem)
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 322, in
maintenance
self.execute(sql)
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 183, in
execute
result = curs.execute(stmt)
File "/usr/local/zenoss/lib/python/MySQLdb/cursors.py", line 137, in execute
self.errorhandler(self, exc, value)
File "/usr/local/zenoss/lib/python/MySQLdb/connections.py", line 33, in
defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry '17b20f1193949540a10ffffff' for key 1")
mray wrote:
> It appears that there is an error moving events from the status table
> to the history table. The easiest solution is to truncate the history
> table. This should clear up the integrity errors, but you'll lose all
> your event history. You could try to manually delete the offending
> rows, but that could be quite time consuming.
>
> Connect to the mysql DB:
>
> mysql -u zenoss -p
>
> >connect events
>
> >truncate table history;
>
> Thanks,
> Matt Ray
> Zenoss Community Manager
> community.zenoss.com
> [email protected]
>
>
>
> On Feb 10, 2009, at 4:11 PM, mray wrote:
>
>
> > This is probably related to problems generating unique event IDs
> > (evid) on some platforms, we implemented a new uuid generator for
> > Blue Crab that doesn't have this problem. Still looking for a work-
> > around, but this should be fixed in the next major release (2.4).
> >
> > -Matt
> >
> > _______________________________________________
> > zenoss-users mailing list
> > [email protected]
> > http://lists.zenoss.org/mailman/listinfo/zenoss-users
> >
>
> _______________________________________________
> zenoss-users mailing list
> [email protected]
> http://lists.zenoss.org/mailman/listinfo/zenoss-users
-------------------- m2f --------------------
Read this topic online here:
http://forums.zenoss.com/viewtopic.php?p=31248#31248
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
