)]}'
{"id":"openstack%2Fkeystone~687753","triplet_id":"openstack%2Fkeystone~master~I7c068e350811e22622d1f1e7d8b0a55d4d7cab11","project":"openstack/keystone","branch":"master","topic":"resource-fk","hashtags":[],"change_id":"I7c068e350811e22622d1f1e7d8b0a55d4d7cab11","subject":"Drop project.id foreign keys","status":"MERGED","created":"2019-10-10 00:00:39.000000000","updated":"2019-11-12 20:44:12.000000000","submitted":"2019-11-12 20:42:23.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":"687753-1573591343619-91d4b73c","meta_rev_id":"b2a4de8f72f4b2c5495b0529842f00a0488dc503","_number":687753,"virtual_id_number":687753,"owner":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2019-11-12 20:42:23.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},{"value":0,"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},{"value":0,"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},{"value":0,"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},{"value":0,"date":"2019-11-12 15:44:31.000000000","_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"}],"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":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"all":[{"value":2,"date":"2019-11-12 01:44:02.000000000","_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2019-11-05 07:05:24.000000000","_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},{"value":1,"date":"2019-11-12 01:57:51.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},{"value":1,"date":"2019-10-14 07:39:43.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},{"value":1,"date":"2019-10-14 06:44:59.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":1,"date":"2019-11-12 00:22:44.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},{"value":0,"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"}],"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":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"all":[{"value":1,"date":"2019-11-12 01:44:02.000000000","_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},{"value":0,"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},{"value":0,"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},{"value":0,"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},{"value":0,"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},{"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-10-14 06:44:59.000000000","updated_by":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"reviewer":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"state":"REVIEWER"},{"updated":"2019-10-14 07:39:43.000000000","updated_by":{"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},"reviewer":{"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},"state":"REVIEWER"},{"updated":"2019-11-05 07:05:24.000000000","updated_by":{"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},"reviewer":{"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},"state":"REVIEWER"},{"updated":"2019-11-12 00:22:44.000000000","updated_by":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"reviewer":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"state":"REVIEWER"},{"updated":"2019-11-12 01:44:02.000000000","updated_by":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"reviewer":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"state":"REVIEWER"},{"updated":"2019-11-12 01:57:51.000000000","updated_by":{"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},"reviewer":{"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},"state":"REVIEWER"},{"updated":"2019-11-12 20:42:23.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"}],"messages":[{"id":"f4f309afaed3d8f35e900c7ca9eb052a4da77705","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-10 00:00:39.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"7324f9946cc118595b72eaafac56a678fb641a85","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-10 00:52:21.000000000","message":"Uploaded patch set 2: Commit message was updated.","accounts_in_message":[],"_revision_number":2},{"id":"c9dedf0271c2ac68c339e3be5d05eeb41769d8b1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-10-10 02:25:34.000000000","message":"Patch Set 2: 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-cover https://zuul.opendev.org/t/openstack/build/08e17962b18844d09f4c4b7ad1ad7a5f : SUCCESS in 22m 05s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/2e4fe8a1d6f0449db856614b9bb00efe : SUCCESS in 21m 35s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/5f002afa307045afb76485f152147e4b : SUCCESS in 5m 14s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/f602c1f1bf614118bb7e49eeb2567ccb : FAILURE in 14m 48s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/1ed80d665eb94c3ba95fd6660fcc88c7 : SUCCESS in 35m 58s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/8322cffff36e4215ab461845ec1011be : SUCCESS in 17m 17s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/4ba2852c19af4493bf024e8c11b97d0d : SUCCESS in 10m 28s\n- tempest-full https://zuul.opendev.org/t/openstack/build/4dddef20c369467faa627bd7ef1cf045 : SUCCESS in 1h 31m 46s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/d68a7701652248838be62661974b23b8 : SUCCESS in 56m 23s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/8b04268c76fa4976ad28ec9ed6b9629b : SUCCESS in 50m 16s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/e302626daadc4e6b9e62efe61ad61a9a : SUCCESS in 1h 20m 03s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/709b59fe1c5f43d4a0f96efaacd18059 : SUCCESS in 13m 39s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/2b59aa8147cc49f99c070f883cc57d60 : SUCCESS in 38m 45s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/dcef6a2f593a4fb08c486d377e34e8d6 : SUCCESS in 41m 03s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/b91b676756f94ccf8b20ce3ccd7a8861 : SUCCESS in 34m 48s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/7e622d227cd247fe994ce4864ac56bd6 : SUCCESS in 35m 56s (non-voting)\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/8ccfce1d70cd4fcb8ccab616a323c205 : SUCCESS in 12m 24s (non-voting)\n- legacy-tempest-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/c650a470907e4cf3ac6c8cea3e6f32c1 : SUCCESS in 1h 22m 50s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/ec3d0f815e214ff29c4be9f1f6c147f6 : SUCCESS in 55m 19s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/c21cc4bddebd4deaa12892e2af406a0b : SUCCESS in 38m 29s","accounts_in_message":[],"_revision_number":2},{"id":"b81a3d90a4b77437712e930ebdb3bb02e7bff717","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-10 15:10:13.000000000","message":"Uploaded patch set 3: Commit message was updated.","accounts_in_message":[],"_revision_number":3},{"id":"439c18eb529abdfe1926650145f85ca182dd56d0","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-10-10 18:34:43.000000000","message":"Patch Set 3: 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-cover https://zuul.opendev.org/t/openstack/build/6f7a749b775e41f4aec7c1b9d3e29a6b : FAILURE in 17m 21s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/93c1f1f097724cd88ddd4dbeab5421d5 : FAILURE in 17m 52s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/94818c98de3349c684a72b691bc51086 : SUCCESS in 7m 32s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/1d80c99910754d7b96eea63d41c20015 : FAILURE in 24m 33s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/12bfb122bd6a4938aa749fbc92cc8815 : FAILURE in 16m 22s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/908a2092ab8c4d2b9549dc3f2206539b : FAILURE in 16m 07s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e36f0c6a36f84cf1b92033204bebf9e3 : SUCCESS in 11m 55s\n- tempest-full https://zuul.opendev.org/t/openstack/build/1f04885eab6c4d1c8e73fa356db86b81 : SUCCESS in 1h 40m 45s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/97b7b1dd4dd743bfb358fae99c967203 : SUCCESS in 58m 00s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/eec46a8ba8784efa98abead0fe6911e0 : SUCCESS in 1h 00m 12s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/919dbe1d84324fb78a834b3764c71b40 : SUCCESS in 1h 19m 20s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/edcf38f6bd274bbfb31f2d7149fea561 : SUCCESS in 17m 38s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/80df46b4e2df4ea7907b8c4b33366032 : SUCCESS in 39m 13s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/3790bd8eca9d44b9af4e6b61761adeed : SUCCESS in 40m 04s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/0c7a70de02474ddeaaf694c290d92507 : SUCCESS in 38m 50s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/e5f5a622244046ab96eb2f151e01b31e : SUCCESS in 37m 58s (non-voting)\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/8ca86cb2e32a495e95e84564e92eba23 : SUCCESS in 16m 11s (non-voting)\n- legacy-tempest-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/d48a67b0ce764dbc87df354b9bce2089 : SUCCESS in 1h 53m 29s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/93286a999a4044ce91199f378679d3b0 : SUCCESS in 1h 00m 05s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/e6d4c0a6e81d486997c62fb8f40b651d : SUCCESS in 42m 35s","accounts_in_message":[],"_revision_number":3},{"id":"c87896d085a169ee3d0df05557d41e172760443f","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2019-10-11 06:29:02.000000000","message":"Patch Set 3:\n\n(2 comments)","accounts_in_message":[],"_revision_number":3},{"id":"436ffb992a70677abb5de5686e1ecf68b678c258","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-11 21:03:09.000000000","message":"Patch Set 3:\n\n(2 comments)","accounts_in_message":[],"_revision_number":3},{"id":"20fc33d1157c626b88999325bc95415f0b602427","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-11 21:13:10.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"5211f417f92bea6d6734b7c0d9a760f1fcad332a","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-10-11 23:41:56.000000000","message":"Patch Set 4: 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-cover https://zuul.opendev.org/t/openstack/build/94f1dff5ce8f4b669b81c2f9df936bf8 : SUCCESS in 21m 42s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/fb9e0d19e78044d38903ef5220ef59aa : SUCCESS in 15m 15s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e0ab513dd06346bcae4d3728943d67fa : SUCCESS in 6m 32s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/14068d1f57c2470aba3f679359d318f6 : SUCCESS in 15m 48s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/94d3ec1e3be34391aa51659274a1ea0f : SUCCESS in 12m 21s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/5b2695f4a2394e6497a9139f9b897152 : TIMED_OUT in 40m 56s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d8a645cf089541768eceba232ad6ad0e : SUCCESS in 15m 53s\n- tempest-full https://zuul.opendev.org/t/openstack/build/426193966fcb4930b544121009971080 : SUCCESS in 1h 52m 45s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/e54bdabc1b0a47e8b7c43e474e2d16bb : SUCCESS in 1h 23m 58s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/419a14a3a9444b1e8cc851f92857faac : SUCCESS in 1h 18m 37s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/284c67a66e974781ab944d6767a0b622 : SUCCESS in 1h 28m 39s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/cca951e9293c4efab40c311d2dd58702 : SUCCESS in 21m 08s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/c6a517a498634b4890abf5c970ff81c8 : SUCCESS in 46m 09s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/9ef6bed3d09042f29d3c94353c58094f : SUCCESS in 44m 59s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/5b98d2fad9cc4090b53c8d0a0373da87 : SUCCESS in 39m 59s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/37a8e643e10843089c828e5c16285705 : SUCCESS in 30m 42s (non-voting)\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/f923c8061fcf4b4b8d6a40d5ce71b770 : SUCCESS in 15m 07s (non-voting)\n- legacy-tempest-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/b02acb9e562b44b2b264e42ed2bb96b9 : SUCCESS in 1h 39m 41s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/f20435e22db74eeebe0b9f9b689d8d04 : SUCCESS in 1h 06m 10s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/4c16985a0823456d8617be7a917da11b : SUCCESS in 44m 06s","accounts_in_message":[],"_revision_number":4},{"id":"1c8b85bd9e33a1f753037d04b0a12796365003fa","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-10-12 00:02:51.000000000","message":"Patch Set 4:\n\nrecheck","accounts_in_message":[],"_revision_number":4},{"id":"2232c0a4d04af784072dd845818e4e1bd1a93d1b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-10-12 01:46:11.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/1e1f604d4277450c9433bc06bb53f596 : SUCCESS in 15m 04s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/16901667edb54237b4c6c54d67454dc4 : SUCCESS in 14m 27s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/b3fe8d3b7dca418395e85c441dc63075 : SUCCESS in 5m 35s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/9d7d86f799964897abb6df4f5e179f0d : SUCCESS in 12m 43s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f39e213c3ca9423db644f57518fadddf : SUCCESS in 14m 22s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/ab7e934f44844025b14e1f5b209dc3c0 : SUCCESS in 13m 46s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8098085e6a1649c286578ffdc978839e : SUCCESS in 11m 32s\n- tempest-full https://zuul.opendev.org/t/openstack/build/18c44c365ff24e418c98cd3e2bdfa3d0 : SUCCESS in 1h 37m 48s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/8bae75e6ff544c91b9310091085ee1e5 : SUCCESS in 1h 14m 05s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/a3576f6d6865461fa20b2084d662a6ed : SUCCESS in 59m 03s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/7d204b11a935419fa00d4cb816bd8aab : SUCCESS in 1h 15m 27s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/ab26afcc9bc1490690f0c880dc15caae : SUCCESS in 15m 44s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/0ddfac4410c641dfb9cc526f72c08a40 : SUCCESS in 31m 51s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/8d80ebbd600842f78ceb598444e9cf5b : SUCCESS in 34m 58s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/126c869f34524aa098876dc329c9e0e7 : SUCCESS in 37m 38s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/58121792e9ec4f84b46a2446016c490c : SUCCESS in 40m 32s (non-voting)\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/57202f8dfe4d42298f767301d9109a82 : SUCCESS in 21m 20s (non-voting)\n- legacy-tempest-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/34cc3bde41224af39c34ee0c6af447ba : SUCCESS in 1h 27m 37s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/bb29f854e0244288825f95b92ac585ad : SUCCESS in 1h 08m 32s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/895fb82e6ca14a5099ddf605ec05cd7c : SUCCESS in 39m 17s","accounts_in_message":[],"_revision_number":4},{"id":"079dcb8e1ff075abfc5bf391c1317e55248104e4","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2019-10-14 06:44:12.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"75d377abe7801b40e9114775033bb232b0f87dfe","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2019-10-14 06:44:59.000000000","message":"Patch Set 4: Code-Review+1\n\nMy Comments are clear. Looks good to me.","accounts_in_message":[],"_revision_number":4},{"id":"2e0e1273db70c461ad24684da990e73717cec222","author":{"_account_id":17499,"name":"Filippo Inzaghi","email":"zhao.daqing@99cloud.net","username":"qingszhao"},"date":"2019-10-14 07:39:43.000000000","message":"Patch Set 4: Code-Review+1","accounts_in_message":[],"_revision_number":4},{"id":"5aa1db4cf80a0125432c696d847c6bfd49743406","author":{"_account_id":15054,"name":"wangxiyuan","email":"wangxiyuan1007@gmail.com","username":"wangxiyuan"},"date":"2019-11-05 07:05:24.000000000","message":"Patch Set 4: Code-Review+2\n\nYeah, we should remove the fk across backend.","accounts_in_message":[],"_revision_number":4},{"id":"90538fb9525a6541a7b90893e107958d02b58704","author":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"date":"2019-11-12 00:22:44.000000000","message":"Patch Set 4: Code-Review+1\n\nYes please!","accounts_in_message":[],"_revision_number":4},{"id":"4e47d4f03b87ad2c12b344f455d760f6acc03ab1","author":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"date":"2019-11-12 01:44:02.000000000","message":"Patch Set 4: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":4},{"id":"f7c4b24903ce5a8720176840951e7b3248fddb23","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 01:44:33.000000000","message":"Patch Set 4: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":4},{"id":"da66136d366c00868e5d8784f783ecd12fa870cd","author":{"_account_id":28543,"name":"shupeng","email":"15050873171@163.com","username":"Vieri"},"date":"2019-11-12 01:57:51.000000000","message":"Patch Set 4: Code-Review+1","accounts_in_message":[],"_revision_number":4},{"id":"397849799fab9fd218dacac984a9c2a3c4340ca9","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 09:52:48.000000000","message":"Patch Set 4: Verified-2\n\nBuild failed (gate pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/15aa4a80083a42c4bb29b872497bd8c8 : SUCCESS in 17m 44s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4128b23853cc4b50a8aa934bac37bd85 : SUCCESS in 7m 20s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/dc2ebed3da304b5db251e2c07e929e13 : SUCCESS in 18m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/3cfb9be4735a434bb1b729b949fe36e5 : SUCCESS in 17m 38s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/d1429d2001564475a1d3461710a902ed : SUCCESS in 17m 21s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9664bc1f335041f38a2278c1a8888e3b : SUCCESS in 11m 00s\n- tempest-full https://zuul.opendev.org/t/openstack/build/62de1a28d703488aaea41cd4aca42d33 : SUCCESS in 1h 31m 01s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/fd42f2f3922c406ca3ab258cfe267f16 : SUCCESS in 1h 02m 47s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/39777c4217024445bab0dcb9ceaaf11e : SUCCESS in 1h 04m 49s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/93775380a5b346dd9d41513bb3d02d3f : FAILURE in 1h 05m 39s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/7d50ca3da3d04d588c574520f096e198 : SUCCESS in 17m 36s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/4c0b58beeed0444bb62c720cdd5bbacf : SUCCESS in 32m 18s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/178459b5e9724a24b87c98fc70972cf2 : SUCCESS in 36m 19s\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/b164ccd5e74b4d8097736545ff79fce2 : SUCCESS in 35m 21s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/421b00e6c03742d3abf78d495a2bd270 : SUCCESS in 59m 54s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/ee3722dd5f86443c997007ab2da0a09d : SUCCESS in 38m 08s","accounts_in_message":[],"_revision_number":4},{"id":"34dfe254b3782c67981a06c853bddd629b4d76de","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2019-11-12 15:44:31.000000000","message":"Patch Set 4:\n\nrecheck","accounts_in_message":[],"_revision_number":4},{"id":"47fb1394ddfc982b316285009090f99ec303edd2","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 17:27:42.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/868f205e425d48cab1062649ef3b802d : SUCCESS in 20m 27s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/ceeb46fcc44b41db88fa4b6e641b3717 : SUCCESS in 13m 15s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a40f3b5787ec4a48a4a6a95f0f98ce14 : SUCCESS in 6m 41s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/4236bfb236194229b72043efc742e9f6 : SUCCESS in 24m 20s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/179e406c4af14ffda755a1cda1fe6440 : SUCCESS in 14m 38s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/b226beb92a954f53b138bc6e8e583b98 : SUCCESS in 16m 41s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/758e639366fa4ceba433db1c4f4d011a : SUCCESS in 15m 33s\n- tempest-full https://zuul.opendev.org/t/openstack/build/7890f93425d44758b053556528101fc2 : SUCCESS in 1h 29m 03s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/0713ddda100740e98eb001fb12f94852 : SUCCESS in 58m 12s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/66b3e119aa374acfb67c71bc66565b45 : SUCCESS in 58m 39s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/14b15d7b7d964832abc41c42572ba7ae : SUCCESS in 1h 35m 10s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/656f676324fc42fa8141abaa273690e9 : SUCCESS in 20m 23s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/1abde7c4f52c4beeb290049d22b5d521 : SUCCESS in 41m 23s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/c57b543b28ae48769b27d5fe36acb5ae : SUCCESS in 34m 18s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/1e1ff59d38ef498d98fdbd716648e10b : SUCCESS in 46m 07s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/bb7bd67b09f04f7c91cbdecccebc62ff : POST_FAILURE in 49m 11s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/d39cb0f583d345439329cd7edf33f4ef : SUCCESS in 45m 20s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/bc5ab3df6b96478985610248aa695650 : SUCCESS in 15m 20s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/907bc555b4ef40f4ab551964b4e22a41 : SUCCESS in 42m 47s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/53b0ba138ad34cf3970e956efa22b3fe : SUCCESS in 1h 05m 25s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/abf8e20b009f45a2b1d9ce2064f90c6e : SUCCESS in 42m 56s","accounts_in_message":[],"_revision_number":4},{"id":"01063d5b8b16d1a1ce5fc555287eabdedabd2168","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 17:28:00.000000000","message":"Patch Set 4: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":4},{"id":"93b86714a87469922636ab472a781a4df95753ea","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 20:42:23.000000000","message":"Patch Set 4: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/83df4a2f615f490eaf3f0e1ac4d441cc : SUCCESS in 13m 18s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a8d42e953e444465b69b7fcfc0e526d2 : SUCCESS in 5m 58s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/a7c1236d47f74f5a98ad94548ecc187e : SUCCESS in 13m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/348a16dab77441e8ad44c04c7eda3194 : SUCCESS in 12m 59s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/23a198d7e6244b31836d971452c53e57 : SUCCESS in 12m 08s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/77fadce690c044c8ab6dee0186c8bc96 : SUCCESS in 12m 09s\n- tempest-full https://zuul.opendev.org/t/openstack/build/aafa68ec7703429ba1575b609669bcfd : SUCCESS in 1h 25m 19s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/fe759488191e43028a70fc389944d2a4 : SUCCESS in 1h 04m 50s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/14643e014fa649e5bf9257a8b0036567 : SUCCESS in 56m 07s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/60f256b611f349548002e58717231c1a : SUCCESS in 1h 41m 47s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/f6a2ddf861414df2a5bb68100e670efe : SUCCESS in 16m 54s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/d962d0b8d28f42aa9d0afcaf734b432f : SUCCESS in 33m 45s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/d460a2b015e541eea3d0c9147cbb0bf7 : SUCCESS in 32m 21s\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/4fd4b60eb31049cbad5c289f8d1ccb76 : SUCCESS in 37m 12s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/c04a563cae8e4b41ad4f3594a4a96866 : SUCCESS in 1h 04m 40s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/55b8286a9f6f47a98d4eabdbcb2b8f1b : SUCCESS in 36m 49s","accounts_in_message":[],"_revision_number":4},{"id":"bc239beaf2e306e8305565490e01aa0e54a4cff8","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 20:42:23.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":4},{"id":"5a50e7449b8c8ed78db6fd32fc7deda80f34fc65","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-12 20:44:12.000000000","message":"Patch Set 4:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/107056c18af1453a9780bb52589f30ed : SUCCESS in 1m 25s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/4241d61cbcf34b17b43a0ed329501836 : SUCCESS in 1m 10s","accounts_in_message":[],"_revision_number":4}],"current_revision_number":4,"current_revision":"c4d60977881ac2f014dc6e2eaaba37892f075266","revisions":{"4bec607801b8614934ae9d32adc5d034c93b4c30":{"kind":"REWORK","_number":1,"created":"2019-10-10 00:00:39.000000000","uploader":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"ref":"refs/changes/53/687753/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/53/687753/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/53/687753/1"}}},"commit":{"parents":[{"commit":"e4626f4bc32b846ca9b99f954101a7a462675ea5","subject":"Add schema placeholders for Train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/e4626f4bc32b846ca9b99f954101a7a462675ea5"}]}],"author":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-09 23:30:33.000000000","tz":-420},"committer":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-10 00:00:22.000000000","tz":-420},"subject":"Drop project.id foreign keys","message":"Drop project.id foreign keys\n\nIn 2bd88d30 we added a new column domain_id to the user table to\ndeduplicate the domain_id columns in the local_user and nonlocal_user\ntables, and at that point made the user.domain_id column a foreign key\nreferencing the project.id column. This is a problem that led to\n3d46c8a5 in which we removed the ability for the resource driver to be\npluggable, since we had linked two sql backends together and made them\nreliant on one another.\n\nThis commit removes the foreign key constraint from the user table and\nthe identity_provider table. For the user table, the sqlalchemy model\nnever reflected this schema so we don\u0027t need to change the model. For\nthe identity_provider table, we need to update the model. In both cases,\nwe already enforce, at the manager layer, the constraint that the\ndomain_id needs to reference a real domain ID[1][2], so we do not need\nto rely on this constraint at the database layer.\n\n[1] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/identity/core.py#L935\n[2] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/federation/core.py#L73-L77\n\nChange-Id: I7c068e350811e22622d1f1e7d8b0a55d4d7cab11\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/4bec607801b8614934ae9d32adc5d034c93b4c30"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/4bec607801b8614934ae9d32adc5d034c93b4c30"}]},"branch":"refs/heads/master"},"0956075d23678c046fcf9ec295efe5a56a643218":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2019-10-10 00:52:21.000000000","uploader":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"ref":"refs/changes/53/687753/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/53/687753/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/53/687753/2"}}},"commit":{"parents":[{"commit":"e4626f4bc32b846ca9b99f954101a7a462675ea5","subject":"Add schema placeholders for Train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/e4626f4bc32b846ca9b99f954101a7a462675ea5"}]}],"author":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-09 23:30:33.000000000","tz":-420},"committer":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-10 00:45:39.000000000","tz":-420},"subject":"Drop project.id foreign keys","message":"Drop project.id foreign keys\n\nIn 2bd88d30 we added a new column domain_id to the user table to\ndeduplicate the domain_id columns in the local_user and nonlocal_user\ntables, and at that point made the user.domain_id column a foreign key\nreferencing the project.id column. This is a problem that led to\n3d46c8a5 in which we removed the ability for the resource driver to be\npluggable, since we had linked two sql backends together and made them\nreliant on one another.\n\nThis commit removes the foreign key constraint from the user table and\nthe identity_provider table. For the user table, the sqlalchemy model\nnever reflected this schema so we don\u0027t need to change the model. For\nthe identity_provider table, we need to update the model. In both cases,\nwe already enforce, at the manager layer, the constraint that the\ndomain_id needs to reference a real domain ID[1][2], so we do not need\nto rely on this constraint at the database layer.\n\n[1] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/identity/core.py#L935\n[2] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/federation/core.py#L73-L77\n\nPartial-bug: #1672713\n\nChange-Id: I7c068e350811e22622d1f1e7d8b0a55d4d7cab11\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0956075d23678c046fcf9ec295efe5a56a643218"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0956075d23678c046fcf9ec295efe5a56a643218"}]},"branch":"refs/heads/master"},"9e331e938ba77df7d70a869327717eda112c92d0":{"kind":"NO_CODE_CHANGE","_number":3,"created":"2019-10-10 15:10:13.000000000","uploader":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"ref":"refs/changes/53/687753/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/53/687753/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/53/687753/3"}}},"commit":{"parents":[{"commit":"e4626f4bc32b846ca9b99f954101a7a462675ea5","subject":"Add schema placeholders for Train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/e4626f4bc32b846ca9b99f954101a7a462675ea5"}]}],"author":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-09 23:30:33.000000000","tz":-420},"committer":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-10 15:09:52.000000000","tz":-420},"subject":"Drop project.id foreign keys","message":"Drop project.id foreign keys\n\nIn 2bd88d30 we added a new column domain_id to the user table to\ndeduplicate the domain_id columns in the local_user and nonlocal_user\ntables, and at that point made the user.domain_id column a foreign key\nreferencing the project.id column. This is a problem that led to\n3d46c8a5 in which we removed the ability for the resource driver to be\npluggable, since we had linked two sql backends together and made them\nreliant on one another.\n\nThis commit removes the foreign key constraint from the user table and\nthe identity_provider table. For the user table, the sqlalchemy model\nnever reflected this schema so we don\u0027t need to change the model. For\nthe identity_provider table, we need to update the model. In both cases,\nwe already enforce, at the manager layer, the constraint that the\ndomain_id needs to reference a real domain ID[1][2], so we do not need\nto rely on this constraint at the database layer.\n\n[1] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/identity/core.py#L935\n[2] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/federation/core.py#L73-L77\n\nPartial-bug: #1672713\nDepends-on: https://review.opendev.org/687770\n\nChange-Id: I7c068e350811e22622d1f1e7d8b0a55d4d7cab11\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/9e331e938ba77df7d70a869327717eda112c92d0"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/9e331e938ba77df7d70a869327717eda112c92d0"}]},"branch":"refs/heads/master"},"c4d60977881ac2f014dc6e2eaaba37892f075266":{"kind":"REWORK","_number":4,"created":"2019-10-11 21:13:10.000000000","uploader":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"ref":"refs/changes/53/687753/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/53/687753/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/53/687753/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/53/687753/4"}}},"commit":{"parents":[{"commit":"e4626f4bc32b846ca9b99f954101a7a462675ea5","subject":"Add schema placeholders for Train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/e4626f4bc32b846ca9b99f954101a7a462675ea5"}]}],"author":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-09 23:30:33.000000000","tz":-420},"committer":{"name":"Colleen Murphy","email":"colleen.murphy@suse.de","date":"2019-10-11 21:12:57.000000000","tz":-420},"subject":"Drop project.id foreign keys","message":"Drop project.id foreign keys\n\nIn 2bd88d30 we added a new column domain_id to the user table to\ndeduplicate the domain_id columns in the local_user and nonlocal_user\ntables, and at that point made the user.domain_id column a foreign key\nreferencing the project.id column. This is a problem that led to\n3d46c8a5 in which we removed the ability for the resource driver to be\npluggable, since we had linked two sql backends together and made them\nreliant on one another.\n\nThis commit removes the foreign key constraint from the user table and\nthe identity_provider table. For the user table, the sqlalchemy model\nnever reflected this schema so we don\u0027t need to change the model. For\nthe identity_provider table, we need to update the model. In both cases,\nwe already enforce, at the manager layer, the constraint that the\ndomain_id needs to reference a real domain ID[1][2], so we do not need\nto rely on this constraint at the database layer.\n\n[1] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/identity/core.py#L935\n[2] https://opendev.org/openstack/keystone/src/commit/43142e4470df976a459a1a2e95cfb163afc42893/keystone/federation/core.py#L73-L77\n\nPartial-bug: #1672713\n\nChange-Id: I7c068e350811e22622d1f1e7d8b0a55d4d7cab11\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/c4d60977881ac2f014dc6e2eaaba37892f075266"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/c4d60977881ac2f014dc6e2eaaba37892f075266"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}