Hi Natalia, perhaps not much of a help - but I usually try to reproduce "good" records - in your case by deploying a VM, then destroy it, wait for some time (expunge, cleanup, etc...i.e. wait 24h) and then get these "good" records and compare against other records that you want to change.
This is good practice anytime you need to do DB change.... Cheers On Thu, 5 Jul 2018 at 10:02, Natalia Costas Lago <nata...@cesga.es> wrote: > > Hi, > > We have several virtual machines in unconsistent state. > > - Two of them are system VMs in Expunging state. I think this VM lost > its root disk due to a host server that was removed. > > - Two of them are User VMs that cannot be deleted because their network > was removed first. Cloudstack did not warn that the network was used by > several VMs. I can change their status from Destroyed to Stopped, but I > cannot delete them. > > Our cloudstack version is 4.9. > > I read about setting the removed date to NULL in Expunging VMs. But only > in case there are no async_jobs pending. Here is the info: > > > http://mail-archives.apache.org/mod_mbox/cloudstack-users/201504.mbox/%3cblu184-w501fd6ea1e037b10cf01e3b4...@phx.gbl%3E > > So I cannot follow this procedure. How can I remove these VMs and their > associated resources? > > > Thanking you in advance, > > Kind regards, > > NOTA: Para cualquier incidencia/consulta/petición que requiera > seguimiento por favor enviar a helpdesk_comunicacio...@cesga.es > > -- > ==================================================== > Natalia Costas Lago > Senior Communications Technician > Galicia Supercomputing Centre (CESGA) > (CESGA on Twitter | CESGA on Facebook) > > Avenida de Vigo, s/n (Campus Vida) > 15705 Santiago de Compostela - SPAIN > > E-mail: nata...@cesga.es > Cell: +34 981 56 98 10 (ext. 237) > Fax: +34 981 59 46 16 > Web: https://www.cesga.es/ > ==================================================== > [IMPORTANTE] La información contenida en este mensaje y > sus posibles documentos adjuntos es privada y confidencial > y está dirigida únicamente a su destinatario/a. Si usted no > es el/la destinatario/a original de este mensaje, por favor > elimínelo. La distribución o copia de este mensaje no está > autorizada. > > -- Andrija Panić
