DB rebuild on remote server

[tbarnett]

When I do a rebuild of the Nagios databases, which live on a remote server now, I get the following on several different tables.

Is this bad since at the end it says repair succeeded?

Tom


Issued remote command 'mysqlcheck -f -r -u nagiosql -pmypassword -h myip --port=3306 --databases nagiosql'
DATABASE: nagiosxi
TABLE:
nagiosxi.xi_auditlog OK
nagiosxi.xi_auth_tokens
note : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_ccm_backups
note : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_favorites
note : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_nagiosbpi_backups
note : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_trapdata
note : The storage engine for the table doesn't support repair
nagiosxi.xi_cmp_trapdata_log
note : The storage engine for the table doesn't support repair
nagiosxi.xi_commands OK
nagiosxi.xi_deploy_agents
note : The storage engine for the table doesn't support repair
nagiosxi.xi_deploy_jobs
note : The storage engine for the table doesn't support repair
nagiosxi.xi_eventqueue
note : The storage engine for the table doesn't support repair
nagiosxi.xi_events OK
nagiosxi.xi_incidents OK
nagiosxi.xi_meta OK
nagiosxi.xi_mibs
note : The storage engine for the table doesn't support repair
nagiosxi.xi_options OK
nagiosxi.xi_sessions
note : The storage engine for the table doesn't support repair
nagiosxi.xi_sysstat OK
nagiosxi.xi_usermeta OK
nagiosxi.xi_users OK
Issued remote command 'mysqlcheck -f -r -u nagiosxi -pmypassword -h myIP --port=3306 --databases nagiosxi'

=======================
nagios offloaded database repair succeeded
nagiosql offloaded database repair succeeded
nagiosxi offloaded database repair succeeded

[tbarnett]

Right now I'm also seeing a couple of services on a specific host that although I have changed thier parameters and the correct ones show up
in the config manager, the measurements are using the original parameters for warn and critical that were in place before I changed them.

[vtrac]

Hi Tom,
How are you doing?

note : The storage engine for the table doesn't support repair

The above is not an error.

Since the "ENGINE" type defined for the "nagiosxi" database is "InnoDB", which does not support repair.

Only "MyISAM" engine type is able to be repaired .... like the "nagios" database.

I tested by running the "/usr/local/nagiosxi/scripts/repair_databases.sh" script and only "nagios" tables are being repaired.


Best Regards,
Vinh

[tbarnett]

Thank you Vinh,

It appears all is well this AM.

Tom

[vtrac]

Great!! .... locking thread ...

Vinh