Hi, On Thu, Oct 23, 2014 at 3:25 AM, Steven C Timm <t...@fnal.gov> wrote:
> Due to an ongoing issue with having to purge the vm_pool of my database > from time > to time, I inadvertently did the purge while 8 vm's were still active and > thus leases > were still allocated. > > I ran onedb fsck to clean it up. It successfully cleaned up the > host_pool table to show > no running vm's. It also said that it updated the network_pool table to > show > no allocated leases but it did not do so. > > The network_pool table in ONE4 holds all 1000 leases of this particular > vnet in a single row of the table. > Correctly executing a manual mysql query to clean it up would be almost > impossible. > > Suggestions on what to do to clean it up? > > Steve Timm > Unfortunately there is no easy workaround. If you want to dig into the AR/ALLOCATED attribute, you will find a string with pairs of numbers: <index> <binary>. To identify the pairs you must delete, get the binary numbers that match the mask 0x0000001000000000. Then, the operation & 0xFFFFFFFF will give you the VM ID. Best regards. -- Carlos Martín, MSc Project Engineer OpenNebula - Flexible Enterprise Cloud Made Simple www.OpenNebula.org <http://www.opennebula.org/> | cmar...@opennebula.org | @OpenNebula <http://twitter.com/opennebula>
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org