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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp

