← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #16679

[Bug 1334779] [NEW] db_sync breaks in non-utf8 databases on region table

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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

** Affects: keystone
     Importance: Undecided
         Status: New


** Tags: icehouse-backport-potential

** Tags added: icehouse-backport-potential

-- 
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):
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next