** Changed in: keystone
Status: Fix Committed => Fix Released
** Changed in: keystone
Milestone: None => juno-2
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1334779
Title:
db_sync breaks in non-utf8 databases on region table
Status in OpenStack Identity (Keystone):
Fix Released
Status in Keystone icehouse series:
In Progress
Bug description:
The migration that creates the region table does not explicitly set
utf8 so if the database default is not set, then db_sync fails with
the following error:
2014-06-26 17:00:48.231 965 CRITICAL keystone [-] ValueError: Tables "region"
have non utf8 collation, please make sure all tables are CHARSET=utf8
2014-06-26 17:00:48.231 965 TRACE keystone Traceback (most recent call last):
2014-06-26 17:00:48.231 965 TRACE keystone File "/usr/bin/keystone-manage",
line 51, in <module>
2014-06-26 17:00:48.231 965 TRACE keystone cli.main(argv=sys.argv,
config_files=config_files)
2014-06-26 17:00:48.231 965 TRACE keystone File
"/usr/lib/python2.7/dist-packages/keystone/cli.py", line 191, in main
2014-06-26 17:00:48.231 965 TRACE keystone CONF.command.cmd_class.main()
2014-06-26 17:00:48.231 965 TRACE keystone File
"/usr/lib/python2.7/dist-packages/keystone/cli.py", line 67, in main
2014-06-26 17:00:48.231 965 TRACE keystone
migration_helpers.sync_database_to_version(extension, version)
2014-06-26 17:00:48.231 965 TRACE keystone File
"/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py",
line 139, in sync_database_to_version
2014-06-26 17:00:48.231 965 TRACE keystone
migration.db_sync(sql.get_engine(), abs_path, version=version)
2014-06-26 17:00:48.231 965 TRACE keystone File
"/usr/lib/python2.7/dist-packages/keystone/openstack/common/db/sqlalchemy/migration.py",
line 195, in db_sync
2014-06-26 17:00:48.231 965 TRACE keystone _db_schema_sanity_check(engine)
2014-06-26 17:00:48.231 965 TRACE keystone File
"/usr/lib/python2.7/dist-packages/keystone/openstack/common/db/sqlalchemy/migration.py",
line 228, in _db_schema_sanity_check
2014-06-26 17:00:48.231 965 TRACE keystone ) % ','.join(table_names))
2014-06-26 17:00:48.231 965 TRACE keystone ValueError: Tables "region" have
non utf8 collation, please make sure all tables are CHARSET=utf8
2014-06-26 17:00:48.231 965 TRACE keystone
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1334779/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
