Bug 1320243
Summary: | Change OpenStack db collation from utf_unicode_ci to utf8_general_ci | ||
---|---|---|---|
Product: | Red Hat OpenStack | Reporter: | nalmond |
Component: | mariadb-galera | Assignee: | Damien Ciabrini <dciabrin> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Udi Shkalim <ushkalim> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 7.0 (Kilo) | CC: | chjones, mbayer, nalmond, srevivo |
Target Milestone: | --- | Keywords: | ZStream |
Target Release: | 7.0 (Kilo) | ||
Hardware: | x86_64 | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2017-10-24 13:39:14 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
nalmond
2016-03-22 16:19:19 UTC
> Currently we have databases that have both utf8_general_ci and utf8_unicode_ci. In our development environment all db's were utf8_general_ci. We do not have server level setting for collation.
is this collation being set in the CREATE DATABASE statement ? What tool is being used to emit CREATE DATABASE ? Confirm no collation is set in /etc/my.cnf.d/mariadb-server.cnf ?
if this is a retroactive fix, then they should choose one collation or the other, then set it for all existing tables as well as the database: ALTER DATABASE neutron CHARACTER SET utf8_general_ci then, for every table in neutron (output of SHOW TABLES command): ALTER TABLE <tablename> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; then, as neutron migrations create subsequent tables, they will also have the utf8_general_ci collation and will match for FK definitions. in Director, charset and collation are handled by the individual puppet-<project> modules, e.g. puppet-nova/manifests/db/mysql.pp, puppet-neutron/manifests/db/mysql.pp, etc. and they are all on utf8/utf8_general_ci. So this issue involves only upgrades from very old versions of openstack, most likely from the previous installer. We believe this may have been related to upgrading an older, pre-Director deployment. Any more recent deployments should be using the correct collation method, and certainly current versions deploy using the correct method. The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days |