** Changed in: oslo
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1279000
Title:
db migrate script to set charset=utf8 for all tables
Status in OpenStack Image Registry and Delivery Service (Glance):
Fix Released
Status in Oslo - a Library of Common OpenStack Code:
Fix Released
Status in “glance” package in Ubuntu:
Triaged
Status in “glance” source package in Trusty:
Triaged
Bug description:
2014-02-11 17:42:15.495 26564 CRITICAL glance [-] ValueError: Tables
"image_locations,image_members,image_properties,image_tags,images,migrate_version,task_info,tasks"
have non utf8 collation, please make sure all tables are CHARSET=utf8
2014-02-11 17:42:15.495 26564 TRACE glance Traceback (most recent call last):
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv//bin/glance-manage", line 13, in <module>
2014-02-11 17:42:15.495 26564 TRACE glance sys.exit(main())
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py",
line 220, in main
2014-02-11 17:42:15.495 26564 TRACE glance return CONF.command.action_fn()
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py",
line 121, in sync
2014-02-11 17:42:15.495 26564 TRACE glance CONF.command.current_version)
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py",
line 98, in sync
2014-02-11 17:42:15.495 26564 TRACE glance
migration.db_sync(db_migration.MIGRATE_REPO_PATH, version)
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/openstack/common/db/sqlalchemy/migration.py",
line 195, in db_sync
2014-02-11 17:42:15.495 26564 TRACE glance _db_schema_sanity_check()
2014-02-11 17:42:15.495 26564 TRACE glance File
"/usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/openstack/common/db/sqlalchemy/migration.py",
line 216, in _db_schema_sanity_check
2014-02-11 17:42:15.495 26564 TRACE glance ) % ','.join(table_names))
2014-02-11 17:42:15.495 26564 TRACE glance ValueError: Tables
"image_locations,image_members,image_properties,image_tags,images,migrate_version,task_info,tasks"
have non utf8 collation, please make sure all tables are CHARSET=utf8
2014-02-11 17:42:15.495 26564 TRACE glance
glance-manage fail to come up with above error. It's like due to following
commit in oslo wherein we enforce charset=utf8 for all tables.
7aa94df Add a db check for CHARSET=utf8
I think we should have a migration script to change the charset for
all tables.
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+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
