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: 49 times

Last updated: May 05 '11

Related questions

Adding a second compute node fails

Xenserver Guide

Can not create keypair

Several question about Cactus :) plz

nova-manage db sync problem

Windows instance password generation

Using zones in Cactus

Stack ops LOGIN And password

VM instance cannot access outside network

WebSock error [Object Event]