安装OpenStack ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8 在Openstack中，安装 Glance 镜像组件时，初始化

# glance-manage db_sync

……

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

初始化失败

 

然后登陆MySQL数据库查看此表，

mysql> use glance;

 Database changed    

mysql> show tables;

+------------------+    
| Tables_in_glance |    
+------------------+    
| migrate_version  |    
+------------------+    
1 row in set (0.00 sec)

 

然后根据报错信息设置 migrate_version  表的字符集为 utf8

mysql> alter table migrate_version convert to character set 'utf8';   
Query OK, 1 row affected (0.02 sec)    
Records: 1  Duplicates: 0  Warnings: 0

 

接着再继续初始化

# glance-manage db_sync

问题完美解决