Upgrade from 5.2.9 to 5.3.0 Limits Issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jwessels
Posts: 16
Joined: Mon May 12, 2014 5:57 am

Upgrade from 5.2.9 to 5.3.0 Limits Issue

Post 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!
jomann
Development Lead
Posts: 611
Joined: Mon Apr 22, 2013 10:06 am
Location: Nagios Enterprises

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
jwessels
Posts: 16
Joined: Mon May 12, 2014 5:57 am

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Post by jwessels »

Thank you! I have successfully upgraded to 5.3.0.

I had to uncomment lines 820-828 & 834 for it to complete.
jomann
Development Lead
Posts: 611
Joined: Mon Apr 22, 2013 10:06 am
Location: Nagios Enterprises

Re: Upgrade from 5.2.9 to 5.3.0 Limits Issue

Post by jomann »

Great, I'm going to close this, feel free to open a new thread if you encounter any other problems.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked