Zenoss 3.1.1 --- zenactions MySQL 1114, "The table 'history' is full"
Subject: |
Zenoss 3.1.1 --- zenactions MySQL 1114, "The table 'history' is full" |
Author: |
Davide Mancosu |
Posted: |
2021-12-29 09:43 |
Hi all,
My Zenoss 3.1.1 doesn't clear the alarms when the trouble is fixed.
I noticed that zenactions log has this errors:
2021-12-29 14:42:41,189 ERROR zen.ZenActions: unexpected exception
Traceback (most recent call last):
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 636, in runCycle
self.mainbody()
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 627, in mainbody
self.maintenance(zem)
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 432, in maintenance
self.execute(sql)
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 186, in execute
return self._getCursor(stmt, callback)
File "/usr/local/zenoss/Products/ZenEvents/zenactions.py", line 172, in _getCursor
rowsAffected = 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
OperationalError: (1114, "The table 'history' is full")
I verified that the file system has enough space: 40GB available and I verified that the mysql variable innodb_data_file_path=ibdata1:10M:autoextend has no limits.
Can someone help me to understand why zenoss doesn't clear the alarms?
Thank's in adavance
Davide
------------------------------
Davide Mancosu
system administartor
Tiscali Italia S.p.A.
Cagliari
------------------------------
Subject: |
RE: Zenoss 3.1.1 --- zenactions MySQL 1114, "The table 'history' is full" |
Author: |
Davide Mancosu |
Posted: |
2021-12-30 06:46 |
Hi all,
I solved the trouble.
------------------------------
Davide Mancosu
system administartor
Tiscali Italia S.p.A.
Cagliari
------------------------------