TECHZEN Zenoss User Community ARCHIVE  

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
------------------------------


< Previous
Configure Zenoss 4.2.5 Zope UI to use SSL
  Next
Unable to see the data in SNMP Location field in Overview page
>