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:/