Nagios XI db table error

[mansonli]

table nagios_notifications is marked as crashed after running 'mysqlcheck -f -uroot -p<password> --all-databases' (without quotes). Should it be fixed by running 'mysqlcheck -r -f -uroot -p<password> --tables'? Does this error also make system backup failed with the following error message in /usr/local/nagiosxi/var/components/scheduledbackups.log?

Error backing up MySQL database 'nagios' - check the password in this script!

mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
nagios.nagios_acknowledgements OK
nagios.nagios_commands OK
nagios.nagios_commenthistory OK
nagios.nagios_comments OK
nagios.nagios_configfiles OK
nagios.nagios_configfilevariables OK
nagios.nagios_conninfo OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands OK
nagios.nagios_contactgroup_members OK
nagios.nagios_contactgroups OK
nagios.nagios_contactnotificationmethods OK
nagios.nagios_contactnotifications OK
nagios.nagios_contacts OK
nagios.nagios_contactstatus OK
nagios.nagios_customvariables OK
nagios.nagios_customvariablestatus OK
nagios.nagios_dbversion OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands OK
nagios.nagios_flappinghistory OK
nagios.nagios_host_contactgroups OK
nagios.nagios_host_contacts OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks OK
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members OK
nagios.nagios_hostgroups OK
nagios.nagios_hosts OK
nagios.nagios_hoststatus OK
nagios.nagios_instances OK
nagios.nagios_logentries OK
nagios.nagios_notifications
warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 13638224836 Should be: 13638193100
error : Found 81726206 keys of 26241390
error : Corrupt
nagios.nagios_objects OK
nagios.nagios_processevents OK
nagios.nagios_programstatus OK
nagios.nagios_runtimevariables OK
nagios.nagios_scheduleddowntime OK
nagios.nagios_service_contactgroups OK
nagios.nagios_service_contacts OK
nagios.nagios_service_parentservices OK
nagios.nagios_servicechecks OK
nagios.nagios_servicedependencies OK
nagios.nagios_serviceescalation_contactgroups OK
nagios.nagios_serviceescalation_contacts OK
nagios.nagios_serviceescalations OK
nagios.nagios_servicegroup_members OK
nagios.nagios_servicegroups OK
nagios.nagios_services OK
nagios.nagios_servicestatus OK
nagios.nagios_statehistory OK
nagios.nagios_systemcommands OK
nagios.nagios_timedeventqueue OK
nagios.nagios_timedevents OK
nagios.nagios_timeperiod_timeranges OK
nagios.nagios_timeperiods OK
nagios.tbl_command OK
nagios.tbl_contact OK
nagios.tbl_contactgroup OK
nagios.tbl_contacttemplate OK
nagios.tbl_domain OK
nagios.tbl_host OK
nagios.tbl_hostdependency OK
nagios.tbl_hostescalation OK
nagios.tbl_hostextinfo OK
nagios.tbl_hostgroup OK
nagios.tbl_hosttemplate OK
nagios.tbl_info OK
nagios.tbl_lnkContactToCommandHost OK
nagios.tbl_lnkContactToCommandService OK
nagios.tbl_lnkContactToContactgroup OK
nagios.tbl_lnkContactToContacttemplate OK
nagios.tbl_lnkContactToVariabledefinition OK
nagios.tbl_lnkContactgroupToContact OK
nagios.tbl_lnkContactgroupToContactgroup OK
nagios.tbl_lnkContacttemplateToCommandHost OK
nagios.tbl_lnkContacttemplateToCommandService OK
nagios.tbl_lnkContacttemplateToContactgroup OK
nagios.tbl_lnkContacttemplateToContacttemplate OK
nagios.tbl_lnkContacttemplateToVariabledefinition OK
nagios.tbl_lnkHostToContact OK
nagios.tbl_lnkHostToContactgroup OK
nagios.tbl_lnkHostToHost OK
nagios.tbl_lnkHostToHostgroup OK
nagios.tbl_lnkHostToHosttemplate OK
nagios.tbl_lnkHostToVariabledefinition OK
nagios.tbl_lnkHostdependencyToHost_DH OK
nagios.tbl_lnkHostdependencyToHost_H OK
nagios.tbl_lnkHostdependencyToHostgroup_DH OK
nagios.tbl_lnkHostdependencyToHostgroup_H OK
nagios.tbl_lnkHostescalationToContact OK
nagios.tbl_lnkHostescalationToContactgroup OK
nagios.tbl_lnkHostescalationToHost OK
nagios.tbl_lnkHostescalationToHostgroup OK
nagios.tbl_lnkHostgroupToHost OK
nagios.tbl_lnkHostgroupToHostgroup OK
nagios.tbl_lnkHosttemplateToContact OK
nagios.tbl_lnkHosttemplateToContactgroup OK
nagios.tbl_lnkHosttemplateToHost OK
nagios.tbl_lnkHosttemplateToHostgroup OK
nagios.tbl_lnkHosttemplateToHosttemplate OK
nagios.tbl_lnkHosttemplateToVariabledefinition OK
nagios.tbl_lnkServiceToContact OK
nagios.tbl_lnkServiceToContactgroup OK
nagios.tbl_lnkServiceToHost OK
nagios.tbl_lnkServiceToHostgroup OK
nagios.tbl_lnkServiceToServicegroup OK
nagios.tbl_lnkServiceToServicetemplate OK
nagios.tbl_lnkServiceToVariabledefinition OK
nagios.tbl_lnkServicedependencyToHost_DH OK
nagios.tbl_lnkServicedependencyToHost_H OK
nagios.tbl_lnkServicedependencyToHostgroup_DH OK
nagios.tbl_lnkServicedependencyToHostgroup_H OK
nagios.tbl_lnkServicedependencyToService_DS OK
nagios.tbl_lnkServicedependencyToService_S OK
nagios.tbl_lnkServiceescalationToContact OK
nagios.tbl_lnkServiceescalationToContactgroup OK
nagios.tbl_lnkServiceescalationToHost OK
nagios.tbl_lnkServiceescalationToHostgroup OK
nagios.tbl_lnkServiceescalationToService OK
nagios.tbl_lnkServicegroupToService OK
nagios.tbl_lnkServicegroupToServicegroup OK
nagios.tbl_lnkServicetemplateToContact OK
nagios.tbl_lnkServicetemplateToContactgroup OK
nagios.tbl_lnkServicetemplateToHost OK
nagios.tbl_lnkServicetemplateToHostgroup OK
nagios.tbl_lnkServicetemplateToServicegroup OK
nagios.tbl_lnkServicetemplateToServicetemplate OK
nagios.tbl_lnkServicetemplateToVariabledefinition OK
nagios.tbl_lnkTimeperiodToTimeperiod OK
nagios.tbl_logbook OK
nagios.tbl_mainmenu OK
nagios.tbl_service OK
nagios.tbl_servicedependency OK
nagios.tbl_serviceescalation OK
nagios.tbl_serviceextinfo OK
nagios.tbl_servicegroup OK
nagios.tbl_servicetemplate OK
nagios.tbl_session OK
nagios.tbl_session_locks OK
nagios.tbl_settings OK
nagios.tbl_submenu OK
nagios.tbl_timedefinition OK
nagios.tbl_timeperiod OK
nagios.tbl_user OK
nagios.tbl_variabledefinition OK
nagios.xi_auditlog OK
nagios.xi_commands OK
nagios.xi_eventqueue OK
nagios.xi_events OK
nagios.xi_incidents OK
nagios.xi_meta OK
nagios.xi_options OK
nagios.xi_sysstat OK
nagios.xi_usermeta OK
nagios.xi_users OK
nagiosql.tbl_command OK
nagiosql.tbl_contact OK
nagiosql.tbl_contactgroup OK
nagiosql.tbl_contacttemplate OK
nagiosql.tbl_domain OK
nagiosql.tbl_host OK
nagiosql.tbl_hostdependency OK
nagiosql.tbl_hostescalation OK
nagiosql.tbl_hostextinfo OK
nagiosql.tbl_hostgroup OK
nagiosql.tbl_hosttemplate OK
nagiosql.tbl_info OK
nagiosql.tbl_lnkContactToCommandHost OK
nagiosql.tbl_lnkContactToCommandService OK
nagiosql.tbl_lnkContactToContactgroup OK
nagiosql.tbl_lnkContactToContacttemplate OK
nagiosql.tbl_lnkContactToVariabledefinition OK
nagiosql.tbl_lnkContactgroupToContact OK
nagiosql.tbl_lnkContactgroupToContactgroup OK
nagiosql.tbl_lnkContacttemplateToCommandHost OK
nagiosql.tbl_lnkContacttemplateToCommandService OK
nagiosql.tbl_lnkContacttemplateToContactgroup OK
nagiosql.tbl_lnkContacttemplateToContacttemplate OK
nagiosql.tbl_lnkContacttemplateToVariabledefinition OK
nagiosql.tbl_lnkHostToContact OK
nagiosql.tbl_lnkHostToContactgroup OK
nagiosql.tbl_lnkHostToHost OK
nagiosql.tbl_lnkHostToHostgroup OK
nagiosql.tbl_lnkHostToHosttemplate OK
nagiosql.tbl_lnkHostToVariabledefinition OK
nagiosql.tbl_lnkHostdependencyToHost_DH OK
nagiosql.tbl_lnkHostdependencyToHost_H OK
nagiosql.tbl_lnkHostdependencyToHostgroup_DH OK
nagiosql.tbl_lnkHostdependencyToHostgroup_H OK
nagiosql.tbl_lnkHostescalationToContact OK
nagiosql.tbl_lnkHostescalationToContactgroup OK
nagiosql.tbl_lnkHostescalationToHost OK
nagiosql.tbl_lnkHostescalationToHostgroup OK
nagiosql.tbl_lnkHostgroupToHost OK
nagiosql.tbl_lnkHostgroupToHostgroup OK
nagiosql.tbl_lnkHosttemplateToContact OK
nagiosql.tbl_lnkHosttemplateToContactgroup OK
nagiosql.tbl_lnkHosttemplateToHost OK
nagiosql.tbl_lnkHosttemplateToHostgroup OK
nagiosql.tbl_lnkHosttemplateToHosttemplate OK
nagiosql.tbl_lnkHosttemplateToVariabledefinition OK
nagiosql.tbl_lnkServiceToContact OK
nagiosql.tbl_lnkServiceToContactgroup OK
nagiosql.tbl_lnkServiceToHost OK
nagiosql.tbl_lnkServiceToHostgroup OK
nagiosql.tbl_lnkServiceToServicegroup OK
nagiosql.tbl_lnkServiceToServicetemplate OK
nagiosql.tbl_lnkServiceToVariabledefinition OK
nagiosql.tbl_lnkServicedependencyToHost_DH OK
nagiosql.tbl_lnkServicedependencyToHost_H OK
nagiosql.tbl_lnkServicedependencyToHostgroup_DH OK
nagiosql.tbl_lnkServicedependencyToHostgroup_H OK
nagiosql.tbl_lnkServicedependencyToService_DS OK
nagiosql.tbl_lnkServicedependencyToService_S OK
nagiosql.tbl_lnkServiceescalationToContact OK
nagiosql.tbl_lnkServiceescalationToContactgroup OK
nagiosql.tbl_lnkServiceescalationToHost OK
nagiosql.tbl_lnkServiceescalationToHostgroup OK
nagiosql.tbl_lnkServiceescalationToService OK
nagiosql.tbl_lnkServicegroupToService OK
nagiosql.tbl_lnkServicegroupToServicegroup OK
nagiosql.tbl_lnkServicetemplateToContact OK
nagiosql.tbl_lnkServicetemplateToContactgroup OK
nagiosql.tbl_lnkServicetemplateToHost OK
nagiosql.tbl_lnkServicetemplateToHostgroup OK
nagiosql.tbl_lnkServicetemplateToServicegroup OK
nagiosql.tbl_lnkServicetemplateToServicetemplate OK
nagiosql.tbl_lnkServicetemplateToVariabledefinition OK
nagiosql.tbl_lnkTimeperiodToTimeperiod OK
nagiosql.tbl_logbook OK
nagiosql.tbl_mainmenu OK
nagiosql.tbl_service OK
nagiosql.tbl_servicedependency OK
nagiosql.tbl_serviceescalation OK
nagiosql.tbl_serviceextinfo OK
nagiosql.tbl_servicegroup OK
nagiosql.tbl_servicetemplate OK
nagiosql.tbl_session OK
nagiosql.tbl_session_locks OK
nagiosql.tbl_settings OK
nagiosql.tbl_submenu OK
nagiosql.tbl_timedefinition OK
nagiosql.tbl_timeperiod OK
nagiosql.tbl_user OK
nagiosql.tbl_variabledefinition OK
nagiosxi.xi_auditlog OK
nagiosxi.xi_commands OK
nagiosxi.xi_eventqueue OK
nagiosxi.xi_events OK
nagiosxi.xi_incidents OK
nagiosxi.xi_meta OK
nagiosxi.xi_options OK
nagiosxi.xi_sysstat OK
nagiosxi.xi_usermeta OK
nagiosxi.xi_users OK
sys.sys_config OK
test.cats OK

