yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: keystone
       Status: Fix Committed => Fix Released

** Changed in: keystone
    Milestone: None => havana-3

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

Title:
  "Select N+1" issue in catalog's SQL backend

Status in OpenStack Identity (Keystone):
  Fix Released

Bug description:
  DESCRIPTION

  SQL backend for keystone catalog has classic select n+1 issue in
  get_catalog() and get_v3_catalog() methods (for each endpoint get
  service). Even though the number of endpoints and services is usually
  not very high, given methods are executed on each authenticate
  request, which impacts performance of each openstack service
  regardless of keystone identity backend used.

  FILES
  keystone/catalog/backends/sql.py

  EXPECTED BEHAVIOR
  Single "select ... join" SQL statement generated

  ACTUAL BEHAVIOR
  N+1 select statements generated, where N is the number of endpoints.

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