How to reset instance id to 00000001
Can you reset instance id to 00000001? without reinstalling nova? thanks!
add a comment
Vish,
Thanks so much again, I used your suggested alternative method and it worked.
I have just deleted the content of the two tables: instances and security_group_instance_association and reset the counter with the following query: ALTER TABLE instances AUTO_INCREMENT = 0;
Thanks again!
you could delete the database and recreate it with nova-manage db sync, but you would have to recreate your users and networks as well.
Alternatively you could drop all rows from the instances table and reset the auto-increment value on the table.
Asked: 2011-05-05 20:20:30 -0500
Seen: 28 times
Last updated: May 05 '11
