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 -- 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