Problems with update to 5.5.0

[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

[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';

[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

[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

[scottwilkerson]

Can you send me then nagiosxi database backup?

It would have to be extracted from that

[smersh]

Please check your PM.
NJ

[scottwilkerson]

replied with SQL to restore custom actions

[[email protected]]

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

[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

[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.