Page 1 of 2
ftp backups stopped working
Posted: Mon May 30, 2016 2:49 am
by WillemDH
It seems last week our ftp backups stopped working, plus minus around the day after I upgraded to 5.2.7. The backups were still created in /store/backups/nagiosxi but not ftp'd to the home directory of the ftp user defined in scheduled ftp backups. This behaviour resulted in the root disk of my XI production server filling up very fast. It seems the folders in /store/backups/nagiosxi are not zipped / tarred.
Tests of the ftp backup settings with 'test connection' and 'test user' are all succesfully.
Secondary issue came up during troubleshooting => While troubleshooting the issue I enabled local backup and tried backing up to a mounted nfs share. While testing the permissions, my browser hung and I had to manually restart the httpd service on the XI server to be able to continue working.
Tertiary issue I noticed. When trying to choose 10:00 as local backup time, the minutes dropdownbox keeps getting reset to 59...
Please let me know what I can do to make the sftp backups work again.
Re: ftp backups stopped working
Posted: Tue May 31, 2016 2:02 am
by WillemDH
? Guys? What about my "1-business day guaranteed response time"?
So the backup again didn't run. What script is run exactly when an ftp backup is initiated?
Re: ftp backups stopped working
Posted: Tue May 31, 2016 9:55 am
by tmcdonald
WillemDH wrote:? Guys? What about my "1-business day guaranteed response time"? :)
U.S. holiday, sorry! Posted about it here:
https://support.nagios.com/forum/viewto ... 39&t=38610
We were just discussing this a few minutes ago, and
@lmiltchev will be testing it internally. We've had some other reports of odd behavior in scheduled backups, so it's possibly a bug. Will keep you posted.
Re: ftp backups stopped working
Posted: Tue May 31, 2016 10:45 am
by lmiltchev
Willem, I, Ian, and Matt tested scheduled ftp backups in 5.2.7 & 5.2.8, and didn't find any issues. Can you post the "/usr/local/nagiosxi/var/components/scheduledbackups.log"?
Re: ftp backups stopped working
Posted: Wed Jun 01, 2016 8:43 am
by WillemDH
Here you go:
Code: Select all
05-11-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-11-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-12-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-12-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-13-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-13-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-14-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-14-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-15-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-15-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-16-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-16-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-17-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-17-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-18-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-18-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-19-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-19-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-20-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-20-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-21-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-21-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-22-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-22-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-23-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-23-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-24-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-24-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-24-2016 00:17:45 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-25-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-25-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-25-2016 00:17:11 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-26-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-26-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-26-2016 00:17:24 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-27-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-27-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-27-2016 00:17:44 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-28-2016 00:05:02 DEBUG: Running scheduled FTP backup ...
05-28-2016 00:05:02 DEBUG: Sending create local backup command to CmdSubsystem
05-28-2016 00:20:06 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-29-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-29-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-29-2016 00:17:25 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-30-2016 00:05:01 DEBUG: Running scheduled FTP backup ...
05-30-2016 00:05:01 DEBUG: Sending create local backup command to CmdSubsystem
05-30-2016 00:17:10 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-30-2016 10:00:02 DEBUG: Running scheduled FTP backup ...
05-30-2016 10:00:02 DEBUG: Sending create local backup command to CmdSubsystem
05-30-2016 10:12:27 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-30-2016 10:59:01 DEBUG: Running scheduled local backup ...
05-30-2016 10:59:01 INFO: Creating a local backup: nagiosxi.1464598741
05-31-2016 10:00:01 DEBUG: Running scheduled FTP backup ...
05-31-2016 10:00:01 DEBUG: Sending create local backup command to CmdSubsystem
05-31-2016 10:12:31 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
05-31-2016 10:59:01 DEBUG: Running scheduled local backup ...
05-31-2016 10:59:01 INFO: Creating a local backup: nagiosxi.1464685141
06-01-2016 10:00:01 DEBUG: Running scheduled FTP backup ...
06-01-2016 10:00:01 DEBUG: Sending create local backup command to CmdSubsystem
06-01-2016 10:12:29 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist
06-01-2016 10:59:01 DEBUG: Running scheduled local backup ...
06-01-2016 10:59:01 INFO: Creating a local backup: nagiosxi.1464771541
So "Local file to transfer does not exist" => Where would it look for the local backups. I suspected /store/backups/nagiosxi
Code: Select all
ls -la /store/backups/nagiosxi
total 28
drwxr-xr-x 7 nagios nagios 4096 Jun 1 10:00 .
drwxr-xr-x. 5 root root 4096 May 29 2013 ..
drwxr-xr-x 4 nagios users 4096 May 27 00:17 nagiosxi.1464300301
drwxr-xr-x 4 nagios users 4096 May 28 00:20 nagiosxi.1464386702
drwxr-xr-x 4 nagios users 4096 May 29 00:17 nagiosxi.1464473101
drwxr-xr-x 4 nagios users 4096 May 30 10:12 nagiosxi.1464595202
drwxr-xr-x 4 nagios users 4096 Jun 1 10:12 nagiosxi.1464768001
Re: ftp backups stopped working
Posted: Wed Jun 01, 2016 12:38 pm
by tgriep
The backup has to create the local file first and then copy it to the remote server and is looks like the local backup isn't working.
Can you delete the folders in the /store/backups/nagiosxi folder and try and run a local backup manually so see if there are any errors generated?
Run the following to create the local backup.
Code: Select all
/usr/local/nagiosxi/scripts/backup_xi.sh
Post any errors and then we can go from there.
Re: ftp backups stopped working
Posted: Thu Jun 02, 2016 5:30 am
by WillemDH
Output:
Code: Select all
/usr/local/nagiosxi/scripts/backup_xi.sh
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
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/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server/2_48_Bandwidth.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
tar: /usr/local/nagios/share/perfdata/server: file changed as we read it
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 Nagvis...
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!
I replaced the different hosts with 'server'. How is the password provided to the backup Basch script?
Re: ftp backups stopped working
Posted: Thu Jun 02, 2016 10:29 am
by tgriep
The script retrieves the mysql password from the config files on the XI server but the issue is that the MYSQL database needs to be repaired.
To repair the MYSQL database, login as root and run the following.
Code: Select all
cd /usr/local/nagiosxi/scripts
./repair_databases.sh
After this, try running the backup again.
If the MYSQL database if offloaded to a remote server, you can run this to repair it.
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi --databases nagios -h xxx.xxx.xxx.xxx
Change the xxx.xxx.xxx.xxx to the IP address of the server and the username and password if they are not default.
Re: ftp backups stopped working
Posted: Thu Jun 02, 2016 12:09 pm
by WillemDH
Repair output:
Code: Select all
./repair_databases.sh
mysqld (pid 2350) is running...
mysqld (pid 2350) is running...
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /usr/local/nagiosxi/scripts
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 6339
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_commands.MYI'
Data records: 322
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_commenthistory.MYI'
Data records: 645021
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_comments.MYI'
Data records: 173
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_configfiles.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_configfilevariables.MYI'
Data records: 133
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_conninfo.MYI'
Data records: 9143
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_contact_addresses.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactgroup_members.MYI'
Data records: 114
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactgroups.MYI'
Data records: 22
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands.MYI'
Data records: 996
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods.MYI'
Data records: 51417
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_contactnotifications.MYI'
Data records: 51417
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'nagios_contacts.MYI'
Data records: 83
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactstatus.MYI'
Data records: 83
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_customvariables.MYI'
Data records: 12914
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_customvariablestatus.MYI'
Data records: 12914
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with keycache) MyISAM-table 'nagios_dbversion.MYI'
Data records: 1
---------
- recovering (with sort) MyISAM-table 'nagios_downtimehistory.MYI'
Data records: 360482
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_eventhandlers.MYI'
Data records: 21
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_externalcommands.MYI'
Data records: 8660
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_flappinghistory.MYI'
Data records: 44367
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_hostchecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_contactgroups.MYI'
Data records: 930
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_contacts.MYI'
Data records: 1477
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostdependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostgroup_members.MYI'
Data records: 5130
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostgroups.MYI'
Data records: 191
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_parenthosts.MYI'
Data records: 6
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hosts.MYI'
Data records: 878
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_hoststatus.MYI'
Data records: 878
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19
---------
- recovering (with sort) MyISAM-table 'nagios_instances.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_logentries.MYI'
Data records: 308271
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
Data records: 2117433
---------
- recovering (with sort) MyISAM-table 'nagios_notifications.MYI'
Data records: 106839
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'nagios_objects.MYI'
Data records: 30562
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'nagios_processevents.MYI'
Data records: 9789
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_programstatus.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_runtimevariables.MYI'
Data records: 18
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime.MYI'
Data records: 98
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicechecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_service_contactgroups.MYI'
Data records: 16439
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_service_contacts.MYI'
Data records: 17768
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicedependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicegroup_members.MYI'
Data records: 21024
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicegroups.MYI'
Data records: 95
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_service_parentservices.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_services.MYI'
Data records: 16317
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_servicestatus.MYI'
Data records: 16317
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19
---------
- recovering (with sort) MyISAM-table 'nagios_statehistory.MYI'
Data records: 1664501
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_systemcommands.MYI'
Data records: 92
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_timedeventqueue.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'nagios_timedevents.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'nagios_timeperiods.MYI'
Data records: 93
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges.MYI'
Data records: 619
- Fixing index 1
- Fixing index 2
Starting mysqld: [ OK ]
/usr/local/nagiosxi/scripts
===============
REPAIR COMPLETE
===============
mysqld (pid 2711) is running...
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql /usr/local/nagiosxi/scripts
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'tbl_command.MYI'
Data records: 327
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contactgroup.MYI'
Data records: 23
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contact.MYI'
Data records: 82
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contacttemplate.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_domain.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostdependency.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostescalation.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostgroup.MYI'
Data records: 191
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_host.MYI'
Data records: 903
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hosttemplate.MYI'
Data records: 80
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_info.MYI'
Data records: 218
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup.MYI'
Data records: 4
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact.MYI'
Data records: 2
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup.MYI'
Data records: 2
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost.MYI'
Data records: 6
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService.MYI'
Data records: 6
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup.MYI'
Data records: 40
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate.MYI'
Data records: 80
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition.MYI'
Data records: 98
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup.MYI'
Data records: 79
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost.MYI'
Data records: 507
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup.MYI'
Data records: 4
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact.MYI'
Data records: 17
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup.MYI'
Data records: 16
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate.MYI'
Data records: 55
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup.MYI'
Data records: 950
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact.MYI'
Data records: 1404
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup.MYI'
Data records: 2861
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost.MYI'
Data records: 6
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate.MYI'
Data records: 904
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition.MYI'
Data records: 2219
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup.MYI'
Data records: 17
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService.MYI'
Data records: 117
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup.MYI'
Data records: 15
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact.MYI'
Data records: 142
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup.MYI'
Data records: 335
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate.MYI'
Data records: 83
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition.MYI'
Data records: 19
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup.MYI'
Data records: 16004
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact.MYI'
Data records: 16465
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost.MYI'
Data records: 16572
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup.MYI'
Data records: 9046
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate.MYI'
Data records: 16114
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition.MYI'
Data records: 10861
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_logbook.MYI'
Data records: 5
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_mainmenu.MYI'
Data records: 7
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_servicedependency.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_serviceescalation.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_serviceextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_servicegroup.MYI'
Data records: 95
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_service.MYI'
Data records: 16604
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_servicetemplate.MYI'
Data records: 401
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_settings.MYI'
Data records: 13
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_submenu.MYI'
Data records: 29
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_timedefinition.MYI'
Data records: 625
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_timeperiod.MYI'
Data records: 92
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_user.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_variabledefinition.MYI'
Data records: 17223
- Fixing index 1
Starting mysqld: [ OK ]
/usr/local/nagiosxi/scripts
===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
Started a backup ( not sure if I will be able to post the output today)
Re: ftp backups stopped working
Posted: Thu Jun 02, 2016 12:13 pm
by lmiltchev
Started a backup ( not sure if I will be able to post the output today)
Whenever you are ready...