← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1834308] Re: [DVR][DB] too many slow query during agent restart

 

Reviewed:  https://review.opendev.org/673557
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=dd96f3775939dc0209396b4bd73038c1962e6a7e
Submitter: Zuul
Branch:    master

commit dd96f3775939dc0209396b4bd73038c1962e6a7e
Author: LIU Yulong <i@xxxxxxxxxxxx>
Date:   Mon Jun 24 18:06:22 2019 +0800

    Optimize DVR related port DB query
    
    Save order by in port query when not require fixed_ips,
    and save some useless query for dvr subnet mac.
    
    Closes-Bug: #1834308
    Change-Id: I6836840edcaa5a21fd2ba9f65ffd24f7e5038fa3


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

Title:
  [DVR][DB] too many slow query during agent restart

Status in neutron:
  Fix Released

Bug description:
  ENV: stable/queens

  In a large scale cloud deployment, when restart neutron agent,
  especially l3 agents, neutron server side will trigger too many slow
  DB query. And this will cause the agent restart time to be too long to
  operate.

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


References