I am seeing this issue with ubuntu 14.04 image . Even tried the steps mention in comment #1 by "JJ Asghar (d-jj)".
Still able to reproduce this issue.
root@controller:~# dpkg -l | grep -i glance
ii glance 1:2014.1.2-0ubuntu1.1 all OpenStack Image Registry and Delivery Service - Daemons
ii glance-api 1:2014.1.2-0ubuntu1.1 all OpenStack Image Registry and Delivery Service - API
ii glance-common 1:2014.1.2-0ubuntu1.1 all OpenStack Image Registry and Delivery Service - Common
ii glance-registry 1:2014.1.2-0ubuntu1.1 all OpenStack Image Registry and Delivery Service - Registry
ii python-glance 1:2014.1.2-0ubuntu1.1 all OpenStack Image Registry and Delivery Service - Python library
ii python-glanceclient 1:0.12.0-0ubuntu1 all Client library for Openstack glance server.
glance-manage db_sync
2014-09-15 16:35:08.341 8673 CRITICAL glance [-] ValueError: Tables "image_locations,image_members,image_properties,image_tags,images,task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
I am seeing this issue with ubuntu 14.04 image . Even tried the steps mention in comment #1 by "JJ Asghar (d-jj)".
Still able to reproduce this issue.
root@controller:~# dpkg -l | grep -i glance 1.2-0ubuntu1. 1 all OpenStack Image Registry and Delivery Service - Daemons 1.2-0ubuntu1. 1 all OpenStack Image Registry and Delivery Service - API 1.2-0ubuntu1. 1 all OpenStack Image Registry and Delivery Service - Common 1.2-0ubuntu1. 1 all OpenStack Image Registry and Delivery Service - Registry 1.2-0ubuntu1. 1 all OpenStack Image Registry and Delivery Service - Python library
ii glance 1:2014.
ii glance-api 1:2014.
ii glance-common 1:2014.
ii glance-registry 1:2014.
ii python-glance 1:2014.
ii python-glanceclient 1:0.12.0-0ubuntu1 all Client library for Openstack glance server.
glance-manage db_sync locations, image_members, image_propertie s,image_ tags,images, task_info, tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8
2014-09-15 16:35:08.341 8673 CRITICAL glance [-] ValueError: Tables "image_