← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #42536

[Bug 1503852] Re: Do not use SQL IN on empty sequence

  Thread Previous • Date Previous • • Thread Next 
** Changed in: neutron
       Status: Fix Committed => 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/1503852

Title:
  Do not use SQL IN on empty sequence

Status in neutron:
  Fix Released

Bug description:
  According to a log warning[1] and logstash[2], neutron uses SQL IN
  operator on an empty list:

  SAWarning: The IN-predicate on "ports.id" was invoked with an empty
  sequence. This results in a contradiction, which nonetheless can be
  expensive to evaluate.  Consider alternative strategies for improved
  performance.'

  which seems to have an effect on performance.

  [1] http://logs.openstack.org/82/228582/13/check/gate-neutron-python34/5b36c34/console.html
  [2] http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOiBcIlNBV2FybmluZzogVGhlIElOLXByZWRpY2F0ZSBvbiBcIiBBTkQgbWVzc2FnZTogXCJ3YXMgaW52b2tlZCB3aXRoIGFuIGVtcHR5IHNlcXVlbmNlXCIgQU5EIHByb2plY3Q6IFwib3BlbnN0YWNrL25ldXRyb25cIiIsImZpZWxkcyI6W10sIm9mZnNldCI6MCwidGltZWZyYW1lIjoiMTcyODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJ0aW1lIjp7InVzZXJfaW50ZXJ2YWwiOjB9LCJzdGFtcCI6MTQ0NDI0NzYwOTI4NH0=

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

References

  Thread Previous • Date Previous • • Thread Next