)]}'
{"id":"openstack%2Fnova~768364","triplet_id":"openstack%2Fnova~master~I58d82054b41095792f30a23a9e0cef0d9e38a350","project":"openstack/nova","branch":"master","topic":"bp/compact-db-migrations-wallaby","hashtags":[],"change_id":"I58d82054b41095792f30a23a9e0cef0d9e38a350","subject":"Add schema files to compare against after squashing","status":"ABANDONED","created":"2020-12-23 19:15:16.000000000","updated":"2021-01-07 13:32:32.000000000","total_comment_count":1,"unresolved_comment_count":1,"has_review_started":true,"meta_rev_id":"e285392d757a3969f7c5bfe8588ecc616cf46fbd","_number":768364,"virtual_id_number":768364,"owner":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2020-12-23 21:13:00.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":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-12-23 20:40:09.000000000","updated_by":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"reviewer":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2020-12-23 20:56:54.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":"CC"},{"updated":"2020-12-23 21:13:00.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":"2020-12-23 21:13:29.000000000","updated_by":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2020-12-23 21:48:52.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":"CC"},{"updated":"2020-12-24 09:49:46.000000000","updated_by":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"reviewer":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"state":"CC"}],"messages":[{"id":"e2650d423927cc2512f881b78cfd1f12d4eb1187","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2020-12-23 19:15:16.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"7776a24a339128c2c34d9323e52e68b6b2c039fc","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2020-12-23 20:40:09.000000000","message":"Patch Set 1:\n\nBuild succeeded\n\n- dsvm-nova http://207.189.188.190/logs/768364/768364/1/check-not-vote/ext-nova-zuul/034b92e : SUCCESS in 1h 23m 19s","accounts_in_message":[],"_revision_number":1},{"id":"a5281930972965b72b38195df7a23f2b2faa4d1e","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-12-23 20:56:54.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-focal-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/64/768364/1/check/tempest-dsvm-full-focal-py3/f9b202a/ : SUCCESS in 1h 35m 43s","accounts_in_message":[],"_revision_number":1},{"id":"ee6d43c84e0a53313aff5870bfde5ca713a2648d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-12-23 21:13:00.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/2b4286566b6c4dcd9f863d32d1245193 : SUCCESS in 1h 16m 45s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/48f1ae015d684268b6b99e4c4555d5a7 : SUCCESS in 1h 35m 22s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/40238d6cfc314ec38dd680a87204b23c : SUCCESS in 19m 03s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/881c30661ae9476cb60579cc54fdc9f9 : SUCCESS in 17m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/511d5e425d034f0490e6f632d194cc45 : SUCCESS in 9m 42s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/2ee3a11a3c8b4c2cad2574eefad3851a : SUCCESS in 15m 49s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9747879fb109407ea6c12808c93d88cc : SUCCESS in 16m 37s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/8749b6fb0b274941ad7f73da046be9cd : SUCCESS in 22m 42s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6061c23e1c304f7189e4286d424c7169 : SUCCESS in 15m 49s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/21bde2bb81b14dfe9a349cb7e36342ee : SUCCESS in 1h 25m 19s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/340ad7a7e1d34152a83898144671ece3 : SUCCESS in 1h 17m 17s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/913687f81c27495d8ade4d491b0c4f41 : SUCCESS in 1h 36m 54s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/7d86c7850a4c4560a4c84f1843fea969 : SUCCESS in 1h 03m 51s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/8f4e2922d7c0492f8e63fd418dee7385 : SUCCESS in 1h 53m 41s\n- nova-next https://zuul.opendev.org/t/openstack/build/cb8654a996e44d5b84f46234cfffc430 : SUCCESS in 1h 46m 13s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/8aaa927750b44e89b939c269c3047b18 : SUCCESS in 13m 43s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/3d0f14220f5d4c4a81ce3819cd4af4e9 : SUCCESS in 20m 52s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/3e66427bb3d44d24962ed12dab3afcbf : SUCCESS in 48m 52s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/d847bb86e2a140969293a0902fff3fde : SUCCESS in 46m 04s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/35718012133d4bb7b3157a775e91d96c : SUCCESS in 38m 16s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/b4c594eb55de4b5ba10ebcb89bfc6a68 : SUCCESS in 38m 43s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"16d32b7ea27623fd7b79df97bef19ca3a33fbadb","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2020-12-23 21:13:29.000000000","message":"Patch Set 1:\n\nBuild failed.  For information on how to proceed, see https://docs.openstack.org/infra/manual/developers.html\n\n- EMC_PowerFlex_NOVA http://publiclogs.emc.com/64/768364/1/check/EMC_PowerFlex_NOVA/a38be72/EMC_PowerFlex_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC PowerFlex CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_PowerFlex_CI","accounts_in_message":[],"_revision_number":1},{"id":"5b0c8254c0e4591a5e7696c0b426c25e5d725d23","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2020-12-23 21:48:52.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/768364/1 : FAILURE in 2h 32m 31s","accounts_in_message":[],"_revision_number":1},{"id":"3c0edf2ff13155d05eaed0bf8c1eb75e3f33acb2","author":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"date":"2020-12-24 09:49:46.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"acea2b732dc3f70c63ffaaaa48b69f0859c40f0e","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-01-07 13:32:27.000000000","message":"Patch Set 1:\n\nI\u0027m going to abandon this since there isn\u0027t a clean way to CI this, and people can simply lay down the tool, which I\u0027ve published separately [1], in the root of their repository and run it for each migration, diffing the generated schemas, e.g.:\n\n  curl https://gist.githubusercontent.com/stephenfin/adc84a21f5f5ae3793f6a8ffa0b3f40f/raw/203438b8ee5ed7b0ce9031caa617c795827f2bc2/generate-schemas.sh \u003e generate-schemas\n  chmod +x generate-schemas\n  git rebase -i master --exec ./generate-schemas\n\n[1] https://that.guru/blog/comparing-nova-db-migrations/#example","accounts_in_message":[],"_revision_number":1},{"id":"e285392d757a3969f7c5bfe8588ecc616cf46fbd","tag":"autogenerated:gerrit:abandon","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-01-07 13:32:32.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"3c87f4072f960508874937637100ccc7b8cc5fe3","revisions":{"3c87f4072f960508874937637100ccc7b8cc5fe3":{"kind":"REWORK","_number":1,"created":"2020-12-23 19:15:16.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/64/768364/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/64/768364/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/64/768364/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/64/768364/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/64/768364/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/64/768364/1"}}},"commit":{"parents":[{"commit":"96e9124ad705df82fb4866c9241fac5e5e98b761","subject":"Merge \"Ignore PCI devices with 32bit domain\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/96e9124ad705df82fb4866c9241fac5e5e98b761"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2020-12-23 17:51:06.000000000","tz":0},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2020-12-23 18:18:40.000000000","tz":0},"subject":"Add schema files to compare against after squashing","message":"Add schema files to compare against after squashing\n\nThese are generated using the \u0027generate-schemas\u0027 tool included in this\nchange and then renamed to \"before\" rather than after.\n\nChange-Id: I58d82054b41095792f30a23a9e0cef0d9e38a350\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/3c87f4072f960508874937637100ccc7b8cc5fe3"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/3c87f4072f960508874937637100ccc7b8cc5fe3"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}