Return
-
Title
FMS log error "JTA commit failed" and mysqld log error "The table 'alarm_alarm' is full" -
Description
Getting table full errors in mysqd log. FMS log has errors in regards to JTA commit failed.
110809 15:31:34 [ERROR] /usr/local/mysql/bin/mysqld: The table 'alarm_alarm' is full
110809 15:31:35 [ERROR] /usr/local/mysql/bin/mysqld: The table 'topology_object_history' is full
110809 15:31:25 [ERROR] /usr/local/mysql/bin/mysqld: The table 'topology_object' is fullWe are getting this error:
2011-08-09 14:39:05.604 WARN [Data-3-thread-1305836]
com.quest.nitro.service.rule.rule.RuleSeverityFamily - Failed to report
alarm on rule ServiceLevelEvaluation - FMSServiceSLP
org.hibernate.TransactionException: JTA commit failed: -
Cause
FileSize limit within the Operating System.
-
Resolution
In regards to the filetable limits, the MySQL site has some documenation on this subject.
Customer indicated there was plenty of filesystem space but the O/S may have a limit on filesizes, so please review the MySQL article on their website."The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits."
http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html