I had a problem with our log server flooding syslog. So i moved some 8000+
events to history then had to remove the device all together. Here is the
history output.
mysql> select count(evid) from history;
+-------------+
| count(evid) |
+-------------+
| 1124692 |
+-------------+
1 row in set (3.80 sec)
mysql>
[EMAIL PROTECTED] log]# python -c 'import time; print time.time() - (86400 *
30)'
1175351614.84
mysql> delete from history where lastTime < 1175351614.84;
Query OK, 0 rows affected (0.01 sec)
mysql> select count(evid) from history;
+-------------+
| count(evid) |
+-------------+
| 1124692 |
+-------------+
1 row in set (1.35 sec)
Looks like it didn't work or I didn't do it right?
Thanks,
Ricky
==> zenxevent.log <==
OperationalError: (1114, "The table 'history' is full")
2007-04-30 10:40:01 ERROR zen.Events: (1114, "The table 'history' is full")
Traceback (most recent call last):
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 89, in sendEvent
evid = self.doSendEvent(event, db)
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 129, in
doSendEvent
execute(curs, delete)
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 24, in execute
raise ex
OperationalError: (1114, "The table 'history' is full")
==> zentrap.log <==
OperationalError: (1114, "The table 'log' is full")
2007-04-30 10:40:20 ERROR zen.Events: (1114, "The table 'log' is full")
Traceback (most recent call last):
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 89, in sendEvent
evid = self.doSendEvent(event, db)
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 114, in
doSendEvent
execute(curs, insert)
File "/opt/zenoss/Products/ZenEvents/MySqlSendEvent.py", line 24, in execute
raise ex
OperationalError: (1114, "The table 'log' is full")
------------------------
Ricky Patrick
-------------------- m2f --------------------
Read this topic online here:
http://community.zenoss.com/forums/viewtopic.php?p=6133#6133
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
