Hello,
my storage got disconnected during the image migration, resulting is stuck
migration. Task had been cleaned with restart of vdsdm service, but lead to
stuck disk image. The VM got powered down in the meantime, and currently I
cannot do anything with it, I always get a message like "Cannot Related
operation is currently in progress." I already used the unlock_entity.sh
script, it cleaned something, but did not help me. I cannot delete the VM,
delete the disk, delete the snapshots. I even deleted the wrong snapshot from
disk. All I need is it get rid of the VM and its disk, as I can restore it from
the backup. Could you please somebody try to navigate me how to solve the
problem? Engine log keeps filling up with messages which indicate there is an
orphaned task, however I am not sure what to delete from database:
2022-04-13 22:26:41,822+02 INFO [org.ovirt.engine.core.bll.StorageJobCallback]
(EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-87)
[e546bb30-7d18-4348-9c28-9dbbf4ab1893] Command CopyData id:
'62b1976b-729a-41ae-972c-a42de750ad1d': couldn't get the status of job
'6ef3cb28-14cf-486a-ad71-96484c1a596e' on host 'kvm2.finamis.com' (id:
'f880cfbe-5827-4853-a4fc-11199c439f79'), assuming it's still running
2022-04-13 22:26:41,846+02 INFO
[org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback]
(EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-87)
[e546bb30-7d18-4348-9c28-9dbbf4ab1893] Command 'LiveMigrateDisk' (id:
'3cd698fd-08a2-419e-bdd8-6b3516bb3127') waiting on child command id:
'2e9ad954-8f4e-41ed-9c75-015afeed337d' type:'CopyImageGroupVolumesData' to
complete
2022-04-13 22:26:41,847+02 INFO [org.ovirt.engine.core.bll.StorageJobCallback]
(EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-87)
[e546bb30-7d18-4348-9c28-9dbbf4ab1893] Command FenceVolumeJob id:
'831828a3-2e0f-4989-965b-91761fa9601f': job
'9dc88836-db04-49ae-b01e-18a56e24c91a' wasn't executed on any host, considering
the job status as failed
2022-04-13 22:26:41,847+02 INFO [org.ovirt.engine.core.bll.StorageJobCallback]
(EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-87)
[e546bb30-7d18-4348-9c28-9dbbf4ab1893] Command FenceVolumeJob id:
'831828a3-2e0f-4989-965b-91761fa9601f': execution was completed, the command
status is 'FAILED'
2022-04-13 22:26:42,850+02 ERROR
[org.ovirt.engine.core.bll.job.JobRepositoryImpl]
(EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-6)
[e546bb30-7d18-4348-9c28-9dbbf4ab1893] Failed to save step
'499b0207-61ba-4998-8cb8-2cb93b89422b', 'FINALIZING':
CallableStatementCallback; SQL [{call insertstep(?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)}ERROR: insert or update on table "step" violates foreign key
constraint "fk_step_job"
Detail: Key (job_id)=(ed10f993-cfd2-4a8b-806f-3fbd823101ef) is not present in
table "job".
Where: SQL statement "INSERT INTO step (
step_id,
parent_step_id,
job_id,
step_type,
description,
step_number,
status,
progress,
start_time,
end_time,
correlation_id,
external_id,
external_system_type,
is_external
)
VALUES (
v_step_id,
v_parent_step_id,
v_job_id,
v_step_type,
v_description,
v_step_number,
v_status,
v_progress,
v_start_time,
v_end_time,
v_correlation_id,
v_external_id,
v_external_system_type,
v_is_external
)"
PL/pgSQL function insertstep(uuid,uuid,uuid,character
varying,text,integer,character varying,smallint,timestamp with time
zone,timestamp with time zone,character varying,uuid,character varying,boolean)
line 3 at SQL statement; nested exception is org.postgresql.util.PSQLException:
ERROR: insert or update on table "step" violates foreign key constraint
"fk_step_job"
Detail: Key (job_id)=(ed10f993-cfd2-4a8b-806f-3fbd823101ef) is not present in
table "job".
Where: SQL statement "INSERT INTO step (
step_id,
parent_step_id,
job_id,
step_type,
description,
step_number,
status,
progress,
start_time,
end_time,
correlation_id,
external_id,
external_system_type,
is_external
)
VALUES (
v_step_id,
v_parent_step_id,
v_job_id,
v_step_type,
v_description,
v_step_number,
v_status,
v_progress,
v_start_time,
v_end_time,
v_correlation_id,
v_external_id,
v_external_system_type,
v_is_external
)"
PL/pgSQL function insertstep(uuid,uuid,uuid,character
varying,text,integer,character varying,smallint,timestamp with time
zone,timestamp with time zone,character varying,uuid,character varying,boolean)
line 3 at SQL statement
2022-04-13 22:26:42,851+02 ERROR
[org