Errors in DB trying to upgrade to XI 5

[snapon_admin]

I'm trying to upgrade our test server to XI 5 and I'm getting several exciting errors. At first there were several "error: 130" errors with different tables that had issues. I ran repairs on each of those (half a dozen or so) and now I'm getting:

Code: Select all

mysqldump: Got error: 144: Table './nagios/nagios_processevents' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES

I've tried running the repair_databases script and the repairmysql script and neither seem to be fixing the issue. Thoughts?

[hsmith]

Did you have anything interesting going on such as an offloaded database?

[snapon_admin]

Nope, we have an incredibly boring setup. No offloaded DB or anything like that.

[hsmith]

What OS? I ran the upgrade script so many times in testing and could never make it do anything too interesting. Do you have an upgrade.log we can take a look at?

[snapon_admin]

Sorry, CentOS 6, XI current version is 2014R2.5. Where do I find the update.log?

[hsmith]

It should be wherever you are running the ./upgrade script from. In my case, I am running it from /tmp/nagiosxi.

[snapon_admin]

Ah, I was running it from the GUI.

[hsmith]

You can always find / -name upgrade.log from the terminal.

[snapon_admin]

Yep, just did that.

Code: Select all

---- Starting Nagios XI Backup ----
No entry for terminal type "unknown";
using dumb terminal settings.
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/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
tar: /usr/local/nagios/share/perfdata/kenacmp01t_on_kentest06g: file changed as we read it
tar: /usr/local/nagios/share/perfdata/KENO-CSHP-01-TV: file changed as we read it
tar: /usr/local/nagios/share/perfdata/kendbms05q_on_kentest07g: file changed as we read it
tar: /usr/local/nagios/share/perfdata/kenacic02t_on_kentest05g: 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_processevents' 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!

[hsmith]

Did you change the password on the database by chance?