[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/KV6DBE5Z4SMCAB3Y55Z4WSFMIYWUPRHZ/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/BYG5BDBQMSWOLLW7O5BMBMNYZ5ZA4YME/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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.moni...@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-le...@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/TXYSDN7LLCSLS4MV37XBCJT3EMX4BUKB/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/IOK6IUSOOOAIIIZQ6YGXLRKIBCLC75F2/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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-le...@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/TXYSDN7LLCSLS4MV37XBCJT3EMX4BUKB/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/TNI476LB57WM5RIV5XZ2P6RDT2OEHYAN/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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/common/src/main/java/org/ovirt/engine/core/common/businessentities/VMStatus.java#L10 On Wed, Dec 2, 2020 at 12:57 PM <3c.moni...@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-le...@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/PIZ7TQV46L3FBOV6PTNMTWQ2O7CF5EGX/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/AD3SUCPR2TR73VXTINI522M5BDTJ56FU/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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-le...@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/PIZ7TQV46L3FBOV6PTNMTWQ2O7CF5EGX/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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.moni...@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-le...@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/I5E5IMBWORF45BLIKRSQPNSTH2O22WWG/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/DW43N255FSL62JNJMNFJH57NZTNOOODY/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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-le...@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/I5E5IMBWORF45BLIKRSQPNSTH2O22WWG/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
imagestatus is in the images table, not vms On Wed, Dec 2, 2020 at 11:30 AM <3c.moni...@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-le...@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/BCJNRY274XLTKNIXJBGKSJAS26YKCROI/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/WRXOGGQ7ZPVIQEEZ4SDNCQXU5CQ6RPFC/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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-le...@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/BCJNRY274XLTKNIXJBGKSJAS26YKCROI/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/DFLIMZDCQWCPLFZK7D7DO6HIAXBCTL3Y/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
On Wed, Nov 25, 2020 at 8:05 PM <3c.moni...@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-le...@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/KWGD5PB7ACRAJ7VQRFSYFZE2SQDZTIPY/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/GT4NWMLI4M6OYTCQFGDFXGNTLENEMWSR/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/KWGD5PB7ACRAJ7VQRFSYFZE2SQDZTIPY/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
On Tue, Nov 17, 2020, 18:42 <3c.moni...@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-le...@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/74QMVFTM356GHFIHWPUKMIZLIRDOPYHT/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/HV2ZJ34JWFGGSGFBH6ULJ46R4FCQICAJ/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
Hi, anyone with an idea on what else I can do? Thanks a lot. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/LIJKPF6HDVWA5ULQV43LK4VLAAKDU2QR/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
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. ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/74QMVFTM356GHFIHWPUKMIZLIRDOPYHT/
[ovirt-users] Re: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
On Tue, Nov 17, 2020, 16:12 <3c.moni...@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-le...@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/7IK2IAJTEMNR7IM4FJYVHJRJQTQZD537/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/LNT3SXR62FVCBAW4FKC273BA23HO74PV/
