Ask Your Question
0

How to reset instance id to 00000001

asked 2011-05-05 20:20:30 -0600

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
0

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

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
0

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

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2011-05-05 20:20:30 -0600

Seen: 28 times

Last updated: May 05 '11