Tables "migrate_version" have non utf8 collation

[Maximiliano Osorio]

On ubuntu 14.04
I updated keystone to the version 1:2014.1~rc1-0ubuntu1.

I drop the database and re-create.

CREATE DATABASE keystone;
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY '$KEYSTONE_DBPASS';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY '$KEYSTONE_DBPASS';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'$' IDENTIFIED BY '$KEYSTONE_DBPASS';

And then,

keystone-manage db_sync

I got the next error

./keystone/keystone.log:2014-04-01 10:49:20.681 5423 CRITICAL keystone [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8
./keystone/keystone.log:2014-04-01 10:49:20.681 5423 TRACE keystone ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

Problem:
Bad charset

Solution:
alter table migrate_version charset=utf8;

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Dolph Mathews (dolph)]

This is a dupe of bug 1301036, but LP is timing out when I try to "Mark as duplicate."