← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1383617] Re: SAWarning contradiction IN-predicate on "instances.uuid"

 

** Also affects: nova/juno
   Importance: Undecided
       Status: New

** Changed in: nova/juno
    Milestone: None => 2014.2.2

** Changed in: nova/juno
       Status: New => Fix Committed

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1383617

Title:
  SAWarning contradiction IN-predicate on "instances.uuid"

Status in OpenStack Compute (Nova):
  Fix Released
Status in OpenStack Compute (nova) juno series:
  Fix Committed

Bug description:
  /usr/lib64/python2.7/site-
  packages/sqlalchemy/sql/default_comparator.py:35: SAWarning: The IN-
  predicate on "instances.uuid" was invoked with an empty sequence. This
  results in a contradiction, which nonetheless can be expensive to
  evaluate.  Consider alternative strategies for improved performance.

  The above warning reported in the n-cond (or n-cpu) log when using
  SQLAlchemy 0.9.8.

  The system doing an invain query at the end.

  The warning generated by this code part:
  https://github.com/openstack/nova/blob/9fd059b938a2acca8bf5d58989c78d834fbb0ad8/nova/compute/manager.py#L696
  driver_uuids can be an empty list. In this case the sql query is not necessary.

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


References