CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

Ubuntu 14.04 - Openstack ICEHOUSE release

During the installation of Glance I ran into what seems to be a common problem with this release (supposedly fixed as well) in this release, which is when you run the below command to initialize the database for glance:

# su -s /bin/sh -c "glance-manage db_sync" glance

You receive the below output error.

CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

In order to resolve this one (assuming you have access to the mysql database directly) run the commands below.

# mysql -u root -p glance
mysql> alter table migrate_version convert to character set utf8 collate utf8_unicode_ci;
mysql> flush privileges;
mysql> quit
#

You should now be able to run the command below successfully to create the database for glance.

# su -s /bin/sh -c "glance-manage db_sync" glance

Bug ID: https://bugs.launchpad.net/glance/+bug/1279000

Tweet

Openstack Havana ceilometer-alarm-notifier & ceilometer-alarm-evaluator services

The Ubuntu CloudArchive packages, do not create the required ceilometer-alarm-notifier & ceilometer-alarm-evaluator services, which makes using ceilometer somewhat more of a metrics collector than an actual monitoring service without these

I created a bug about this some time ago, it seems the package does not create the upstart services as it should, typically Openstack would say this is the problem of the packager owner in this case ubuntu.

Bug here: https://bugs.launchpad.net/cloud-archive/+bug/1267307

You have to create the upstart services manually.

this might not be the proper way to do it, but it works

Change directory to /etc/init and create the missing conf files 

# cd /etc/init
# vim ceilometer-alarm-evaluator.conf

copy and past the below in the code block

 description "ceilometer-alarm-evaluator"  
 author "Bruce Martins"  
 start on runlevel [2345]  
 stop on runlelvel [!2345]  
 chdir /var/run  
 pre-start script  
     mkdir -p /var/run/ceilometer  
     chown ceilometer:ceilometer /var/run/ceilometer  
     mkdir -p /var/lock/ceilometer  
     chown ceilometer:ceilometer /var/lock/ceilometer  
 end script  
 exec start-stop-daemon --start --chuid ceilometer --exec /usr/bin/ceilometer-alarm-evaluator  

save and then create the second file

#vim ceilometer-alarm-notifier.conf

 description "ceilometer-alarm-evaluator"  
 author "Bruce Martins"  
 start on runlevel [2345]  
 stop on runlelvel [!2345]  
 chdir /var/run  
 pre-start script  
     mkdir -p /var/run/ceilometer  
     chown ceilometer:ceilometer /var/run/ceilometer  
     mkdir -p /var/lock/ceilometer  
     chown ceilometer:ceilometer /var/lock/ceilometer  
 end script  
 exec start-stop-daemon --start --chuid ceilometer --exec /usr/bin/ceilometer-alarm-notifier  

save and exit
change the the init.d directiory

# cd /etc/init.d

create the symbolic links
# ln -s /lib/init/upstart-job ceilometer-alarm-notifier
# ln -s /lib/init/upstart-job ceilometer-alarm-evaluator

then start the services
# service ceilometer-alarm-notifier start
# service ceilometer-alarm-evaluator start

That should resolve the missing services required for ceilometer until fixed in a later patch

Tweet