[openstack-dev] [Neutron] Issue with pymysql

Joe Gordon joe.gordon0 at gmail.com
Fri Jun 12 10:31:42 UTC 2015

On Fri, Jun 12, 2015 at 7:13 PM, Sean Dague <sean at dague.net> wrote:

> On 06/12/2015 01:17 AM, Salvatore Orlando wrote:
> > It is however interesting that both "lock wait timeouts" and "missing
> > savepoint" errors occur in operations pertaining the same table -
> > securitygroups in this case.
> > I wonder if the switch to pymysl has not actually uncovered some other
> > bug in Neutron.
> >
> > I have no opposition to a revert, but since this will affect most
> > projects, it's probably worth finding some time to investigate what is
> > triggering this failure when sqlalchemy is backed by pymysql before
> > doing that.
> Right, we knew that the db driver would move some bugs around because
> we're no longer blocking python processes on db access (so there used to
> be a pseudo synchronization point before you ever got to the database).
> My feeling is this should be looked into before it is straight reverted
> (are jobs failing beyond Rally?). There are a number of benefits with

A quick look at logstash.openstack.org shows some of the stacktraces are
happening in other neutron jobs as well.

> the new driver, and we can't get to python3 with the old one.

Agreed, pymysql is not to blame it looks like we have hit some neutron
issues.  So lets try to fix neutron. Just because neutron reverts the
default sql connector doesn't mean operators won't end up trying pymysql.

> Rally failing is also an indicator that just such and implicit lock was
> behavior that was depended on before, because it will be sending a bunch
> of similar operations all at once as a kind of stress test. It would
> tend to expose issues like this first.

Glad to see us catch these issues early.

>         -Sean
> --
> Sean Dague
> http://dague.net
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150612/3400c26b/attachment.html>

More information about the OpenStack-dev mailing list