yahoo-eng-team team mailing list archive

[Cedric Brandily <1364358@xxxxxxxxxxxxxxxxxx>]

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.

Moreover SELECT FOR  UPDATE could be deadlock and slowness sources.

Remove the use of SELECT FOR UPDATE in (neutron.db.firewall.)firewall_db
module

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

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


** Tags: db

** 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/1364358

Title:
  Remove SELECT FOR UPDATE usage

Status in OpenStack Neutron (virtual network service):
  In Progress

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.

  Moreover SELECT FOR  UPDATE could be deadlock and slowness sources.

  Remove the use of SELECT FOR UPDATE in
  (neutron.db.firewall.)firewall_db module

  [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/1364358/+subscriptions