ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom

Hi all. I've deployed a VM from a corrupted template (it's disk is missing, but I've checked it later...). My Software Version is:4.3 Now, I have an unmanaged VM in inventory and unable to remove it too. It's reference is "locked image". I've restarted ovirt-engine many times on self-hosted engine and hosts too, but no benefits. So, what's now? I've also consulted: https://access.redhat.com/solutions/396753 but still no results. No tasks or items results to be "locked"... Any other ideas? Thanks a lot.

On Tue, Nov 17, 2020, 16:12 <3c.monitor@gruppofilippetti.it> wrote:
Hi all. I've deployed a VM from a corrupted template (it's disk is missing, but I've checked it later...). My Software Version is:4.3 Now, I have an unmanaged VM in inventory and unable to remove it too. It's reference is "locked image". I've restarted ovirt-engine many times on self-hosted engine and hosts too, but no benefits. So, what's now? I've also consulted: https://access.redhat.com/solutions/396753 but still no results. No tasks or items results to be "locked"... Any other ideas?
You might try using some of the tools mentioned at https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities.html There is an unlock tool.
Thanks a lot. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/7IK2IAJTEMNR7I...

Hi. taskcleaner and unlock_entity are just 2 items of reported rhel solution I've used , but didn't worked. Locked Image still there! Thanks. M.

On Tue, Nov 17, 2020, 18:42 <3c.monitor@gruppofilippetti.it> wrote:
Hi. taskcleaner and unlock_entity are just 2 items of reported rhel solution I've used , but didn't worked. Locked Image still there!
I would try also to unlock it at db. Some steps from version 3.x. should be same for 4.x: log into the DB and perform the following SELECT vm_name frim vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); See if you get the VM which the disk is locked on it. If so do: SELECT image_guid from vm_images_view where imagestatus=2; # Get the guid returned and then Update images SET imagestatus=1 where image_guid = {The guid which returned in the last query} Thanks.
M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/74QMVFTM356GHF...

Hi, it seems not work... bash-4.2$ psql psql (10.6) Type "help" for help. postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); ERROR: relation "vms" does not exist LINE 1: SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM... ^ postgres=# Thanks a lot anyway. M.

On Wed, Nov 25, 2020 at 8:05 PM <3c.monitor@gruppofilippetti.it> wrote:
Hi, it seems not work...
bash-4.2$ psql psql (10.6) Type "help" for help.
postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); ERROR: relation "vms" does not exist LINE 1: SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM...
seems you did not connect at engine DB. At ovirt 4.3, do the following: 1. ssh at engine 2. su - postgres -c 'scl enable rh-postgresql10 -- psql' 3. \c engine 4. SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); 5. SELECT image_guid from vm_images_view where imagestatus=2; 6. update images SET imagestatus=1 where image_guid = {The guid which returned in the last query} ^
postgres=#
Thanks a lot anyway. M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KWGD5PB7ACRAJ7...

Hi. Now select suggested works (thanks), but still no results: # su - postgres -c 'scl enable rh-postgresql10 -- psql' psql (10.6) Type "help" for help. postgres=# \c engine You are now connected to database "engine" as user "postgres". engine=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); vm_name --------- (0 rows) engine=# SELECT image_guid from vm_images_view where imagestatus=2; image_guid ------------ (0 rows) engine=# Indeed, as reported, locked image is always there... Thanks, M.

