yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem@xxxxxxxxxx>]

Public bug reported:

As noted in this spec:

https://review.openstack.org/#/c/393205/6/specs/ocata/approved/add-
whitelist-for-server-list-filter-sort-parameters.rst

We should have an index on the instances.updated_at table because that's
what's used to filter instances when using the --changes-since filter
parameter with nova list.

** Affects: nova
     Importance: Wishlist
         Status: Confirmed


** Tags: db

-- 
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/1642729

Title:
  instances.updated_at should be indexed for "nova list --changes-since"
  queries

Status in OpenStack Compute (nova):
  Confirmed

Bug description:
  As noted in this spec:

  https://review.openstack.org/#/c/393205/6/specs/ocata/approved/add-
  whitelist-for-server-list-filter-sort-parameters.rst

  We should have an index on the instances.updated_at table because
  that's what's used to filter instances when using the --changes-since
  filter parameter with nova list.

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