OpenStack Compute (nova)

Accidently dropped floating_ips and fixed_ips tables from nova db. How to recreate?

Asked by Sachin Agarwal

Dear all,

While trying to remove some stale information about IP addresses from the nova database, I accidently dropped the floating_ips and fixed_ips tables from the nova database. Is there a (sql or python script) command to recreate these empty tables (With the correct schema) so that I can do things like nova-manage network list?

I am running the Essex release under Ubuntu.

Thanks in advance!

Sachin

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
Sachin Agarwal
Solved:
Last query:
Last reply:
Revision history for this message
ConMotto (conmotto) said : 		#1

Not sure, but I just posted a schema diagram and reverse-engineered MySQL .sql file that might help: http://www.prestonlee.com/2012/05/03/openstack-nova-essex-mysql-database-schema-diagram-and-sql/

Revision history for this message
Sachin Agarwal (sachinkagarwal) said : 		#2

Thanks @ ConMotto.

For now I decided to do a fresh install, because I wasnt sure about the status of the other tables when creating new tables. Although this reverse-engineered picture you have is very handy (printed it out just for reference!). Thanks!

I also figured out that since Openstack speaks to the SQL database through the sqlalchemy software the models described in the api.py file exactly correspond to the tables being setup in SQL. Its probably important to follow these model descriptions because the sql tables have been changing through the version of Openstack.

Cheers!

Sachin