OLVM: Unable to RefreshCapabilities: PSQLException: ERROR: duplicate key value violates unique constraint "name_server_pkey" (Doc ID 3037592.1)

Last updated on JULY 26, 2024

Applies to:

Symptoms

Customer unable to activate KVM hosts in OLVM Admin portal. On the OLVM Engine, the following errors are seen

engine.log

~snip~

PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3 at SQL statement
2024-07-25 03:29:06,461+05 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.GetHardwareInfoAsyncVDSCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-36) [] START, GetHardwareInfoAsyncVDSCommand(HostName = kvm01, VdsIdAndVdsVDSCommandParametersBase:{hostId='dxxxxxxb-dxxa-4xxf-bxx9-1xxxxxxxxxx2', vds='Host[kvm01,dxxxxxxb-dxxa-4xxf-bxx9-1xxxxxxxxxx2]'}), log id: 2b639c56
2024-07-25 03:29:06,461+05 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.GetHardwareInfoAsyncVDSCommand] (EE-ManagedThreadFactory-engineScheduled-Thread-36) [] FINISH, GetHardwareInfoAsyncVDSCommand, return: , log id: 2b639c56
2024-07-25 03:29:06,466+05 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (EE-ManagedThreadFactory-engineScheduled-Thread-36) [] transaction rolled back
2024-07-25 03:29:06,466+05 ERROR [org.ovirt.engine.core.vdsbroker.monitoring.HostMonitoring] (EE-ManagedThreadFactory-engineScheduled-Thread-36) [] Unable to RefreshCapabilities: PSQLException: ERROR: duplicate key value violates unique constraint "name_server_pkey" <<<<<<<<<<<<
Detail: Key (dns_resolver_configuration_id, address)=(dxxxxxxb-dxxa-4xxf-bxx9-1xxxxxxxxxx2, B.B.B.B) already exists.
Where: SQL statement "INSERT INTO
name_server(
address,
position,
dns_resolver_configuration_id)
VALUES (
v_address,
v_position,
v_dns_resolver_configuration_id)"
PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3 at SQL statement

~snip~

Changes

Customer has performed reconfiguration via custom Ansible scripts.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.