Page 1 of 1

Upgrade fails from 5.4.13 to 5.5.0

Posted: Wed Jul 04, 2018 8:20 am
by 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

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Thu Jul 05, 2018 9:43 am
by 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!

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Mon Jul 09, 2018 6:43 pm
by jdulac
I re-ran the upgrade and attached a copy of the log. Can you take one more peek?

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Tue Jul 10, 2018 10:58 am
by 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!

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Thu Jul 19, 2018 4:11 pm
by 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.

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Thu Jul 19, 2018 4:17 pm
by 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?

Re: Upgrade fails from 5.4.13 to 5.5.0

Posted: Thu Jul 19, 2018 4:19 pm
by jomann
Great let us know how it goes and if you have any errors.