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.phi...@voxtelecom.co.za www.vox.co.za [cid:image001.png@01D8E93D.2A63A580] From: Benny Zlotnik <bzlot...@redhat.com> Sent: 23 October 2022 1:47 PM To: Roanne Philip <roanne.phi...@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.phi...@voxtelecom.co.za<mailto: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<mailto:roanne.phi...@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 <bzlot...@redhat.com<mailto:bzlot...@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 <bzlot...@redhat.com<mailto:bzlot...@redhat.com>> Sent: 19 October 2022 11:57 AM To: Roanne Philip <roanne.phi...@voxtelecom.co.za<mailto:roanne.phi...@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’;
_______________________________________________ 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/I2HC7I6QPV65QMK4H5HYADSDBZ33T3ES/
