Page 2 of 2
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Wed Jun 01, 2016 7:40 am
by questrad
Please find the attached output. Yes, i can open a ticket - Can you provide the link to open a ticket ?
Thanks,
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Wed Jun 01, 2016 12:22 pm
by tgriep
It could be that the nagios_logentries table is too large and needs to be truncated before repairing it.
Can you login as root to the XI server, run the following commands to truncate the table to 120 days of entries.
Code: Select all
echo 'DELETE FROM nagios_logentries WHERE entry_time < DATE_SUB(NOW(), INTERVAL 120 DAY);' |mysql -t -u root -pnagiosxi nagios
echo 'repair table nagios_logentries use_frm;' | mysql -t -u root -pnagiosxi nagios
Try that and post if this fixes the issue for you.
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Wed Jun 01, 2016 2:17 pm
by questrad
Code: Select all
# echo 'DELETE FROM nagios_logentries WHERE entry_time < DATE_SUB(NOW(), INTERVAL 120 DAY);' |mysql -t -u root -pnagiosxi nagios
# echo 'repair table nagios_logentries use_frm;' | mysql -t -u root -pnagiosxi nagios
+--------------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+--------+----------+------------------------------------------+
| nagios.nagios_logentries | repair | info | Delete link points outside datafile at 0 |
| nagios.nagios_logentries | repair | status | OK |
+--------------------------+--------+----------+------------------------------------------+
After running the above commands when i ran the backup script i got the same error.
Code: Select all
# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
Code: Select all
# /usr/local/nagiosxi/scripts/backup_xi.sh
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Wed Jun 01, 2016 4:16 pm
by tgriep
If looks like the repair didn't run, can you run this command twice to repair the mysql database?
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi --databases nagios
The reason I ask to run it twice, the second run should come up clean, let us know if it doesn't.
Can you run this command and post the output?
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Thu Jun 02, 2016 7:12 am
by questrad
Ran it twice. Posting the output of the second run.
Code: Select all
# mysqlcheck -f -r -u root -pnagiosxi --databases nagios
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 OK
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
Code: Select all
# ls -l /var/lib/mysql/nagios
total 1180
-rw-rw---- 1 mysql mysql 61 May 21 2014 db.opt
-rw-rw---- 1 mysql mysql 9100 May 21 2014 nagios_acknowledgements.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_acknowledgements.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_acknowledgements.MYI
-rw-rw---- 1 mysql mysql 8746 May 21 2014 nagios_commands.frm
-rw-rw---- 1 mysql mysql 12424 Jun 2 08:08 nagios_commands.MYD
-rw-rw---- 1 mysql mysql 7168 Jun 2 08:08 nagios_commands.MYI
-rw-rw---- 1 mysql mysql 9340 May 21 2014 nagios_commenthistory.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_commenthistory.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_commenthistory.MYI
-rw-rw---- 1 mysql mysql 9220 May 21 2014 nagios_comments.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_comments.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_comments.MYI
-rw-rw---- 1 mysql mysql 8726 May 21 2014 nagios_configfiles.frm
-rw-rw---- 1 mysql mysql 44 Jun 2 08:08 nagios_configfiles.MYD
-rw-rw---- 1 mysql mysql 5120 Jun 2 08:08 nagios_configfiles.MYI
-rw-rw---- 1 mysql mysql 8760 May 21 2014 nagios_configfilevariables.frm
-rw-rw---- 1 mysql mysql 7000 Jun 2 08:08 nagios_configfilevariables.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 2 08:08 nagios_configfilevariables.MYI
-rw-rw---- 1 mysql mysql 9262 May 21 2014 nagios_conninfo.frm
-rw-rw---- 1 mysql mysql 2480 Jun 2 08:08 nagios_conninfo.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 2 08:08 nagios_conninfo.MYI
-rw-rw---- 1 mysql mysql 8760 May 21 2014 nagios_contact_addresses.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_contact_addresses.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_contact_addresses.MYI
-rw-rw---- 1 mysql mysql 8748 May 21 2014 nagios_contactgroup_members.frm
-rw-rw---- 1 mysql mysql 375 Jun 2 08:08 nagios_contactgroup_members.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_contactgroup_members.MYI
-rw-rw---- 1 mysql mysql 8768 May 21 2014 nagios_contactgroups.frm
-rw-rw---- 1 mysql mysql 72 Jun 2 08:08 nagios_contactgroups.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_contactgroups.MYI
-rw-rw---- 1 mysql mysql 8856 May 21 2014 nagios_contact_notificationcommands.frm
-rw-rw---- 1 mysql mysql 6600 Jun 2 08:08 nagios_contact_notificationcommands.MYD
-rw-rw---- 1 mysql mysql 12288 Jun 2 08:08 nagios_contact_notificationcommands.MYI
-rw-rw---- 1 mysql mysql 9000 May 21 2014 nagios_contactnotificationmethods.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_contactnotificationmethods.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_contactnotificationmethods.MYI
-rw-rw---- 1 mysql mysql 8928 May 21 2014 nagios_contactnotifications.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_contactnotifications.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_contactnotifications.MYI
-rw-rw---- 1 mysql mysql 10026 May 21 2014 nagios_contacts.frm
-rw-rw---- 1 mysql mysql 2436 Jun 2 08:08 nagios_contacts.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_contacts.MYI
-rw-rw---- 1 mysql mysql 9240 May 21 2014 nagios_contactstatus.frm
-rw-rw---- 1 mysql mysql 1224 Jun 2 08:08 nagios_contactstatus.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_contactstatus.MYI
-rw-rw---- 1 mysql mysql 8844 May 21 2014 nagios_customvariables.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_customvariables.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 2 08:08 nagios_customvariables.MYI
-rw-rw---- 1 mysql mysql 8870 May 21 2014 nagios_customvariablestatus.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_customvariablestatus.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 2 08:08 nagios_customvariablestatus.MYI
-rw-rw---- 1 mysql mysql 8596 May 21 2014 nagios_dbversion.frm
-rw-rw---- 1 mysql mysql 20 Jun 2 08:08 nagios_dbversion.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_dbversion.MYI
-rw-rw---- 1 mysql mysql 9490 May 21 2014 nagios_downtimehistory.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_downtimehistory.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_downtimehistory.MYI
-rw-rw---- 1 mysql mysql 9380 May 21 2014 nagios_eventhandlers.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_eventhandlers.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_eventhandlers.MYI
-rw-rw---- 1 mysql mysql 8812 May 21 2014 nagios_externalcommands.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_externalcommands.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_externalcommands.MYI
-rw-rw---- 1 mysql mysql 9166 May 21 2014 nagios_flappinghistory.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_flappinghistory.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_flappinghistory.MYI
-rw-rw---- 1 mysql mysql 9660 May 21 2014 nagios_hostchecks.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_hostchecks.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_hostchecks.MYI
-rw-rw---- 1 mysql mysql 8738 May 21 2014 nagios_host_contactgroups.frm
-rw-rw---- 1 mysql mysql 15 Jun 2 08:08 nagios_host_contactgroups.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_host_contactgroups.MYI
-rw-rw---- 1 mysql mysql 8718 May 21 2014 nagios_host_contacts.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_host_contacts.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_host_contacts.MYI
-rw-rw---- 1 mysql mysql 9108 May 21 2014 nagios_hostdependencies.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_hostdependencies.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_hostdependencies.MYI
-rw-rw---- 1 mysql mysql 8778 May 21 2014 nagios_hostescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_hostescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_hostescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql 8758 May 21 2014 nagios_hostescalation_contacts.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_hostescalation_contacts.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_hostescalation_contacts.MYI
-rw-rw---- 1 mysql mysql 9148 May 21 2014 nagios_hostescalations.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_hostescalations.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_hostescalations.MYI
-rw-rw---- 1 mysql mysql 8730 May 21 2014 nagios_hostgroup_members.frm
-rw-rw---- 1 mysql mysql 15 Jun 2 08:08 nagios_hostgroup_members.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_hostgroup_members.MYI
-rw-rw---- 1 mysql mysql 8756 May 21 2014 nagios_hostgroups.frm
-rw-rw---- 1 mysql mysql 32 Jun 2 08:08 nagios_hostgroups.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_hostgroups.MYI
-rw-rw---- 1 mysql mysql 8732 May 21 2014 nagios_host_parenthosts.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_host_parenthosts.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_host_parenthosts.MYI
-rw-rw---- 1 mysql mysql 11932 May 21 2014 nagios_hosts.frm
-rw-rw---- 1 mysql mysql 132 Jun 2 08:08 nagios_hosts.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 2 08:08 nagios_hosts.MYI
-rw-rw---- 1 mysql mysql 15368 May 21 2014 nagios_hoststatus.frm
-rw-rw---- 1 mysql mysql 292 Jun 2 08:08 nagios_hoststatus.MYD
-rw-rw---- 1 mysql mysql 21504 Jun 2 08:08 nagios_hoststatus.MYI
-rw-rw---- 1 mysql mysql 8684 May 21 2014 nagios_instances.frm
-rw-rw---- 1 mysql mysql 20 Jun 2 08:08 nagios_instances.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 2 08:08 nagios_instances.MYI
-rw-rw---- 1 mysql mysql 8972 May 21 2014 nagios_logentries.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_logentries.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 2 08:08 nagios_logentries.MYI
-rw-rw---- 1 mysql mysql 9168 May 21 2014 nagios_notifications.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_notifications.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_notifications.MYI
-rw-rw---- 1 mysql mysql 8766 May 21 2014 nagios_objects.frm
-rw-rw---- 1 mysql mysql 7964 Jun 2 08:08 nagios_objects.MYD
-rw-rw---- 1 mysql mysql 18432 Jun 2 08:08 nagios_objects.MYI
-rw-rw---- 1 mysql mysql 8948 May 21 2014 nagios_processevents.frm
-rw-rw---- 1 mysql mysql 7800 Jun 2 08:08 nagios_processevents.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 2 08:08 nagios_processevents.MYI
-rw-rw---- 1 mysql mysql 10174 May 21 2014 nagios_programstatus.frm
-rw-rw---- 1 mysql mysql 124 Jun 2 08:08 nagios_programstatus.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_programstatus.MYI
-rw-rw---- 1 mysql mysql 8706 May 21 2014 nagios_runtimevariables.frm
-rw-rw---- 1 mysql mysql 792 Jun 2 08:08 nagios_runtimevariables.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_runtimevariables.MYI
-rw-rw---- 1 mysql mysql 9332 May 21 2014 nagios_scheduleddowntime.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_scheduleddowntime.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_scheduleddowntime.MYI
-rw-rw---- 1 mysql mysql 9626 May 21 2014 nagios_servicechecks.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_servicechecks.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_servicechecks.MYI
-rw-rw---- 1 mysql mysql 8750 May 21 2014 nagios_service_contactgroups.frm
-rw-rw---- 1 mysql mysql 120 Jun 2 08:08 nagios_service_contactgroups.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_service_contactgroups.MYI
-rw-rw---- 1 mysql mysql 8730 May 21 2014 nagios_service_contacts.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_service_contacts.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_service_contacts.MYI
-rw-rw---- 1 mysql mysql 9178 May 21 2014 nagios_servicedependencies.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_servicedependencies.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_servicedependencies.MYI
-rw-rw---- 1 mysql mysql 8790 May 21 2014 nagios_serviceescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_serviceescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_serviceescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql 8770 May 21 2014 nagios_serviceescalation_contacts.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_serviceescalation_contacts.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_serviceescalation_contacts.MYI
-rw-rw---- 1 mysql mysql 9220 May 21 2014 nagios_serviceescalations.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_serviceescalations.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_serviceescalations.MYI
-rw-rw---- 1 mysql mysql 8748 May 21 2014 nagios_servicegroup_members.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_servicegroup_members.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_servicegroup_members.MYI
-rw-rw---- 1 mysql mysql 8768 May 21 2014 nagios_servicegroups.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_servicegroups.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_servicegroups.MYI
-rw-rw---- 1 mysql mysql 8756 May 21 2014 nagios_service_parentservices.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_service_parentservices.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_service_parentservices.MYI
-rw-rw---- 1 mysql mysql 11766 May 21 2014 nagios_services.frm
-rw-rw---- 1 mysql mysql 1016 Jun 2 08:08 nagios_services.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 2 08:08 nagios_services.MYI
-rw-rw---- 1 mysql mysql 15448 May 21 2014 nagios_servicestatus.frm
-rw-rw---- 1 mysql mysql 2168 Jun 2 08:08 nagios_servicestatus.MYD
-rw-rw---- 1 mysql mysql 21504 Jun 2 08:08 nagios_servicestatus.MYI
-rw-rw---- 1 mysql mysql 9174 May 21 2014 nagios_statehistory.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_statehistory.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_statehistory.MYI
-rw-rw---- 1 mysql mysql 9110 May 21 2014 nagios_systemcommands.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_systemcommands.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_systemcommands.MYI
-rw-rw---- 1 mysql mysql 8914 May 21 2014 nagios_timedeventqueue.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_timedeventqueue.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_timedeventqueue.MYI
-rw-rw---- 1 mysql mysql 9104 May 21 2014 nagios_timedevents.frm
-rw-rw---- 1 mysql mysql 0 Jun 2 08:08 nagios_timedevents.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 2 08:08 nagios_timedevents.MYI
-rw-rw---- 1 mysql mysql 8760 May 21 2014 nagios_timeperiods.frm
-rw-rw---- 1 mysql mysql 1404 Jun 2 08:08 nagios_timeperiods.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 2 08:08 nagios_timeperiods.MYI
-rw-rw---- 1 mysql mysql 8794 May 21 2014 nagios_timeperiod_timeranges.frm
-rw-rw---- 1 mysql mysql 4074 Jun 2 08:08 nagios_timeperiod_timeranges.MYD
-rw-rw---- 1 mysql mysql 9216 Jun 2 08:08 nagios_timeperiod_timeranges.MYI
I just want the backup script to complete successfully.
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Thu Jun 02, 2016 10:34 am
by tgriep
It looks like the database is repaired now so go ahead and run the backup and see if it works now.
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Thu Jun 02, 2016 1:19 pm
by questrad
Well, i'm getting the same error.
Code: Select all
/usr/local/nagiosxi/scripts/backup_xi.sh
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
Could there be any issues with the backup script ?
Code: Select all
# ls -l /usr/local/nagiosxi/scripts/backup_xi.sh
-rwxr-x--- 1 nagios nagios 4696 Mar 10 2015 /usr/local/nagiosxi/scripts/backup_xi.sh
Re: updating from nagios XI 2014R2.6 to 2014R2.7
Posted: Thu Jun 02, 2016 3:23 pm
by tgriep
We are going to need more information from your server so you can open a ticket by emailing to
Reference this post and send in your system profile as well.
To send us your system profile
Click "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the file and email it back to us.
Thanks