yahoo-eng-team team mailing list archive

[Cedric Brandily <1503852@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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=

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

-- 
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:
  New

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