Upgrade fails from 5.4.13 to 5.5.0

[jdulac]

Hello,

Trying to upgrade from 5.4.13 to 5.5.0 and the following fails:

Starting nrpe
NRPE installed OK
Updating NRDP..
ALTER TABLE
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:11: ERROR: relation "xi_cmp_trapdata_trapdata_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:17: ERROR: relation "xi_cmp_trapdata_trapdata_log_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:34: ERROR: relation "xi_cmp_trapdata" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:54: ERROR: relation "xi_cmp_trapdata_log" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:61: ERROR: relation "xi_auth_tokens_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:75: ERROR: relation "xi_auth_tokens" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:82: ERROR: relation "xi_sessions_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_03.sql:96: ERROR: relation "xi_sessions" already exists

Thoughts?

Thanks
Jeff

[lmiltchev]

If your upgrade hangs at:

Code: Select all

NRPE installed OK
Updating NRDP..

most probably you will need to comment out a section of the code in the upgrade script that deals with Ajaxterm, and rerun the upgrade script from the command line. For more information, please see this post:

https://support.nagios.com/forum/viewto ... 08#p255370

Let us know if this helped. Thank you!

[jdulac]

I re-ran the upgrade and attached a copy of the log. Can you take one more peek?

[lmiltchev]

Run the following commands:

Code: Select all

cd /tmp/nagiosxi
touch mysql.5500.updated

then rerun the upgrade script:

Code: Select all

./upgrade

Let us know if the upgrade finish successfully this time. Thanks!

[jdulac]

All,

Thanks for the responses. I was on vacation through 7/18 and it looks like a new revision is now out 5.5.1. I am now getting a message indicating that it cannot connect to the mirror sites. I will try again tomorrow and post my results.

[lmiltchev]

Sure, let us know. Try:

Code: Select all

yum clean all
yum update

first. Were you able to update?

Are you using a proxy?

[jomann]

Great let us know how it goes and if you have any errors.