Configuration & Administration

 View Only
  • 1.  Zenoss 3.1.1 --- zenactions MySQL 1114, "The table 'history' is full"

    Posted 24 days ago
    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
    ------------------------------


  • 2.  RE: Zenoss 3.1.1 --- zenactions MySQL 1114, "The table 'history' is full"

    Posted 23 days ago
    Hi all,

    I solved the trouble.


    ------------------------------
    Davide Mancosu
    system administartor
    Tiscali Italia S.p.A.
    Cagliari
    ------------------------------