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 at Vox

T:  087 805 0000 | D: 087 805 0000 M: 072 047 5408 E: roanne.philip@voxtelecom.co.za A: Suite 302, 3rd Floor, The Waverley Business Park, 27 Kotzee Road, Observatory www.vox.co.za

From: Benny Zlotnik <bzlotnik@redhat.com>
Sent: 23 October 2022 1:47 PM
To: Roanne Philip <Roanne.Philip@voxtelecom.co.za>
Cc: users@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> 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 A: Suite 302, 3rd Floor, The Waverley Business Park, 27 Kotzee Road, Observatory www.vox.co.za

 

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.

-----Original Message-----
From: Roanne Philip
Sent: 19 October 2022 12:00 PM
To: Benny Zlotnik <bzlotnik@redhat.com>
Cc: 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>
Sent: 19 October 2022 11:57 AM
To: Roanne Philip <Roanne.Philip@voxtelecom.co.za>
Cc: 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’;