Hi,<div><br></div><div>When you modify the DB, there are two important things to be aware of:</div><div><br></div><div>- OpenNebula must be stopped first, otherwise the cached objects will be flushed again to the DB and your changes will be ignored</div>
<div>- All the data is stored as xml inside the body column. Some attributes are copied to another column, to perform searches. These attributes, in your case the VM state and lcm_state, must be updated in both places.</div>
<div><br></div><div>Aside from that, the delete action should have worked. Do you have several VMs with the same name? You may have come across this bug [1].</div><div><br></div><div>Regards</div><div><br></div><div>[1] <a href="http://lists.opennebula.org/pipermail/users-opennebula.org/2012-April/008522.html">http://lists.opennebula.org/pipermail/users-opennebula.org/2012-April/008522.html</a><br clear="all">
--<br>Carlos Martín, MSc<br>
Project Engineer<br>OpenNebula - The Open-source Solution for Data Center Virtualization<div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="http://www.OpenNebula.org" target="_blank">www.OpenNebula.org</a> | <a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a> | <a href="http://twitter.com/opennebula" target="_blank">@OpenNebula</a></span><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="mailto:cmartin@opennebula.org" style="color:rgb(42,93,176)" target="_blank"></a></span></div>
<br>
<br><br><div class="gmail_quote">On Tue, Apr 17, 2012 at 11:32 AM, biro lehel <span dir="ltr"><<a href="mailto:lehel.biro@yahoo.com" target="_blank">lehel.biro@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit">Okay, so far, for my hung VM, I have set the "default" values for the deleted VM's in the<span style="font-weight:bold"> vm_pool</span> table of one.db (more precisely, I have set: last_poll=0, state=6, lcm_state=0), and also, in the <span style="font-weight:bold">leases </span>table, I have freed the respective IP address (<used>=0, <VID>=-1).<br>
<br>However, I'm looking for a confirmation if this is okay, or it can cause inconsistencies. Is anything else need to be done?<br><br>Thanks,<br>Lehel.<br><br>--- On <b>Tue, 4/17/12, biro lehel <i><<a href="mailto:lehel.biro@yahoo.com" target="_blank">lehel.biro@yahoo.com</a>></i></b> wrote:<br>
<blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px"><br>From: biro lehel <<a href="mailto:lehel.biro@yahoo.com" target="_blank">lehel.biro@yahoo.com</a>><br>Subject: [one-users] VM forced deletion? [VM hanging in CLEANUP state]<br>
To: <a href="mailto:users@lists.opennebula.org" target="_blank">users@lists.opennebula.org</a><br>Date:
Tuesday, April 17, 2012, 11:09 AM<div><div><br><br><div><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top"><div>Dear all,<br><br>I have a VM that apparently got hung in the CLEANUP state (now for quite a while). The problem is, I would need it's fixed IP to be used for another VM. "Delete" action from Sunstone has no effect on the hung VM, it disappears from the VM-list but it reappears at the next refresh.<br>
<br>Is there any way to manually force the VM's deletion (take it out from the DB)?<br><br>Thank you,<br>Lehel.<br></div></td></tr></tbody></table></div><br></div></div>-----Inline Attachment Follows-----<br><br><div>
_______________________________________________<br>Users mailing list<br><a href="http://mc/compose?to=Users@lists.opennebula.org" target="_blank">Users@lists.opennebula.org</a><br><a href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org" target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
</div></blockquote></td></tr></tbody></table><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opennebula.org" target="_blank">Users@lists.opennebula.org</a><br>
<a href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org" target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
<br></blockquote></div><br></div>