)]}'
{"id":"openstack%2Fswift~791015","triplet_id":"openstack%2Fswift~master~I17d1907432d00662dca07f457c038cee8a204c02","project":"openstack/swift","branch":"master","topic":"optimize-get-own-range","hashtags":[],"change_id":"I17d1907432d00662dca07f457c038cee8a204c02","subject":"Optimize get_own_shard_range","status":"NEW","created":"2021-05-12 15:51:17.000000000","updated":"2021-05-12 20:52:46.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":false,"submittable":false,"total_comment_count":5,"unresolved_comment_count":5,"has_review_started":true,"meta_rev_id":"8fee472f360c5e6d8fd1bbed8da6bebac3b25efb","_number":791015,"virtual_id_number":791015,"owner":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},{"tag":"autogenerated:zuul:check","value":-1,"date":"2021-05-12 20:52:46.000000000","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":"","value":-1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_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":{"rejected":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"all":[{"value":-1,"date":"2021-05-12 19:16:54.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},{"_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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-05-12 16:57:15.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":"c7510f4a0329f15e4b0144a76161d7e741f8789e","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"date":"2021-05-12 15:51:17.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"0ca518a6f43b4fea7fddb8bc6d606360817ed399","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-05-12 16:57:15.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c972079a46224ac1b8c72514d3a836ce : SUCCESS in 9m 08s\n- grenade https://zuul.opendev.org/t/openstack/build/e1156c85dc354d6cb0a271425dee0e73 : SUCCESS in 58m 19s\n- tempest-integrated-object-storage https://zuul.opendev.org/t/openstack/build/281c3f1897774bb5b40716606e67f609 : SUCCESS in 38m 08s\n- swift-build-image https://zuul.opendev.org/t/openstack/build/d531bac8550745ebaf8bcc9ef60721fd : SUCCESS in 8m 42s (non-voting)\n- swift-build-image-py3 https://zuul.opendev.org/t/openstack/build/1a46bcf1e68c4626a6aeee71c7a4fb96 : SUCCESS in 7m 05s (non-voting)\n- swift-tox-py27 https://zuul.opendev.org/t/openstack/build/28e2516473ce45aa9da2b50096660de0 : FAILURE in 15m 57s\n- swift-tox-py36 https://zuul.opendev.org/t/openstack/build/16d62c7f2a3246819f6e53d40327dbfe : FAILURE in 20m 28s\n- swift-tox-py37 https://zuul.opendev.org/t/openstack/build/165dc11c32864ddea11d41f9e5679eb5 : FAILURE in 20m 16s\n- swift-tox-py38 https://zuul.opendev.org/t/openstack/build/3570e630819b416496d9bc54bec5f999 : FAILURE in 20m 01s\n- swift-tox-py39 https://zuul.opendev.org/t/openstack/build/18d8ab2c1f7d4ea4adc97ab8942c0ebe : FAILURE in 20m 34s\n- swift-tox-func-py27 https://zuul.opendev.org/t/openstack/build/214147519ffb4b28a72a1ba8586b2491 : SUCCESS in 22m 35s\n- swift-tox-func-encryption-py27 https://zuul.opendev.org/t/openstack/build/12850fa928fa47758be42d176b0f88c7 : SUCCESS in 23m 00s\n- swift-tox-func-ec-py27 https://zuul.opendev.org/t/openstack/build/8252de857315435a8fe5060c3ef502bd : SUCCESS in 24m 16s\n- swift-tox-func-py37 https://zuul.opendev.org/t/openstack/build/fc5928e7e80147eebf68fec056f7791c : SUCCESS in 24m 24s\n- swift-tox-func-encryption-py37 https://zuul.opendev.org/t/openstack/build/9ebd8ff89cb94ca6931915e8d728664a : SUCCESS in 28m 42s\n- swift-tox-func-ec-py37 https://zuul.opendev.org/t/openstack/build/c291dac354f447f79fa0783c5108ed09 : SUCCESS in 25m 35s\n- swift-func-cors https://zuul.opendev.org/t/openstack/build/424fa300b7f0497d85219a5a48b7eb61 : SUCCESS in 6m 44s\n- swift-tox-func-s3api-ceph-s3tests-tempauth https://zuul.opendev.org/t/openstack/build/f0d5a66c593c4d7ab26fda54e8c5245e : SUCCESS in 21m 11s (non-voting)\n- swift-probetests-centos-7 https://zuul.opendev.org/t/openstack/build/6bb4bbd06abb4149885b52468c48b016 : FAILURE in 41m 50s\n- swift-probetests-centos-8 https://zuul.opendev.org/t/openstack/build/59016afac423421dbe521964f3547c90 : FAILURE in 1h 00m 14s\n- swift-dsvm-functional https://zuul.opendev.org/t/openstack/build/d3bb1908bde3498d8b5a9cdd2153f028 : SUCCESS in 39m 01s\n- swift-dsvm-functional-ipv6 https://zuul.opendev.org/t/openstack/build/403861315b784afdaea6e7ca5148bc09 : SUCCESS in 47m 18s\n- swift-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/102ddbd815be41c4946a4e93675d7fdf : FAILURE in 19m 49s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/fa55d729a40d4bfca0c01933ab40d214 : SUCCESS in 6m 36s\n- swift-multinode-rolling-upgrade https://zuul.opendev.org/t/openstack/build/8a6ae6a7f756405ab70942b98403d0be : SUCCESS in 22m 23s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/58c8927e20414221b57e1380a99590d3 : SUCCESS in 52m 58s","accounts_in_message":[],"_revision_number":1},{"id":"224999774ff55b952e13b2e1bf22e64ac1730c12","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"date":"2021-05-12 19:15:28.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"867ac09a0979246222239241208c6a9ff794733c","author":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"date":"2021-05-12 19:16:54.000000000","message":"Patch Set 2: Workflow-1\n\nthis is turning out to have a bit of teeth, but it is interesting to observe how coupled together all these shard ranges interfaces are...\n\nnot even sure if we want this; if so it\u0027s a bit more discussion","accounts_in_message":[],"_revision_number":2},{"id":"4d0b6db67c255cc2df00acad73e77abefff439b5","author":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"date":"2021-05-12 19:23:52.000000000","message":"Patch Set 2:\n\n(5 comments)\n\nStill not sure if this is helpful","accounts_in_message":[],"_revision_number":2},{"id":"8fee472f360c5e6d8fd1bbed8da6bebac3b25efb","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-05-12 20:52:46.000000000","message":"Patch Set 2: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/74940be4db9d4cfe9d3c7c24e11b9cde : SUCCESS in 8m 52s\n- grenade https://zuul.opendev.org/t/openstack/build/0e03515300e5471bb8ce7b9dfa53feb9 : SUCCESS in 54m 44s\n- tempest-integrated-object-storage https://zuul.opendev.org/t/openstack/build/bd9a76c719fc42b5b103baf28940c189 : SUCCESS in 36m 26s\n- swift-build-image https://zuul.opendev.org/t/openstack/build/f6af035343e74e60a6c7036c70f28a91 : SUCCESS in 8m 14s (non-voting)\n- swift-build-image-py3 https://zuul.opendev.org/t/openstack/build/85824177e19a4785b0d08c11caf45e8c : SUCCESS in 8m 13s (non-voting)\n- swift-tox-py27 https://zuul.opendev.org/t/openstack/build/e7ef8a4a34874669883936e7b31d258c : FAILURE in 13m 17s\n- swift-tox-py36 https://zuul.opendev.org/t/openstack/build/4f547009ba034df6b85661e84740c2ac : FAILURE in 12m 57s\n- swift-tox-py37 https://zuul.opendev.org/t/openstack/build/31acd29a625f43858227e33bfb95efc2 : FAILURE in 13m 15s\n- swift-tox-py38 https://zuul.opendev.org/t/openstack/build/d0a6cc8aed464d6fad59aecadba63877 : FAILURE in 13m 33s\n- swift-tox-py39 https://zuul.opendev.org/t/openstack/build/3e9dc2e7af74486b835b4a4ab5000f89 : FAILURE in 13m 58s\n- swift-tox-func-py27 https://zuul.opendev.org/t/openstack/build/9e8a47b6b1144172a943b328fef8feef : SUCCESS in 19m 28s\n- swift-tox-func-encryption-py27 https://zuul.opendev.org/t/openstack/build/40ac3ef69eb442369657512391e2184f : SUCCESS in 14m 18s\n- swift-tox-func-ec-py27 https://zuul.opendev.org/t/openstack/build/e71d35c59f1f477ea23468208fff1811 : SUCCESS in 17m 29s\n- swift-tox-func-py37 https://zuul.opendev.org/t/openstack/build/2f3cf74521784e9babb8ae3156f009a6 : SUCCESS in 18m 15s\n- swift-tox-func-encryption-py37 https://zuul.opendev.org/t/openstack/build/5f67856250da4660a6ef34f22c9a14b9 : SUCCESS in 18m 15s\n- swift-tox-func-ec-py37 https://zuul.opendev.org/t/openstack/build/977c19a4fc2149ada58387e5d07d3201 : SUCCESS in 24m 25s\n- swift-func-cors https://zuul.opendev.org/t/openstack/build/49d8f7961bc14af5843054c15f9d0293 : SUCCESS in 6m 30s\n- swift-tox-func-s3api-ceph-s3tests-tempauth https://zuul.opendev.org/t/openstack/build/a8df163b0c7c4b1dae4c3ea63934e52c : FAILURE in 23m 02s (non-voting)\n- swift-probetests-centos-7 https://zuul.opendev.org/t/openstack/build/09b5bcd8bebd4384a841c795c3f55db2 : FAILURE in 40m 43s\n- swift-probetests-centos-8 https://zuul.opendev.org/t/openstack/build/f0d043f832824b3895df3db618ecaa2d : FAILURE in 41m 10s\n- swift-dsvm-functional https://zuul.opendev.org/t/openstack/build/0dd25602d89b45d585e2d62dd6973a5b : SUCCESS in 39m 41s\n- swift-dsvm-functional-ipv6 https://zuul.opendev.org/t/openstack/build/4f1c858ab30b4319b7f955ae764ac4c0 : SUCCESS in 28m 47s\n- swift-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/2989179f336448abbe1a80346009d9bc : FAILURE in 18m 36s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4fe0d2dc0bb64977b41494109489bdb6 : SUCCESS in 6m 19s\n- swift-multinode-rolling-upgrade https://zuul.opendev.org/t/openstack/build/86297465a80848bc9f97e60a30850b60 : TIMED_OUT in 1h 31m 32s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/81dc8801e9024f39bf0e919a5a74584e : SUCCESS in 52m 27s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"10bdb46be4a664ad8c9719715ea6036441ea563a","revisions":{"39f7f5ba281f8c0cc4bec855c14da23760314f62":{"kind":"REWORK","_number":1,"created":"2021-05-12 15:51:17.000000000","uploader":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"ref":"refs/changes/15/791015/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/swift","ref":"refs/changes/15/791015/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/swift refs/changes/15/791015/1"}}},"commit":{"parents":[{"commit":"443677f104c0181490cc1ff04f95efbed0a6a0de","subject":"Merge \"object: Plumb logger_thread_locals through _finalize_put\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/443677f104c0181490cc1ff04f95efbed0a6a0de"}]}],"author":{"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","date":"2021-05-12 15:50:44.000000000","tz":-300},"committer":{"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","date":"2021-05-12 15:50:56.000000000","tz":-300},"subject":"Optimize get_own_shard_range","message":"Optimize get_own_shard_range\n\nRelated-Change-Id: I3f5bb0f3e19eb9af25557efb90470f2cdd1299d4\nChange-Id: I17d1907432d00662dca07f457c038cee8a204c02\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/39f7f5ba281f8c0cc4bec855c14da23760314f62"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/39f7f5ba281f8c0cc4bec855c14da23760314f62"}]},"branch":"refs/heads/master"},"10bdb46be4a664ad8c9719715ea6036441ea563a":{"kind":"REWORK","_number":2,"created":"2021-05-12 19:15:28.000000000","uploader":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"},"ref":"refs/changes/15/791015/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/swift","ref":"refs/changes/15/791015/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/swift refs/changes/15/791015/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/swift refs/changes/15/791015/2"}}},"commit":{"parents":[{"commit":"443677f104c0181490cc1ff04f95efbed0a6a0de","subject":"Merge \"object: Plumb logger_thread_locals through _finalize_put\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/443677f104c0181490cc1ff04f95efbed0a6a0de"}]}],"author":{"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","date":"2021-05-12 15:50:44.000000000","tz":-300},"committer":{"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","date":"2021-05-12 19:13:52.000000000","tz":-300},"subject":"Optimize get_own_shard_range","message":"Optimize get_own_shard_range\n\nread values from shard_range table and container_stat table with one\nquery, and fill in any info we can to cook up a ShardRange object.\n\nTODO: if we want this we can probably zero out filler rows object_count\nand bytes_used and then update container server tests\n\nRelated-Change-Id: I3f5bb0f3e19eb9af25557efb90470f2cdd1299d4\nChange-Id: I17d1907432d00662dca07f457c038cee8a204c02\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/10bdb46be4a664ad8c9719715ea6036441ea563a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/swift/commit/10bdb46be4a664ad8c9719715ea6036441ea563a"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"OK","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY"},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":1179,"name":"Clay Gerrard","email":"clay.gerrard@gmail.com","username":"clay-gerrard"}}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{"label:Code-Review\u003dMAX":"","label:Code-Review\u003dMIN":""}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":["label:Workflow\u003dMIN"],"failing_atoms":["label:Workflow\u003dMAX"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}