Hi,<div><br></div><div>If you update the pool_control table without a cleanup of the pool tables you will face some inconsistencies.</div><div><br></div><div>To "reset" opennebula, the easiest way is to delete the DB. With sqlite, just execute 'rm /var/lib/one/one.db', or issue a 'drop database' in mysql.</div>
<div><br></div><div>Regards.</div><div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px">--<br>Carlos Martín, MSc<br>Project Engineer<br>OpenNebula - The Open Source Toolkit for Data Center Virtualization<br>
<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><br>
<br><br><div class="gmail_quote">On Sat, Dec 24, 2011 at 2:33 PM, Håkan Iaksson <span dir="ltr"><<a href="mailto:hakan.isaksson@init.se">hakan.isaksson@init.se</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I believe the database table 'pool_control' contains that information,<br>
<br>
a "update pool_control set last_oid=0 where tablename like 'vm_pool'" would reset the vm-counter.<br>
<br>
Exactly how you update it, would depend on if you are using mysql or sqllite.<br>
<br>
--<br>
<br>
Håkan Isaksson<br>
<br>
Init System Management<div class="im"><br>
<br>
<br>
On Fri, 23 Dec 2011 14:56:33 -0300, matheus tor4 wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
After lots of lots of test, now I want to clean up all my cloud.<br>
<br>
Does exist a way to clean all templates that I built?<br>
I want to have my IDs from 0 again! :/<br>
<br>
Thanks in advance.<br>
</blockquote>
<br></div>
______________________________<u></u>_________________<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/<u></u>listinfo.cgi/users-opennebula.<u></u>org</a><br>
</blockquote></div><br></div>