Brad,
Had you previously had an earlier version of zenoss installed? Looks
like the mysql tables don't have the latest update. zenmigrate might
fix that problem:
> zenmigrate run --step=EventClassMapping --commit
If that doesn't fix the problem you may want to drop and recreate the
mysql database. This will drop all your event data too, so if that's
important you'll want some sort of data migrate script.
> mysqladmin -u<username> -p drop events
> mysqladmin -u<username> -p create events
> mysql -u<username> -p events < $ZENHOME/ProductsZenEvents/db/
zenevents.sql
After doing this you may need to hit the Refresh Event Schema button
on the zenoss Event Manager page.
-jason
On Feb 15, 2007, at 10:33 AM, bflanary wrote:
Hi All,
Under 'Main Views'>Events I have several events. When selecting the
events and clicking
history to move them to History I get the following.
-----------------------------
Zenoss Error
An error was encountered while publishing this resource. Please use
the form below to submit details of this error to Zenoss, Inc.
Type: OperationalError
Value: (1136, "Column count doesn't match value count at row 1")
Traceback (innermost last):
Module ZPublisher.Publish, line 114, in publish
Module ZPublisher.mapply, line 88, in mapply
Module ZPublisher.Publish, line 40, in call_object
Module Products.ZenModel.EventView , line 100, in manage_deleteEvents
Module Products.ZenEvents.EventManagerBase, line 1049, in
manage_deleteEvents
Module Products.ZenEvents.EventManagerBase, line 1039, in deleteEvents
Module Products.ZenEvents.EventManagerBase, line 1017, in updateEvents
Module MySQLdb.cursors, line 137, in execute
Module MySQLdb.connections, line 33, in defaulterrorhandler
OperationalError: (1136, "Column count doesn't match value count at
row 1")
The following fields are optional. This information will only be
used to contact you if further information is needed regarding this
error.
---------------------------
Also when running 'zendisc run --net 10.x.x.y' I see the following.
INFO:zen.Ping:pinged 1022 devices in 106.47 seconds
ERROR:zen.Events:(1136, "Column count doesn't match value count at
row 1")
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/MySqlSendEvent.py",
line 19, in execute
result = cursor.execute(statement)
File "usr/local/zenoss/lib/python/MySQLdb/cursors.py", line 137,
in execute
File "usr/local/zenoss/lib/python/MySQLdb/connections.py", line
33, in defaulterrorhandler
OperationalError: (1136, "Column count doesn't match value count at
row 1")
ERROR:zen.Events:(1136, "Column count doesn't match value count at
row 1")
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/MySqlSendEvent.py",
line 89, in sendEvent
evid = self.doSendEvent(event, db)
File "/usr/local/zenoss/Products/ZenEvents/MySqlSendEvent.py",
line 129, in doSendEvent
execute(curs, delete)
File "/usr/local/zenoss/Products/ZenEvents/MySqlSendEvent.py",
line 24, in execute
raise ex
OperationalError: (1136, "Column count doesn't match value count at
row 1")
ERROR:zen.ZenDisc:Error performing net discovery on (1136, "Column
count doesn't match value count at row 1")Traceback (most recent
call last):
File "/usr/local/zenoss/Products/DataCollector/zendisc.py", line
168, in run
for ip in self.discoverIps((netobj,)):
File "/usr/local/zenoss/Products/DataCollector/zendisc.py", line
71, in discoverIps
self.sendEvent(ipobj, sev=0)
File "/usr/local/zenoss/Products/DataCollector/zendisc.py", line
106, in sendEvent
self.dmd.ZenEventManager.sendEvent(evt)
File "/usr/local/zenoss/Products/ZenEvents/MySqlSendEvent.py",
line 94, in sendEvent
raise ZenBackendFailure(str(e))
ZenBackendFailure: (1136, "Column count doesn't match value count
at row 1")
Any pointers would be appreciated. I have done the following.
- cleared event cache
- refresh event schema
This is a new install of 1.1.0 on RHEL4U4
--
Brad
_______________________________________________
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
