Thanks a lot
2014-04-29 18:27 GMT+02:00 Corey Bryant <corey.bry...@canonical.com>: > ** Changed in: glance (Ubuntu) > Status: Triaged => Fix Released > > ** Changed in: glance (Ubuntu Trusty) > Status: Triaged => Fix Released > > -- > You received this bug notification because you are subscribed to the bug > report. > 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): > Fix Released > Status in Oslo - a Library of Common OpenStack Code: > Fix Released > Status in “glance” package in Ubuntu: > Fix Released > Status in “glance” source package in Trusty: > Fix Released > > 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 > -- *Élève ingénieur de l'E*cole* N*ationale des *S*ciences* d*e l'*I* nformatique* (ENSI)* Stagiaire au *CEA *(*Commissariat à l'énergie atomique et aux énergies alternatives*). Membre de L'Institute of Electrical and Electronics Engineers (IEEE) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1279000 Title: db migrate script to set charset=utf8 for all tables To manage notifications about this bug go to: https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs