]> review.fuel-infra Code Review - openstack-build/cinder-build.git/commit
FK lookup failures during migration
authorJohn Griffith <john.griffith@solidfire.com>
Tue, 15 Oct 2013 19:57:48 +0000 (13:57 -0600)
committerJohn Griffith <john.griffith@solidfire.com>
Tue, 15 Oct 2013 20:46:56 +0000 (14:46 -0600)
commit645a84f990c90e28548cf35b4b5f242eb0e0c286
tree9c4d5e5d9933718e8be3f2fb442ce0809c7f0522
parent430eb757ae9a721ff3fe40104472cec2ca6e6993
FK lookup failures during migration

There are a couple of cases where migrations have failed
upgrading from Grizzly to Havana, this seems to be isolated
to a couple of migrations so far and the error message is a
failure to lookup/associate the volume-id FK dependency.

It appears that this is caused by not setting the charset
in the migration, so the result is that the initial db setup
uses utf8 and the migrations are using the default latin1.

This patch goes through all of the migrations in Havana that
specify InnoDB and explicitly sets the charset to utf8 to match
the volumes table (and the other original tables).

Change-Id: I43b219ff5e4eea10a7391ad65ef68a80b7460370
Closes-Bug: #1233861
cinder/db/sqlalchemy/migrate_repo/versions/010_add_transfers_table.py
cinder/db/sqlalchemy/migrate_repo/versions/015_drop_migrations_table.py
cinder/db/sqlalchemy/migrate_repo/versions/016_drop_sm_tables.py
cinder/db/sqlalchemy/migrate_repo/versions/017_add_encryption_information.py
cinder/db/sqlalchemy/migrate_repo/versions/018_add_qos_specs.py
cinder/db/sqlalchemy/migrate_repo/versions/020_add_volume_admin_metadata_table.py