Hi. I did a full select on "vms" and field "imagestatus" there isn't! May be this the reason for which the tool is unable to manage it? Follows full field list: "vm_name","mem_size_mb","max_memory_size_mb","num_of_io_threads","nice_level","cpu_shares","vmt_guid","os","description","free_text_comment","cluster_id","creation_date","auto_startup","lease_sd_id","lease_info","is_stateless","is_smartcard_enabled","is_delete_protected","sso_method","dedicated_vm_for_vds","default_boot_sequence","vm_type","vm_pool_spice_proxy","cluster_name","transparent_hugepages","trusted_service","storage_pool_id","storage_pool_name","cluster_spice_proxy","vmt_name","status","vm_ip","vm_ip_inet_array","vm_host","last_start_time","boot_time","downtime","guest_cur_user_name","console_cur_user_name","runtime_name","guest_os","console_user_id","guest_agent_nics_hash","run_on_vds","migrating_to_vds","app_list","vm_pool_name","vm_pool_id","vm_guid","num_of_monitors","single_qxl_pci","allow_console_reconnect","is_initialized","num_of_sockets","cpu_per_socket","threads_per_cpu","usb_policy","acpi_enable","session","num_of_cpus","quota_id","quota_name","quota_enforcement_ type","boot_sequence","utc_diff","client_ip","guest_requested_memory","time_zone","cpu_user","cpu_sys","elapsed_time","usage_network_percent","disks_usage","usage_mem_percent","usage_cpu_percent","run_on_vds_name","cluster_cpu_name","default_display_type","priority","iso_path","origin","cluster_compatibility_version","initrd_url","kernel_url","kernel_params","pause_status","exit_message","exit_status","migration_support","predefined_properties","userdefined_properties","min_allocated_mem","hash","cpu_pinning","db_generation","host_cpu_flags","tunnel_migration","vnc_keyboard_layout","is_run_and_pause","created_by_user_id","last_watchdog_event","last_watchdog_action","is_run_once","volatile_run","vm_fqdn","cpu_name","emulated_machine","current_cd","reason","exit_reason","instance_type_id","image_type_id","architecture","original_template_id","original_template_name","last_stop_time","migration_downtime","template_version_number","serial_number_policy","custom_serial_number","is_boot_m enu_enabled","guest_cpu_count","next_run_config_exists","is_previewing_snapshot","numatune_mode","is_spice_file_transfer_enabled","is_spice_copy_paste_enabled","cpu_profile_id","is_auto_converge","is_migrate_compressed","custom_emulated_machine","bios_type","custom_cpu_name","spice_port","spice_tls_port","spice_ip","vnc_port","vnc_ip","ovirt_guest_agent_status","qemu_guest_agent_status","guest_mem_buffered","guest_mem_cached","small_icon_id","large_icon_id","migration_policy_id","provider_id","console_disconnect_action","resume_behavior","guest_timezone_offset","guest_timezone_name","guestos_arch","guestos_codename","guestos_distribution","guestos_kernel_version","guestos_type","guestos_version","custom_compatibility_version","guest_containers","has_illegal_images","multi_queues_enabled" And just for let You know, its "status = 15" Please let me know. Thanks, M.

imagestatus is in the images table, not vms On Wed, Dec 2, 2020 at 11:30 AM <3c.monitor@gruppofilippetti.it> wrote:
Hi. I did a full select on "vms" and field "imagestatus" there isn't! May be this the reason for which the tool is unable to manage it? Follows full field list:
"vm_name","mem_size_mb","max_memory_size_mb","num_of_io_threads","nice_level","cpu_shares","vmt_guid","os","description","free_text_comment","cluster_id","creation_date","auto_startup","lease_sd_id","lease_info","is_stateless","is_smartcard_enabled","is_delete_protected","sso_method","dedicated_vm_for_vds","default_boot_sequence","vm_type","vm_pool_spice_proxy","cluster_name","transparent_hugepages","trusted_service","storage_pool_id","storage_pool_name","cluster_spice_proxy","vmt_name","status","vm_ip","vm_ip_inet_array","vm_host","last_start_time","boot_time","downtime","guest_cur_user_name","console_cur_user_name","runtime_name","guest_os","console_user_id","guest_agent_nics_hash","run_on_vds","migrating_to_vds","app_list","vm_pool_name","vm_pool_id","vm_guid","num_of_monitors","single_qxl_pci","allow_console_reconnect","is_initialized","num_of_sockets","cpu_per_socket","threads_per_cpu","usb_policy","acpi_enable","session","num_of_cpus","quota_id","quota_name","quota_enforcement_
type","boot_sequence","utc_diff","client_ip","guest_requested_memory","time_zone","cpu_user","cpu_sys","elapsed_time","usage_network_percent","disks_usage","usage_mem_percent","usage_cpu_percent","run_on_vds_name","cluster_cpu_name","default_display_type","priority","iso_path","origin","cluster_compatibility_version","initrd_url","kernel_url","kernel_params","pause_status","exit_message","exit_status","migration_support","predefined_properties","userdefined_properties","min_allocated_mem","hash","cpu_pinning","db_generation","host_cpu_flags","tunnel_migration","vnc_keyboard_layout","is_run_and_pause","created_by_user_id","last_watchdog_event","last_watchdog_action","is_run_once","volatile_run","vm_fqdn","cpu_name","emulated_machine","current_cd","reason","exit_reason","instance_type_id","image_type_id","architecture","original_template_id","original_template_name","last_stop_time","migration_downtime","template_version_number","serial_number_policy","custom_serial_number","is_boot_m
enu_enabled","guest_cpu_count","next_run_config_exists","is_previewing_snapshot","numatune_mode","is_spice_file_transfer_enabled","is_spice_copy_paste_enabled","cpu_profile_id","is_auto_converge","is_migrate_compressed","custom_emulated_machine","bios_type","custom_cpu_name","spice_port","spice_tls_port","spice_ip","vnc_port","vnc_ip","ovirt_guest_agent_status","qemu_guest_agent_status","guest_mem_buffered","guest_mem_cached","small_icon_id","large_icon_id","migration_policy_id","provider_id","console_disconnect_action","resume_behavior","guest_timezone_offset","guest_timezone_name","guestos_arch","guestos_codename","guestos_distribution","guestos_kernel_version","guestos_type","guestos_version","custom_compatibility_version","guest_containers","has_illegal_images","multi_queues_enabled"
And just for let You know, its "status = 15"
Please let me know. Thanks, M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/BCJNRY274XLTKN...

