yahoo-eng-team team mailing list archive

[OpenStack Infra <1973726@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.opendev.org/c/openstack/neutron/+/844297
Committed: https://opendev.org/openstack/neutron/commit/5957e90575eddc864b59ea2862e4c2bcd7a1bf7a
Submitter: "Zuul (22348)"
Branch:    master

commit 5957e90575eddc864b59ea2862e4c2bcd7a1bf7a
Author: yatinkarel <ykarel@xxxxxxxxxx>
Date:   Wed Jun 1 19:34:25 2022 +0530

    Create an index for subnetpools.address_scope_id
    
    The method "get_network_address_scope" filters
    "Subnetpool" with "address_scope_id" using an
    exact match. Making the column indexed will improve
    the query performance.
    
    Closes-Bug: #1973726
    Change-Id: Ib3f8e18ba28b277d5fa02dd386ca80a5a113c247


** Changed in: neutron
       Status: In Progress => Fix Released

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

Title:
  [DB] "SubnetPool" exact match queries to non-indexed columns

Status in neutron:
  Fix Released

Bug description:
  In
  ``neutron.objects.address_scope.AddressScope.get_network_address_scope``,
  the OVO executes a query using exact match filters to
  "address_scope_id". This column is not indexed and the query could
  under perform.

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