ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8

[Sam Morrison]

When upgrading to Juno and running DB migrations I get the following error:

glance-manage db version
34

glance-manage db sync

2015-01-16 13:42:08.647 6746 CRITICAL glance [-] ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
2015-01-16 13:42:08.647 6746 TRACE glance Traceback (most recent call last):
2015-01-16 13:42:08.647 6746 TRACE glance File "/usr/bin/glance-manage", line 10, in <module>
2015-01-16 13:42:08.647 6746 TRACE glance sys.exit(main())
2015-01-16 13:42:08.647 6746 TRACE glance File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 290, in main
2015-01-16 13:42:08.647 6746 TRACE glance return CONF.command.action_fn(*func_args, **func_kwargs)
2015-01-16 13:42:08.647 6746 TRACE glance File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 115, in sync
2015-01-16 13:42:08.647 6746 TRACE glance version)
2015-01-16 13:42:08.647 6746 TRACE glance File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 77, in db_sync
2015-01-16 13:42:08.647 6746 TRACE glance _db_schema_sanity_check(engine)
2015-01-16 13:42:08.647 6746 TRACE glance File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 110, in _db_schema_sanity_check
2015-01-16 13:42:08.647 6746 TRACE glance ) % ','.join(table_names))
2015-01-16 13:42:08.647 6746 TRACE glance ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
2015-01-16 13:42:08.647 6746 TRACE glance

[Sam Morrison (sorrison)]

Should say looks like this also happened in Icehouse https://bugs.launchpad.net/glance/+bug/1279000

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/181347
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=647d2895a7287da06a4f83009b23d350220bb3db
Submitter: Jenkins
Branch: master

commit 647d2895a7287da06a4f83009b23d350220bb3db
Author: Flavio Percoco <email address hidden>
Date: Fri May 8 11:56:28 2015 +0200

    Make utf8 the default charset for mysql

    Newer versions of oslo_db added a sanity check to ensure that table's
    charsets are utf8. This patch makes this change explicit and re-enables
    the sanity check that was disabled in Ifffbdd50c38a1d25215faa6a966c2d2a63935711

    Change-Id: Icbc41bd3964a6124d3e0d906cb85944fdc312844
    Closes-bug: #1411489