diff options
author | Dan Prince <dprince@redhat.com> | 2012-05-04 17:01:14 -0400 |
---|---|---|
committer | Dan Prince <dprince@redhat.com> | 2012-05-11 11:56:36 -0400 |
commit | 7b5fdac84b513c6b606848cc353995d6abb9a7c9 (patch) | |
tree | 2fea8476caf3799ac3236f7f66aae338769209eb /tools/hacking.py | |
parent | 0598ec2d3618022e913c0d1a84feb71d2b6c6a95 (diff) | |
download | nova-7b5fdac84b513c6b606848cc353995d6abb9a7c9.tar.gz nova-7b5fdac84b513c6b606848cc353995d6abb9a7c9.tar.xz nova-7b5fdac84b513c6b606848cc353995d6abb9a7c9.zip |
Create a utf8 version of the dns_domains table.
The old dns_domains table was encoded in the 'latin1'
charset and has its primary key length set to 512.
This is too long to be a valid pkey in a proper 'utf8' encoded
table and seems to cause a slew of errors like:
1) Dumping a database with mysqldump and trying to import it fails
because this table is latin1 but fkeys to utf8 tables (projects).
2) Trying to alter the old dns_domains table fails with errors
like:
mysql> ALTER TABLE dns_domains DROP PRIMARY KEY;
ERROR 1025 (HY000): Error on rename of './nova/#sql-6cf_855'....
This patch creates a new migration that re-creates the dns_domains
table with a shorter 'domain' column which works with the utf8
charset.
Fixes LP Bug #993663.
Change-Id: I2060d39cbdabd20f410ebd501160a04c51641755
Diffstat (limited to 'tools/hacking.py')
0 files changed, 0 insertions, 0 deletions