OpenStack Compute (nova)

  1. Bug #1660959
  2. Comment #2

Comment 2 for bug 1660959

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/427667
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=03eced19f5d6665724a4fa432401be742383f8cf
Submitter: Jenkins
Branch: master

commit 03eced19f5d6665724a4fa432401be742383f8cf
Author: Mehdi Abaakouk <email address hidden>
Date: Wed Feb 1 13:31:38 2017 +0100

    placement-api: fix ResourceProviderList query

    The ResourceProviderList query use groupby without all grouped columns.
    This works on mysql with unpredicable result, but don't for other RDBMS.

    For example, postgresql gating jobs dsvm that use nova are currently
    broken.

    This change removes the unused consumer_id on first query,
    and uses the primary key 'id' instead of 'uuid' the second groupby.
    (Because groupby in postgresql requires a PK or all non-primary columns)

    The fix is tested by gate-ceilometer-dsvm-tempest-plugin-postgresql-ubuntu-xenial job
    here: https://review.openstack.org/#/c/427668/

    closes-bug: #1660959
    Change-Id: I6cc93ba0dd569d56696c9210d38dd2d77b4157c1