Did you restart ovirt-engine after removing? On Wed, Oct 26, 2022 at 2:17 PM Roanne Philip < roanne.phi...@voxtelecom.co.za> wrote:
> > > 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.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> > > *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> 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/WVOT6EEORKHONZHE3FM5VCQUVUPFTZI2/
