Open Stack

> > 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

Cheers,
Eoghan