Page 1 of 3
Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 8:16 am
by 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?
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 9:26 am
by hsmith
Did you have anything interesting going on such as an offloaded database?
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 9:29 am
by snapon_admin
Nope, we have an incredibly boring setup. No offloaded DB or anything like that.
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 9:31 am
by 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?
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 9:36 am
by snapon_admin
Sorry, CentOS 6, XI current version is 2014R2.5. Where do I find the update.log?
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 9:56 am
by hsmith
It should be wherever you are running the ./upgrade script from. In my case, I am running it from /tmp/nagiosxi.
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 10:17 am
by snapon_admin
Ah, I was running it from the GUI.
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 10:23 am
by hsmith
You can always find / -name upgrade.log from the terminal.
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 10:26 am
by 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!
Re: Errors in DB trying to upgrade to XI 5
Posted: Tue Oct 06, 2015 10:27 am
by hsmith
Did you change the password on the database by chance?