Misleading warning about MySQL TRADITIONAL mode not being set
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Fix Released
|
Medium
|
Mehdi Abaakouk | ||
OpenStack Heat |
Fix Released
|
Undecided
|
lvdongbing | ||
OpenStack Identity (keystone) |
Fix Released
|
Medium
|
Brant Knudson | ||
oslo-incubator |
Fix Released
|
Medium
|
Florian Haas |
Bug Description
common.
WARNING keystone.
That warning is problematic for several reasons:
(1) It suggests the wrong mode. Arguably TRADITIONAL is better than the default, but STRICT_ALL_TABLES would actually be more useful.
(2) The user has no way to fix the warning.
(3) The warning does not take into account that a global sql-mode may in fact have been set via the server-side MySQL configuration, in which case the session *may* in fact be using TRADITIONAL mode all along, despite the warning saying otherwise. This makes (2) even worse.
My suggested approach would be:
- Remove the warning.
- Make the SQL mode a config option.
Patches forthcoming.
description: | updated |
description: | updated |
Changed in oslo: | |
milestone: | none → icehouse-3 |
importance: | Undecided → Medium |
Changed in oslo: | |
assignee: | nobody → Florian Haas (fghaas) |
Changed in oslo: | |
assignee: | Florian Haas (fghaas) → Ben Nemec (bnemec) |
Changed in oslo: | |
assignee: | Ben Nemec (bnemec) → Florian Haas (fghaas) |
tags: | added: oslo |
Changed in oslo: | |
status: | Fix Committed → Fix Released |
Changed in keystone: | |
milestone: | none → icehouse-rc1 |
importance: | Undecided → Medium |
Changed in keystone: | |
status: | Fix Committed → Fix Released |
Changed in oslo: | |
milestone: | icehouse-3 → 2014.1 |
Changed in keystone: | |
milestone: | icehouse-rc1 → 2014.1 |
Changed in ceilometer: | |
status: | Fix Committed → Fix Released |
milestone: | none → juno-1 |
Changed in fuel: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
milestone: | none → 5.1 |
Changed in heat: | |
assignee: | nobody → lvdongbing (dbcocle) |
Changed in fuel: | |
assignee: | nobody → Timur Nurlygayanov (tnurlygayanov) |
summary: |
- Misleading warning about MySQL TRADITIONAL mode not being set + [mos] Misleading warning about MySQL TRADITIONAL mode not being set |
no longer affects: | fuel |
summary: |
- [mos] Misleading warning about MySQL TRADITIONAL mode not being set + Misleading warning about MySQL TRADITIONAL mode not being set |
Changed in ceilometer: | |
milestone: | juno-1 → 2014.2 |
Fix proposed to branch: master /review. openstack. org/68474
Review: https:/