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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp