[Yahoo-eng-team] [Bug 1334779] Re: db_sync breaks in non-utf8 databases on region table
** 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
[Yahoo-eng-team] [Bug 1334779] Re: db_sync breaks in non-utf8 databases on region table
** Also affects: keystone/icehouse Importance: Undecided Status: New -- 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 Committed 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
