FMS log error "JTA commit failed" and mysqld log error "The table 'alarm

Chat now with support

FMS log error "JTA commit failed" and mysqld log error "The table 'alarm_alarm' is full" (4320689)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

FMS log error "JTA commit failed" and mysqld log error "The table 'alarm_alarm' is full"
Beschreibung

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 full
We 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:
Ursache

FileSize limit within the Operating System.
Lösung

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

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

FMS log error "JTA commit failed" and mysqld log error "The table 'alarm_alarm' is full" (4320689)