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 laterInformation 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 |