Thanks a lot


2014-04-29 18:27 GMT+02:00 Corey Bryant <email address hidden>:

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