Page 1 of 1

Upgrade from 5.2.9 to 5.3.0 Limits Issue

Posted: Thu Oct 06, 2016 3:56 am
by jwessels
Hi Support,

I am trying to upgrade my Nagios XI 5.2.9 version to 5.3.0, the installation process has installed and upgraded most components, but I get the following error:

Dashlets installed/updated OK
ALTER TABLE
ALTER TABLE
UPDATE 7
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:24: ERROR: relation "xi_eventqueue_eventqueue_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:33: ERROR: relation "xi_eventqueue" already exists
Attempting to read global hard/soft nofile limits failed. Check /etc/security/limits.conf and try again!

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Posted: Thu Oct 06, 2016 10:01 am
by jomann
Hello,

This is an issue with some systems that don't allow us to update the file limits, which isn't necessary it's just a performance tweak.

It is safe to comment out line 834 in the upgrade script and then run it again. Since it looks like you successfully ran the DB portion, if you'd like to not get the DB errors, you can also comment out lines 820-828.

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Posted: Thu Oct 06, 2016 11:48 pm
by jwessels
Thank you! I have successfully upgraded to 5.3.0.

I had to uncomment lines 820-828 & 834 for it to complete.

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Posted: Fri Oct 07, 2016 10:17 am
by jomann
Great, I'm going to close this, feel free to open a new thread if you encounter any other problems.