)]}'
{"id":"openstack%2Fnova~967977","triplet_id":"openstack%2Fnova~master~I30c9bc43f4b7ff9205f6a9fa6cb947b669a2fbba","project":"openstack/nova","branch":"master","topic":"server-group-list-optimize-pagination","hashtags":[],"change_id":"I30c9bc43f4b7ff9205f6a9fa6cb947b669a2fbba","subject":"Enhance performance of get instance groups from DB","status":"NEW","created":"2025-11-21 11:29:01.000000000","updated":"2025-11-21 20:56:28.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":true,"submittable":false,"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"a2ba99cfe5828a41f5bb2e6ebc5c1534b9c0a55f","_number":967977,"virtual_id_number":967977,"owner":{"_account_id":26250,"name":"Johannes Kulik","email":"johannes.kulik@sap.com","username":"jkulik"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2025-11-21 13:44:53.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":-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":{"all":[{"_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,"permitted_voting_range":{"min":0,"max":1},"_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":{"CC":[{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"_account_id":36571,"name":"vmwareapi CI run by SAP","display_name":"vmwareapi CI run by SAP","email":"openstack-ci@sap.com","username":"sap-openstack-ci","status":"CI account for integration tests of the Nova vmwareapi driver","tags":["SERVICE_USER"]},{"_account_id":38551,"name":"Bashar Alkhateeb","display_name":"Bashar Alkhateeb","email":"b.alkhateeb@sap.com","username":"b-alkhateeb"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2025-11-21 11:29:01.000000000","updated_by":{"_account_id":26250,"name":"Johannes Kulik","email":"johannes.kulik@sap.com","username":"jkulik"},"reviewer":{"_account_id":38551,"name":"Bashar Alkhateeb","display_name":"Bashar Alkhateeb","email":"b.alkhateeb@sap.com","username":"b-alkhateeb"},"state":"CC"},{"updated":"2025-11-21 13:44:53.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":"2025-11-21 14:05:18.000000000","updated_by":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2025-11-21 20:56:28.000000000","updated_by":{"_account_id":36571,"name":"vmwareapi CI run by SAP","display_name":"vmwareapi CI run by SAP","email":"openstack-ci@sap.com","username":"sap-openstack-ci","status":"CI account for integration tests of the Nova vmwareapi driver","tags":["SERVICE_USER"]},"reviewer":{"_account_id":36571,"name":"vmwareapi CI run by SAP","display_name":"vmwareapi CI run by SAP","email":"openstack-ci@sap.com","username":"sap-openstack-ci","status":"CI account for integration tests of the Nova vmwareapi driver","tags":["SERVICE_USER"]},"state":"CC"}],"messages":[{"id":"626138d630f75b03357327a777b46ef01b745f44","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":26250,"name":"Johannes Kulik","email":"johannes.kulik@sap.com","username":"jkulik"},"date":"2025-11-21 11:29:01.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"e813202e105796526886f43cb2bab20fefe2621b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2025-11-21 13:44:53.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/de7619478ad645cda145a98ddf4426f8\n\n- grenade-skip-level-always https://zuul.opendev.org/t/openstack/build/52e092217ade4c9f98ebe2e1cb903971 : SUCCESS in 53m 11s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/3d2df985d07e48f5a8994d69829442b7 : SUCCESS in 2h 08m 33s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/7fa11bb3498947768f5e500cec055196 : SUCCESS in 39m 37s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/878caaaa635047b793bd960d7f1d7f13 : SUCCESS in 24m 21s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1f3aa8e782324754ab968a2f7ae1d04c : SUCCESS in 10m 28s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/f4a2b3da33074c038a990c377b90fd91 : SUCCESS in 11m 37s\n- openstack-tox-py312 https://zuul.opendev.org/t/openstack/build/b6f066ee1ee74603a24bac99e5f2f462 : SUCCESS in 16m 38s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/a66db03549104ce988d31d1f3d08220c : SUCCESS in 11m 01s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/82a2133f1cde4dc88c4a0c0b52fe96c0 : SUCCESS in 6m 49s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/4d823049268445709fdc3173c73a78b1 : SUCCESS in 38m 22s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/61a334f0ebfd488dabccff757a40b0ae : SUCCESS in 1h 05m 47s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/27ca6052aae14d55ab3ebc98ad49c2f6 : SUCCESS in 1h 45m 24s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/27bec5b49b5349e0ad60909fd0d03738 : SUCCESS in 33m 50s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/58d1966edb0040778d8bafe835ae86d3 : SUCCESS in 51m 50s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/6f38043490a1440b9da49168b2ee81bc : SUCCESS in 1h 07m 12s\n- nova-next https://zuul.opendev.org/t/openstack/build/75c3f2be1bda48639127decc59284874 : SUCCESS in 1h 59m 34s\n- nova-alt-configurations https://zuul.opendev.org/t/openstack/build/f8f963fdc661446ea863cd9b17d700cb : SUCCESS in 49m 05s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/c9fb2d8d0d8546608c014d6338d4ee23 : SUCCESS in 3m 56s (non-voting)\n- nova-tox-functional-py310 https://zuul.opendev.org/t/openstack/build/99889f5de1d9413e932bb0c51da0d6ac : SUCCESS in 29m 19s\n- nova-tox-functional-py312 https://zuul.opendev.org/t/openstack/build/3b61c0926e06426fba21084d89341d59 : SUCCESS in 33m 42s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/7408e5aece8a47c9b54f86717e1651b7 : SUCCESS in 57m 42s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/97e685ad0bfe4144a0503187cb711613 : SUCCESS in 54m 51s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/facef057ff884cca883d88263a44dd2c : SUCCESS in 16m 29s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/3b60052cce224045b48071573388d1ba : SUCCESS in 18m 46s (non-voting)\n- nova-tox-py312-threading https://zuul.opendev.org/t/openstack/build/721aa31991b34aeeb62415c1a01edd38 : SUCCESS in 13m 57s","accounts_in_message":[],"_revision_number":1},{"id":"1c32677e092fc9ef333505eca2839541a4bd79cf","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2025-11-21 14:05:18.000000000","message":"Patch Set 1:\n\nBuild Failed \n\n* quobyteci:  nova_quobyteci : FAILURE, logs at: https://oscilogs.quobyte.com/logs/I30c9bc43f4b7ff9205f6a9fa6cb947b669a2fbba .","accounts_in_message":[],"_revision_number":1},{"id":"39759e62cc1b686e28cbdd62708d9ab124fccc1b","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2025-11-21 15:56:12.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/6921503da2504b12a5e9b4025bbc8b76\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/3e8fac6239d24d5aa9ffd6519caf6c6e : SUCCESS in 47m 44s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/446321fbc663438eb7ae21efc46ddf6b : SUCCESS in 48m 04s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/83c06a6d492546619fefc2d5af314594 : SUCCESS in 19m 44s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"a2ba99cfe5828a41f5bb2e6ebc5c1534b9c0a55f","tag":"autogenerated:sap-openstack-ci~result","author":{"_account_id":36571,"name":"vmwareapi CI run by SAP","display_name":"vmwareapi CI run by SAP","email":"openstack-ci@sap.com","username":"sap-openstack-ci","status":"CI account for integration tests of the Nova vmwareapi driver","tags":["SERVICE_USER"]},"date":"2025-11-21 20:56:28.000000000","message":"Patch Set 1:\n\nIgnore for now: Test failed. Logs on \u003chttp://openstack-ci-logs.global.cloud.sap/openstack-nova-967977-dhbrb/index.html\u003e","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"f566dca8e9b6668bc330503c6829f3cf2016a755","revisions":{"f566dca8e9b6668bc330503c6829f3cf2016a755":{"kind":"REWORK","_number":1,"created":"2025-11-21 11:29:01.000000000","uploader":{"_account_id":26250,"name":"Johannes Kulik","email":"johannes.kulik@sap.com","username":"jkulik"},"ref":"refs/changes/77/967977/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/77/967977/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/77/967977/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/77/967977/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/77/967977/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/77/967977/1"}}},"commit":{"parents":[{"commit":"c09e17582dee782d840974410c99016f02fca51c","subject":"Merge \"api: Add response body schemas for security group APIs\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/c09e17582dee782d840974410c99016f02fca51c"}]}],"author":{"name":"Bashar Alkhateeb","email":"b.alkhateeb@sap.com","date":"2023-01-23 10:50:36.000000000","tz":60},"committer":{"name":"Johannes Kulik","email":"johannes.kulik@sap.com","date":"2025-11-21 11:27:42.000000000","tz":60},"subject":"Enhance performance of get instance groups from DB","message":"Enhance performance of get instance groups from DB\n\nInstead of getting all instance groups from DB and afterwards limiting the\nresults with `common.limited`, we add `limit` and `offset` parameters to\n`_instance_group_get_query()` function to limit the database query itself.\n\nSQLAlchemy throws an exception when applying a filter to the query\nafter setting limits and offset that\u0027s why we add the `project_id`\nparameter to `_instance_group_get_query()`.\n\nChange-Id: I30c9bc43f4b7ff9205f6a9fa6cb947b669a2fbba\nSigned-off-by: Bashar Alkhateeb \u003cb.alkhateeb@sap.comm\u003e\nSigned-off-by: Johannes Kulik \u003cjohannes.kulik@sap.com\u003e\nCloses-Bug: #2122109\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/f566dca8e9b6668bc330503c6829f3cf2016a755"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/f566dca8e9b6668bc330503c6829f3cf2016a755"}]},"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"},{"label":"Review-Priority","status":"MAY"}]}],"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":"Review-Priority","description":"Review Priority","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"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":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}