commit f0a9f475c5d82493f90debd1082b913511ebacf0
Author: Dan Prince <email address hidden>
Date: Fri Jun 8 16:59:27 2012 -0400
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 an Essex fix that re-creates the dns_domains
table with a shorter 'domain' column which works with the utf8
charset. This database upgrade will run on MySQL databases only
which have a dns_domains table with a domain column length of
VARCHAR(512).
Reviewed: https:/ /review. openstack. org/8356 github. com/openstack/ nova/commit/ f0a9f475c5d8249 3f90debd1082b91 3511ebacf0
Committed: http://
Submitter: Jenkins
Branch: stable/essex
commit f0a9f475c5d8249 3f90debd1082b91 3511ebacf0
Author: Dan Prince <email address hidden>
Date: Fri Jun 8 16:59:27 2012 -0400
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 #sql-6cf_ 855'... .
like:
mysql> ALTER TABLE dns_domains DROP PRIMARY KEY;
ERROR 1025 (HY000): Error on rename of './nova/
This patch creates an Essex fix that re-creates the dns_domains
table with a shorter 'domain' column which works with the utf8
charset. This database upgrade will run on MySQL databases only
which have a dns_domains table with a domain column length of
VARCHAR(512).
Fixes LP Bug #993663 on Essex.
Change-Id: I97888fbc18ebfc 0e25c9ba3116058 8c9cdf5c448