+++ This bug was initially created as a clone of Bug #1090648 +++ Description of problem: glance-manage db_sync silently fails to prepare the database: # glance-manage db_sync && echo ok ok # mysql glance -e "show tables" +------------------+ | Tables_in_glance | +------------------+ | migrate_version | +------------------+ Version-Release number of selected component (if applicable): openstack-glance-2014.1-1.el6.noarch How reproducible: 100% Steps to Reproduce: 1. connection = mysql://glance:glance@localhost/glance 2. openstack-db --init --service glance Actual results: # openstack-db --init --service glance && echo ok Verified connectivity to MySQL. Creating 'glance' database. Initializing the glance database, please wait... Complete! ok # mysql glance -e "show tables" +------------------+ | Tables_in_glance | +------------------+ | migrate_version | +------------------+ Expected results: The glance database should be ready to be used or an error should be clearly reported. Additional info: Adding some debugging it's possible to see that the actual error is: # glance-manage db_sync && echo ok Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8 ok If CHARSET=utf8 is another issue that should be fixed separately (and not just something related to my env) feel free to split the bug. --- Additional comment from Brad P. Crochet on 2014-05-05 10:59:58 EDT --- As a workaround, one can set: db_enforce_mysql_charset=False in /etc/glance/glance.conf This will get you past this error. --- Additional comment from Brad P. Crochet on 2014-05-05 11:00:21 EDT --- Sorry... /etc/glance/glance-api.conf --- Additional comment from Federico Simoncelli on 2014-05-05 11:55:42 EDT --- (In reply to Brad P. Crochet from comment #1) > As a workaround, one can set: > > db_enforce_mysql_charset=False > > in /etc/glance/glance.conf > > This will get you past this error. The biggest problem is that the error is not printed anywhere (I had to manually add debugging to the code) so no one can tell if this is the issue they're having. --- Additional comment from Flavio Percoco on 2014-05-06 05:44:23 EDT --- I agree a proper error is necessary.
I can still hit this problem with those builds: [root@rhos5-glance1 ~]# rpm -q -a |grep glance python-glance-2014.1-2.el7ost.noarch python-glanceclient-0.12.0-1.el7ost.noarch openstack-glance-2014.1-2.el7ost.noarch and I had to manually force db_enforce_mysql_charset.
Verified on: RHEL6.5 (used el6, el7 packages are the same) python-glanceclient-0.12.0-1.el6.noarch python-glance-2014.1-4.el6ost.noarch openstack-glance-2014.1-4.el6ost.noarch Test flow 1. Manually installed: mysql keystone Glance (Havana 2013.2.3-2.el6) over RHEL6.5. 2. Configured and checked Glance service, checked Glance db. 3. Stopped Glance services 4. Downloaded Glance Icehouse build packages 2014.1-4.el6ost. 3. Upgraded Glance to new packages. 4. Ran #glance-manage db_sync && echo ok Glance-manage db_sync works fine, OK echo not returned not sure why. 6. Checked Glance db fits Icehouse release, checked a few basic Glance commands 7. glance-api.dist.conf file includes: db_enforce_mysql_charset = False Flavio, thanks assistance.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHEA-2014-0851.html
Cancelling old needinfo request.