3:12 p.m.
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.
5:37 p.m.
New subject: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
On Tue, Nov 17, 2020, 16:12 <3c.monitor(a)gruppofilippetti.it> wrote:
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.
5:41 p.m.
New subject: 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.
6:41 p.m.
New subject: ovirt 4.3 - locked image vm - unable to remove a failed deploy of a guest dom
On Tue, Nov 17, 2020, 18:42 <3c.monitor(a)gruppofilippetti.it> wrote:
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.
7:04 p.m.
New subject: 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.
8:05 p.m.
New subject: 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.monitor(a)gruppofilippetti.it> wrote:
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}
^
9:41 a.m.
New subject: 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.
10:27 a.m.
New subject: 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.
11:42 a.m.
New subject: 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.
11:49 a.m.
New subject: 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.monitor(a)gruppofilippetti.it> wrote:
11:56 a.m.
New subject: 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.
12:07 p.m.
New subject: 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...
On Wed, Dec 2, 2020 at 12:57 PM <3c.monitor(a)gruppofilippetti.it> wrote:
12:34 p.m.
New subject: 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.
1:15 p.m.
New subject: 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.
1:21 p.m.
New subject: 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.monitor(a)gruppofilippetti.it> wrote:
2:31 p.m.
New subject: 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.
5:27 p.m.
New subject: 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.
1651
days inactive
1673
days old
17 comments
3 participants
participants (3)
-
3c.monitor＠gruppofilippetti.it -
Alex K -
Benny Zlotnik