Nagios XI database issue " myisamchk: error"

[anish]

Hi,

We are facing issue at database end after upgrading nagios xi from 5.3.2 to 5.4.1.

After running DB repair script, we get below error:

myisamchk: error: 'xi_sysstat.MYI' is not a MyISAM-table
myisamchk: error: 'xi_meta.MYI' is not a MyISAM-table
myisamchk: error: 'xi_events.MYI' is not a MyISAM-table

Kindly provide your assistance.

Regards,
Rohit Tiwari

[mcapra]

Was this database modified after you initially installed Nagios XI?

Can you share the output of the following command executed from the CLI of your Nagios XI machine:

Code: Select all

echo 'SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = "nagiosxi";' | mysql -uroot -pnagiosxi

[anish]

Issue has been resolved..

we restored the db backup to resolve the issue.

However we are not sure what caused the issue. After 5 days of upgrade.

[mcapra]

The default MySQL storage engine did change from MyISAM to InnoDB at some point, though I don't think the upgrade scripts for Nagios XI's tables would do that. The only other thing that might have caused it is if the tables where altered by hand.