Checked my old notes, had to directly alter PostgreSQL db several times,
yet my cases were different.
I think this can be still fixed with editing PostgeSQL database directly.
A blueprint for your solution may be found here, someone from Red Hat
had to clarify:
https://noeschanga.wordpress.com/2018/02/09/how-to-solve-snapshots-state-locked-in-ovirt-4-1/
This for example is a fix for unknown VM status.
su - postgres
psql engine
select vm_guid from vm_static where vm_name='MyProblematicVM';
vm_guid
--
b1b8d576-9567--y-xxx
(1 row)
select status from vm_dynamic where
vm_guid='b1b8d576-9567--y-xxx';
status
7
(1 row)
update vm_dynamic SET status=0 where
vm_guid='b1b8d576-9567--y-xxx';
update vm_dynamic SET run_on_vds=null WHERE
vm_guid='b1b8d576-9567--y-xxx';
On 9/23/22 20:22, Clint Boggio wrote:
Attempting to create another snapshot fails with this snippit:
- Result: 'cleanSuccess'
-- Message: 'VDSGenericException: VDSErrorException: Failed in vdscommand to
HSMGetAllTasksStatusesVDS, error = Cannot create volume snapshot from illegal
volume: (u'576b2761-a5bc-427b-95a9-0594447f0705',)',
-- Exception: 'VDSGenericException: VDSErrorException: Failed in vdscommand to
HSMGetAllTasksStatusesVDS, error = Cannot create volume snapshot from illegal
volume: (u'576b2761-a5bc-427b-95a9-0594447f0705',)'
2022-09-23 12:17:08,031-05 INFO
[org.ovirt.engine.core.bll.tasks.CommandAsyncTask]
(EE-ManagedThreadFactory-engineScheduled-Thread-41) []
CommandAsyncTask::endActionIfNecessary: All tasks of command
'2505390c-dd54-41ff-91f5-b56af5b0b3ee' has ended -> executing 'endAction'
2022-09-23 12:17:08,031-05 INFO
[org.ovirt.engine.core.bll.tasks.CommandAsyncTask]
(EE-ManagedThreadFactory-engineScheduled-Thread-41) []
CommandAsyncTask::endAction: Ending action for '1' tasks (command ID:
'2505390c-dd54-41ff-91f5-b56af5b0b3ee'): calling endAction '.
2022-09-23 12:17:08,032-05 INFO
[org.ovirt.engine.core.bll.tasks.CommandAsyncTask]
(EE-ManagedThreadFactory-engine-Thread-73809) []
CommandAsyncTask::endCommandAction [within thread] context: Attempting to
endAction 'CreateSnapshot',
2022-09-23 12:17:08,041-05 INFO
[org.ovirt.engine.core.bll.snapshots.CreateSnapshotCommand]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] Command
[id=2505390c-dd54-41ff-91f5-b56af5b0b3ee]: Updating status to 'FAILED', The
command end method logic will be executed by one of its parent commands.
2022-09-23 12:17:08,042-05 INFO
[org.ovirt.engine.core.bll.tasks.CommandAsyncTask]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] CommandAsyncTask::HandleEndActionResult
[within thread]: endAction for action type 'CreateSnapshot' completed, handling
the result.
2022-09-23 12:17:08,042-05 INFO
[org.ovirt.engine.core.bll.tasks.CommandAsyncTask]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] CommandAsyncTask::HandleEndActionResult
[within thread]: endAction for action type 'CreateSnapshot' succeeded, clearing
tasks.
2022-09-23 12:17:08,042-05 INFO [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] SPMAsyncTask::ClearAsyncTask: Attempting
to clear task '835aef5c-ff62-4d14-aa24-4b82321e866d'
2022-09-23 12:17:08,043-05 INFO
[org.ovirt.engine.core.vdsbroker.irsbroker.SPMClearTaskVDSCommand]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] START, SPMClearTaskVDSCommand(
SPMTaskGuidBaseVDSCommandParameters:{storagePoolId='31fdd642-6b06-11ea-a4c4-00163e333bd2',
ignoreFailoverLimit='false', taskId='835aef5c-ff62-4d14-aa24-4b82321e866d'}),
log id: a9fec48
2022-09-23 12:17:08,043-05 INFO
[org.ovirt.engine.core.vdsbroker.vdsbroker.HSMClearTaskVDSCommand]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] START, HSMClearTaskVDSCommand(HostName =
hprvsr02.locacore.com,
HSMTaskGuidBaseVDSCommandParameters:{hostId='ecad78a5-58e3-4fcd-8b84-e30e3e1993cf',
taskId='835aef5c-ff62-4d14-aa24-4b82321e866d'}), log id: 6712f5cc
2022-09-23 12:17:08,076-05 INFO
[org.ovirt.engine.core.vdsbroker.vdsbroker.HSMClearTaskVDSCommand]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] FINISH, HSMClearTaskVDSCommand, return:
, log id: 6712f5cc
2022-09-23 12:17:08,076-05 INFO
[org.ovirt.engine.core.vdsbroker.irsbroker.SPMClearTaskVDSCommand]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] FINISH, SPMClearTaskVDSCommand, return:
, log id: a9fec48
2022-09-23 12:17:08,087-05 INFO [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
(EE-ManagedThreadFactory-engine-Thread-73809)
[dacd81ee-2d8c-4f8e-a590-181c0082bcea] BaseAsyncTask::removeTaskFromDB: Removed
task