)]}'
{"id":"openstack%2Ftacker~755600","triplet_id":"openstack%2Ftacker~stable%2Fvictoria~I7a62ecf3eeec2f363d0f099bb46d3dec7948501a","project":"openstack/tacker","branch":"stable/victoria","topic":"bug/1886622","hashtags":[],"change_id":"I7a62ecf3eeec2f363d0f099bb46d3dec7948501a","subject":"Fix: Remove wrong constraint in vnf_package_vnfd","status":"MERGED","created":"2020-10-01 17:23:13.000000000","updated":"2020-10-02 16:23:30.000000000","submitted":"2020-10-02 16:23:29.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"755600-1601655810038-f61217dc","meta_rev_id":"852bb0bfe4315e912025f7b8a344a8237b19f837","_number":755600,"virtual_id_number":755600,"owner":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":0,"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2020-10-02 16:23:29.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":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"all":[{"value":2,"date":"2020-10-02 15:56:55.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":2,"date":"2020-10-02 13:32:26.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"value":0,"_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":{"approved":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"all":[{"value":1,"date":"2020-10-02 15:56:55.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":0,"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"value":0,"_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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-10-02 13:32:26.000000000","updated_by":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"reviewer":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"state":"REVIEWER"},{"updated":"2020-10-02 16:23:29.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":"9416b0681488d7bd064d7144ca16ccae37ee0026","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-01 17:23:13.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"c7b26236152b91a7f292bfd162dec22258961810","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-01 17:43:12.000000000","message":"Patch Set 1: Workflow-1","accounts_in_message":[],"_revision_number":1},{"id":"8b2a0ab5aec0a8465d3a494d66b17f071c5d8414","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-01 20:03:14.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/5f7daf6da1bc4a968e98bb815bef808b : SUCCESS in 6m 10s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a7c9dd5d38e1478e9fbbb0d85e0d0ba9 : SUCCESS in 7m 39s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/32b7499516ee484f892ceed305fe15df : SUCCESS in 5m 09s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e0e1e130985a45a0a63ea8c0a9f1d8d4 : SUCCESS in 8m 20s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/62e762c398f84b768a970242e0b6907f : SUCCESS in 8m 14s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d5865ad6dadb4482b8229b8969476a79 : SUCCESS in 6m 12s\n- tacker-functional-devstack-multinode-python3 https://zuul.opendev.org/t/openstack/build/1d7f374a7f0f4c859ad7064d879516fe : FAILURE in 1h 34m 58s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"6618c12477c2b99037f3079e87f9ede4d4c377ea","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-02 06:44:44.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":1},{"id":"9826f0cbc3319fe11095ec85ebf4bd5b082d3e56","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-02 09:15:55.000000000","message":"Restored","accounts_in_message":[],"_revision_number":1},{"id":"b9cd3e8942ff83e2edb879184155cf4b00a06283","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-02 09:21:15.000000000","message":"Uploaded patch set 2: Patch Set 1 was rebased.","accounts_in_message":[],"_revision_number":2},{"id":"1386170473ce089d2a8f41248bf3be7d2b85f0ce","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-02 11:20:40.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/4d526d87c559498f906856230d40b663 : SUCCESS in 6m 43s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/7bee15097b2645358d327be7e6144a73 : SUCCESS in 9m 09s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ac6943c3b3af42ddafe665027d075632 : SUCCESS in 7m 12s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/70e9b0ad398f460b87b5848a216b2ed5 : SUCCESS in 9m 30s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/b09222a7e6da406d8a8d9774b69e4dd5 : SUCCESS in 9m 02s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/1bc0621e6d87417eaf6dd930c65c9d52 : SUCCESS in 6m 15s\n- tacker-functional-devstack-multinode-python3 https://zuul.opendev.org/t/openstack/build/84e46b4a93944c108cd78632c295b72c : FAILURE in 1h 37m 58s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"6a144354116115d64be644a025156a5efd992baa","author":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"date":"2020-10-02 13:32:26.000000000","message":"Patch Set 2: Code-Review+2","accounts_in_message":[],"_revision_number":2},{"id":"82ee9516019e6128dccc09422861b81274da024b","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2020-10-02 15:56:55.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"4a9fb36f5fd9b6b30bea5a8fbb3032defbd89488","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-02 15:57:09.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"09a1fdd205f627efc27a2a379158219e84ad0e71","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-02 16:23:29.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/54cee2adf51446a5b3c8c976dab8726a : SUCCESS in 9m 32s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3096580ce682471c8a06da3a1215a010 : SUCCESS in 4m 41s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/58b19c061076479a96be795666a8e55e : SUCCESS in 9m 49s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/581a9f951a834dc4aceadd679aeb87e5 : SUCCESS in 9m 59s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a818978a2326428881ebfed548d210f0 : SUCCESS in 7m 49s","accounts_in_message":[],"_revision_number":2},{"id":"ba6ba3e9567a6e96dd8a2fbf574396dd0b8ceac1","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-02 16:23:30.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"aee1a048cba463f1fd8eae8b122dc31c58f80055","revisions":{"3e2cba1f56fd600c5283b077508a66e0cadad3f5":{"kind":"REWORK","_number":1,"created":"2020-10-01 17:23:13.000000000","uploader":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"ref":"refs/changes/00/755600/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/00/755600/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/00/755600/1"}}},"commit":{"parents":[{"commit":"f05525359d6276bdfdd32e74550df87cff817a80","subject":"Add note about not use docker on CentOS8","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/f05525359d6276bdfdd32e74550df87cff817a80"}]}],"author":{"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","date":"2020-07-09 05:59:17.000000000","tz":540},"committer":{"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","date":"2020-10-01 17:22:37.000000000","tz":540},"subject":"Fix: Remove wrong constraint in vnf_package_vnfd","message":"Fix: Remove wrong constraint in vnf_package_vnfd\n\nCurrently, vnf_package_vnfd table has a following constraint\nin database created by tacker db migration.\nThis is incorrect, so this patch remove the constraint.\n\nCONSTRAINT `CONSTRAINT_1` CHECK (`deleted` in (0,1))\n\nThis is created because `deleted` was boolean before.\n`deleted` is varchar(36) now, so db migration change its type\nby alter_column method. But this does not remove check constraint.\nThis patch add drop_constraint to remove the constraint.\n\nChange-Id: I7a62ecf3eeec2f363d0f099bb46d3dec7948501a\nCloses-Bug: #1886622\nSigned-off-by: Toshiaki Takahashi \u003cts-takahashi@nec.com\u003e\n(cherry picked from commit d744c3936ef6afa4b985e2241be3555b63fb699f)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/3e2cba1f56fd600c5283b077508a66e0cadad3f5"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/3e2cba1f56fd600c5283b077508a66e0cadad3f5"}]},"branch":"refs/heads/stable/victoria"},"aee1a048cba463f1fd8eae8b122dc31c58f80055":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2020-10-02 09:21:15.000000000","uploader":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"ref":"refs/changes/00/755600/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/00/755600/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/00/755600/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/00/755600/2"}}},"commit":{"parents":[{"commit":"e1a991a0caf9ef0b8d9b7d9fa86310b12356f434","subject":"Add docs of VNF Package and VNFD with ETSI NFV-SOL","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/e1a991a0caf9ef0b8d9b7d9fa86310b12356f434"}]}],"author":{"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","date":"2020-07-09 05:59:17.000000000","tz":540},"committer":{"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","date":"2020-10-02 09:13:33.000000000","tz":540},"subject":"Fix: Remove wrong constraint in vnf_package_vnfd","message":"Fix: Remove wrong constraint in vnf_package_vnfd\n\nCurrently, vnf_package_vnfd table has a following constraint\nin database created by tacker db migration.\nThis is incorrect, so this patch remove the constraint.\n\nCONSTRAINT `CONSTRAINT_1` CHECK (`deleted` in (0,1))\n\nThis is created because `deleted` was boolean before.\n`deleted` is varchar(36) now, so db migration change its type\nby alter_column method. But this does not remove check constraint.\nThis patch add drop_constraint to remove the constraint.\n\nChange-Id: I7a62ecf3eeec2f363d0f099bb46d3dec7948501a\nCloses-Bug: #1886622\nSigned-off-by: Toshiaki Takahashi \u003cts-takahashi@nec.com\u003e\n(cherry picked from commit d744c3936ef6afa4b985e2241be3555b63fb699f)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/aee1a048cba463f1fd8eae8b122dc31c58f80055"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/aee1a048cba463f1fd8eae8b122dc31c58f80055"}]},"branch":"refs/heads/stable/victoria"}},"requirements":[],"submit_records":[],"submit_requirements":[]}