)]}'
{"id":"openstack%2Fwatcher~669876","triplet_id":"openstack%2Fwatcher~stable%2Fstein~I797ad934a0f8496dbcbf65798e28b0443f238137","project":"openstack/watcher","branch":"stable/stein","topic":"bug/1834679","hashtags":[],"change_id":"I797ad934a0f8496dbcbf65798e28b0443f238137","subject":"Reduce the query time of the instances when call get_instance_list()","status":"MERGED","created":"2019-07-09 13:44:17.000000000","updated":"2019-07-10 06:57:26.000000000","submitted":"2019-07-10 06:57:26.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"669876-1562741846173-dd0b5d1a","meta_rev_id":"72c1fe03eff37aa4970a6aa750d0aac0cc727983","_number":669876,"virtual_id_number":669876,"owner":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},{"value":0,"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},{"value":0,"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},{"value":2,"date":"2019-07-10 06:57:25.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},"all":[{"value":2,"date":"2019-07-09 14:07:19.000000000","_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},{"value":2,"date":"2019-07-09 13:59:23.000000000","_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},{"value":0,"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2019-07-09 23:19:01.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},"all":[{"value":0,"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},{"value":0,"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},{"value":1,"date":"2019-07-10 06:14:05.000000000","_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},{"value":0,"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},{"value":0,"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"}],"values":{" 0":"Standard Change","+1":"Important Change","+2":"High Priority Change"},"default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},{"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},{"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-07-09 13:59:23.000000000","updated_by":{"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},"reviewer":{"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},"state":"REVIEWER"},{"updated":"2019-07-09 14:07:19.000000000","updated_by":{"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},"reviewer":{"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},"state":"REVIEWER"},{"updated":"2019-07-09 23:19:01.000000000","updated_by":{"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"},"reviewer":{"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"},"state":"REVIEWER"},{"updated":"2019-07-10 06:14:05.000000000","updated_by":{"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},"reviewer":{"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},"state":"REVIEWER"},{"updated":"2019-07-10 06:57:25.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"db852002246a2594e21dcec4d0ecdfe96fdf6250","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-07-09 13:44:17.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"90032bb186b568fb155295047cea1d899c3b8509","author":{"_account_id":28748,"name":"chenker","email":"chen.ke14@zte.com.cn","username":"chenke"},"date":"2019-07-09 13:59:23.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"cc005b3a18dbb18fac2f031fde2a50247e0d4f39","author":{"_account_id":29911,"name":"Dantali0n","email":"info@dantalion.nl","username":"Dantali0n"},"date":"2019-07-09 14:07:19.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"7ab5aa82559d0f0a3a9a8c37764bdcf35d9e4636","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-07-09 14:57:27.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover http://logs.openstack.org/76/669876/1/check/openstack-tox-cover/1de796f/cover/ : SUCCESS in 4m 22s\n- openstack-tox-lower-constraints http://logs.openstack.org/76/669876/1/check/openstack-tox-lower-constraints/106c52e/ : SUCCESS in 3m 55s\n- openstack-tox-pep8 http://logs.openstack.org/76/669876/1/check/openstack-tox-pep8/6a8e4b5/ : SUCCESS in 5m 19s\n- openstack-tox-py27 http://logs.openstack.org/76/669876/1/check/openstack-tox-py27/53bab50/ : SUCCESS in 6m 21s\n- openstack-tox-py35 http://logs.openstack.org/76/669876/1/check/openstack-tox-py35/526b60c/ : SUCCESS in 5m 22s\n- openstack-tox-py36 http://logs.openstack.org/76/669876/1/check/openstack-tox-py36/f0228cd/ : SUCCESS in 5m 06s\n- openstack-tox-docs http://logs.openstack.org/76/669876/1/check/openstack-tox-docs/3f7fc6b/html/ : SUCCESS in 3m 56s\n- watcher-tempest-functional http://logs.openstack.org/76/669876/1/check/watcher-tempest-functional/5fe1217/ : SUCCESS in 26m 23s\n- watcher-grenade http://logs.openstack.org/76/669876/1/check/watcher-grenade/5d47e2c/ : SUCCESS in 47m 05s\n- watcher-tempest-dummy_optim http://logs.openstack.org/76/669876/1/check/watcher-tempest-dummy_optim/d15245c/ : SUCCESS in 49m 16s (non-voting)\n- watcher-tempest-actuator http://logs.openstack.org/76/669876/1/check/watcher-tempest-actuator/29efb99/ : SUCCESS in 49m 08s (non-voting)\n- watcher-tempest-basic_optim http://logs.openstack.org/76/669876/1/check/watcher-tempest-basic_optim/e783067/ : FAILURE in 49m 15s (non-voting)\n- watcher-tempest-vm_workload_consolidation http://logs.openstack.org/76/669876/1/check/watcher-tempest-vm_workload_consolidation/e6818c9/ : SUCCESS in 48m 27s (non-voting)\n- watcher-tempest-workload_balancing http://logs.openstack.org/76/669876/1/check/watcher-tempest-workload_balancing/2b4f5df/ : FAILURE in 57m 19s (non-voting)\n- watcher-tempest-zone_migration http://logs.openstack.org/76/669876/1/check/watcher-tempest-zone_migration/154e7f2/ : SUCCESS in 48m 54s (non-voting)\n- watcher-tempest-host_maintenance http://logs.openstack.org/76/669876/1/check/watcher-tempest-host_maintenance/fd10d0b/ : SUCCESS in 48m 29s (non-voting)\n- watcher-tempest-storage_balance http://logs.openstack.org/76/669876/1/check/watcher-tempest-storage_balance/3bfc141/ : SUCCESS in 45m 06s (non-voting)\n- watcher-tls-test http://logs.openstack.org/76/669876/1/check/watcher-tls-test/a0de9f3/ : SUCCESS in 55m 24s","accounts_in_message":[],"_revision_number":1},{"id":"d41a966187c37d37263c96523229b674182a0bbf","author":{"_account_id":30381,"name":"Jean-Pierre REN","email":"renzp@awcloud.com","username":"jpren"},"date":"2019-07-09 23:19:01.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"fe2366d7a18ad0410077d2a5c355938d6f90490b","author":{"_account_id":21692,"name":"licanwei","email":"li.canwei2@zte.com.cn","username":"licanwei"},"date":"2019-07-10 06:14:05.000000000","message":"Patch Set 1: Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"0965d935f42c647ef570e7c8858bf0b470903591","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-07-10 06:14:16.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"70b4a67d3332b0403fae67fd3380c5bf876f1929","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-07-10 06:57:25.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-lower-constraints http://logs.openstack.org/76/669876/1/gate/openstack-tox-lower-constraints/73bf130/ : SUCCESS in 6m 38s\n- openstack-tox-pep8 http://logs.openstack.org/76/669876/1/gate/openstack-tox-pep8/86b3889/ : SUCCESS in 5m 42s\n- openstack-tox-py27 http://logs.openstack.org/76/669876/1/gate/openstack-tox-py27/5cfcb85/ : SUCCESS in 6m 56s\n- openstack-tox-py35 http://logs.openstack.org/76/669876/1/gate/openstack-tox-py35/f913e74/ : SUCCESS in 6m 04s\n- openstack-tox-py36 http://logs.openstack.org/76/669876/1/gate/openstack-tox-py36/20d5e48/ : SUCCESS in 3m 48s\n- openstack-tox-docs http://logs.openstack.org/76/669876/1/gate/openstack-tox-docs/0e5d905/html/ : SUCCESS in 4m 35s\n- watcher-tempest-functional http://logs.openstack.org/76/669876/1/gate/watcher-tempest-functional/67037d9/ : SUCCESS in 37m 55s","accounts_in_message":[],"_revision_number":1},{"id":"3ef0557a78b96378beaa6c87bb94335d95175ef4","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-07-10 06:57:26.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"34324c95f9010fd3e5178e7105dc3ddc5a0dcfe2","revisions":{"34324c95f9010fd3e5178e7105dc3ddc5a0dcfe2":{"kind":"REWORK","_number":1,"created":"2019-07-09 13:44:17.000000000","uploader":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"ref":"refs/changes/76/669876/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/watcher","ref":"refs/changes/76/669876/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/watcher refs/changes/76/669876/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/watcher refs/changes/76/669876/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/watcher refs/changes/76/669876/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/watcher refs/changes/76/669876/1"}}},"commit":{"parents":[{"commit":"0f90ad596c891e74cb0b65b9a3bde64f1e89da40","subject":"[stable-only] Stop running watcherclient-tempest-functional","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/0f90ad596c891e74cb0b65b9a3bde64f1e89da40"}]}],"author":{"name":"chenke","email":"chen.ke14@zte.com.cn","date":"2019-06-28 06:43:57.000000000","tz":480},"committer":{"name":"Matt Riedemann","email":"mriedem.os@gmail.com","date":"2019-07-09 13:39:46.000000000","tz":-240},"subject":"Reduce the query time of the instances when call get_instance_list()","message":"Reduce the query time of the instances when call get_instance_list()\n\nThe problem is that watcher is passing limit\u003d-1 to novaclient when\nlisting servers which will always make at least two API calls to be\nsure it\u0027s done paging:\n\nhttps://github.com/openstack/python-novaclient/blob/13.0.1/novaclient/v2/servers.py#L896\n\nIf we can determine before we list servers that there are only a\ncertain number where the number of servers is less than 1000. For\nexample: 4, we should just pass the limit\u003dlen(servers) to novaclient\nand avoid the second call for paging which takes extra time and\nyields no results.\n\nChange-Id: I797ad934a0f8496dbcbf65798e28b0443f238137\nCloses-Bug: #1834679\n(cherry picked from commit 1e8b17ac46a9052234c9f56da42a2a4bb8250216)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/34324c95f9010fd3e5178e7105dc3ddc5a0dcfe2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/34324c95f9010fd3e5178e7105dc3ddc5a0dcfe2"}]},"branch":"refs/heads/stable/stein"}},"requirements":[],"submit_records":[],"submit_requirements":[]}