Page 1 of 2
Problems with update to 5.5.0
Posted: Thu Jul 05, 2018 9:19 am
by smersh
Hello,
Today I have performed the update from 5.4.13 to 5.5.
The log ended with the following:
Code: Select all
Nagios XI Upgrade Complete!
---------------------------
You can access the Nagios XI web interface by visiting:
http://192.168.0.90/nagiosxi/
cp: cannot stat ‘upgrade.log’: No such file or directory
And I have the message with the red background
"The update did not complete successfully. Please try updating manually."
However, the system looks ok.
UPDATE
Well, not really OK. All my custom actions are lost.
Were is Actions Component setup stored? Can I restore is form the backup?
How can I find what exactly went wrong? Do I really need manual update?
Thanks!
NJ
Re: Problems with update to 5.5.0
Posted: Thu Jul 05, 2018 10:30 am
by scottwilkerson
This actually appears upgraded.
Losing the action component settings is weird, it is normally stored in he nagiosxi DB serialized
Code: Select all
select * from xi_options where name='actions_component_options';
Re: Problems with update to 5.5.0
Posted: Thu Jul 05, 2018 10:41 am
by lmiltchev
I would like to add that I haven't been able to recreate the issue with losing custom actions on an upgrade. Are you sure that you don't have any crashed tables in the database? Can you run the db repair script to see if this is going to fix your issue?
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Re: Problems with update to 5.5.0
Posted: Thu Jul 05, 2018 4:02 pm
by smersh
Hello!
Looks like the script has found some problems with the DB, Indexes have benn fixed at several points. Particularly, for the xi_options I've got the following:
- recovering (with sort) MyISAM-table 'xi_options'
Data records: 183
- Fixing index 1
- Fixing index 2
However, it did not restore custom actions. May be because I have already recreated part of them prior to running the script?
The following returns only the recreated entries I wrote above.
echo "select * from xi_options where name='custom_component_options';" | mysql -uroot -pnagiosxi -Dnagiosxi
The DB in the backup archive contains everything I've lost, is there any way to update the new DB from the backup?
NJ
Re: Problems with update to 5.5.0
Posted: Thu Jul 05, 2018 5:01 pm
by scottwilkerson
Can you send me then nagiosxi database backup?
It would have to be extracted from that
Re: Problems with update to 5.5.0
Posted: Fri Jul 06, 2018 9:22 am
by smersh
Please check your PM.
NJ
Re: Problems with update to 5.5.0
Posted: Fri Jul 06, 2018 10:29 am
by scottwilkerson
replied with SQL to restore custom actions
Re: Problems with update to 5.5.0
Posted: Mon Jul 09, 2018 4:52 pm
Nagios Enterprises,
Apart from the SQL problems that may have to do with this users environment only.. Is there any new on the error:
cp: cannot stat ‘upgrade.log’: No such file or directory
I tried several updates (and reverted back to a snapshot) and the error reported is 100% reproducable.
Regards, Jørgen
Re: Problems with update to 5.5.0
Posted: Tue Jul 10, 2018 8:17 am
by scottwilkerson
This will be resolved in the next minor, but I will not it is not an actual error and that the upgrade did in fact complete, it is just an error in the log cleanup
Re: Problems with update to 5.5.0
Posted: Thu Jul 12, 2018 3:12 pm
by altsysrq
I just updated to the 5.5.1 release. I have the message with the red background
"The update did not complete successfully. Please try updating manually."
The logs from the update don't report any error. The install seems fine.
Running "/usr/local/nagiosxi/scripts/repair_databases.sh" seems to fix several issues, until I run it again and it reports fixing the same issues.
I can create a new thread if needed.