Our Nagios Fusion server recently ran out of disk space due to the polled_extra database filling up. I believe we have cleared that issue, but now it looks like our polled_data database has gone missing. I am seeing the following at the end of the mariaDB log file:
I attempted to run the repair_databases.sh script on the appliance, but am now receiving:211026 13:18:43 InnoDB: cannot calculate statistics for table fusion/polled_data
InnoDB: because the .ibd file is missing. For help, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
211026 13:18:43 [ERROR] MySQL is trying to open a table handle but the .ibd file for
table fusion/polled_data does not exist.
Have you deleted the .ibd file from the database directory under
the MySQL datadir, or have you used DISCARD TABLESPACE?
See http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
how you can resolve the problem.
Any help would be greatly apprecieated../repair_databases.sh
Nagios Fusion
Repair Databases
****************
AUTOMATIC REPAIR UNAVAILABLE!
PLEASE CONTACT NAGIOS SUPPORT STAFF IMMEDIATELY!
Stopping the database...
Stopping the database succeeded.
It is suggested you leave the database in this state until you contact Nagios Support
Thanks!