Nagios Support Forum

CentOS (2.6.32-696.13.2.el6.x86_64)
64Bit
From VM Image
Are there special configurations on your system:
Distributing checks w/ mod-gearman, otherwise no.

Nagios XI Version info:
Latest Available Version: 5.4.12
Installed Version: 5.4.12
Last Update Check: 2018-01-23 10:56:03

System profile attached

Issue: database tables appear crashed ( "SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus'") -also seeing errors for nagios_hoststatus
Cause was failed startup due to Host (ESXi) datastore disk space shortage - resolved.
Database repair script /usr/local/nagiosxi/scripts/repair_databases.sh has not resolved. Errors during repair; ~"is not myISAM"
Did: SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, '
engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';
per: https://assets.nagios.com/downloads/nag ... tabase.pdf
Returned no match or null set

At this point I suspect I either need to truncate the problem tables or try to restore from the automatic backups. Can anyone offer advice?

Thanks

Avasek wrote: Issue: database tables appear crashed ( "SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus'")

The good news is that db is just used for display, so the next time those checks run, it should refill. I'd try the truncate first. If that doesn't work, then yes, a restore is probably the best option.

Reporting in; I truncated the tables per documentation here: https://assets.nagios.com/downloads/nag ... tabase.pdf and we seem to be recovered. Many thanks!