)]}'
{"id":"openstack%2Fnova~666782","triplet_id":"openstack%2Fnova~stable%2Fqueens~I9bec28c73522aa050b0b86dc30e466778d63009b","project":"openstack/nova","branch":"stable/queens","hashtags":[],"change_id":"I9bec28c73522aa050b0b86dc30e466778d63009b","subject":"Suppot paginaton for server groups by sql","status":"ABANDONED","created":"2019-06-21 07:48:33.000000000","updated":"2019-06-25 03:41:36.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"dc4e27875703f55609a0035692524dd975fb59a4","_number":666782,"virtual_id_number":666782,"owner":{"_account_id":30597,"name":"huichen","email":"chen.hui@99cloud.net","username":"charles"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"date":"2019-06-21 09:06:49.000000000","_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},{"date":"2019-06-21 13:16:58.000000000","_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"date":"2019-06-21 08:31:09.000000000","_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"date":"2019-06-21 07:48:46.000000000","_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},{"value":0,"date":"2019-06-21 09:01:44.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":-1,"date":"2019-06-21 09:47:57.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"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":{"disliked":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":-1,"date":"2019-06-21 08:02:23.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"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":"","value":-1,"default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"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":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-06-21 07:48:46.000000000","updated_by":{"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},"reviewer":{"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},"state":"REVIEWER"},{"updated":"2019-06-21 08:02:23.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"},{"updated":"2019-06-21 08:31:09.000000000","updated_by":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"reviewer":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"state":"REVIEWER"},{"updated":"2019-06-21 09:01:44.000000000","updated_by":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2019-06-21 09:06:49.000000000","updated_by":{"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2019-06-21 09:47:57.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":"2019-06-21 13:16:58.000000000","updated_by":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"eb06a8a168c07514b7f77c1eeb55d19216f31c7b","author":{"_account_id":30597,"name":"huichen","email":"chen.hui@99cloud.net","username":"charles"},"date":"2019-06-21 07:48:33.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"f45763ede193b799b1210508a73c7bbfc7ac2448","author":{"_account_id":10068,"name":"Welcome, new contributor!","username":"welcome-message"},"date":"2019-06-21 07:48:46.000000000","message":"Patch Set 1:\n\nThank you for your first contribution to OpenStack.\n\nYour patch will now be tested automatically by OpenStack testing frameworks\nand once the automatic tests pass, it will be reviewed by other friendly\ndevelopers. They will give you feedback and may require you to refine it.\n\nPeople seldom get their patch approved on the first try, so don\u0027t be\nconcerned if requested to make corrections. Feel free to modify your patch\nand resubmit a new change-set.\n\nPatches usually take 3 to 7 days to be reviewed so be patient and be\navailable on IRC to ask and answer questions about your work. Also it\ntakes generally at least a couple of weeks for cores to get around to\nreviewing code. The more you participate in the community the more\nrewarding it is for you. You may also notice that the more you get to know\npeople and get to be known, the faster your patches will be reviewed and\neventually approved. Get to know others and become known by doing code\nreviews: anybody can do it, and it\u0027s a great way to learn the code base.\n\nThanks again for supporting OpenStack, we look forward to working with you.\n\nIRC: https://wiki.openstack.org/wiki/IRC\nWorkflow: https://docs.openstack.org/infra/manual/developers.html\nCommit Messages: https://wiki.openstack.org/wiki/GitCommitMessages","accounts_in_message":[],"_revision_number":1},{"id":"1390ee6a230d751987192a1972ffc9e541e25ac8","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2019-06-21 08:02:23.000000000","message":"Patch Set 1: Code-Review-1\n\n@huichen: Thanks for the patch. This feature seems like a bug fix or a performance improvement. Could you please file a bug in [1] and refer to that bug in the commit message? Also please propose such bugfix against the master branch first. And when the fix merged there you can propose backports from all the stable branches.\n\nCheers,\ngibi\n\n[1]https://bugs.launchpad.net/nova","accounts_in_message":[],"_revision_number":1},{"id":"9bff2c7fa6e74a029e28d8c5772adb8934c6513d","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2019-06-21 08:31:09.000000000","message":"Patch Set 1:\n\nFor rechecking only on the Cloudbase Nova Hyper-V CI, add a review comment with run-Cloudbase Nova Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/666782/1 : FAILURE in 41m 35s","accounts_in_message":[],"_revision_number":1},{"id":"c5fdb388396f3bc9b3875477c016ab3c3bf79d24","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2019-06-21 09:01:44.000000000","message":"Patch Set 1:\n\nBuild succeeded. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm: recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/82/666782/1/check/tempest-dsvm-full-xenial/ce03ec5/ : SUCCESS in 1h 07m 34s\n- tempest-dsvm-full-xenial-py3 https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/82/666782/1/check/tempest-dsvm-full-xenial-py3/4b5d476/ : FAILURE in 1h 12m 14s (non-voting)\n- grenade-dsvm-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/82/666782/1/check/grenade-dsvm-xenial/6fe0d2d/ : SUCCESS in 1h 02m 06s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"cde855fed3a260cd8c51e1d44817186ee559a8b0","author":{"_account_id":16128,"name":"IBM PowerVM CI","email":"powervmci@linux.vnet.ibm.com","username":"powervmci","tags":["SERVICE_USER"]},"date":"2019-06-21 09:06:49.000000000","message":"Patch Set 1:\n\nBuild failed. Comment \u0027powervm: recheck\u0027 to recheck.\n For 3rd party CI contact info: https://wiki.openstack.org/wiki/ThirdPartySystems/IBM_PowerVM_CI\n\n- nova-out-of-tree-pvm http://184.172.12.213/82/666782/1/check/nova-out-of-tree-pvm/c48b887 : FAILURE in 2m 37s\n- nova-in-tree-pvm http://184.172.12.213/82/666782/1/check/nova-in-tree-pvm/a604302 : FAILURE in 22m 21s","accounts_in_message":[],"_revision_number":1},{"id":"c50def14835672cbff95aaf5c470fe5d97a19838","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-21 09:47:57.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- openstack-tox-pep8 http://logs.openstack.org/82/666782/1/check/openstack-tox-pep8/a150415/ : SUCCESS in 8m 47s\n- openstack-tox-py27 http://logs.openstack.org/82/666782/1/check/openstack-tox-py27/d08e45e/ : SUCCESS in 16m 18s\n- openstack-tox-py35 http://logs.openstack.org/82/666782/1/check/openstack-tox-py35/85e5f61/ : FAILURE in 8m 39s\n- build-openstack-sphinx-docs http://logs.openstack.org/82/666782/1/check/build-openstack-sphinx-docs/4627106/html/ : SUCCESS in 10m 29s\n- tempest-full http://logs.openstack.org/82/666782/1/check/tempest-full/72de3b1/ : SUCCESS in 1h 16m 40s\n- neutron-grenade http://logs.openstack.org/82/666782/1/check/neutron-grenade/e0b4bec/ : SUCCESS in 57m 11s\n- tempest-full-py3 http://logs.openstack.org/82/666782/1/check/tempest-full-py3/832bb58/ : SUCCESS in 1h 15m 28s\n- ironic-tempest-dsvm-ipa-wholedisk-bios-agent_ipmitool-tinyipa http://logs.openstack.org/82/666782/1/check/ironic-tempest-dsvm-ipa-wholedisk-bios-agent_ipmitool-tinyipa/2135bf1/ : SUCCESS in 48m 48s (non-voting)\n- nova-cells-v1 http://logs.openstack.org/82/666782/1/check/nova-cells-v1/2acff5d/ : SUCCESS in 45m 50s\n- nova-grenade-live-migration http://logs.openstack.org/82/666782/1/check/nova-grenade-live-migration/94fe300/ : SUCCESS in 59m 36s (non-voting)\n- nova-live-migration http://logs.openstack.org/82/666782/1/check/nova-live-migration/6df3508/ : SUCCESS in 41m 58s\n- nova-multiattach http://logs.openstack.org/82/666782/1/check/nova-multiattach/55a953a/ : SUCCESS in 58m 10s\n- nova-next http://logs.openstack.org/82/666782/1/check/nova-next/850d3bc/ : SUCCESS in 1h 15m 32s\n- tempest-slow http://logs.openstack.org/82/666782/1/check/tempest-slow/df177d7/ : SUCCESS in 1h 53m 36s\n- nova-tox-functional http://logs.openstack.org/82/666782/1/check/nova-tox-functional/1e0e0c8/ : SUCCESS in 17m 55s\n- nova-tox-functional-py35 http://logs.openstack.org/82/666782/1/check/nova-tox-functional-py35/facadfe/ : SUCCESS in 27m 44s\n- neutron-grenade-multinode http://logs.openstack.org/82/666782/1/check/neutron-grenade-multinode/1777479/ : SUCCESS in 58m 30s\n- devstack-plugin-ceph-tempest http://logs.openstack.org/82/666782/1/check/devstack-plugin-ceph-tempest/afa6a60/ : SUCCESS in 1h 07m 18s (non-voting)\n- tempest-multinode-full http://logs.openstack.org/82/666782/1/check/tempest-multinode-full/7669ba3/ : SUCCESS in 1h 32m 08s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"d200923093d1d2df316ba9209ef2174c97a307ad","author":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"date":"2019-06-21 13:16:58.000000000","message":"Patch Set 1:\n\nTesting failed ubuntu-xenial-s390x. For rechecking only on the ubuntu-xenial-s390x CI, add a review comment with recheck-zkvm. Contact info: zkvm-ci@linux.vnet.ibm.com. For more information, see https://wiki.openstack.org/wiki/ThirdPartySystems/IBM_zKVM_CI\n\n- check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x http://sng01.objectstorage.softlayer.net/v1/AUTH_1940ea10-6e82-4501-b2f9-eb236510e575/ibmzkvmci/production/666782/1/check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x/67c8b16 : FAILURE in 1h 00m 12s","accounts_in_message":[],"_revision_number":1},{"id":"dc4e27875703f55609a0035692524dd975fb59a4","author":{"_account_id":30597,"name":"huichen","email":"chen.hui@99cloud.net","username":"charles"},"date":"2019-06-25 03:41:36.000000000","message":"Abandoned\n\nrepeat in master","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"f50ef3c374969db8e1498e080cffe4fb72677d8a","revisions":{"f50ef3c374969db8e1498e080cffe4fb72677d8a":{"kind":"REWORK","_number":1,"created":"2019-06-21 07:48:33.000000000","uploader":{"_account_id":30597,"name":"huichen","email":"chen.hui@99cloud.net","username":"charles"},"ref":"refs/changes/82/666782/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/82/666782/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/82/666782/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/82/666782/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/82/666782/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/82/666782/1"}}},"commit":{"parents":[{"commit":"58a140487c8127da727fa7e4fb56892f8c162536","subject":"Block swap volume on volumes with \u003e1 rw attachment","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/58a140487c8127da727fa7e4fb56892f8c162536"}]}],"author":{"name":"chenhui","email":"chen.hui@99cloud.net","date":"2019-06-19 10:17:51.000000000","tz":480},"committer":{"name":"chenhui","email":"chen.hui@99cloud.net","date":"2019-06-21 07:31:08.000000000","tz":480},"subject":"Suppot paginaton for server groups by sql","message":"Suppot paginaton for server groups by sql\n\nChange-Id: I9bec28c73522aa050b0b86dc30e466778d63009b\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/f50ef3c374969db8e1498e080cffe4fb72677d8a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/f50ef3c374969db8e1498e080cffe4fb72677d8a"}]},"branch":"refs/heads/stable/queens"}},"requirements":[],"submit_records":[],"submit_requirements":[]}