Reviewed: https://review.openstack.org/399672
Committed:
https://git.openstack.org/cgit/openstack/nova/commit/?id=887cc5243eeef7028aafb393948abd320893179b
Submitter: Jenkins
Branch: master
commit 887cc5243eeef7028aafb393948abd320893179b
Author: int32bit <kryst...@gmail.com>
Date: Sat Nov 19 00:08:12 2016 +0800
Add index on instances table across project_id and updated_at
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.
Closes-Bug: #1642729
Change-Id: I4c723839f36efddd95cd24d745fb71c96c75d2c1
** Changed in: nova
Status: In Progress => Fix Released
--
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):
Fix Released
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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
