Nagios XI backups failing

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
aap
Posts: 180
Joined: Wed Oct 12, 2011 4:01 am

Nagios XI backups failing

Post 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.
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Nagios XI backups failing

Post 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?
Former Nagios employee
https://www.mcapra.com/
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios XI backups failing

Post 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.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked