Was working on upgrading OpenStack lab from Havana to Icehouse release. It looks like it’s common problem after installation of new OpenStack service packages if you have MySQL db backend. db_sync command
returns error related to the issue with collation of some tables in database.
For keystone I got the following error message:
To fix this you should log into mysql and alter table, for keystone:
1 2 3
After this migration should run smoothly. In general this issue/fix applies to all major OpenStack services.
Thanks to Bruce Martins, here is his blog post.