Page 1 of 1

Sql Error in Admin->System Config->Performance Settings

Posted: Mon Oct 17, 2011 2:08 pm
by cskang
I am trying out NagiosXI 2011 R1.7.
The package is CentOS 6 version on VMware.
I am running it on the host with Windows 7 Enterprise OS.
Browser using is Firefox 6.

I am getting a bunch of sql error messages when I selected a check box called, Use Unified Tactical Overview:, and then clicked Update Settings button.
The following is the error message appeared on the top portion of Admin->System Config->Performance Settings:

SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey" SQL: SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_options_pkey"

It looks like the similar post has been made by jrmartin on Fri Oct 14th under the title, "sql errors on update user settings".
I am glad that the fix is on the way.
Please let me know when it becomes available.

Regards,
Charles

Re: Sql Error in Admin->System Config->Performance Settings

Posted: Tue Oct 18, 2011 10:48 am
by mguthrie
This error actually shows up when there's a problem with the postgres sequences. Run:

Code: Select all

/usr/local/nagisoxi/tools/fix_postgres_sequences.sh 
and the message should disappear.

Re: Sql Error in Admin->System Config->Performance Settings

Posted: Wed Oct 19, 2011 5:12 pm
by cskang
Thanks.