Ask Your Question

Grizzly: is it possible to recover nova's database table instance_system_metadata? Where can I find info about the Openstack databases?

asked 2014-01-06 09:15:50 -0500

amber_nic gravatar image

updated 2014-01-06 09:17:42 -0500

Hi all,

trying to delete instances that got shutoff (even after using nova reset-state) for a long time, I decided to follow this guide. I succesfully deleted the IPs and the floating ones but didn't delete the instances because of foreign key dependency pointing to the table instance_system_metadata so i typed: select uuid from instances WHERE vm_state = "error"; to get the uuids of the instances to delete from that table. Then I manually deleted each of the uuids from that table and then bam! Nothing works...

Is it possible to recover that table without a previous backup? My guess is that's not possible but I'm asking just in case because I can't manage anything now.

I would also like to know where to find information about the different databases of Openstack, it's not only very interesting, sometimes I read answers to certain problems and there's no other option left but to operate with Openstack's databases.

Hope someone can help me.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2014-01-06 09:46:30 -0500

larsks gravatar image

In theory, to do what you were trying to do you would:

delete from instance_system_metadata
  where instance_uuid in (select uuid from instances
    where vm_state = "error");

delete from instances where vm_state = "error";

If you haven't already deleted the entries from the instances table, try that. Otherwise, no, there's probably nothing you can do to recover the tables and your best best it to wipe the database and re-create using nova-manage db sync.

edit flag offensive delete link more


NB: I don't have a Grizzly install handy on which to test this, so I can't actually verify that this will work correctly.

larsks gravatar imagelarsks ( 2014-01-06 09:47:13 -0500 )edit

Thanks! :)

amber_nic gravatar imageamber_nic ( 2014-01-06 09:50:19 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2014-01-06 09:15:50 -0500

Seen: 144 times

Last updated: Jan 06 '14