hi there I have a problem in that I can't delete any devices from our zenoss installation. I've upgraded to 2.4.2 and have reindexed/commited using zendmd. I've also done the db tuning steps of dumping old events and details, followed by running optimize on the tables. Performance is significantly better now but I still can't delete devices. I've tried through both IE and Firefox so don't think it's a browser issue. In the event.log file I see the following:
2009-08-19T17:14:16 ERROR Zope.SiteErrorLog http://zenoss.domain.com.au:8080/zport/dmd/Devices/Server/Windows/removeDevices Traceback (most recent call last): File "/usr/local/zenoss/zenoss/lib/python/ZPublisher/Publish.py", line 114, in publish request, bind=1) File "/usr/local/zenoss/zenoss/lib/python/ZPublisher/mapply.py", line 88, in mapply if debug is not None: return debug(object,args,context) File "/usr/local/zenoss/zenoss/lib/python/ZPublisher/Publish.py", line 40, in call_object result=apply(object,args) # Type s<cr> to step into published object. File "/usr/local/zenoss/zenoss/Products/ZenModel/DeviceClass.py", line 306, in removeDevices deleteHistory=deleteHistory, deletePerf=deletePerf) File "/usr/local/zenoss/zenoss/Products/ZenModel/Device.py", line 1672, in deleteDevice self.getEventManager().manage_deleteAllEvents(self.getId()) File "/usr/local/zenoss/zenoss/Products/ZenEvents/EventManagerBase.py", line 1504, in manage_deleteAllEvents self.deleteEvents(whereClause, 'Device deleted') File "/usr/local/zenoss/zenoss/Products/ZenEvents/EventManagerBase.py", line 1449, in deleteEvents self.updateEvents('DELETE FROM status', whereClause, reason) File "/usr/local/zenoss/zenoss/Products/ZenEvents/EventManagerBase.py", line 1410, in updateEvents if toLog: curs.execute(insert) File "/usr/local/zenoss/python/lib/python2.4/site-packages/MySQLdb/cursors.py", line 137, in execute self.errorhandler(self, exc, value) File "/usr/local/zenoss/python/lib/python2.4/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') Does anyone have any ideas? Oh, I'm running the zenoss-stack installation on an ubuntu system. Apart from deleting devices I am able to do everything else in the console and it seems to be functioning ok. thanks Andrew -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=38142#38142 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
