Hi All,
I'm new to the Zenoss product and I'm now having problems since rebooting our
Zenoss server over the weekend, we're using Zenoss version 2.1.2.
When trying to view any devices in the web admin page, nothing displays in the
error list, when viewing the 'Events' section an error message is displayed for
'Events Unavailable'. I've obtained the following from the zeneventlog.log file
(/usr/local/zenoss/log).
------
2008-10-06T11:04:56 ERROR zen.Events event summary for /Discovered failed
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 568, in
getEventSummaryME
return self.getEventSummary(where, severity, state, prodState)
File "/usr/local/zenoss/Products/ZenEvents/MySqlEventManager.py", line 87, in
getEventSummary
curs.execute(select)
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
InternalError: (145, "Table './events/status' is marked as crashed and should be
repaired")
------
2008-10-06T11:04:56 ERROR Zope.SiteErrorLog
http://cplzenoss01.cwpl.localnet:8080/zport/dmd/ZenEventManager/getDeviceIssuesJSON
Traceback (most recent call last):
File "/usr/local/zenoss/lib/python/ZPublisher/Publish.py", line 114, in
publish
request, bind=1)
File "/usr/local/zenoss/lib/python/ZPublisher/mapply.py", line 88, in mapply
if debug is not None: return debug(object,args,context)
File "/usr/local/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/Products/ZenEvents/EventManagerBase.py", line 1331,
in getDeviceIssuesJSON
deviceinfo = self.getDeviceDashboard()
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 1352,
in getDeviceDashboard
devices = [d[0] for d in self.getDeviceIssues(
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 1014,
in getDeviceIssues
curs.execute(select)
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, errorvalueevents
InternalError: (145, "Table './events/status' is marked as crashed and should be
repaired")
------
2008-10-06T11:04:56 ERROR zen.Events event summary for /Discovered failed
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 591, in
getEventPillME
evsum = self.getEventSummaryME(me, 0)
File "/usr/local/zenoss/Products/ZenEvents/EventManagerBase.py", line 568, in
getEventSummaryME
return self.getEventSummary(where, severity, state, prodState)
File "/usr/local/zenoss/Products/ZenEvents/MySqlEventManager.py", line 87, in
getEventSummary
curs.execute(select)
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
InternalError: (145, "Table './events/status' is marked as crashed and should be
repaired")
Any help would be greatly appreciated. Am I right in suspecting a database
corruption? If so, is there any way to recover this?
Thanks
Darryl
-------------------- m2f --------------------
Read this topic online here:
http://forums.zenoss.com/viewtopic.php?p=25920#25920
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
