CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

Ubuntu 14.04 - Openstack ICEHOUSE release

During the installation of Glance I ran into what seems to be a common problem with this release (supposedly fixed as well) in this release, which is when you run the below command to initialize the database for glance:

# su -s /bin/sh -c "glance-manage db_sync" glance

You receive the below output error.

CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

In order to resolve this one (assuming you have access to the mysql database directly) run the commands below.

# mysql -u root -p glance
mysql> alter table migrate_version convert to character set utf8 collate utf8_unicode_ci;
mysql> flush privileges;
mysql> quit
#

You should now be able to run the command below successfully to create the database for glance.

# su -s /bin/sh -c "glance-manage db_sync" glance

Bug ID: https://bugs.launchpad.net/glance/+bug/1279000

Tweet