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

[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

[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.

[cskang]

Thanks.