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.phi...@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.phi...@voxtelecom.co.za
> *A:* Suite 302, 3rd Floor, The Waverley Business Park, 27 Kotzee Road,
> Observatory
> www.vox.co.za
>
> [image: F] <https://www.facebook.com/voxtelecomZA>
> [image: T] <https://www.twitter.com/voxtelecom>
> [image: I] <https://www.instagram.com/voxtelecomza/>
> [image: L] <https://www.linkedin.com/company/voxtelecom>
> [image: Y] <https://www.youtube.com/user/VoxTelecom>
>
> [image: 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 <bzlot...@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 <bzlot...@redhat.com>
> Sent: 19 October 2022 11:57 AM
> To: Roanne Philip <roanne.phi...@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’;
>
_______________________________________________
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/GM6XGPV7SFAWAMR44FUFVQJ5YLEWBDAM/

Reply via email to