[benjaminsmith]

Hi,

Does this error also make system backup failed with the following error message in /usr/local/nagiosxi/var/components/scheduledbackups.log?

That's correct. If there's a bad table it's going to cause the backup_xi.sh to fail and exit, so it doesn't try to restore a corrupted archive.

Code: Select all

warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 13638224836 Should be: 13638193100
error : Found 81726206 keys of 26241390
error : Corrupt

Try running the back repair script, and let me know if that is successful. Run the following as root from the terminal.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

--Benjamin

[mansonli]

backup script run successful after corrupted table has been fixed. Suggest to log more informative message in /usr/local/nagiosxi/var/components/scheduledbackups.log instead of the following message. It's not a accurate or informative message to the root cause.

Error backing up MySQL database 'nagios' - check the password in this script!

[ssax]

I've submitted a feature request for them to add more logging details:

Code: Select all

FR: XI - (Customer Requested) - Add more logging to scheduledbackups.log, only seeing "Error backing up MySQL database 'nagios' - check the password in this script!" and it's not showing the crashed tables message

Let's check your DB tables again (if they say NULL they are crashed):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

[mansonli]

Hi,

Does this error also make system backup failed with the following error message in /usr/local/nagiosxi/var/components/scheduledbackups.log?

That's correct. If there's a bad table it's going to cause the backup_xi.sh to fail and exit, so it doesn't try to restore a corrupted archive.

