yahoo-eng-team team mailing list archive

[Bhuvan Arumugam <bhuvaneswaran@xxxxxxxxx>]

Public bug reported:

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.

** Affects: glance
     Importance: Undecided
         Status: New


** Tags: glance

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

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