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.