yahoo-eng-team team mailing list archive

[Flavio Percoco <1453047@xxxxxxxxxxxxxxxxxx>]

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