updating from nagios XI 2014R2.6 to 2014R2.7

[questrad]

Please find the attached output. Yes, i can open a ticket - Can you provide the link to open a ticket ?

Thanks,

[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.

[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!

[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?

Code: Select all

ls -l /var/lib/mysql/nagios

[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.

[tgriep]

It looks like the database is repaired now so go ahead and run the backup and see if it works now.

[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

[tgriep]

We are going to need more information from your server so you can open a ticket by emailing to

Code: Select all

[email protected]

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