yahoo-eng-team team mailing list archive

[nikhil komawar <nik.komawar@xxxxxxxxx>]

This has become non-relevant so, lowering priority and removing
milestone target.

The status has been moved to opinion until we get back to it next time.
If no more updates exists it will be won't fix then.

** Changed in: glance
   Importance: High => Wishlist

** Changed in: glance
       Status: New => Opinion

** Changed in: glance
    Milestone: liberty-rc1 => None

-- 
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 Glance:
  Opinion

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