Page 1 of 1

Nagios XI backups failing

Posted: Sat Aug 05, 2017 1:01 am
by aap
Hello,
The backup script is failing with the error

mysqldump: Error: 'Got error 28 from storage engine' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `nagios_acknowledgements`': Got error 28 from storage engine (1030)
Error backing up MySQL database 'nagios' - check the password in this script!

Currently running version 5.4.8

No passwords have been changed on the XI system.

Re: Nagios XI backups failing

Posted: Mon Aug 07, 2017 9:50 am
by mcapra
Have you verified there are no storage space issues on this machine? Error 28 usually pertains to that specifically. It can also be produced when the system's tmp dir has no space, even if the main path which holds the mysql files has plenty of space.

What is the output of df -h?

Re: Nagios XI backups failing

Posted: Mon Aug 07, 2017 12:18 pm
by tgriep
Thanks @mcapra for the help but I agree, that error is generated when the system's drive is out of space when dumping the MYSQL database.