Default MySQL collate parameter is not the one from db_sync
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| puppet-ceilometer |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-cinder |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-designate |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-glance |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-gnocchi |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-heat |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-ironic |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-keystone |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-manila |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-neutron |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-nova |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-openstacklib |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-sahara |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-trove |
Fix Released
|
Critical
|
Emilien Macchi | ||
| puppet-tuskar |
Fix Released
|
Critical
|
Sebastien Badia | ||
Bug Description
It affects all Puppet OpenStack modules when running MySQL with ::<module>
* First time you run puppet: the database will be created with utf8_unicode_ci collate. The db_sync runs at the end of the catalog. db_sync (for any project) changes the collate to utf8_general_ci.
* Second time you run puppet: the database is utf8_general_ci so openstacklib will change it to utf8_unicode_ci and will notifiy some resources in catalog (eventually restarts depending of modules).
* If db_sync is run again, the collate will change, and Puppet will always try to configure it to 'utf8_unicode_ci'. This is endless.
Default documentation suggests 'utf8_general_ci' [1].
Default in puppetlabs-mysql is 'utf8_general_ci'.
I suggest we move our modules to use 'utf8_general_ci' and be consistent everywhere.
This default won't be backward compatible.
[1] http://
| Changed in puppet-ceilometer: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-cinder: | |
| importance: | Undecided → Critical |
| Changed in puppet-cinder: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| Changed in puppet-designate: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-glance: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-gnocchi: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-heat: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → High |
| Changed in puppet-ironic: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-keystone: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-manila: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-neutron: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-nova: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-openstacklib: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-sahara: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-trove: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-tuskar: | |
| assignee: | nobody → Emilien Macchi (emilienm) |
| importance: | Undecided → Critical |
| Changed in puppet-heat: | |
| importance: | High → Critical |
| Changed in puppet-tuskar: | |
| assignee: | Matt Fischer (mfisch) → Sebastien Badia (sbadia) |
| Changed in puppet-openstacklib: | |
| status: | New → Fix Committed |
| Changed in puppet-cinder: | |
| assignee: | Emilien Macchi (emilienm) → nobody |
| assignee: | nobody → Emilien Macchi (emilienm) |
| Changed in puppet-designate: | |
| assignee: | Emilien Macchi (emilienm) → nobody |
| Changed in puppet-glance: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-cinder: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-designate: | |
| assignee: | Matt Fischer (mfisch) → Emilien Macchi (emilienm) |
| Changed in puppet-designate: | |
| status: | In Progress → Fix Committed |
| Changed in puppet-ceilometer: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-cinder: | |
| milestone: | none → 6.0.0 |
| status: | Fix Released → Fix Committed |
| Changed in puppet-glance: | |
| status: | Fix Released → Fix Committed |
| milestone: | none → 6.0.0 |
| Changed in puppet-heat: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-keystone: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-neutron: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-nova: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-openstacklib: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-sahara: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-trove: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-designate: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-ironic: | |
| milestone: | none → 6.0.0 |
| Changed in puppet-keystone: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-glance: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-ironic: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-cinder: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-nova: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-designate: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-ceilometer: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-openstacklib: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-neutron: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-sahara: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-trove: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-heat: | |
| status: | Fix Committed → Fix Released |
| Changed in puppet-manila: | |
| milestone: | none → 6.0.0 |
| status: | Fix Committed → Fix Released |
| Changed in puppet-tuskar: | |
| milestone: | none → 6.0.0 |
| status: | Fix Committed → Fix Released |
| Changed in puppet-gnocchi: | |
| status: | Fix Committed → Fix Released |
Fix proposed to branch: master /review. openstack. org/175989
Review: https:/