Nagios Support Forum

Posted: **Mon Mar 20, 2017 5:18 am**

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

Posted: **Mon Mar 20, 2017 12:19 pm**

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

Posted: **Tue Mar 21, 2017 7:43 am**

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.

Posted: **Tue Mar 21, 2017 9:56 am**

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.

Nagios Support Forum

Nagios XI database issue " myisamchk: error"

Nagios XI database issue " myisamchk: error"

Re: Nagios XI database issue " myisamchk: error"

Re: Nagios XI database issue " myisamchk: error"

Re: Nagios XI database issue " myisamchk: error"