)]}'
{"id":"openstack%2Fcloudkitty~894812","triplet_id":"openstack%2Fcloudkitty~master~I8282f44ad837c71df0cb6c73776eafc7014ebedf","project":"openstack/cloudkitty","branch":"master","topic":"batch-delete-for-reprocessing-task-upstream","attention_set":{},"removed_from_attention_set":{"28356":{"account":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"last_update":"2023-11-27 12:57:43.000000000","reason":"\u003cGERRIT_ACCOUNT_28356\u003e replied on the change","reason_account":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}},"15197":{"account":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"last_update":"2023-11-13 14:49:47.000000000","reason":"removed on reply"},"25277":{"account":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"last_update":"2023-11-13 14:48:23.000000000","reason":"\u003cGERRIT_ACCOUNT_25277\u003e replied on the change","reason_account":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"}}},"hashtags":[],"change_id":"I8282f44ad837c71df0cb6c73776eafc7014ebedf","subject":"Optimize CloudKitty reprocessing process","status":"MERGED","created":"2023-09-12 16:54:28.000000000","updated":"2023-11-27 13:50:15.000000000","submitted":"2023-11-27 13:48:26.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":5,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"894812-batch-delete-for-reprocessing-task-upstream","meta_rev_id":"2b56f850efa5e8d43fbcc62e83f8883bf6a89d32","_number":894812,"virtual_id_number":894812,"owner":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-11-27 13:48:26.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"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":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"all":[{"value":0,"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2023-11-13 14:48:23.000000000","_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":2,"date":"2023-11-13 14:49:47.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"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":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"all":[{"value":1,"date":"2023-11-27 12:57:43.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-09-12 17:47:43.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":"2023-10-02 14:45:15.000000000","updated_by":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"reviewer":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"state":"CC"},{"updated":"2023-10-02 14:47:07.000000000","updated_by":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"reviewer":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"state":"CC"},{"updated":"2023-11-13 14:48:23.000000000","updated_by":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"reviewer":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"state":"REVIEWER"},{"updated":"2023-11-13 14:49:47.000000000","updated_by":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"reviewer":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"state":"REVIEWER"}],"messages":[{"id":"43faf4f58331d16120d03bfb0ba4bcc3ae44bb94","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-09-12 16:54:28.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"6201e9857f83358744d1ed78d597c89169712cc3","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-09-12 17:01:15.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"642823c01dbbe62f85c4e37bce62c2dbb7b51d2f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-12 17:47:43.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f049525549dc4b20bda43c903080fe77\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/0c39ad2203eb4be2adc9ffea27615e46 : SUCCESS in 4m 20s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/84ea8bd9150a435b80cd2db08833f79f : SUCCESS in 3m 26s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bf959e486a5b49019a3a8084399febb5 : SUCCESS in 3m 59s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/5a85afe7c7d34a26b5c3618373565250 : SUCCESS in 4m 07s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/829282717baf4697b60b8403e1c1fde2 : SUCCESS in 4m 03s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/e3ac57ddca15410f921720d02ca90a31 : SUCCESS in 4m 48s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6a2586d5a94645f297fb7c37db439970 : SUCCESS in 4m 01s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/507e9401fa9649fc9bc753e4bec1b20e : SUCCESS in 3m 02s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/52b13878c19e4de2a2f6858a4358607e : SUCCESS in 38m 41s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/55140f9536fe40b98b7da78cb01fdeb2 : SUCCESS in 28m 39s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/ccfab1ed5cf841269c4feba17a20d3a9 : SUCCESS in 39m 07s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/df4c917f23ff4e8b9d03a8e33c33d6d0 : SUCCESS in 37m 41s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/30ee4c5ba3ff46e0ad0d72555888b469 : FAILURE in 3m 47s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"be9340e9d04063955b62095f46b1795e7d236e1e","author":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"date":"2023-10-02 14:45:15.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"ae1fdb2e67a3c41cae34db80831f7b74bf33a07a","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2023-10-02 14:47:07.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"7fa82ad9b3772a44d2cf16055985f65e14f5e5e8","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-10-02 14:47:40.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"d9a300b1715a36886119c7bb0eeb570398dafb80","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-10-02 14:47:45.000000000","message":"Uploaded patch set 3.\n\nOutdated Votes:\n* Verified+1\n","accounts_in_message":[],"_revision_number":3},{"id":"c35f9cd5f63556ef2f7a35e88bce3ff91813d1e1","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-10-02 14:50:49.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"3694266c427c18404ae3263c06e213eb9685fb5f","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-10-02 14:50:51.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"b0333269bb0e864e0da197c03bd5309a67bb1737","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-10-02 15:44:19.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/3f7be95957f44f0294713d564d69f9f4\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/6c210f6e027743afa5a4e472bf2d1fc8 : SUCCESS in 4m 39s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2ce605b2e4494aaaa9c53fa3edef4934 : SUCCESS in 3m 21s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ba308eb7ca464b298bc21647281ebfb8 : SUCCESS in 3m 47s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/7a32a72dbe6c4567b6a9ace6ef6df648 : SUCCESS in 5m 15s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/2c07647753dc4424aba7dd0afd63d9ab : SUCCESS in 4m 36s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/6db2b41795554ff3bbfca58566bcd93b : SUCCESS in 4m 52s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/93ccdf7a622e491d81bcaab9dc04c32b : SUCCESS in 4m 47s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/3772ce54a72c477ab2e037de01a3837a : SUCCESS in 2m 44s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/8b43eced1c5641d5847312b9d6482fe9 : SUCCESS in 41m 33s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/8ff16f80a18243d6a18878af83132b68 : SUCCESS in 38m 15s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/ec708ac60bb94a078cfc3c339cec2c45 : SUCCESS in 38m 44s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/46615d28b5d94e58b2eb1433c533afdc : SUCCESS in 44m 47s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/d353f739a91b44c8869fd80b9f60901a : FAILURE in 3m 13s (non-voting)","accounts_in_message":[],"_revision_number":4},{"id":"d282981a253fdfb70b8fc98a605afb63256c28c2","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2023-11-13 14:48:23.000000000","message":"Patch Set 4: Code-Review+2","accounts_in_message":[],"_revision_number":4},{"id":"d03f0e5ebfbd66db424fb04eca6ecbed62b58cce","author":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"date":"2023-11-13 14:49:47.000000000","message":"Patch Set 4: Code-Review+2","accounts_in_message":[],"_revision_number":4},{"id":"1d6f323a49aa9e9c61f75d3bf563f3c5290a54dd","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-11-27 12:57:43.000000000","message":"Patch Set 4: Workflow+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":4},{"id":"8907a711bcb128cea95a8f2efd8e15dfc5734bf2","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-27 12:58:14.000000000","message":"Patch Set 4: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":4},{"id":"abf7994cdd7e62019cd882f854ddc180c81567ef","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-27 13:48:26.000000000","message":"Patch Set 4: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/bb549df7a76b4f578eec9e410912177a\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e1a50542275046c49084e10f35806877 : SUCCESS in 3m 22s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bd91a83437b94847ac3e29f4a7a9c223 : SUCCESS in 3m 55s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/6138f8b76c5a41589ecd7561c3d99d35 : SUCCESS in 3m 55s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ae5b77c5b5254ceaae2464aa224befac : SUCCESS in 3m 37s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/32cce3a0b5b04aa196a82a078e85b88f : SUCCESS in 3m 12s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/8203339d92bf46608ff6405989bd81e6 : SUCCESS in 38m 54s\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/b19ce3860d2448598072276566ff5ef2 : SUCCESS in 23m 38s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/5c9a0ed7b5db45be963d514118e463b2 : SUCCESS in 27m 54s","accounts_in_message":[],"_revision_number":4},{"id":"d843cf5f27e3a9565db47086b85f275c58cff1ab","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-27 13:48:26.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":4},{"id":"2b56f850efa5e8d43fbcc62e83f8883bf6a89d32","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-27 13:50:15.000000000","message":"Patch Set 4:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/95d112e54b114f0185ff2d5ca95c57dc\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5c461c283ddc40328d9ee265ea47485c : SUCCESS in 36s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/2487c57db0644969bd9ff0bd23973126 : SUCCESS in 36s","accounts_in_message":[],"_revision_number":4}],"current_revision_number":4,"current_revision":"5c2f9e7f71b5d96c807f691556a5e6c5b754f492","revisions":{"24a7a56a6be17d2729a1794aad0a3cfe695e85d2":{"kind":"REWORK","_number":1,"created":"2023-09-12 16:54:28.000000000","uploader":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"ref":"refs/changes/12/894812/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/12/894812/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/1"}}},"commit":{"parents":[{"commit":"60077a3cc47eaa49e33930bfe4253bff784c6a63","subject":"Fix docs jobs in the CI that were broken due to Sphinx upgrade","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/60077a3cc47eaa49e33930bfe4253bff784c6a63"}]}],"author":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-07-12 22:27:04.000000000","tz":-180},"committer":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-09-12 16:52:02.000000000","tz":-180},"subject":"Optimize CloudKitty reprocessing process","message":"Optimize CloudKitty reprocessing process\n\nCurrently, when a reprocessing task is scheduled, CloudKitty executes\nthe cleaning of the data for the reprocessing period in one hour\nfashion (the default period). Therefore, for each one of the\ntimeframes, a delete query is sent to InfluxDB (when using it as a\nbackend). However, InfluxDB is not a very optimized time series database\nfor deletion; thus, this workflow generates quite some overhead and\nslowness when reprocessing. If we clean right away the whole time\nframe for the reprocessing task, and then we just reprocess it, it will\nexecute a single delete query in InfluxDB, which has a similar cost as\na delete to remove the data for a single time frame.\n\nThis patch optimized the reprocessing workflow to execute batch cleaning\nof data in the storage backend of CloudKitty.\n\nChange-Id: I8282f44ad837c71df0cb6c73776eafc7014ebedf\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/24a7a56a6be17d2729a1794aad0a3cfe695e85d2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/24a7a56a6be17d2729a1794aad0a3cfe695e85d2"}]},"branch":"refs/heads/master"},"d9d6c94b4ba284df638eb5cceb3c21ab1df5863d":{"kind":"REWORK","_number":2,"created":"2023-09-12 17:01:15.000000000","uploader":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"ref":"refs/changes/12/894812/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/12/894812/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/2"}}},"commit":{"parents":[{"commit":"60077a3cc47eaa49e33930bfe4253bff784c6a63","subject":"Fix docs jobs in the CI that were broken due to Sphinx upgrade","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/60077a3cc47eaa49e33930bfe4253bff784c6a63"}]}],"author":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-07-12 22:27:04.000000000","tz":-180},"committer":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-09-12 17:01:04.000000000","tz":-180},"subject":"Optimize CloudKitty reprocessing process","message":"Optimize CloudKitty reprocessing process\n\nCurrently, when a reprocessing task is scheduled, CloudKitty executes\nthe cleaning of the data for the reprocessing period in one hour\nfashion (the default period). Therefore, for each one of the\ntimeframes, a delete query is sent to InfluxDB (when using it as a\nbackend). However, InfluxDB is not a very optimized time series database\nfor deletion; thus, this workflow generates quite some overhead and\nslowness when reprocessing. If we clean right away the whole time\nframe for the reprocessing task, and then we just reprocess it, it will\nexecute a single delete query in InfluxDB, which has a similar cost as\na delete to remove the data for a single time frame.\n\nThis patch optimized the reprocessing workflow to execute batch cleaning\nof data in the storage backend of CloudKitty.\n\nChange-Id: I8282f44ad837c71df0cb6c73776eafc7014ebedf\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/d9d6c94b4ba284df638eb5cceb3c21ab1df5863d"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/d9d6c94b4ba284df638eb5cceb3c21ab1df5863d"}]},"branch":"refs/heads/master"},"d0501c35b81b4c5ce1a24fc8c5b24aca9e73feab":{"kind":"REWORK","_number":3,"created":"2023-10-02 14:47:45.000000000","uploader":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"ref":"refs/changes/12/894812/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/12/894812/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/3"}}},"commit":{"parents":[{"commit":"60077a3cc47eaa49e33930bfe4253bff784c6a63","subject":"Fix docs jobs in the CI that were broken due to Sphinx upgrade","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/60077a3cc47eaa49e33930bfe4253bff784c6a63"}]}],"author":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-07-12 22:27:04.000000000","tz":-180},"committer":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-10-02 14:47:33.000000000","tz":-180},"subject":"Optimize CloudKitty reprocessing process","message":"Optimize CloudKitty reprocessing process\n\nCurrently, when a reprocessing task is scheduled, CloudKitty executes\nthe cleaning of the data for the reprocessing period in one hour\nfashion (the default period). Therefore, for each one of the\ntimeframes, a delete query is sent to InfluxDB (when using it as a\nbackend). However, InfluxDB is not a very optimized time series database\nfor deletion; thus, this workflow generates quite some overhead and\nslowness when reprocessing. If we clean right away the whole time\nframe for the reprocessing task, and then we just reprocess it, it will\nexecute a single delete query in InfluxDB, which has a similar cost as\na delete to remove the data for a single time frame.\n\nThis patch optimized the reprocessing workflow to execute batch cleaning\nof data in the storage backend of CloudKitty.\n\nChange-Id: I8282f44ad837c71df0cb6c73776eafc7014ebedf\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/d0501c35b81b4c5ce1a24fc8c5b24aca9e73feab"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/d0501c35b81b4c5ce1a24fc8c5b24aca9e73feab"}]},"branch":"refs/heads/master"},"5c2f9e7f71b5d96c807f691556a5e6c5b754f492":{"kind":"REWORK","_number":4,"created":"2023-10-02 14:50:51.000000000","uploader":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"ref":"refs/changes/12/894812/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/12/894812/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/12/894812/4"}}},"commit":{"parents":[{"commit":"60077a3cc47eaa49e33930bfe4253bff784c6a63","subject":"Fix docs jobs in the CI that were broken due to Sphinx upgrade","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/60077a3cc47eaa49e33930bfe4253bff784c6a63"}]}],"author":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-07-12 22:27:04.000000000","tz":-180},"committer":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-10-02 14:50:37.000000000","tz":-180},"subject":"Optimize CloudKitty reprocessing process","message":"Optimize CloudKitty reprocessing process\n\nCurrently, when a reprocessing task is scheduled, CloudKitty executes\nthe cleaning of the data for the reprocessing period in one hour\nfashion (the default period). Therefore, for each one of the\ntimeframes, a delete query is sent to InfluxDB (when using it as a\nbackend). However, InfluxDB is not a very optimized time series database\nfor deletion; thus, this workflow generates quite some overhead and\nslowness when reprocessing. If we clean right away the whole time\nframe for the reprocessing task, and then we just reprocess it, it will\nexecute a single delete query in InfluxDB, which has a similar cost as\na delete to remove the data for a single time frame.\n\nThis patch optimized the reprocessing workflow to execute batch cleaning\nof data in the storage backend of CloudKitty.\n\nChange-Id: I8282f44ad837c71df0cb6c73776eafc7014ebedf\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5c2f9e7f71b5d96c807f691556a5e6c5b754f492"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5c2f9e7f71b5d96c807f691556a5e6c5b754f492"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review priority","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"-label:Review-Priority\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":[],"failing_atoms":["label:Review-Priority\u003dMIN"],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{}}}]}