← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1330562] [NEW] Remove SELECT ... FOR UPDATE usage from ML2 type drivers

 

Public bug reported:

MySQL Galera does not support SELECT ... FOR UPDATE[1], since it has no
concept of cross-node locking of records and results are non-
deterministic.

We should prefer to avoid SELECT ... FOR UPDATE (sqlalchemy
with_lockmode method)


[1]http://lists.openstack.org/pipermail/openstack-dev/2014-May/035264.html

** Affects: neutron
     Importance: Undecided
     Assignee: Cedric Brandily (cbrandily)
         Status: New


** Tags: db ml2

** Changed in: neutron
     Assignee: (unassigned) => Cedric Brandily (cbrandily)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1330562

Title:
  Remove SELECT ... FOR UPDATE usage from ML2 type drivers

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  MySQL Galera does not support SELECT ... FOR UPDATE[1], since it has
  no concept of cross-node locking of records and results are non-
  deterministic.

  We should prefer to avoid SELECT ... FOR UPDATE (sqlalchemy
  with_lockmode method)

  
  [1]http://lists.openstack.org/pipermail/openstack-dev/2014-May/035264.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1330562/+subscriptions


Follow ups

References