SAWarning: The IN-predicate on [...] was invoked with an empty sequence

Bug #931687 reported by Johannes Erdfelt on 2012-02-13
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Johannes Erdfelt

Bug Description

When the list of retrieved servers is empty, warnings are printed in the nova-api logs:

SAWarning: The IN-predicate on "instance_faults.instance_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.

This is the result of querying the database with an empty list of UUIDs. The fix is to not query the DB in that case.

Changed in nova:
assignee: nobody → Johannes Erdfelt (johannes.erdfelt)

Fix proposed to branch: master

Changed in nova:
status: New → In Progress

Submitter: Jenkins
Branch: master

commit 7347a14213919aa78ad156b50deee846ec333b6a
Author: Johannes Erdfelt <email address hidden>
Date: Mon Feb 13 20:51:29 2012 +0000

    Don't query database with an empty list for IN clause

    Fixes bug 931687

    Change-Id: Ieec2c43c1d56c8d54d5bce606db9909b2ef5d6d4

Changed in nova:
status: In Progress → Fix Committed
Thierry Carrez (ttx) on 2012-02-29
Changed in nova:
milestone: none → essex-4
status: Fix Committed → Fix Released
Thierry Carrez (ttx) on 2012-04-05
Changed in nova:
milestone: essex-4 → 2012.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers