[ovirt-users] Re: disk_vm_element ERROR: duplicate key value violates unique constraint "pk_disk_vm_element"

Hello, when i tried to attach a snapshot disk into my backupvm. oVirt doesn't want to attach it. In the engine.log I can see this. 2018-08-04 19:20:04,472-10 ERROR [org.ovirt.engine.core.bll.storage.disk.AttachDiskToVmCommand] (default task-33) [646ad7a1-4501-4648-a937-bbee0abaec46] Command 'org.ovirt.engine.core.bll.storage.disk.AttachDiskToVmCommand' failed: CallableStatementCallback; SQL [{call insertdiskvmelement(?, ?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint "pk_disk_vm_element" Detail: Key (vm_id, disk_id)=(78ef239f-3cb3-4eef-921f-f989724009ef, c7cef731-e31d-4597-80f1-1f2393cd66ea) already exists. Where: SQL statement "INSERT INTO disk_vm_element ( disk_id, vm_id, is_boot, pass_discard, disk_interface, is_using_scsi_reservation) VALUES ( v_disk_id, v_vm_id, v_is_boot, v_pass_discard, v_disk_interface, v_is_using_scsi_reservation)" PL/pgSQL function insertdiskvmelement(uuid,uuid,boolean,boolean,character varying,boolean) line 3 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_disk_vm_element" Detail: Key (vm_id, disk_id)=(78ef239f-3cb3-4eef-921f-f989724009ef, c7cef731-e31d-4597-80f1-1f2393cd66ea) already exists. When i SQL the database, the entries is present (and many other). But in the webinterface, I can't see them on the backupVM. It's just like ovirt didn't delete old entries engine=# select * from disk_vm_element where vm_id = '78ef239f-3cb3-4eef-921f-f989724009ef' and disk_id = 'c7cef731-e31d-4597-80f1-1f2393cd66ea' ; disk_id | vm_id | is_boot | disk_interface | is_using_scsi_reservation | pass_discard --------------------------------------+--------------------- -----------------+---------+----------------+--------------- ------------+-------------- c7cef731-e31d-4597-80f1-1f2393cd66ea | 78ef239f-3cb3-4eef-921f-f989724009ef | f | VirtIO | f | f (1 row) Do you guys have any idea on how to correct this ? Is there any function to update / refresh this table ? I dont want to delete entries by sql as i don't know the consequences, is it safe to delete entries ? Thank you for your help _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community- guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/ message/PXGZ62TGLMO7PTBKVPSTZCEBRAW2L5QK/