[openstack-dev] [Openstack] Unable to start NOVA VOLUME

Eoghan Glynn eglynn at redhat.com
Mon Sep 3 13:41:47 UTC 2012

> > I have Installed Nova Volume in the Openstack Essex Controller. But
> > When I restart the nova-volume service, I get the following error
> [...]
> > 2012-09-03 12:26:22 TRACE nova OperationalError: (OperationalError)
> > (1054, "Unknown column 'volumes.instance_id' in 'field list'")
> Hi Trinath,
> One possibility is that you've mismatched versions of nova core
> (specifically the DB schema) and nova volume.
> The volumes.instance_id column exists in the Essex schema, but was
> later dropped and replaced with an instance_uuid column (to reflect
> the foreign key type changing from int to UUID-as-varchar).
> Have you run a DB sync to up the schema version beyond Essex (i.e.
> past migration index 82)?

I should have mentioned that a quick way to check if a migration has
been applied, and if so report the current version, just run the
following SQL statement against your nova DB:

  SELECT MAX(id) FROM migrations


More information about the OpenStack-dev mailing list