Ask Your Question

How to reset instance id to 00000001

asked 2011-05-05 20:20:30 -0500

arturo-lorenzo gravatar image

Can you reset instance id to 00000001? without reinstalling nova? thanks!

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted

answered 2011-05-05 20:29:14 -0500

vishvananda gravatar image

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.

edit flag offensive delete link more

answered 2011-05-05 21:04:09 -0500

arturo-lorenzo gravatar image

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!

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2011-05-05 20:20:30 -0500

Seen: 49 times

Last updated: May 05 '11