)]}'
{"id":"openstack%2Foctavia~798257","triplet_id":"openstack%2Foctavia~stable%2Fussuri~I55136f570db33cfd22e919019c18e9028a6a9bf7","project":"openstack/octavia","branch":"stable/ussuri","hashtags":[],"change_id":"I55136f570db33cfd22e919019c18e9028a6a9bf7","subject":"Fix race conditions between API and worker DB calls","status":"MERGED","created":"2021-06-28 07:16:10.000000000","updated":"2021-08-18 15:58:21.000000000","submitted":"2021-08-18 15:56:51.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":"798257","meta_rev_id":"e98c472b4d0ab72fe9199f5782bb58238a39c187","_number":798257,"virtual_id_number":798257,"owner":{"_account_id":6469,"name":"Carlos Gonçalves","display_name":"Carlos Goncalves","email":"cgoncalves@redhat.com","username":"cgoncalves"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:gate","value":2,"date":"2021-08-18 15:56:51.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},{"value":0,"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}],"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":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2021-08-11 09:52:12.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},{"value":2,"date":"2021-08-18 14:15:06.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}],"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":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},{"value":1,"date":"2021-08-18 14:15:06.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},{"value":0,"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}],"values":{"-2":"Do Not Backport","-1":"Not A Backport Candidate"," 0":"Backport Review Needed","+1":"Proposed Backport","+2":"Should Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-06-28 07:16:10.000000000","updated_by":{"_account_id":6469,"name":"Carlos Gonçalves","display_name":"Carlos Goncalves","email":"cgoncalves@redhat.com","username":"cgoncalves"},"reviewer":{"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},"state":"REVIEWER"},{"updated":"2021-06-28 09:14:22.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"},{"updated":"2021-08-18 14:15:06.000000000","updated_by":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},"reviewer":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},"state":"REVIEWER"}],"messages":[{"id":"42bdee71cec57c5839fd86033bc7238b538f0249","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":6469,"name":"Carlos Gonçalves","display_name":"Carlos Goncalves","email":"cgoncalves@redhat.com","username":"cgoncalves"},"date":"2021-06-28 07:16:10.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"64e20b986f777cc36f0c94789b8c0418a5e1b844","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-28 09:14:22.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-cover https://zuul.opendev.org/t/openstack/build/8a0d0f09e7834b88b3a0c233752ca23c : FAILURE in 7m 51s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2bf1eb1b5eef49ac9eb76c7aa4438263 : SUCCESS in 8m 17s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/43697be4c4a84561a90dba61395f5690 : FAILURE in 7m 03s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/fb9fc0c66dc3406d95cf1f134429a82c : FAILURE in 7m 47s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/f26c505dd41b4898a738c87e06f25a2b : SUCCESS in 12m 36s\n- octavia-tox-py37-tips https://zuul.opendev.org/t/openstack/build/48151074da2840319dc2ff877f31d465 : FAILURE in 8m 32s\n- octavia-tox-functional-py37-tips https://zuul.opendev.org/t/openstack/build/89bf0e29b95b4168b4a7d10a4f284c16 : SUCCESS in 9m 28s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/d6ef97e560ba4185983c9063ec8d3df5 : SUCCESS in 8m 54s\n- octavia-v2-dsvm-noop-api https://zuul.opendev.org/t/openstack/build/1dddb5f1fadc42d893cdb3072d095141 : SUCCESS in 1h 12m 52s\n- octavia-v2-dsvm-scenario https://zuul.opendev.org/t/openstack/build/33c3042412c841d5836e34a40bb3e2f2 : SUCCESS in 1h 54m 30s\n- octavia-v2-dsvm-tls-barbican https://zuul.opendev.org/t/openstack/build/e18cc599916f462997fd42089d587f50 : SUCCESS in 43m 44s\n- octavia-v2-dsvm-spare-pool https://zuul.opendev.org/t/openstack/build/ac58f530be8840f08bdc9976387eb837 : SUCCESS in 37m 47s\n- octavia-v2-act-stdby-dsvm-scenario https://zuul.opendev.org/t/openstack/build/7cfb8cba5c5e4970b6ce7dfee75c922d : SUCCESS in 36m 05s\n- octavia-grenade https://zuul.opendev.org/t/openstack/build/4f1c759ab2e44322898df449f6d21ebc : SUCCESS in 51m 11s\n- octavia-v2-dsvm-cinder-amphora https://zuul.opendev.org/t/openstack/build/733f375c259745dbbedd089e23ab3b03 : SUCCESS in 1h 38m 15s (non-voting)\n- octavia-v2-dsvm-scenario-two-node https://zuul.opendev.org/t/openstack/build/b8d1d099e3b043c4b971cff09705e8ee : RETRY_LIMIT in 7m 39s (non-voting)\n- octavia-v2-dsvm-scenario-amphora-v2 https://zuul.opendev.org/t/openstack/build/caddf8815d7c481dbfd0ae466515dd63 : FAILURE in 1h 21m 08s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"177c9952ded957e52304f9638f5957c679528dd0","author":{"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},"date":"2021-06-29 09:40:04.000000000","message":"Patch Set 1:\n\nhttps://review.opendev.org/c/openstack/octavia/+/798577 needs to be merged first","accounts_in_message":[],"_revision_number":1},{"id":"1479803cc0c469974ca79197e939530dee355d45","author":{"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},"date":"2021-07-23 19:07:55.000000000","message":"Patch Set 1:\n\nrecheck","accounts_in_message":[],"_revision_number":1},{"id":"2f549e2ec0b7b098f63734e3c0480e6b0c5e5abb","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":11628,"name":"Michael Johnson","email":"johnsomor@gmail.com","username":"johnsom"},"date":"2021-07-23 20:08:49.000000000","message":"Patch Set 2: Patch Set 1 was rebased","accounts_in_message":[],"_revision_number":2},{"id":"2d6013c4dee6bc77a150d7c7994c47831178c777","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-23 21:57:35.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-cover https://zuul.opendev.org/t/openstack/build/f844b25640e34f3a8025166b0f498540 : SUCCESS in 10m 35s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/83c884de116d4d1da4ce4fb9d2b91a2a : SUCCESS in 6m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/c9ae0332ba2b4a86b6454c78ced45d25 : SUCCESS in 5m 34s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/7c163b7f50fa44b08362fb84dd0529d4 : SUCCESS in 6m 25s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/bca29c85883e403ab6088651d64d2c79 : SUCCESS in 12m 26s\n- octavia-tox-py37-tips https://zuul.opendev.org/t/openstack/build/ee19f203f999439b814680c250cb6325 : SUCCESS in 6m 29s\n- octavia-tox-functional-py37-tips https://zuul.opendev.org/t/openstack/build/ec0e985fe76d409db884ec7ce2314400 : SUCCESS in 8m 07s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/130950e35cbc455ca840b78550d12b74 : SUCCESS in 7m 56s\n- octavia-v2-dsvm-noop-api https://zuul.opendev.org/t/openstack/build/78ffdafaaa3c46da8b02612586f5d5e4 : SUCCESS in 1h 01m 42s\n- octavia-v2-dsvm-scenario https://zuul.opendev.org/t/openstack/build/078e40fafa924d8cbf94eb40b9002fee : FAILURE in 1h 47m 03s\n- octavia-v2-dsvm-tls-barbican https://zuul.opendev.org/t/openstack/build/d8025ab63b5242c3939eeeaae360c5b9 : SUCCESS in 33m 24s\n- octavia-v2-dsvm-spare-pool https://zuul.opendev.org/t/openstack/build/5add5e1dbace48e9a2e649b96a82d90f : SUCCESS in 38m 21s\n- octavia-v2-act-stdby-dsvm-scenario https://zuul.opendev.org/t/openstack/build/ac48f9de7269482286a9e63e78954d86 : SUCCESS in 44m 25s\n- octavia-grenade https://zuul.opendev.org/t/openstack/build/573a43e7187f42dea23f82126f078039 : SUCCESS in 1h 04m 16s\n- octavia-v2-dsvm-cinder-amphora https://zuul.opendev.org/t/openstack/build/c9214d3ae2964b499310aa17d30508e8 : SUCCESS in 1h 25m 28s (non-voting)\n- octavia-v2-dsvm-scenario-two-node https://zuul.opendev.org/t/openstack/build/73117cb509e8425d8723ec33a7431439 : RETRY_LIMIT in 7m 56s (non-voting)\n- octavia-v2-dsvm-scenario-amphora-v2 https://zuul.opendev.org/t/openstack/build/07b8590b5a724b3d804a42b8c11c65f3 : SUCCESS in 1h 28m 03s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"e8fb445ee590d403c096b97485f6f25aad878c03","author":{"_account_id":6469,"name":"Carlos Gonçalves","display_name":"Carlos Goncalves","email":"cgoncalves@redhat.com","username":"cgoncalves"},"date":"2021-08-10 08:44:40.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"f72b32bf5c4e57585ff57a89aa77dbd0364ac8d5","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-08-10 10:52:01.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/5432b211cf854045a70936e70982d5a2 : SUCCESS in 10m 59s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ea63d6cb3ae54df78e192c271e8eee37 : SUCCESS in 7m 11s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f000919eab8d41098dd54345c27fda0b : SUCCESS in 6m 15s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/f9ae57440c1e43e3ae064e52ea8d813a : SUCCESS in 6m 02s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/3a5afda93fdb497e9ddd885a610c5eb6 : SUCCESS in 12m 37s\n- octavia-tox-py37-tips https://zuul.opendev.org/t/openstack/build/bb3782aec588491bbf65e33dd1854ba7 : SUCCESS in 6m 52s\n- octavia-tox-functional-py37-tips https://zuul.opendev.org/t/openstack/build/60e41a5f91ce46288e22e67d194600a5 : SUCCESS in 8m 32s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/a8ad8b9057cd40cf903e1e15032b61fd : SUCCESS in 8m 08s\n- octavia-v2-dsvm-noop-api https://zuul.opendev.org/t/openstack/build/ccca954026f4466b8b661309217f9cd4 : SUCCESS in 1h 24m 08s\n- octavia-v2-dsvm-scenario https://zuul.opendev.org/t/openstack/build/519649e85eed48c8a1b28df4da3a74bd : SUCCESS in 1h 46m 37s\n- octavia-v2-dsvm-tls-barbican https://zuul.opendev.org/t/openstack/build/f888305fcc9543609bdf57baaa186bdb : SUCCESS in 43m 46s\n- octavia-v2-dsvm-spare-pool https://zuul.opendev.org/t/openstack/build/89c6acc863124b63a881eb7ae78e976e : SUCCESS in 32m 11s\n- octavia-v2-act-stdby-dsvm-scenario https://zuul.opendev.org/t/openstack/build/baac2039443642ccb052d602b0d233a7 : SUCCESS in 32m 59s\n- octavia-grenade https://zuul.opendev.org/t/openstack/build/350d91a4f4a445d5b51bed8ff381831e : SUCCESS in 1h 10m 07s\n- octavia-v2-dsvm-cinder-amphora https://zuul.opendev.org/t/openstack/build/268bd5ebec244cef80b25b7694615816 : SUCCESS in 1h 58m 05s (non-voting)\n- octavia-v2-dsvm-scenario-two-node https://zuul.opendev.org/t/openstack/build/a448f1f01cf448b58eb716f6e5c8af24 : RETRY_LIMIT in 6m 24s (non-voting)\n- octavia-v2-dsvm-scenario-amphora-v2 https://zuul.opendev.org/t/openstack/build/2d4584a524704a3f884d4d118c5b9010 : SUCCESS in 2h 05m 40s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"81c580a469e335b4806733047d4a37c575519a26","author":{"_account_id":29244,"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","username":"gthiemonge"},"date":"2021-08-11 09:52:12.000000000","message":"Patch Set 2: Code-Review+2","accounts_in_message":[],"_revision_number":2},{"id":"d1876314fa6b97c10ff2bc738a532bf77d7337c2","author":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},"date":"2021-08-18 14:15:06.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"a58acff246ea6392529be19ce1454891f220894d","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-08-18 14:15:43.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"0a1a8b6ec1bf17f559aaed6621ef5d84ed0045aa","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-08-18 15:56:51.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/b4f8423264394d5e845957399c2a1a98 : SUCCESS in 7m 21s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/8089d9f13650452aaf15fa0b7bf074aa : SUCCESS in 6m 49s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/2efc0f4a6a1340b988fa15a1ac091935 : SUCCESS in 7m 46s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5f545c6b49934cbab6915e19de68e1ce : SUCCESS in 13m 30s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/1dd9b9c3695d4ab0b4b399748540053b : SUCCESS in 8m 39s\n- octavia-v2-dsvm-noop-api https://zuul.opendev.org/t/openstack/build/2c8f572a33f74ed48570f491f92793d5 : SUCCESS in 1h 05m 10s\n- octavia-v2-dsvm-scenario https://zuul.opendev.org/t/openstack/build/88d97f461c3b46fd83ff83fa45b49d58 : SUCCESS in 1h 24m 45s\n- octavia-v2-dsvm-tls-barbican https://zuul.opendev.org/t/openstack/build/85c26cadb7c24f899eb7e2668916b758 : SUCCESS in 35m 47s\n- octavia-v2-dsvm-spare-pool https://zuul.opendev.org/t/openstack/build/6180c921d2da48c1acb90c4e1d56c4cc : SUCCESS in 36m 23s\n- octavia-v2-act-stdby-dsvm-scenario https://zuul.opendev.org/t/openstack/build/ff6c7ab1395b4184b811c16f46682309 : SUCCESS in 38m 03s\n- octavia-grenade https://zuul.opendev.org/t/openstack/build/926759d79c714efc9b862abf6d1a83d7 : SUCCESS in 53m 39s","accounts_in_message":[],"_revision_number":2},{"id":"8f9d37b91decef5395074e3ee79b3e360008b2af","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-08-18 15:56:51.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2},{"id":"e98c472b4d0ab72fe9199f5782bb58238a39c187","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-08-18 15:58:21.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c62302c3c0284fc0aaf98b059d794434 : SUCCESS in 1m 09s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"d79c80c39c6953768c267abdba0c38a7374d6e2b","revisions":{"7ac4fd076dcb534747d897d198ea91f16c08c8e5":{"kind":"REWORK","_number":1,"created":"2021-06-28 07:16:10.000000000","uploader":{"_account_id":6469,"name":"Carlos Gonçalves","display_name":"Carlos Goncalves","email":"cgoncalves@redhat.com","username":"cgoncalves"},"ref":"refs/changes/57/798257/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/octavia","ref":"refs/changes/57/798257/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/octavia refs/changes/57/798257/1"}}},"commit":{"parents":[{"commit":"c0af684fd701706a9fcf80a64991f070132591b7","subject":"Merge \"Fix empty Batch Member Update to unlock objects\" into stable/ussuri","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/c0af684fd701706a9fcf80a64991f070132591b7"}]}],"author":{"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","date":"2021-05-03 14:09:25.000000000","tz":120},"committer":{"name":"Carlos Goncalves","email":"cgoncalves@redhat.com","date":"2021-06-28 07:15:59.000000000","tz":120},"subject":"Fix race conditions between API and worker DB calls","message":"Fix race conditions between API and worker DB calls\n\nThe Octavia API creates new resource in the DB and passes the resource\nand its ID to the worker. The worker then accesses to the resource using\nthe database, but it might try to fetch the element before it\u0027s\ncommited by the API.\nThis commit ensures that the resource has been commited to the DB before\nprocessing the request.\n\nStory 2008878\nTask 42423\n\nChange-Id: I55136f570db33cfd22e919019c18e9028a6a9bf7\n(cherry picked from commit cd272ae5a948c22e26b0ea678ea452f559e14d62)\n(cherry picked from commit bd01b2b0b86444bc1fa4501d90c7285ec3368c21)\n(cherry picked from commit 732e0ad6cbeb1b8bc41110e67caf5c7c10cdf956)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/7ac4fd076dcb534747d897d198ea91f16c08c8e5"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/7ac4fd076dcb534747d897d198ea91f16c08c8e5"}]},"branch":"refs/heads/stable/ussuri"},"d79c80c39c6953768c267abdba0c38a7374d6e2b":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2021-07-23 20:08:49.000000000","uploader":{"_account_id":11628,"name":"Michael Johnson","email":"johnsomor@gmail.com","username":"johnsom"},"ref":"refs/changes/57/798257/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/octavia","ref":"refs/changes/57/798257/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/octavia refs/changes/57/798257/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/octavia refs/changes/57/798257/2"}}},"commit":{"parents":[{"commit":"e94e6a39fa27688fed7e0d228c2adeac7547a6b1","subject":"Merge \"Add amphora_id in store params for failover_amphora\" into stable/ussuri","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/e94e6a39fa27688fed7e0d228c2adeac7547a6b1"}]}],"author":{"name":"Gregory Thiemonge","email":"gthiemon@redhat.com","date":"2021-05-03 14:09:25.000000000","tz":120},"committer":{"name":"Michael Johnson","email":"johnsomor@gmail.com","date":"2021-07-23 20:08:49.000000000","tz":0},"subject":"Fix race conditions between API and worker DB calls","message":"Fix race conditions between API and worker DB calls\n\nThe Octavia API creates new resource in the DB and passes the resource\nand its ID to the worker. The worker then accesses to the resource using\nthe database, but it might try to fetch the element before it\u0027s\ncommited by the API.\nThis commit ensures that the resource has been commited to the DB before\nprocessing the request.\n\nStory 2008878\nTask 42423\n\nChange-Id: I55136f570db33cfd22e919019c18e9028a6a9bf7\n(cherry picked from commit cd272ae5a948c22e26b0ea678ea452f559e14d62)\n(cherry picked from commit bd01b2b0b86444bc1fa4501d90c7285ec3368c21)\n(cherry picked from commit 732e0ad6cbeb1b8bc41110e67caf5c7c10cdf956)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/d79c80c39c6953768c267abdba0c38a7374d6e2b"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/d79c80c39c6953768c267abdba0c38a7374d6e2b"}]},"branch":"refs/heads/stable/ussuri","description":"Rebase"}},"requirements":[],"submit_records":[{"status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"}},{"label":"Backport-Candidate","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Workflow\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}}]}