My Oracle Support Banner

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:

Linux OS - Version Oracle Linux 7.6 with Unbreakable Enterprise Kernel [4.14.35] and later
Information in this document applies to any platform.
OLVM 4.3, OLVM 4.4 and OLVM 4.5

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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