)]}'
{"id":"openstack%2Fplacement~675287","triplet_id":"openstack%2Fplacement~master~If9e6693da9ea09966b4282369cd99516658507b6","project":"openstack/placement","branch":"master","topic":"cd/usages-bindparam","hashtags":[],"change_id":"If9e6693da9ea09966b4282369cd99516658507b6","subject":"Use another expanding bindparam in _get_usages_by_provider_trees","status":"MERGED","created":"2019-08-08 10:30:56.000000000","updated":"2019-08-08 18:59:58.000000000","submitted":"2019-08-08 18:59:58.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":4,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"675287-1565290798920-01c2484d","meta_rev_id":"d43678bc484a55ff457aa70f7eeaf3d7ab7d9ea4","_number":675287,"virtual_id_number":675287,"owner":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"value":0,"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"date":"2019-08-08 11:17:44.000000000","_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":2,"date":"2019-08-08 18:59:58.000000000","post_submit":true,"permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"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":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"all":[{"value":2,"date":"2019-08-08 14:54:51.000000000","_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"value":2,"date":"2019-08-08 11:01:49.000000000","_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"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":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"all":[{"value":1,"date":"2019-08-08 14:54:51.000000000","_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"value":0,"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"value":0,"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-08-08 11:01:49.000000000","updated_by":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"reviewer":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"state":"REVIEWER"},{"updated":"2019-08-08 14:54:51.000000000","updated_by":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"reviewer":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"state":"REVIEWER"},{"updated":"2019-08-08 18:59:58.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":"61f329bfd0adc5fd5b10b6a192253b7a297a8bbf","author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"date":"2019-08-08 10:30:56.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"ebf1439da9f1c70f31e7e6170b29f42a9b2cf3ff","author":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"date":"2019-08-08 11:01:49.000000000","message":"Patch Set 1: Code-Review+2\n\n(2 comments)","accounts_in_message":[],"_revision_number":1},{"id":"8139f34c7f05f363a990a90527f1c16cfea1be95","author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"date":"2019-08-08 11:17:44.000000000","message":"Patch Set 1:\n\n(2 comments)","accounts_in_message":[],"_revision_number":1},{"id":"dd53f97054ab3e39bcf78c363ed635759e55c1ea","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-08 13:03:36.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://logs.opendev.org/87/675287/1/check/grenade-py3/424966f/ : SUCCESS in 58m 30s\n- tempest-integrated-placement https://logs.opendev.org/87/675287/1/check/tempest-integrated-placement/2dc2a39/ : SUCCESS in 1h 31m 31s\n- openstack-tox-docs https://logs.opendev.org/87/675287/1/check/openstack-tox-docs/a79607e/html/ : SUCCESS in 5m 27s\n- openstack-tox-cover https://logs.opendev.org/87/675287/1/check/openstack-tox-cover/62e228c/cover/ : SUCCESS in 8m 03s\n- openstack-tox-lower-constraints https://logs.opendev.org/87/675287/1/check/openstack-tox-lower-constraints/b3c61b5/ : SUCCESS in 6m 42s\n- openstack-tox-pep8 https://logs.opendev.org/87/675287/1/check/openstack-tox-pep8/49b261e/ : SUCCESS in 5m 04s\n- openstack-tox-py27 https://logs.opendev.org/87/675287/1/check/openstack-tox-py27/d13c219/ : SUCCESS in 5m 16s\n- openstack-tox-py36 https://logs.opendev.org/87/675287/1/check/openstack-tox-py36/02b9789/ : SUCCESS in 6m 39s\n- openstack-tox-py37 https://logs.opendev.org/87/675287/1/check/openstack-tox-py37/9e2b641/ : SUCCESS in 6m 50s\n- openstack-tox-functional https://logs.opendev.org/87/675287/1/check/openstack-tox-functional/ed1acfd/ : SUCCESS in 5m 40s\n- openstack-tox-functional-py36 https://logs.opendev.org/87/675287/1/check/openstack-tox-functional-py36/f4ad75e/ : SUCCESS in 4m 59s\n- openstack-tox-functional-py37 https://logs.opendev.org/87/675287/1/check/openstack-tox-functional-py37/febbf95/ : SUCCESS in 7m 02s\n- placement-nova-tox-functional-py37 https://logs.opendev.org/87/675287/1/check/placement-nova-tox-functional-py37/6853b83/ : SUCCESS in 14m 53s\n- placement-nested-perfload https://logs.opendev.org/87/675287/1/check/placement-nested-perfload/6a5608d/ : SUCCESS in 11m 09s (non-voting)\n- placement-perfload https://logs.opendev.org/87/675287/1/check/placement-perfload/4b24482/ : SUCCESS in 7m 24s (non-voting)\n- tempest-ipv6-only https://logs.opendev.org/87/675287/1/check/tempest-ipv6-only/7297fab/ : SUCCESS in 1h 06m 26s","accounts_in_message":[],"_revision_number":1},{"id":"2fdf30956baea8099c4d98ee81305bcf161f86d1","author":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"date":"2019-08-08 14:54:51.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"134e0ebf0924a9b437fade8d4ddbc00a89a995df","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-08 15:06:47.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"375f8ffd9f6726623b5ecf3cd8010b6aa47ef27b","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-08 18:59:58.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1},{"id":"db14da922bd69788fb04545774b1f90f8338fa98","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-08 18:59:58.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade-py3 https://logs.opendev.org/87/675287/1/gate/grenade-py3/c9d3992/ : SUCCESS in 1h 10m 31s\n- tempest-integrated-placement https://logs.opendev.org/87/675287/1/gate/tempest-integrated-placement/c979fec/ : SUCCESS in 1h 23m 41s\n- openstack-tox-docs https://logs.opendev.org/87/675287/1/gate/openstack-tox-docs/479bed0/html/ : SUCCESS in 5m 44s\n- openstack-tox-lower-constraints https://logs.opendev.org/87/675287/1/gate/openstack-tox-lower-constraints/911b1e0/ : SUCCESS in 5m 09s\n- openstack-tox-pep8 https://logs.opendev.org/87/675287/1/gate/openstack-tox-pep8/dec61d8/ : SUCCESS in 7m 06s\n- openstack-tox-py27 https://logs.opendev.org/87/675287/1/gate/openstack-tox-py27/6d1ce55/ : SUCCESS in 4m 51s\n- openstack-tox-py36 https://logs.opendev.org/87/675287/1/gate/openstack-tox-py36/d9e95c8/ : SUCCESS in 5m 46s\n- openstack-tox-py37 https://logs.opendev.org/87/675287/1/gate/openstack-tox-py37/ddfc0a1/ : SUCCESS in 5m 01s\n- openstack-tox-functional https://logs.opendev.org/87/675287/1/gate/openstack-tox-functional/76f9c23/ : SUCCESS in 4m 19s\n- openstack-tox-functional-py36 https://logs.opendev.org/87/675287/1/gate/openstack-tox-functional-py36/7f75544/ : SUCCESS in 5m 36s\n- openstack-tox-functional-py37 https://logs.opendev.org/87/675287/1/gate/openstack-tox-functional-py37/8d6c003/ : SUCCESS in 7m 16s\n- placement-nova-tox-functional-py37 https://logs.opendev.org/87/675287/1/gate/placement-nova-tox-functional-py37/2caf501/ : SUCCESS in 11m 41s\n- tempest-ipv6-only https://logs.opendev.org/87/675287/1/gate/tempest-ipv6-only/d28dab5/ : SUCCESS in 1h 05m 20s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"f69f584577eedf07b45862d65fce2c7217634b8f","revisions":{"f69f584577eedf07b45862d65fce2c7217634b8f":{"kind":"REWORK","_number":1,"created":"2019-08-08 10:30:56.000000000","uploader":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"ref":"refs/changes/87/675287/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/87/675287/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/87/675287/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/87/675287/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/87/675287/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/87/675287/1"}}},"commit":{"parents":[{"commit":"307805f96c908d96f7c21cf0f55396b5376dbf1d","subject":"Merge \"Optimize trait creation to check existence first\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/307805f96c908d96f7c21cf0f55396b5376dbf1d"}]}],"author":{"name":"Chris Dent","email":"cdent@anticdent.org","date":"2019-08-08 10:26:15.000000000","tz":60},"committer":{"name":"Chris Dent","email":"cdent@anticdent.org","date":"2019-08-08 10:26:15.000000000","tz":60},"subject":"Use another expanding bindparam in _get_usages_by_provider_trees","message":"Use another expanding bindparam in _get_usages_by_provider_trees\n\nWe had already [1] changed one in_ in _get_usages_by_provider_trees to\nbe an expanding bindparam. This changes the other based on new profiling\nresults. The same value is used for the param.\n\n[1] I121e5ac6e8202467bf72d9de7ac452d5b5804da1h\n\nChange-Id: If9e6693da9ea09966b4282369cd99516658507b6\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/f69f584577eedf07b45862d65fce2c7217634b8f"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/f69f584577eedf07b45862d65fce2c7217634b8f"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}