neutron

  1. Bug #1364358
  2. Comment #2

Comment 2 for bug 1364358

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.openstack.org/116988
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=187217d767ca41b742937fe183ba4a4c20e59185
Submitter: Jenkins
Branch: master

commit 187217d767ca41b742937fe183ba4a4c20e59185
Author: Cedric Brandily <email address hidden>
Date: Tue Aug 26 20:23:04 2014 +0200

    Remove SELECT FOR UPDATE use in delete_firewall

    SELECT FOR UPDATE expression, which is triggered with the use of the
    SQLAlchemy Query object's with_lockmode('update') method, is
    detrimental to performance and scalability of the database
    performance code in Neutron due to the lock contention it produces.

    SELECT FOR UPDATE can be entirely avoided in delete_firewall method
    with the use of single-shot DELETE expressions.

    Partial-Bug: #1364358
    Change-Id: Ia8db73312f5dff6a5bd573694a60a798279834cb