Comment 6 for bug 993663

Revision history for this message
Dan Prince (dan-prince) wrote : Re: dns_domains table mysql charset is 'latin1'. Should be 'utf8'

The trunk (Folsom) fix for this issue is here:

https://review.openstack.org/#/c/7139/

This creates a new dns_domains table with a varchar 255 domain column that is utf8. This fixes issues where the MySQL schema can't be imported after a backup.

I'd like to do a similar fix for Essex that runs on 'nova-manage db sync' but doesn't claim a new migration number. In this manner we should be able to fix the issue for Essex users (fixing MySQL backup/restore) is probably important. In any case running the Folsom migration on any Essex patch will re-create the table again... but that won't hurt anything. I do like keeping it as a migration for Folsom.