Unable to update to version 5.4.11

[demi]

Hello,
I need some assistance with getting past errors while trying to upgrade to version 5.4.11. I have tried running the sql repair scripts as well as tried performing an automatic volume increase using the resizing script, but nothing seems to be working for me. I have cleared on many of the old backups and larger older log files as well. Here is the error I'm receiving:
acking 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: 130: Incorrect file format 'nagios_systemcommands' when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

I'm also receiving this warning in the console: localhost root partition DISK CRITICAL - free space: / 4554 MB (23% inode=88%):

[npolovenko]

Hello, @demi.

I'm also receiving this warning in the console: localhost root partition DISK CRITICAL - free space: / 4554 MB (23% inode=88%):

That doesn't seem like a lot of space. Try increasing the disk size and then run the ./repair_databases.sh script from the /usr/local/nagiosxi/scripts/ folder.

[demi]

I shutdown my vm and resized the volume, then powered back on and ran the resize script. It did not work so I followed the resize manually instructions and it damaged the boot partition. Any other ideas on resizing?

[dwhitfield]

I have cleared on many of the old backups and larger older log files as well.

Where do you store your backups? If they are in one of the directories that the backup is trying to backup, that could be the source of the issue.

Are you able to log in to mysql from the command line? Something like mysql -uroot -pnagiosxi

[demi]

Yes, I am able to log into MySQL from the command line.

[lmiltchev]

Can you run the following commands from the command line, and show the output?

Code: Select all

echo 'repair table nagios_systemcommands use_frm;' | mysql -t -uroot -pnagiosxi nagios
mysqlcheck -f -r -uroot -pnagiosxi --databases nagios
tail -50 /var/log/mysqld.log
tail -50 /var/log/mariadb/mariadb.log
df -h
ls -la /store/backups/nagiosxi

Note: The first two commands should repair the nagios_systemcommands table (and other crashed tables) in the nagios database. The two tail commands (depending on whether you use mysql or mariadb) should show us if there are any errors in the log. We also need to see how much disk space you have. Running out of disk space can, and most probably will corrupt the database. The last command should show us if you have any "incomplete" backups in the "/store/backups/nagiosxi" directory.