Ask Your Question
0

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
add a comment

2 answers

Sort by ยป oldest newest most voted
0

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
add a comment
0

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
add a comment

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

subscribe to rss feed

Stats

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

Seen: 39 times

Last updated: May 05 '11

Related questions

python-novaclient 1:2012.1~e4-1 on wheezy

libvirrt error: Connection reset by peer

Does Nova Support Oracle VM?

flat networking on testing installation

Can't install DevStack on top of XCP 1.6 (cant' get stage.tgz from ansolabs)

Failed to run quantum

Cloudpipe instance network configuration

heartbeats for compute nodes?

diablo: no access via floating ip

Openstack on multiple nodes