yahoo-eng-team team mailing list archive

[Sam Morrison <1411489@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When upgrading to Juno and running DB migrations I get the following
error:


glance-manage db version
34

glance-manage db sync

2015-01-16 13:42:08.647 6746 CRITICAL glance [-] ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
2015-01-16 13:42:08.647 6746 TRACE glance Traceback (most recent call last):
2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/bin/glance-manage", line 10, in <module>
2015-01-16 13:42:08.647 6746 TRACE glance     sys.exit(main())
2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 290, in main
2015-01-16 13:42:08.647 6746 TRACE glance     return CONF.command.action_fn(*func_args, **func_kwargs)
2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 115, in sync
2015-01-16 13:42:08.647 6746 TRACE glance     version)
2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 77, in db_sync
2015-01-16 13:42:08.647 6746 TRACE glance     _db_schema_sanity_check(engine)
2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 110, in _db_schema_sanity_check
2015-01-16 13:42:08.647 6746 TRACE glance     ) % ','.join(table_names))
2015-01-16 13:42:08.647 6746 TRACE glance ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
2015-01-16 13:42:08.647 6746 TRACE glance

** Affects: glance
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1411489

Title:
  ValueError: Tables "task_info,tasks" have non utf8 collation, please
  make sure all tables are CHARSET=utf8

Status in OpenStack Image Registry and Delivery Service (Glance):
  New

Bug description:
  When upgrading to Juno and running DB migrations I get the following
  error:

  
  glance-manage db version
  34

  glance-manage db sync

  2015-01-16 13:42:08.647 6746 CRITICAL glance [-] ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
  2015-01-16 13:42:08.647 6746 TRACE glance Traceback (most recent call last):
  2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/bin/glance-manage", line 10, in <module>
  2015-01-16 13:42:08.647 6746 TRACE glance     sys.exit(main())
  2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 290, in main
  2015-01-16 13:42:08.647 6746 TRACE glance     return CONF.command.action_fn(*func_args, **func_kwargs)
  2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/glance/cmd/manage.py", line 115, in sync
  2015-01-16 13:42:08.647 6746 TRACE glance     version)
  2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 77, in db_sync
  2015-01-16 13:42:08.647 6746 TRACE glance     _db_schema_sanity_check(engine)
  2015-01-16 13:42:08.647 6746 TRACE glance   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 110, in _db_schema_sanity_check
  2015-01-16 13:42:08.647 6746 TRACE glance     ) % ','.join(table_names))
  2015-01-16 13:42:08.647 6746 TRACE glance ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
  2015-01-16 13:42:08.647 6746 TRACE glance

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1411489/+subscriptions