Sql Error in Admin->System Config->Performance Settings
Posted: Mon Oct 17, 2011 2:08 pm
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
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