Hi, in this table all imagestatus = 1 Any other ideas? Thanks a lot, M.

I am not sure what is locked? If everything in the images table is 1, then the disks are not locked. If the VM is in status 15, which is "Images Locked" status, then this status is set in the vm_dynamic table On Wed, Dec 2, 2020 at 12:43 PM <3c.monitor@gruppofilippetti.it> wrote:
Hi, in this table all imagestatus = 1
Any other ideas?
Thanks a lot, M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/I5E5IMBWORF45B...

Hi. It's correct. But how unlock / change / remove it? In the same table, a lot of fields are empty, "0" or NULL. Only vm_guid and status have a value. Thanks, M.

These are the available statuses[1], you can change it to 0, assuming the VM is down [1] https://github.com/oVirt/ovirt-engine/blob/master/backend/manager/modules/co... On Wed, Dec 2, 2020 at 12:57 PM <3c.monitor@gruppofilippetti.it> wrote:
Hi. It's correct. But how unlock / change / remove it? In the same table, a lot of fields are empty, "0" or NULL. Only vm_guid and status have a value. Thanks, M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/PIZ7TQV46L3FBO...

Hi. thanks a lot! a simply: update vm_dynamic SET status = '0' where vm_guid = 'a54f4a3d-e7b3-4fc6-9910-fc5b415b99bf' ; has finally changed the VM in a "removable" state. Just deleted it! Thanks again. M.

Hi, if I can ask some other info, probably I find a "ghost disk" related to previous problem. Infact, I still cannot remove the broken template, because its disk is still registered somewhere; can You please suggest me where to search for it? Thanks a lot.

It should be in the images table, there is an it_guid column which indicates which templates the image is based on On Wed, Dec 2, 2020 at 2:16 PM <3c.monitor@gruppofilippetti.it> wrote:
Hi, if I can ask some other info, probably I find a "ghost disk" related to previous problem.
Infact, I still cannot remove the broken template, because its disk is still registered somewhere; can You please suggest me where to search for it?
Thanks a lot. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/TXYSDN7LLCSLS4...

Hi, ok, I found it, with: SELECT * from images where imagestatus = 2; Now simply update it = 1 ? And then template became removable? Or other steps needed? Thanks a lot.

Hi, change that state was unuseful... Cannot remove Template. The following Disk(s) are based on it: (0ae7f8f0-9dff-4649-8009-34191349dcc9) . Of course, in disk list there isn't... Thanks a lot.
participants (3)
-
3c.monitor@gruppofilippetti.it
-
Alex K
-
Benny Zlotnik