6:16 a.m.
Hi Benny
The VM’s sill shows that its locked am I doing something wrong?
engine=# select command_id,root_command_id from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4';
command_id | root_command_id
------------+-----------------
(0 rows)
engine=# select command_id,root_command_id from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4';
command_id | root_command_id
------------+-----------------
(0 rows)
engine=# delete from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4';
DELETE 0
engine=# delete from command_entities where root_command_id =
'a15a8e6b-1624-4082-ac5d-7609626250cf';
DELETE 0
engine=#
Roanne Philip
Architect: Virtualization and Storage
______________________________________
D: 087 805 0000 | M: 072 047 5408
A: Suite 302, 3rd Floor, The Waverley Business Park, 27 Kotzee Road, Observatory
roanne.philip(a)voxtelecom.co.za
www.vox.co.za
[cid:image001.png@01D8E93D.2A63A580]
From: Benny Zlotnik <bzlotnik(a)redhat.com>
Sent: 23 October 2022 1:47 PM
To: Roanne Philip <Roanne.Philip(a)voxtelecom.co.za>
Cc: users(a)ovirt.org
Subject: Re: [ovirt-users] Re: Unable to delete snapshots on vm
you can run:
delete from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4';
delete from command_entities where root_command_id =
'a15a8e6b-1624-4082-ac5d-7609626250cf';
(your queries didn't work because the closing apostrophe is different then the first
for some reason, not sure why it happened, but replace it if happens again)
Make sure to have a backup before manually manipulating the database
On Fri, Oct 21, 2022 at 3:03 PM Roanne Philip
<Roanne.Philip@voxtelecom.co.za<mailto:Roanne.Philip@voxtelecom.co.za>>
wrote:
Hi Benny
How would I go about removing it from the tables
" If nothing's running the next step would be to remove the commands from the
command_entities table"
Roanne Philip
Architect: Virtualization and Storage at Vox
________________________________
T: 087 805 0000 | D: 087 805 0000
M: 072 047 5408
E: roanne.philip@voxtelecom.co.za<mailto:roanne.philip@voxtelecom.co.za>
A: Suite 302, 3rd Floor, The Waverley Business Park, 27 Kotzee Road, Observatory
www.vox.co.za<http://www.vox.co.za>
[F]<https://www.facebook.com/voxtelecomZA>
[T]<https://www.twitter.com/voxtelecom>
[I]<https://www.instagram.com/voxtelecomza/>
[L]<https://www.linkedin.com/company/voxtelecom>
[Y]<https://www.youtube.com/user/VoxTelecom>
[Get Vox Fibre from
R289pm*]<https://www.vox.co.za/fibre/fibre-to-the-home/?prod=HOME>
Disclaimer
The contents of this email are confidential to the sender and the intended recipient.
Unless the contents are clearly and entirely of a personal nature, they are subject to
copyright in favour of the holding company of the Vox group of companies. Any recipient
who receives this email in error should immediately report the error to the sender and
permanently delete this email from all storage devices.
This email has been scanned for viruses and malware, and may have been automatically
archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business.
Providing a safer and more useful place for your human generated data. Specializing in;
Security, archiving and compliance. To find out more Click
Here<https://www.voxtelecom.co.za/security/mimecast/?prod=Enterprise>.
-----Original Message-----
From: Roanne Philip
Sent: 19 October 2022 12:00 PM
To: Benny Zlotnik <bzlotnik@redhat.com<mailto:bzlotnik@redhat.com>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: RE: [ovirt-users] Re: Unable to delete snapshots on vm
engine=# select command_id,root_command_id from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4’;
engine'# select command_id,root_command_id from command_entities where root_command_id
= 'a15a8e6b-1624-4082-ac5d-7609626250cf’;
ERROR: syntax error at or near "a15a8e6b"
LINE 2: ...id from command_entities where root_command_id = 'a15a8e6b-1...
^ engine=#
-----Original Message-----
From: Benny Zlotnik <bzlotnik@redhat.com<mailto:bzlotnik@redhat.com>>
Sent: 19 October 2022 11:57 AM
To: Roanne Philip
<Roanne.Philip@voxtelecom.co.za<mailto:Roanne.Philip@voxtelecom.co.za>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: Re: [ovirt-users] Re: Unable to delete snapshots on vm
what's the output of these queries:
select command_id,root_command_id from command_entities where root_command_id =
'5de31579-15df-4c61-ac06-2b03a25d5db4’;
select command_id,root_command_id from command_entities where root_command_id =
'a15a8e6b-1624-4082-ac5d-7609626250cf’;