Code: Select all

warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 13638224836 Should be: 13638193100
error : Found 81726206 keys of 26241390
error : Corrupt

Try running the back repair script, and let me know if that is successful. Run the following as root from the terminal.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

--Benjamin

Some tables are not closed properly or even crashed. /usr/local/nagiosxi/scripts/repair_databases.sh can fix these db integrity issues?

nagios.nagios_acknowledgements OK
nagios.nagios_commands OK
nagios.nagios_commenthistory OK
nagios.nagios_comments OK
nagios.nagios_configfiles OK
nagios.nagios_configfilevariables OK
nagios.nagios_conninfo
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands OK
nagios.nagios_contactgroup_members OK
nagios.nagios_contactgroups OK
nagios.nagios_contactnotificationmethods
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_contactnotifications
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_contacts OK
nagios.nagios_contactstatus OK
nagios.nagios_customvariables OK
nagios.nagios_customvariablestatus
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_dbversion OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands OK
nagios.nagios_flappinghistory OK
nagios.nagios_host_contactgroups OK
nagios.nagios_host_contacts OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks OK
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members OK
nagios.nagios_hostgroups OK
nagios.nagios_hosts OK
nagios.nagios_hoststatus
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_instances OK
nagios.nagios_logentries
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_notifications
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Invalid key block position: 284855150420361216 key block size: 1024 file_length: 4339023872
error : key delete-link-chain corrupted
error : Corrupt
nagios.nagios_objects
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_processevents
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_programstatus
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_runtimevariables
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_scheduleddowntime
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_service_contactgroups
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_service_contacts
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_service_parentservices OK
nagios.nagios_servicechecks OK
nagios.nagios_servicedependencies OK
nagios.nagios_serviceescalation_contactgroups OK
nagios.nagios_serviceescalation_contacts OK
nagios.nagios_serviceescalations OK
nagios.nagios_servicegroup_members
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_servicegroups
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_services
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_servicestatus
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_statehistory
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_systemcommands
warning : 2 clients are using or haven't closed the table properly
status : OK
nagios.nagios_timedeventqueue OK
nagios.nagios_timedevents OK
nagios.nagios_timeperiod_timeranges
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.nagios_timeperiods
warning : 1 client is using or hasn't closed the table properly
status : OK
nagios.tbl_command OK
nagios.tbl_contact OK
nagios.tbl_contactgroup OK
nagios.tbl_contacttemplate OK
nagios.tbl_domain OK
nagios.tbl_host OK
nagios.tbl_hostdependency OK
nagios.tbl_hostescalation OK
nagios.tbl_hostextinfo OK
nagios.tbl_hostgroup OK
nagios.tbl_hosttemplate OK
nagios.tbl_info OK
nagios.tbl_lnkContactToCommandHost OK
nagios.tbl_lnkContactToCommandService OK
nagios.tbl_lnkContactToContactgroup OK
nagios.tbl_lnkContactToContacttemplate OK
nagios.tbl_lnkContactToVariabledefinition OK
nagios.tbl_lnkContactgroupToContact OK
nagios.tbl_lnkContactgroupToContactgroup OK
nagios.tbl_lnkContacttemplateToCommandHost OK
nagios.tbl_lnkContacttemplateToCommandService OK
nagios.tbl_lnkContacttemplateToContactgroup OK
nagios.tbl_lnkContacttemplateToContacttemplate OK
nagios.tbl_lnkContacttemplateToVariabledefinition OK
nagios.tbl_lnkHostToContact OK
nagios.tbl_lnkHostToContactgroup OK
nagios.tbl_lnkHostToHost OK
nagios.tbl_lnkHostToHostgroup OK
nagios.tbl_lnkHostToHosttemplate OK
nagios.tbl_lnkHostToVariabledefinition OK
nagios.tbl_lnkHostdependencyToHost_DH OK
nagios.tbl_lnkHostdependencyToHost_H OK
nagios.tbl_lnkHostdependencyToHostgroup_DH OK
nagios.tbl_lnkHostdependencyToHostgroup_H OK
nagios.tbl_lnkHostescalationToContact OK
nagios.tbl_lnkHostescalationToContactgroup OK
nagios.tbl_lnkHostescalationToHost OK
nagios.tbl_lnkHostescalationToHostgroup OK
nagios.tbl_lnkHostgroupToHost OK
nagios.tbl_lnkHostgroupToHostgroup OK
nagios.tbl_lnkHosttemplateToContact OK
nagios.tbl_lnkHosttemplateToContactgroup OK
nagios.tbl_lnkHosttemplateToHost OK
nagios.tbl_lnkHosttemplateToHostgroup OK
nagios.tbl_lnkHosttemplateToHosttemplate OK
nagios.tbl_lnkHosttemplateToVariabledefinition OK
nagios.tbl_lnkServiceToContact OK
nagios.tbl_lnkServiceToContactgroup OK
nagios.tbl_lnkServiceToHost OK
nagios.tbl_lnkServiceToHostgroup OK
nagios.tbl_lnkServiceToServicegroup OK
nagios.tbl_lnkServiceToServicetemplate OK
nagios.tbl_lnkServiceToVariabledefinition OK
nagios.tbl_lnkServicedependencyToHost_DH OK
nagios.tbl_lnkServicedependencyToHost_H OK
nagios.tbl_lnkServicedependencyToHostgroup_DH OK
nagios.tbl_lnkServicedependencyToHostgroup_H OK
nagios.tbl_lnkServicedependencyToService_DS OK
nagios.tbl_lnkServicedependencyToService_S OK
nagios.tbl_lnkServiceescalationToContact OK
nagios.tbl_lnkServiceescalationToContactgroup OK
nagios.tbl_lnkServiceescalationToHost OK
nagios.tbl_lnkServiceescalationToHostgroup OK
nagios.tbl_lnkServiceescalationToService OK
nagios.tbl_lnkServicegroupToService OK
nagios.tbl_lnkServicegroupToServicegroup OK
nagios.tbl_lnkServicetemplateToContact OK
nagios.tbl_lnkServicetemplateToContactgroup OK
nagios.tbl_lnkServicetemplateToHost OK
nagios.tbl_lnkServicetemplateToHostgroup OK
nagios.tbl_lnkServicetemplateToServicegroup OK
nagios.tbl_lnkServicetemplateToServicetemplate OK
nagios.tbl_lnkServicetemplateToVariabledefinition OK
nagios.tbl_lnkTimeperiodToTimeperiod OK
nagios.tbl_logbook OK
nagios.tbl_mainmenu OK
nagios.tbl_service OK
nagios.tbl_servicedependency OK
nagios.tbl_serviceescalation OK
nagios.tbl_serviceextinfo OK
nagios.tbl_servicegroup OK
nagios.tbl_servicetemplate OK
nagios.tbl_session OK
nagios.tbl_session_locks OK
nagios.tbl_settings OK
nagios.tbl_submenu OK
nagios.tbl_timedefinition OK
nagios.tbl_timeperiod OK
nagios.tbl_user OK
nagios.tbl_variabledefinition OK
nagios.xi_auditlog OK
nagios.xi_commands OK
nagios.xi_eventqueue OK
nagios.xi_events OK
nagios.xi_incidents OK
nagios.xi_meta OK
nagios.xi_options OK
nagios.xi_sysstat OK
nagios.xi_usermeta OK
nagios.xi_users OK
test.cats OK

[benjaminsmith]

Hi,

Let's try to stop the applications writing to the database tables, and then run the repair, as follows:

Code: Select all

systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
pkill -9 -u nagios
 mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm
systemctl restart mariadb
systemctl start npcd
systemctl start crond
systemctl start nagios
systemctl start ndo2db

Let us know if the tables are not closed properly error clears out.

--Benjamin

[mansonli]

Service mariadb is not found. mysqld is running. Thus "systemctl restart mariadb" should be replaced by "systemctl restart mysqld"?

# systemctl status mariadb
Unit mariadb.service could not be found.
# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2020-12-15 23:34:45 HKT; 17h ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 12149 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 12124 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 12152 (mysqld)
Memory: 4.5G
CGroup: /system.slice/mysqld.service
└─12152 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Dec 15 23:34:41 AZALVGISNGODP02 systemd[1]: Starting MySQL Server...
Dec 15 23:34:45 AZALVGISNGODP02 systemd[1]: Started MySQL Server.

[benjaminsmith]

Hi,

Sorry about that, the default database ( mysqld / MariaDB ) can vary depending on which Linux distribution you have installed. My Cent7 is using mariadb. It looks like the repair was successful this time, is that correct?

Are you able to successfully run a backup job?

--Benjamin