[openstack-dev] WARNING: ... This application has not enabled MySQL traditional mode, which means silent data corruption may occur - real issue?

Brant Knudson blk at acm.org
Wed Mar 5 23:13:59 UTC 2014


On Tue, Mar 4, 2014 at 1:24 PM, Joe Gordon <joe.gordon0 at gmail.com> wrote:

> On Tue, Mar 4, 2014 at 11:08 AM, Ben Nemec <openstack at nemebean.com> wrote:
> > On 2014-03-04 12:51, Sean Dague wrote:
> >>
> >> On 03/04/2014 01:27 PM, Ben Nemec wrote:
> >>>
> >>> This warning should be gone by default once
> >>>
> >>>
> https://github.com/openstack/oslo-incubator/commit/dda24eb4a815914c29e801ad0176630786db8734
> >>> gets synced.  I believe there is work underway by the db team to get
> >>> that done.
> >>>
> >>> Note that the reason it will be gone is that we're changing the default
> >>> oslo db mode to traditional, so if we have any code that would have
> >>> triggered silent data corruption it's now going to be not so silent.
> >>>
> >>> -Ben
> >>
> >>
> >> Ok, but we're at the i3 freeze. So is there a db patch set up for every
> >> service to sync that, and FFE ready to let this land?
> >>
> >> Because otherwise I'm very afraid this is going to get trapped as 1/2
> >> implemented, which would be terrible for the release.
> >>
> >> So basically, who is driving these patches out to the projects?
> >>
> >>         -Sean
> >
> >
> > I'm not sure.  We're tracking the sync work here:
> > https://etherpad.openstack.org/p/Icehouse-nova-oslo-sync but it just
> says
> > the db team is working on it.
> >
> > Adding Joe and Doug since I think they know more about what's going on
> with
> > this.
>
> https://github.com/openstack/oslo-incubator/blob/master/MAINTAINERS#L100
>
> >
> > If we can't get db synced, it's basically a bit flip to turn on
> traditional
> > mode in the projects that are seeing this message right now.  I'd rather
> not
> > since we want to drop support for that in favor of the general sql_mode
> > option, but it can certainly be done if necessary.
> >
> > -Ben
>
>
I proposed a sync to Keystone to get rid of the warning[1]. But when I
tried it, keystone is now logging an INFO for every query telling me what
the mode is, which is way too spammy[2].

[1] https://review.openstack.org/#/c/78429/
[2] https://bugs.launchpad.net/oslo/+bug/1288443

- Brant
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140305/0fa43fb0/attachment.html>


More information about the OpenStack-dev mailing list