<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Due to an ongoing issue with having to purge the vm_pool of my database from time
<div>to time, I inadvertently did the purge while 8 vm's were still active and thus leases</div>
<div>were still allocated.</div>
<div><br>
</div>
<div>I ran onedb fsck to clean it up. It successfully cleaned up the host_pool table to show </div>
<div>no running vm's. It also said that it updated the network_pool table to show </div>
<div>no allocated leases but it did not do so.</div>
<div><br>
</div>
<div>The network_pool table in ONE4 holds all 1000 leases of this particular vnet in a single row of the table.</div>
<div>Correctly executing a manual mysql query to clean it up would be almost impossible.</div>
<div><br>
</div>
<div>Suggestions on what to do to clean it up? </div>
<div><br>
</div>
<div>Steve Timm</div>
<div><br>
</div>
</div>
</body>
</html>