Public bug reported:
A new sanity_check has been enabled in oslo.db, which verifies the table
charset. We need to make the switch to utf8 explicit in our models
definition. The current error in the gate is:
Traceback (most recent call last):
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py",
line 572, in test_models_sync
self.db_sync(self.get_engine())
File "glance/tests/unit/test_migrations.py", line 1686, in db_sync
migration.db_sync(engine=engine)
File "glance/db/migration.py", line 65, in db_sync
init_version=init_version)
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py",
line 84, in db_sync
_db_schema_sanity_check(engine)
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py",
line 114, in _db_schema_sanity_check
) % ','.join(table_names))
ValueError: Tables
"artifact_blob_locations,artifact_blobs,artifact_dependencies,artifact_properties,artifact_tags,artifacts,image_locations,image_members,image_properties,image_tags,images,metadef_namespace_resource_types,metadef_namespaces,metadef_objects,metadef_properties,metadef_resource_types,metadef_tags,task_info,tasks"
have non utf8 collation, please make sure all tables are CHARSET=utf8
And the fix required should consist in adding `'charset': 'utf-8'` to our
GlanceBase model.
** Affects: glance
Importance: High
Assignee: Flavio Percoco (flaper87)
Status: New
** Changed in: glance
Importance: Undecided => High
** Changed in: glance
Assignee: (unassigned) => Flavio Percoco (flaper87)
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1453047
Title:
ValueError: Tables
"artifact_blob_locations,artifact_blobs,artifact_dependencies,artifact_properties,artifact_tags,artifacts,image_locations,image_members,image_properties,image_tags,images,metadef_namespace_resource_types,metadef_namespaces,metadef_objects,metadef_properties,metadef_resource_types,metadef_tags,task_info,tasks"
have non utf8 collation, please make sure all tables are CHARSET=utf8
Status in OpenStack Image Registry and Delivery Service (Glance):
New
Bug description:
A new sanity_check has been enabled in oslo.db, which verifies the
table charset. We need to make the switch to utf8 explicit in our
models definition. The current error in the gate is:
Traceback (most recent call last):
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py",
line 572, in test_models_sync
self.db_sync(self.get_engine())
File "glance/tests/unit/test_migrations.py", line 1686, in db_sync
migration.db_sync(engine=engine)
File "glance/db/migration.py", line 65, in db_sync
init_version=init_version)
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py",
line 84, in db_sync
_db_schema_sanity_check(engine)
File
"/home/jenkins/workspace/gate-glance-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration.py",
line 114, in _db_schema_sanity_check
) % ','.join(table_names))
ValueError: Tables
"artifact_blob_locations,artifact_blobs,artifact_dependencies,artifact_properties,artifact_tags,artifacts,image_locations,image_members,image_properties,image_tags,images,metadef_namespace_resource_types,metadef_namespaces,metadef_objects,metadef_properties,metadef_resource_types,metadef_tags,task_info,tasks"
have non utf8 collation, please make sure all tables are CHARSET=utf8
And the fix required should consist in adding `'charset': 'utf-8'` to our
GlanceBase model.
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1453047/+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
