)]}'
{"id":"openstack%2Ftacker~796160","triplet_id":"openstack%2Ftacker~master~Ifd1ae2753c639f22fc1afa020222416fe79469ef","project":"openstack/tacker","branch":"master","topic":"migration-sqlalchemy14","hashtags":[],"change_id":"Ifd1ae2753c639f22fc1afa020222416fe79469ef","subject":"Fix migration for SQLAlchemy 1.4","status":"MERGED","created":"2021-06-13 03:25:20.000000000","updated":"2021-07-12 16:04:49.000000000","submitted":"2021-07-12 16:03:14.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":23,"unresolved_comment_count":2,"has_review_started":true,"submission_id":"796160-migration-sqlalchemy14","meta_rev_id":"0b4a174053e553b8c2efeb774209a0c474f51932","_number":796160,"virtual_id_number":796160,"owner":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"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"},{"value":0,"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2021-07-12 16:03:13.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"},"recommended":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"all":[{"value":1,"date":"2021-07-10 04:13:26.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"value":2,"date":"2021-07-10 07:42:17.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":2,"date":"2021-07-12 15:32:43.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":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"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":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"all":[{"value":0,"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"value":0,"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":1,"date":"2021-07-12 15:32:43.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"value":0,"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"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":[{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"_account_id":26222,"name":"Cong Phuoc Hoang","email":"hoangphuocbk2.07@gmail.com","username":"hoangphuoc"}],"reviewers":{"REVIEWER":[{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"_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"},{"_account_id":26222,"name":"Cong Phuoc Hoang","email":"hoangphuocbk2.07@gmail.com","username":"hoangphuoc"},{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-06-13 07:05:16.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":"2021-06-16 01:19:41.000000000","updated_by":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"reviewer":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"state":"REVIEWER"},{"updated":"2021-06-16 05:06:10.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"state":"REVIEWER"},{"updated":"2021-06-18 03:11:28.000000000","updated_by":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"reviewer":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"state":"CC"},{"updated":"2021-06-28 09:37:56.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"state":"REMOVED"},{"updated":"2021-06-28 09:38:09.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"state":"REVIEWER"},{"updated":"2021-07-09 08:31:45.000000000","updated_by":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"reviewer":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"state":"REVIEWER"},{"updated":"2021-07-09 09:36:22.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"state":"REVIEWER"},{"updated":"2021-07-09 09:36:22.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":26222,"name":"Cong Phuoc Hoang","email":"hoangphuocbk2.07@gmail.com","username":"hoangphuoc"},"state":"REVIEWER"},{"updated":"2021-07-09 09:36:22.000000000","updated_by":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"reviewer":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"state":"REVIEWER"}],"messages":[{"id":"eb8f0615bb736e08ffd11006a9b58ced4688e32c","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-13 03:25:20.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"8368b27c0dc87bdd0dad982afcf78da9aa765d53","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-13 07:05:16.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/f6a3afc49e764ef396194c2850e98cfc : FAILURE in 8m 45s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/65cafe249b7e4418960788f523624532 : SUCCESS in 17m 06s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e10642e095a143868e8876035924fe68 : SUCCESS in 6m 51s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/4c07046b121041e3af181545b5fe6043 : FAILURE in 15m 23s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d32f0fec7348490c8cadd2e8ad052c7c : FAILURE in 14m 08s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/892cf829e5f34cd1b3fb6f76ae712c8b : FAILURE in 14m 11s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/19f2b788970e4a84bf94373a1973bc63 : FAILURE in 7m 41s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/b5ad3e72c80e4d86a190473c8650b6ef : RETRY_LIMIT in 59m 48s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/c857e9653fe744109e3c6134e64de614 : RETRY_LIMIT in 1h 04m 28s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/65ea42051d23432a8c36d687e7e9a106 : RETRY_LIMIT in 54m 51s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/dac2a07f55094a2cb8887a5d24c3b655 : RETRY_LIMIT in 41m 52s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/20dc140f02eb4440a79f1f1fd5df6b40 : RETRY_LIMIT in 44m 26s","accounts_in_message":[],"_revision_number":1},{"id":"a1ce8c051a0c2ba42c71a319b034b9217ac29293","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-14 15:31:20.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"e4ac564b1b05f10bafa6d37a9840d67e3f1b8ba2","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-14 21:57:18.000000000","message":"Patch Set 2: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/2df7fa128c5341caa8bc37eaf21064c4 : FAILURE in 7m 31s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/d8e65a49c4664f559eeef97167c81a8e : SUCCESS in 17m 01s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/47a4029cec6c465393cce9fa2db7fe7e : SUCCESS in 6m 17s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/a88a8a83d69a4a7caf84075ee7632176 : FAILURE in 14m 26s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bf81503bb1404e809323252e8370d9fa : FAILURE in 13m 53s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2c758471298b453aa4edb321914388c5 : FAILURE in 14m 46s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2ab45c343a0d42ca9bb47bc70fa353f7 : FAILURE in 6m 34s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/2daaadd5c48b4ae5aeec31071844b041 : RETRY_LIMIT in 1h 06m 34s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/f815e477edd248c38e887e74653a43b8 : RETRY_LIMIT in 59m 14s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/b2f029b0381d45e7b8dcb1dc95973fc6 : RETRY_LIMIT in 59m 33s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/0232f8b43f9e4a54afdeabc9a85d1aa8 : RETRY_LIMIT in 46m 00s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/010b91ce36a846ae998d6c30349f8844 : RETRY_LIMIT in 3h 31m 51s","accounts_in_message":[],"_revision_number":2},{"id":"c03a2eae0271c1f3a30868dea07ed9bb1bca8b01","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-16 04:16:53.000000000","message":"Patch Set 2:\n\nHi Manpreet,\n\nFrom my quick survey, it might be because sqlalchemy and sqlalchemy-filters are maintained separately. In sqlalchemy, there was some change moving `_join_entities` from `lib/sqlalchemy/orm/query.py` to `lib/sqlalchemy/orm/context.py` in [1], but no update in sqlalchemy-filters for that.\n\nSo, we may need to update sqlalchemy-filters for the update, or ask to community, although sqlalchemy-filters has not updated recently.\n\n[1] https://github.com/sqlalchemy/sqlalchemy/commit/dce8c7a125cb99fad62c76cd145752d5afefae36","accounts_in_message":[],"_revision_number":2},{"id":"e513b6c9aa6052d4f1ab22e5af399cdd4683f90a","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 05:23:03.000000000","message":"Patch Set 2:\n\n\u003e Patch Set 2:\n\u003e \n\u003e Hi Manpreet,\n\u003e \n\u003e From my quick survey, it might be because sqlalchemy and sqlalchemy-filters are maintained separately. In sqlalchemy, there was some change moving `_join_entities` from `lib/sqlalchemy/orm/query.py` to `lib/sqlalchemy/orm/context.py` in [1], but no update in sqlalchemy-filters for that.\n\u003e \n\u003e So, we may need to update sqlalchemy-filters for the update, or ask to community, although sqlalchemy-filters has not updated recently.\n\u003e \n\u003e [1] https://github.com/sqlalchemy/sqlalchemy/commit/dce8c7a125cb99fad62c76cd145752d5afefae36\n\nThank you Ogawa san for sharing. Indeed we could ask community for update.\n\nYesterday, while investigating I came across an alternative solution. The \"aodh\" project is using a customize \"apply_filters\" method [1]. I tried this method implementation in local environment for tacker and it worked fine.\n\nCould we customize method in tacker. Please share your valuable opinion.\n\n[1] https://github.com/openstack/aodh/blob/master/aodh/storage/impl_sqlalchemy.py#L58","accounts_in_message":[],"_revision_number":2},{"id":"e338ad78e827f61df546b32bbc19e17ae8584a9c","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-16 06:31:41.000000000","message":"Patch Set 2:\n\nHi,\n\nDo you mean you drop sqlalchemy-filters instead of using code from aodh? Anyway, could you upload your workaround to check whole of tests are passed?\n\nThanks","accounts_in_message":[],"_revision_number":2},{"id":"fa2a0036b31d75c2597a6bf10b4c7e34cccbcb6d","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 07:23:08.000000000","message":"Uploaded patch set 3.","accounts_in_message":[],"_revision_number":3},{"id":"b853ba7a20efa83408128268af9a49364ae52865","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 07:26:17.000000000","message":"Patch Set 3:\n\n\u003e Patch Set 2:\n\u003e \n\u003e Hi,\n\u003e \n\u003e Do you mean you drop sqlalchemy-filters instead of using code from aodh? Anyway, could you upload your workaround to check whole of tests are passed?\n\u003e \n\u003e Thanks\n\nPlease check patch set 3 for dropping \"sqlalchemy-filters\" changes.","accounts_in_message":[],"_revision_number":3},{"id":"c269263a6ff008b8d1fce8a7541536ec0d0d79e5","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-16 08:49:39.000000000","message":"Patch Set 3: Code-Review-1\n\nI\u0027ve tested your patch and confirmed to work well on my local env. Your approach is smarter than I expected! But I\u0027d like to ask you one more thing is to drop sqlalchemy-filters itself.\n\nI checked where this library is used, and here is a list of the dependency. I think you\u0027ve dropped all of them, and no need to install sqlalchemy-filters anymore.\n\n./tacker/objects/vnf_lcm_op_occs.py:21:from sqlalchemy_filters import apply_filters\n./tacker/objects/vnf_lcm_subscriptions.py:19:from sqlalchemy_filters import apply_filters\n./tacker/objects/vnf_package.py:25:from sqlalchemy_filters import apply_filters\n./tacker/objects/vnf_instance.py:23:from sqlalchemy_filters import apply_filters\n\nThanks","accounts_in_message":[],"_revision_number":3},{"id":"058d26be0569170363d519a40cb3f1a750b0a9b1","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-16 08:54:42.000000000","message":"Patch Set 3:\n\nAs additional info, there are few projects using sqlalchemy-filters and it\u0027s not maintained so actively now. So, it seems better to drop it in tacker ASAP if possible.","accounts_in_message":[],"_revision_number":3},{"id":"bb2dbca9aef4503566b13975169869c56c093a16","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-16 10:32:16.000000000","message":"Patch Set 3: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d7ca02941fbf44e5acd9affda2106158 : SUCCESS in 11m 52s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/9f1909bc9ff041ccb74266c830842c6d : SUCCESS in 17m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3e4be82cf801458a841e1c95956c4d82 : SUCCESS in 5m 52s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/dfd25a65eea547e59ab0a9ad160c5469 : SUCCESS in 14m 27s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ddc0a13f041642b0b80454001f641e48 : SUCCESS in 17m 06s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2cfb101fd3c04ff9afa41c222324b600 : SUCCESS in 15m 19s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5341fc67217840b18b94816d25c962a9 : FAILURE in 7m 11s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/ad9538c4d10e40cb8febdb6cb338e8b6 : FAILURE in 2h 48m 25s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/a1bc7ba9272b46eb9c891b0574867178 : TIMED_OUT in 3h 06m 40s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/748ab0563ade4fdf98e91e81f80d83df : SUCCESS in 1h 17m 18s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/44067014e4cb4156b28b22c64cb476db : SUCCESS in 1h 21m 53s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/22c824c2171048ae9f91de9dc0cb69bc : FAILURE in 2h 44m 45s","accounts_in_message":[],"_revision_number":3},{"id":"22215d67984195835758ce6a63302b9053fc3f9a","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-16 15:48:47.000000000","message":"Patch Set 3:\n\nrecheck","accounts_in_message":[],"_revision_number":3},{"id":"feea29b2a8531d139567b2a7ae82f67688048ca9","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 16:25:45.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"02c19ba0a49b1873da3edeb6542578a938299e04","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 18:13:21.000000000","message":"Patch Set 4:\n\n\u003e Patch Set 3: Code-Review-1\n\u003e \n\u003e I\u0027ve tested your patch and confirmed to work well on my local env. Your approach is smarter than I expected! But I\u0027d like to ask you one more thing is to drop sqlalchemy-filters itself.\n\u003e \n\u003e I checked where this library is used, and here is a list of the dependency. I think you\u0027ve dropped all of them, and no need to install sqlalchemy-filters anymore.\n\u003e \n\u003e ./tacker/objects/vnf_lcm_op_occs.py:21:from sqlalchemy_filters import apply_filters\n\u003e ./tacker/objects/vnf_lcm_subscriptions.py:19:from sqlalchemy_filters import apply_filters\n\u003e ./tacker/objects/vnf_package.py:25:from sqlalchemy_filters import apply_filters\n\u003e ./tacker/objects/vnf_instance.py:23:from sqlalchemy_filters import apply_filters\n\u003e \n\u003e Thanks\n\nDone!!!\nPlease check PatchSet 4.\nThanks.","accounts_in_message":[],"_revision_number":4},{"id":"eba0cde4fc8df51f3a1b0f58b656dbe4554c8896","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-16 19:36:11.000000000","message":"Patch Set 4: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/da34dc44cc7c49b2a3547282d5961663 : SUCCESS in 4m 51s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/14782c20fde94044bd3168d2fd0c8151 : SUCCESS in 8m 31s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/ebd5278067524c2ab9cef3b67601d77b : SUCCESS in 17m 35s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/25dd089979d84bd1a0d9bc20e314bdd4 : SUCCESS in 5m 23s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/7b671c2cf189413499fbb5ce1d714afc : SUCCESS in 14m 20s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bfefbee17a0743fabb455136ec65ba0a : SUCCESS in 14m 42s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/17139eddd9dc4942a9f5d8ce343fe525 : SUCCESS in 14m 32s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/16bd91144bea46f28ecec46eab7c7234 : SUCCESS in 6m 55s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/8ce332cf340a43f7be484161ce351d48 : FAILURE in 2h 50m 24s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/99086106c3ae44b99135589fdbf09153 : TIMED_OUT in 3h 05m 43s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/59bfb705d0214deab76ac6b6beca60d3 : SUCCESS in 1h 32m 34s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/b197c29eed344b57803fad048359f6c0 : SUCCESS in 1h 17m 35s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/1438bc8d3bb94f49bc4cbd83151c4b11 : FAILURE in 2h 50m 31s","accounts_in_message":[],"_revision_number":4},{"id":"4780d9d792620139fbe6c334a026505eb64ec447","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-16 22:12:52.000000000","message":"Patch Set 4:\n\nrecheck","accounts_in_message":[],"_revision_number":4},{"id":"e7db285b7136bd020026717db54447d61035df0e","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-17 01:21:51.000000000","message":"Patch Set 4:\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/fad7c4716f2b4f9fa590d3df8ed52f06 : SUCCESS in 4m 44s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/e6011e3d34754d29b65af04fc51fb75d : SUCCESS in 10m 14s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/5dca85cecf1841a59196c0375c7f16e3 : SUCCESS in 16m 10s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a4a7cd48b9154b3792d64804e337a700 : SUCCESS in 5m 43s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/ab2e02d2b8c04f9db911c383739ea162 : SUCCESS in 14m 16s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/e1279bc32dd948218ae02f1a3660118b : SUCCESS in 14m 07s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/313f141a9476479f9b66d404441c8558 : SUCCESS in 14m 18s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e9684795abaa40fb8ef827006a8f5700 : SUCCESS in 7m 00s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/5abe39ed04ed4e138fb6bcd05de56c8b : FAILURE in 2h 47m 56s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/0a2de43d5435430eb17e5a0d72dafb04 : TIMED_OUT in 3h 05m 56s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/b16636b9f2b748bcbf64962f991776f8 : SUCCESS in 58m 18s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/47c418b02833494cbd9b20f83377113d : SUCCESS in 1h 07m 43s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/10c01386672146598b0985cb7e1415b7 : FAILURE in 2h 45m 30s","accounts_in_message":[],"_revision_number":4},{"id":"77e100a7766e1d6124c5b7c660719e635441bd78","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-17 04:16:25.000000000","message":"Patch Set 4:\n\nrecheck","accounts_in_message":[],"_revision_number":4},{"id":"227686fe9f75de2c6da98d1caf97a4250655ed4d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-17 07:24:14.000000000","message":"Patch Set 4:\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/9bfbf0cd55624f50be4c913b3581c28f : SUCCESS in 3m 26s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/7e6c1468bcd944d78a151580f855e518 : SUCCESS in 9m 14s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/6c491d2ad1b549f79da8adcf7bfa28da : SUCCESS in 17m 08s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/215c7f9d163e458892de4a2b617a26d6 : SUCCESS in 5m 26s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/6fe6b0a151f848399ac8337ff3e4e412 : SUCCESS in 18m 04s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d74ce25c7103478aa2649d2e9f1c78a7 : SUCCESS in 13m 40s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/a45e5d933e684e8a9c2da6ace743a39d : SUCCESS in 13m 21s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/3f8b1850bef94d4eb409e8f40ddd907c : SUCCESS in 6m 09s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/e7523479684c4823830c67eae26491d8 : FAILURE in 2h 49m 34s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/8c6300eb273040c19d206a2b0ff7357a : TIMED_OUT in 3h 05m 53s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/2abbd1eeb1bb4396a0dc07f3045dd471 : SUCCESS in 1h 08m 30s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/4fc58f43965d4ca291a2a179f26c8b46 : SUCCESS in 1h 09m 51s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/bd923ef7c2e44529809a515e2759f8d0 : FAILURE in 2h 49m 08s","accounts_in_message":[],"_revision_number":4},{"id":"d3030e8a6e4abc8f4fc562d6f7c567ec62f6a08a","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-17 10:26:33.000000000","message":"Patch Set 4:\n\nrecheck","accounts_in_message":[],"_revision_number":4},{"id":"106d90a79bcf1cbcc2a85e2797b92cec6c3ffc47","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-17 13:40:19.000000000","message":"Patch Set 4:\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/c3ca5e0b7f2b4ff0a2a7bcd2dbd7de9a : SUCCESS in 4m 25s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/b4c7aade36f34b038e314b85e1a94e95 : SUCCESS in 10m 05s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/93881c7a6cc647d990e3910741b152fd : SUCCESS in 18m 50s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a74506a96bf64dedb7d08a299faad4d1 : SUCCESS in 6m 28s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/aa2d0df78a634453957accdfb8c15e84 : SUCCESS in 15m 48s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/206c7c223e5f47e8a5e5e932c095194a : SUCCESS in 14m 31s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/3804167b8661452a82bf4a1cb7387c40 : SUCCESS in 16m 28s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c43643afdd3d4535b65c359df9338f55 : SUCCESS in 7m 43s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/95f3b8e79e7f4635b8d5a44ee85673a0 : FAILURE in 2h 50m 29s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/54b00fff7be64c369e774c8550b880fa : TIMED_OUT in 3h 07m 06s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/8db0aed5a93b482b95e6131520621560 : SUCCESS in 1h 07m 40s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/6c95a0b52d4344e3b50f9a26a4ea2426 : SUCCESS in 1h 14m 35s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/8fe7967e609642f99da10f7e4aa45fd5 : FAILURE in 2h 57m 18s","accounts_in_message":[],"_revision_number":4},{"id":"3cc2d96933d619fe7c950d7b03ca3720c4b8b409","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-06-18 03:11:28.000000000","message":"Patch Set 4:\n\nThanks for your patch.\n\nYou may have already been investigated, but there seems to be some error in aodh.\nhttps://zuul.opendev.org/t/openstack/build/95f3b8e79e7f4635b8d5a44ee85673a0/log/controller/logs/screen-h-eng.txt?severity\u003d4\nI checked the log of aodh a little, but I didn\u0027t know the cause.\nUmm.. I don\u0027t think recheck can fix it..\n\n```\nINFO heat.engine.resource [None req-f47682f2-a27e-4641-a433-f95d367dec70 nfv None] CREATE: EventAlarm \"ALL_maintenance\" Stack \"test_tosca_vnf_with_cirros_inline_6ed3d85c-0918-497c-9839-e9f0daeeee86\" [42a10813-1a8a-432d-9dc3-a889807f34e7]\nERROR heat.engine.resource Traceback (most recent call last):\nERROR heat.engine.resource   File \"/opt/stack/heat/heat/engine/resource.py\", line 916, in _action_recorder\nERROR heat.engine.resource     yield\nERROR heat.engine.resource   File \"/opt/stack/heat/heat/engine/resource.py\", line 1028, in _do_action\nERROR heat.engine.resource     yield from self.action_handler_task(action, args\u003dhandler_args)\nERROR heat.engine.resource   File \"/opt/stack/heat/heat/engine/resource.py\", line 970, in action_handler_task\nERROR heat.engine.resource     handler_data \u003d handler(*args)\nERROR heat.engine.resource   File \"/opt/stack/heat/heat/engine/resources/openstack/aodh/alarm.py\", line 319, in handle_create\nERROR heat.engine.resource     alarm \u003d self.client().alarm.create(props)\nERROR heat.engine.resource   File \"/usr/local/lib/python3.8/dist-packages/aodhclient/v2/alarm.py\", line 100, in create\nERROR heat.engine.resource     return self._post(\nERROR heat.engine.resource   File \"/usr/local/lib/python3.8/dist-packages/aodhclient/v2/base.py\", line 41, in _post\nERROR heat.engine.resource     return self.client.api.post(*args, **kwargs)\nERROR heat.engine.resource   File \"/usr/local/lib/python3.8/dist-packages/keystoneauth1/adapter.py\", line 401, in post\nERROR heat.engine.resource     return self.request(url, \u0027POST\u0027, **kwargs)\nERROR heat.engine.resource   File \"/usr/local/lib/python3.8/dist-packages/aodhclient/client.py\", line 40, in request\nERROR heat.engine.resource     raise exceptions.from_response(resp, url, method)\nERROR heat.engine.resource aodhclient.exceptions.ClientException: \u003c!DOCTYPE HTML PUBLIC \"-//IETF//DTD HTML 2.0//EN\"\u003e\nERROR heat.engine.resource \u003chtml\u003e\u003chead\u003e\nERROR heat.engine.resource \u003ctitle\u003e500 Internal Server Error\u003c/title\u003e\nERROR heat.engine.resource \u003c/head\u003e\u003cbody\u003e\nERROR heat.engine.resource \u003ch1\u003eInternal Server Error\u003c/h1\u003e\nERROR heat.engine.resource \u003cp\u003eThe server encountered an internal error or\nERROR heat.engine.resource misconfiguration and was unable to complete\nERROR heat.engine.resource your request.\u003c/p\u003e\nERROR heat.engine.resource \u003cp\u003ePlease contact the server administrator at\nERROR heat.engine.resource  [no address given] to inform them of the time this error occurred,\nERROR heat.engine.resource  and the actions you performed just before this error.\u003c/p\u003e\nERROR heat.engine.resource \u003cp\u003eMore information about this error may be available\nERROR heat.engine.resource in the server error log.\u003c/p\u003e\nERROR heat.engine.resource \u003chr\u003e\nERROR heat.engine.resource \u003caddress\u003eApache/2.4.41 (Ubuntu) Server at 198.72.124.140 Port 8042\u003c/address\u003e\nERROR heat.engine.resource \u003c/body\u003e\u003c/html\u003e\nERROR heat.engine.resource  (HTTP 500)\nERROR heat.engine.resource \n```","accounts_in_message":[],"_revision_number":4},{"id":"810afa5a11812da7644b22f059b97a89112929a6","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-06-25 00:29:48.000000000","message":"Patch Set 4:\n\nHi, the multinode-sol job seems to have other problems.\nI\u0027m trying it to fix in my test patch. It becomes a little better, but I haven\u0027t completely fixed yet.\nhttps://review.opendev.org/c/openstack/tacker/+/797809\n\nIt is on the way, but it is information sharing. Thanks.","accounts_in_message":[],"_revision_number":4},{"id":"cc4184bceefa6f79310aa890ac8d7da118337c09","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-06-25 07:51:54.000000000","message":"Patch Set 4:\n\n(1 comment)\n\nI found some code that might be related to some of the errors. Please confirm.","accounts_in_message":[],"_revision_number":4},{"id":"8777eec19b3863f692a5702bfa5a1274a75ca520","tag":"autogenerated:gerrit:deleteReviewer","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-28 09:37:56.000000000","message":"Removed reviewer Ghanshyam.","accounts_in_message":[],"_revision_number":4},{"id":"0146016d16002d1566a5112b27feac47926cb041","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-28 12:45:02.000000000","message":"Uploaded patch set 5.","accounts_in_message":[],"_revision_number":5},{"id":"be105079e1f880b172a8fbfe87ec636b580802d8","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-28 15:55:25.000000000","message":"Patch Set 5: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/2ad6dc3cf97343639d23a1fc32c7b190 : SUCCESS in 5m 28s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/eee9d62a2e0341848856146aa10cb033 : SUCCESS in 10m 11s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/7075997b92d74e7a83f2b126bba76eb5 : SUCCESS in 20m 16s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/90b49557aaaf45aab5493e3d1fdb4996 : SUCCESS in 7m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/d87a138c38104b1ab2d7e9f08d573c6a : SUCCESS in 16m 17s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/37c357a2634b4f8ab44e36680c5ff28a : SUCCESS in 16m 28s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/6dbb8bafce5843dc8dfbc32b1e3353c9 : SUCCESS in 16m 59s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/280d6b3e6b79488c93064eb15e7dc51c : SUCCESS in 8m 51s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/a3805b897cf84c79ad6caf2569e485c1 : FAILURE in 2h 48m 58s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/6f612938fe994ed299f1ab3bf5646f31 : TIMED_OUT in 3h 06m 07s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/58b1db297d6a4519afd123f0336df30d : SUCCESS in 1h 31m 11s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/5600ab87f41947f49e9614a5732bbec5 : SUCCESS in 1h 13m 44s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/1a76ea45edc24cf7b8378188be15e2b0 : FAILURE in 2h 51m 46s","accounts_in_message":[],"_revision_number":5},{"id":"adab2e1bf507adf71586efa6311dbe5244a360cc","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-28 17:42:55.000000000","message":"Patch Set 5:\n\nHi,\n\nThere are several failures for matching status, expected to be `ACTIVE` but `ERROR`, I\u0027m not sure why the reason. I think it might be because of your change and we might need to consider other way to fix the issue. Anyway, could you share your thinking in the next IRC today? Thanks!","accounts_in_message":[],"_revision_number":5},{"id":"228eebe9e713f9ee084f1e6156c677f879756543","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-29 08:17:26.000000000","message":"Uploaded patch set 6.","accounts_in_message":[],"_revision_number":6},{"id":"18043783a0b78d84500ee11aee0acdeeb73e3978","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-06-29 08:46:39.000000000","message":"Patch Set 6:\n\nSorry, I\u0027ve uploaded my change on your PS wrongly. Please overwrite again if my change doesn\u0027t work.","accounts_in_message":[],"_revision_number":6},{"id":"6606b8d77cff775590a5ad3580d0bd2ac40838e6","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-29 11:33:25.000000000","message":"Patch Set 6: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- build-openstack-api-ref https://zuul.opendev.org/t/openstack/build/aeca7049ea1e4ef3a6a3e7e8b0539c11 : SUCCESS in 7m 26s\n- requirements-check https://zuul.opendev.org/t/openstack/build/54c38b0d898340e3adc767cf39c57cec : SUCCESS in 6m 05s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/f19e14fbbc174ba0956b2ea4b97beb30 : SUCCESS in 10m 17s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/7c7b7e0630204d69ab0fc0c48ca7a7e1 : SUCCESS in 18m 56s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/93d249954fd54548b133d3604ca30d78 : SUCCESS in 9m 01s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/148c690d891f486eb96460fdfa72d198 : SUCCESS in 15m 56s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/63f9b121f6cc40af9e1119de4229c26e : SUCCESS in 15m 59s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/43ed2d9f041a4a4aad084658c12dbef0 : SUCCESS in 17m 53s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/43ca0bf82fe5433cb87aa447b3f9f442 : SUCCESS in 9m 35s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/3d91be940f93471e9f5cabab038cd3e8 : FAILURE in 2h 55m 01s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/e5219f94ae094ea2baea37db8725ac53 : TIMED_OUT in 3h 07m 03s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/9fd4ade0aefc438fa0ab6dee872e048b : SUCCESS in 1h 35m 27s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/cc83915577e648038dba36c5e3d2ba20 : SUCCESS in 1h 24m 20s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/021414f500424cb29edfa6d624ab5e82 : FAILURE in 2h 54m 09s","accounts_in_message":[],"_revision_number":6},{"id":"06c042257b5c32a878eb33ce54e757331ef774e6","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-06-30 00:59:31.000000000","message":"Patch Set 6:\n\n(1 comment)\n\nHi, Yasufumi-san and Manpreet-san.\n\nSeems to occur checksum verification error caused by changing cirros image version on multinode-sol job.\n\n```\nJun 29 09:19:08.508083 ubuntu-focal-inap-mtl01-0025314572 tacker-conductor[63784]: 2021-06-29 09:19:08.507 ERROR tacker.vnfm.infra_drivers.openstack.openstack [req-eecf1e18-3d81-4f90-9e24-0fc14ce52f02 nfv_user nfv] Image Software of VDU1 not active for vnf 69b1b3b9-561f-4f41-879f-2fdc73f92ad3 error: Image 62e11a01-bd1f-445a-b26e-57e44df31a83 checksum verification failed. Glance calculated checksum is sha512:6b813aa46bb90b4da216a4d19376593fa3f4fc7e617f03a92b7fe11e9a3981cbe8f0959dbebe36225e5f53dc4492341a4863cac4ed1ee0909f3fc78ef9c3e869. Checksum in VNFD is sha-512:6513f21e44aa3da349f248188a44bc304a3653a04122d8fb4535423c8e1d14cd6a153f735bb0982e2161b5b5186106570c17a9e58b64dd39390617cd5a350f78.: Exception: Image 62e11a01-bd1f-445a-b26e-57e44df31a83 checksum verification failed. Glance calculated checksum is sha512:6b813aa46bb90b4da216a4d19376593fa3f4fc7e617f03a92b7fe11e9a3981cbe8f0959dbebe36225e5f53dc4492341a4863cac4ed1ee0909f3fc78ef9c3e869. Checksum in VNFD is sha-512:6513f21e44aa3da349f248188a44bc304a3653a04122d8fb4535423c8e1d14cd6a153f735bb0982e2161b5b5186106570c17a9e58b64dd39390617cd5a350f78.\n```\n\nI think it is necessary to change value of hash or revert change of patchset6.","accounts_in_message":[],"_revision_number":6},{"id":"b0549365d580d574172f88f77636fa4a24d34bcb","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-30 02:00:14.000000000","message":"Uploaded patch set 7.","accounts_in_message":[],"_revision_number":7},{"id":"2e123f51cf6824ff86a602318e90980f34578f93","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-06-30 04:49:54.000000000","message":"Uploaded patch set 8.","accounts_in_message":[],"_revision_number":8},{"id":"41f8ff20506d3321b0ed539e8f777f5f497f11b4","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-06-30 08:02:20.000000000","message":"Patch Set 8: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/e1236ed9ee9e4e70928476f45fb822f8 : SUCCESS in 4m 52s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/1e02c276c40c4791a2b36ec9c0becfc1 : SUCCESS in 9m 24s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/2f037bed4edf41da9836d5b04bff7c3e : SUCCESS in 18m 51s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ce947feb2dc947bb9e76a79966c25098 : SUCCESS in 6m 46s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/560059ec03d248d49973f52f09449361 : SUCCESS in 15m 45s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9ea3a8c530ad422190b2f389c8af9ba2 : SUCCESS in 15m 52s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/5ba49cc5f3f844269684282ff1fe99ff : SUCCESS in 16m 19s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/3b4e1417b7184a9eb45d9f70c8190a91 : SUCCESS in 8m 31s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/a8eba178e1b74c849501ae0571e5db93 : FAILURE in 3h 01m 42s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/2d18362020174ca7a864905b84110fd7 : TIMED_OUT in 3h 06m 19s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/82b591b5a9a6468e98bf7d031798335e : SUCCESS in 1h 25m 11s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/b52f291204db41c8813eb046a76a22ae : SUCCESS in 1h 26m 08s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/b13314f57afc4724ab5e0cad07eb0f4d : FAILURE in 2h 56m 58s","accounts_in_message":[],"_revision_number":8},{"id":"e536f9573d5a2a715e66257e0d8790d7f6faf8bb","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-05 16:18:31.000000000","message":"Uploaded patch set 9.","accounts_in_message":[],"_revision_number":9},{"id":"2673ef13463c7f341b3e53147505f1807f6078a8","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-05 19:29:32.000000000","message":"Patch Set 9: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/c5a15a7c691f4b509b7e86c11a723a07 : SUCCESS in 3m 39s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/c563555d14e94e2a9be3678caaaaeb6e : SUCCESS in 8m 09s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a260f612b2fa4a6fa35309bb994722c3 : SUCCESS in 17m 25s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1bbe21450fc54e88bd83eb4b7f826189 : SUCCESS in 5m 45s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/9d8938ab343c4d25a0964c8876206fe0 : SUCCESS in 14m 49s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ea3d01c5d0b34a11bf8a1111a17260e0 : SUCCESS in 14m 17s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/720c81946a4d403fbc324acc2f7506f6 : SUCCESS in 14m 43s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/82c690948a014317a41753d14cd55efe : SUCCESS in 7m 59s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/701fa35fcb97448e808699a5d4672828 : FAILURE in 2h 55m 44s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/0ff2c7f41c924790a7305c0aa6056721 : TIMED_OUT in 3h 04m 41s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/40e3ed10157e42cfa9a69df81a38685c : SUCCESS in 1h 24m 25s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/ea25da603af04377b53a6053b98216a8 : SUCCESS in 1h 26m 44s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/31ae8957064c46e9a27a252366e39539 : FAILURE in 2h 55m 38s","accounts_in_message":[],"_revision_number":9},{"id":"3f9c5124296f8fcde92f2900beaf6491b9fff2ef","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-08 13:27:43.000000000","message":"Patch Set 9:\n\nThe multinode-legacy job error seems to be fixed by applying the following patches of aodh.\nhttps://review.opendev.org/c/openstack/aodh/+/799651\n\nI tried it to apply by adding \"depends-on\" comment  to commit message in my test patch and it worked.\nI just wanted to inform you. Thanks.","accounts_in_message":[],"_revision_number":9},{"id":"89eb2c0f1e1b51ee85e2cce0e5c03cca0e4f3ed9","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-08 14:03:33.000000000","message":"Patch Set 9:\n\n\u003e Patch Set 9:\n\u003e \n\u003e The multinode-legacy job error seems to be fixed by applying the following patches of aodh.\n\u003e https://review.opendev.org/c/openstack/aodh/+/799651\n\u003e \n\u003e I tried it to apply by adding \"depends-on\" comment  to commit message in my test patch and it worked.\n\u003e I just wanted to inform you. Thanks.\n\nThank you so much Ueha san for sharing information.\nMeanwhile shall I prepare this patch by merging your test patch changes.\nPlease share your opinion.\n\nThanks!","accounts_in_message":[],"_revision_number":9},{"id":"bd88a915e38def7f91e0078a8108846ea1002482","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-08 14:37:40.000000000","message":"Patch Set 9:\n\n\u003e Thank you so much Ueha san for sharing information.\n\u003e Meanwhile shall I prepare this patch by merging your test patch changes.\n\u003e Please share your opinion.\n\u003e \n\u003e Thanks!\n\nYes, I think good to apply the fix of my test patch and wait for the aodh patch is merged.\n\nIt is recognized that the multinode-legacy error is due to the aodh error and has nothing relation with SQLAlchemy migration.\nBy applying my patch changes, I think we don\u0027t have to wait for the SQLAlchemy issue to be fixed as we disscussed in irc this week.","accounts_in_message":[],"_revision_number":9},{"id":"34d003e7fbe03758f9cb6d2b7372589fcf2fc585","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-08 15:39:32.000000000","message":"Uploaded patch set 10.","accounts_in_message":[],"_revision_number":10},{"id":"df25c53b1e59ddf34a44c9fcaad6faa769b3b0bd","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-08 17:23:58.000000000","message":"Patch Set 10:\n\n\u003e Patch Set 9:\n\u003e \n\u003e \u003e Thank you so much Ueha san for sharing information.\n\u003e \u003e Meanwhile shall I prepare this patch by merging your test patch changes.\n\u003e \u003e Please share your opinion.\n\u003e \u003e \n\u003e \u003e Thanks!\n\u003e \n\u003e Yes, I think good to apply the fix of my test patch and wait for the aodh patch is merged.\n\u003e \n\u003e It is recognized that the multinode-legacy error is due to the aodh error and has nothing relation with SQLAlchemy migration.\n\u003e By applying my patch changes, I think we don\u0027t have to wait for the SQLAlchemy issue to be fixed as we disscussed in irc this week.\n\nThanks for revert. I have uploaded Patchset 10 with merged changes. \nYes, we are good to go without sqlalchemy_filters update.","accounts_in_message":[],"_revision_number":10},{"id":"24181f6916697d3bb504839c177eb6b11c79789b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-08 18:23:40.000000000","message":"Patch Set 10: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/6c297ad70a7e4b6881e95f296e5ce2fd : SUCCESS in 4m 45s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/37b37e3c434a4ef58c79e0b4236ae1f5 : SUCCESS in 8m 55s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/f7ba4587443046b280c4b1cdb80decd9 : SUCCESS in 17m 15s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/13d4abc7bbc54ec49020b2d5b4244930 : SUCCESS in 5m 44s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/978a2bbf6dea449ab12245f0908a212a : SUCCESS in 14m 07s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/0bd925cce0d04bfbb20eecfb318a6739 : SUCCESS in 14m 42s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2da0a537f9a54405af9627c3e333ed62 : SUCCESS in 14m 43s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/59860df168db4eb6b8d825fa7080555b : SUCCESS in 7m 27s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/c84d3b22c2204a3fb11a7d9a0b1f6d6f : SUCCESS in 1h 55m 58s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/bce8351eb9b149328ee46f4285e34e55 : SUCCESS in 2h 41m 36s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/3e3be793a89443b6be68db2af33a0efb : SUCCESS in 1h 20m 51s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/d70f70a59f9f40409e9e6b0cc285d452 : SUCCESS in 1h 16m 06s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/4d442c346a474afcbb67e77797738c3d : FAILURE in 1h 37m 28s","accounts_in_message":[],"_revision_number":10},{"id":"9cc837c3569eaa3e01122d4f659772199cfdd25d","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-08 18:27:04.000000000","message":"Patch Set 10:\n\nrecheck","accounts_in_message":[],"_revision_number":10},{"id":"f61fa4de34b7b113e399ca6e7dab45c48cd5513a","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-08 21:20:00.000000000","message":"Patch Set 10: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/ca0a75b7a38d47c8aefdc75a83968662 : SUCCESS in 3m 36s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/8438982311df4a21a12b55457a3627bd : SUCCESS in 7m 37s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/b1b295d5590d4f5aa88faa48f0dd1f04 : SUCCESS in 17m 13s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/256831a670bd4e72bd5bb8c233262747 : SUCCESS in 5m 24s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/0e9de4eccea94a28a1288101f6453014 : SUCCESS in 14m 42s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bafc87a2ff2f4d378fd149b9650e5959 : SUCCESS in 14m 11s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/6bb4e1ba5f924f4eb591eac27fbcb60e : SUCCESS in 15m 14s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/acdd2c8def6b4913849fb435e0dc8e18 : SUCCESS in 7m 11s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/2cc68f87ef9945e9bac1a056320cd62a : SUCCESS in 1h 50m 34s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/9506493af91d4962b32eb4320429e8a6 : SUCCESS in 2h 46m 15s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/8fcb3cde562a450cb63119d7f09b3825 : SUCCESS in 1h 11m 47s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/81b3b0bb3fdc4ab39f0db8d5e95d9e43 : SUCCESS in 1h 17m 33s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/e008afe3ed424aa5a99cfb67d9577f60 : SUCCESS in 1h 48m 30s","accounts_in_message":[],"_revision_number":10},{"id":"c3888d04cf7662204b4b5fbff0b60bff3fdaf0a1","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-09 01:04:37.000000000","message":"Patch Set 10:\n\n\u003e Patch Set 10:\n\u003e \n\u003e \u003e Patch Set 9:\n\u003e \u003e \n\u003e \u003e \u003e Thank you so much Ueha san for sharing information.\n\u003e \u003e \u003e Meanwhile shall I prepare this patch by merging your test patch changes.\n\u003e \u003e \u003e Please share your opinion.\n\u003e \u003e \u003e \n\u003e \u003e \u003e Thanks!\n\u003e \u003e \n\u003e \u003e Yes, I think good to apply the fix of my test patch and wait for the aodh patch is merged.\n\u003e \u003e \n\u003e \u003e It is recognized that the multinode-legacy error is due to the aodh error and has nothing relation with SQLAlchemy migration.\n\u003e \u003e By applying my patch changes, I think we don\u0027t have to wait for the SQLAlchemy issue to be fixed as we disscussed in irc this week.\n\u003e \n\u003e Thanks for revert. I have uploaded Patchset 10 with merged changes. \n\u003e Yes, we are good to go without sqlalchemy_filters update.\n\nThanks for your quick patch! It\u0027s great to be Zuul+1!\n\nBTW, is this patch mergeable if \"Depends-On\" is set?\nDo we need to wait for aodh patches to merge? Does anyone know?","accounts_in_message":[],"_revision_number":10},{"id":"d014d1e7568795712ad32d6b274bcdb0b7b0768a","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-09 02:37:29.000000000","message":"Patch Set 10:\n\n\u003e Patch Set 10:\n\u003e \n\u003e \u003e Patch Set 10:\n\u003e \u003e \n\u003e \u003e \u003e Patch Set 9:\n\u003e \u003e \u003e \n\u003e \u003e \u003e \u003e Thank you so much Ueha san for sharing information.\n\u003e \u003e \u003e \u003e Meanwhile shall I prepare this patch by merging your test patch changes.\n\u003e \u003e \u003e \u003e Please share your opinion.\n\u003e \u003e \u003e \u003e \n\u003e \u003e \u003e \u003e Thanks!\n\u003e \u003e \u003e \n\u003e \u003e \u003e Yes, I think good to apply the fix of my test patch and wait for the aodh patch is merged.\n\u003e \u003e \u003e \n\u003e \u003e \u003e It is recognized that the multinode-legacy error is due to the aodh error and has nothing relation with SQLAlchemy migration.\n\u003e \u003e \u003e By applying my patch changes, I think we don\u0027t have to wait for the SQLAlchemy issue to be fixed as we disscussed in irc this week.\n\u003e \u003e \n\u003e \u003e Thanks for revert. I have uploaded Patchset 10 with merged changes. \n\u003e \u003e Yes, we are good to go without sqlalchemy_filters update.\n\u003e \n\u003e Thanks for your quick patch! It\u0027s great to be Zuul+1!\n\u003e \n\u003e BTW, is this patch mergeable if \"Depends-On\" is set?\n\u003e Do we need to wait for aodh patches to merge? Does anyone know?\n\nIt\u0027s the first time to depend on the tag, so I\u0027m not sure actually. In my opinion, we don\u0027t merge such a patch depends on another one which is not committed yet. However, the depending patch might not be merged soon because of some other problem in aodh itself and not related tacker. So, I think it\u0027s OK to merge it in this case as an exception.","accounts_in_message":[],"_revision_number":10},{"id":"23367aa80a579cbeeb46945eff09587b56329288","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-09 03:14:54.000000000","message":"Patch Set 10: Code-Review-1\n\n(5 comments)\n\nBy the way, we\u0027ve not reviewed enough this patch yet. Although we might not ensure this patch can be replaced with sqlalchemy-filters as Manpreed mentioned before, for example auto join or so, I\u0027d like to go it forward. Here are my comments. Thanks.","accounts_in_message":[],"_revision_number":10},{"id":"6a4eabd0cd35167e6eb08feb455c93b14322b036","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-09 07:45:43.000000000","message":"Patch Set 10:\n\n\u003e Patch Set 10:\n\u003e \n\u003e \u003e Patch Set 10:\n\u003e \u003e \n\u003e \u003e \u003e Patch Set 10:\n\u003e \u003e \u003e \n\u003e \u003e \u003e \u003e Patch Set 9:\n\u003e \u003e \u003e \u003e \n\u003e \u003e \u003e \u003e \u003e Thank you so much Ueha san for sharing information.\n\u003e \u003e \u003e \u003e \u003e Meanwhile shall I prepare this patch by merging your test patch changes.\n\u003e \u003e \u003e \u003e \u003e Please share your opinion.\n\u003e \u003e \u003e \u003e \u003e \n\u003e \u003e \u003e \u003e \u003e Thanks!\n\u003e \u003e \u003e \u003e \n\u003e \u003e \u003e \u003e Yes, I think good to apply the fix of my test patch and wait for the aodh patch is merged.\n\u003e \u003e \u003e \u003e \n\u003e \u003e \u003e \u003e It is recognized that the multinode-legacy error is due to the aodh error and has nothing relation with SQLAlchemy migration.\n\u003e \u003e \u003e \u003e By applying my patch changes, I think we don\u0027t have to wait for the SQLAlchemy issue to be fixed as we disscussed in irc this week.\n\u003e \u003e \u003e \n\u003e \u003e \u003e Thanks for revert. I have uploaded Patchset 10 with merged changes. \n\u003e \u003e \u003e Yes, we are good to go without sqlalchemy_filters update.\n\u003e \u003e \n\u003e \u003e Thanks for your quick patch! It\u0027s great to be Zuul+1!\n\u003e \u003e \n\u003e \u003e BTW, is this patch mergeable if \"Depends-On\" is set?\n\u003e \u003e Do we need to wait for aodh patches to merge? Does anyone know?\n\u003e \n\u003e It\u0027s the first time to depend on the tag, so I\u0027m not sure actually. In my opinion, we don\u0027t merge such a patch depends on another one which is not committed yet. However, the depending patch might not be merged soon because of some other problem in aodh itself and not related tacker. So, I think it\u0027s OK to merge it in this case as an exception.\n\nThanks for your reply, I agree with your thinking.\nI think there will be no problem if there is no abnormality during the merge after the review.\n(We may also need to add \"Depends-On\" to subsequent patches until the aodh patche is merged..)","accounts_in_message":[],"_revision_number":10},{"id":"e4ef9c2ca4d57ad0d12ed98e2c28aff9aa6462c6","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-09 08:31:45.000000000","message":"Patch Set 10: Code-Review-1\n\n(4 comments)\n\n\u003e Patch Set 10: Code-Review-1\n\u003e \n\u003e (5 comments)\n\u003e \n\u003e By the way, we\u0027ve not reviewed enough this patch yet. Although we might not ensure this patch can be replaced with sqlalchemy-filters as Manpreed mentioned before, for example auto join or so, I\u0027d like to go it forward. Here are my comments. Thanks.\n\nYasufumi-san, thanks for your review comments.\nSorry, Manpreet-san, could you fix my coding part too? Thanks.","accounts_in_message":[],"_revision_number":10},{"id":"8cbe39d5f53458cbbd56b058d4477329b21c6dc7","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-09 09:31:42.000000000","message":"Uploaded patch set 11.","accounts_in_message":[],"_revision_number":11},{"id":"091bd54cff87c3bde2b5d18467723a013dbff1f0","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-09 09:35:00.000000000","message":"Patch Set 11:\n\n(9 comments)\n\nThank you for review comments. Please find desired changes in Patchset 11.","accounts_in_message":[],"_revision_number":11},{"id":"bdaf06a9aa198f83c73b5ce3f4c5e1bcd73a1107","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-09 11:34:10.000000000","message":"Uploaded patch set 12.","accounts_in_message":[],"_revision_number":12},{"id":"08a4109c205f10f6c0f88bc7c89e9fc95b36bb42","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-09 12:02:05.000000000","message":"Patch Set 12: Verified-1\n\nThis change depends on a change that failed to merge.","accounts_in_message":[],"_revision_number":12},{"id":"9162eca5132671d79da974b6697d4b150a91e419","author":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"date":"2021-07-09 13:24:08.000000000","message":"Patch Set 12: Code-Review-1\n\nYou may want either to depend on https://review.opendev.org/c/openstack/aodh/+/800198 or just to remove the depends-on once that patch is merged.","accounts_in_message":[],"_revision_number":12},{"id":"05b7cefd286d2fc05c456df3490453d1fe72de8e","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-09 14:47:07.000000000","message":"Uploaded patch set 13: Commit message was updated.","accounts_in_message":[],"_revision_number":13},{"id":"ad71f0089a8883218d8eb54aab80dc8ba62f2bed","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-09 17:16:10.000000000","message":"Patch Set 13: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/fdf6a3808e194195995d34a00d91f046 : SUCCESS in 3m 25s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/902796e5485e4836b8414f5927f02a30 : SUCCESS in 8m 19s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/65e9186fd1124caca39dcaa1415e9dd6 : SUCCESS in 17m 16s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/6ce8b1cff6544974b3994fc3df783392 : SUCCESS in 5m 33s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f4a65ccfc6d04f8dabad2067b73db9ab : SUCCESS in 14m 23s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/fcb0ad0d7de14bb28e693abe5078d214 : SUCCESS in 14m 16s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/d736286cd8544bab910ad218efe3c6a6 : SUCCESS in 14m 40s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0fa67b9372ec4899a8273659fb22ee43 : SUCCESS in 6m 51s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/5cb6e083bb2a46a5be36301174367bd0 : SUCCESS in 1h 49m 46s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/551d78c0da3f438f8c38419bfd845ec9 : SUCCESS in 2h 22m 48s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/1bb416c43e2147b5955af645a36cee80 : SUCCESS in 1h 22m 37s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/fabebb15d0cf475c863d495accc84ec5 : SUCCESS in 1h 15m 38s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/18ce09dc51b24a06a38d012153bb9ac6 : SUCCESS in 1h 43m 01s","accounts_in_message":[],"_revision_number":13},{"id":"9641db74e857bfb57f9ca8dbb732014f999931f9","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-09 18:11:09.000000000","message":"Patch Set 13: Code-Review+2","accounts_in_message":[],"_revision_number":13},{"id":"fcb6c028fed2cb31207720cb0c8962ba09512024","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-09 23:57:08.000000000","message":"Patch Set 13: Code-Review-1\n\n(1 comment)\n\nSorry for late comment.","accounts_in_message":[],"_revision_number":13},{"id":"5952e6ef0333991be6cfb57babd5188f0c192192","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-10 00:50:16.000000000","message":"Uploaded patch set 14.","accounts_in_message":[],"_revision_number":14},{"id":"b7a1a57005ede789e60f998e55daa23b1fd2a3c5","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-10 00:56:00.000000000","message":"Patch Set 14:\n\n(1 comment)\n\nThanks Ueha san for your review comment. The changes will reflect in Patchset 14.","accounts_in_message":[],"_revision_number":14},{"id":"a2e9a4660af713c0ba30696ce06edda258e8913b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2021-07-10 01:21:29.000000000","message":"Uploaded patch set 15.","accounts_in_message":[],"_revision_number":15},{"id":"a7eaf0096e043c8ad529957abdb3c5000d37214a","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-10 03:37:54.000000000","message":"Patch Set 15: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/0e0a0a485e81445fac11636ac6862e92 : SUCCESS in 3m 35s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/2c15eba0a8464752be3b189e0fb45404 : SUCCESS in 10m 56s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/048d0d37707e4155b19c347baa9f6951 : SUCCESS in 16m 06s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/47f7a25e109e470caa781f8dcc06d47a : SUCCESS in 5m 15s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/a08eaa0182734c67be275a8664415109 : SUCCESS in 15m 24s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/e667c6b5cf7b4790b2131fbaa95b7757 : SUCCESS in 13m 55s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/060a2c823d014236a190fa1913131512 : SUCCESS in 13m 44s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a418184271124b80b48e2598472094fe : SUCCESS in 7m 12s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/272090c79b544323bf1fa4ac9d8c48d4 : SUCCESS in 1h 37m 43s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/11cfec0c2aa34090b95073435f493f9f : SUCCESS in 2h 14m 53s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/5480b840a348417baa49487d17d147c6 : SUCCESS in 1h 16m 41s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/d00e6bed010d478da52f750b8c2b6105 : SUCCESS in 1h 14m 30s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/2116636148714c4d9fdf445266a12833 : SUCCESS in 1h 52m 09s","accounts_in_message":[],"_revision_number":15},{"id":"b032dc547c09b568a35578d814441d29c16e9771","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2021-07-10 04:13:26.000000000","message":"Patch Set 15: Code-Review+1\n\n(1 comment)\n\nLGTM","accounts_in_message":[],"_revision_number":15},{"id":"201ed309910a19c97345d576978aa639f33edfb3","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-10 07:42:17.000000000","message":"Patch Set 15: Code-Review+2","accounts_in_message":[],"_revision_number":15},{"id":"f19fca7d940dd394b6cbae603deb98f4761ec195","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2021-07-12 10:35:30.000000000","message":"Patch Set 15:\n\nping","accounts_in_message":[],"_revision_number":15},{"id":"8041a2784f68b07f802257e47fa4bfe04b151588","author":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"date":"2021-07-12 15:32:43.000000000","message":"Patch Set 15: Code-Review+2 Workflow+1\n\nMany thanks!","accounts_in_message":[],"_revision_number":15},{"id":"c063a6ffa82ca87d1e5017a3b9b9e1c07057f76c","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-12 15:33:03.000000000","message":"Patch Set 15: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":15},{"id":"a9c2c71da7d3c8826dc5b1f8f141ea233dfe6c79","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-12 16:03:13.000000000","message":"Patch Set 15: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/ddb755058d5c44cebce4ed2233249a90 : SUCCESS in 3m 52s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/f558433fbc3a4fa49450068b5f0559db : SUCCESS in 25m 55s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/22baf28196bb4b089e79c5ab146bdb61 : SUCCESS in 5m 42s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/74ee5679aeba44d8b03e7b093b6d8831 : SUCCESS in 20m 57s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/eb301e9e1202410599fa61cf7c6f767c : SUCCESS in 22m 32s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/577e531f87014b52abc9ddb0f36a775a : SUCCESS in 7m 02s","accounts_in_message":[],"_revision_number":15},{"id":"907c3954c75ca05783273b8b7ca05b170f4a964a","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-12 16:03:14.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":15},{"id":"0b4a174053e553b8c2efeb774209a0c474f51932","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-12 16:04:49.000000000","message":"Patch Set 15:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/87786138ff0640e3880a81e42615fd08 : SUCCESS in 1m 17s","accounts_in_message":[],"_revision_number":15}],"current_revision_number":15,"current_revision":"e0c09499a68bb21fbcd27200dba49de6de336291","revisions":{"1692e8b2fcbcbf2618406942cf3efcfc50531cfb":{"kind":"REWORK","_number":1,"created":"2021-06-13 03:25:20.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/1"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:25:13.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1.Replace deprecated SQLAlchemy \"with_lockmode\" method.\n  The method was deprecated in sqlalchemy 0.9 [1][2]\n  and finally removed in version 1.4.\n  This patch replaces \"with_lockmode\" with new method\n  \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Fix SA Warning to enable/disable \"cache_ok\" flag.\n   Warning: SAWarning: TypeDecorator Uuid(length\u003d36) will\n   not produce a cache key because the ``cache_ok`` flag\n   is not set to True. Set this flag to True if this type\n   object\u0027s state is safe to use in a cache key, or False\n   to disable this warning.\n\n4. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1692e8b2fcbcbf2618406942cf3efcfc50531cfb"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1692e8b2fcbcbf2618406942cf3efcfc50531cfb"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"41ba98503d4b8eceebf77ce50483a23c9c01f2a0":{"kind":"REWORK","_number":2,"created":"2021-06-14 15:31:20.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/2"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-14 15:27:04.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Fix SA Warning to enable/disable \"cache_ok\" flag.\n   Warning: SAWarning: TypeDecorator Uuid(length\u003d36) will\n   not produce a cache key because the ``cache_ok`` flag\n   is not set to True. Set this flag to True if this type\n   object\u0027s state is safe to use in a cache key, or False\n   to disable this warning.\n\n4. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n5. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in VnfLcmOpOccs\n   table.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/41ba98503d4b8eceebf77ce50483a23c9c01f2a0"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/41ba98503d4b8eceebf77ce50483a23c9c01f2a0"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"c38a5102b9d5e26f5d52af439d1078917a5b20ed":{"kind":"REWORK","_number":3,"created":"2021-06-16 07:23:08.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/3"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-16 07:13:44.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Fix SA Warning to enable/disable \"cache_ok\" flag.\n   Warning: SAWarning: TypeDecorator Uuid(length\u003d36) will\n   not produce a cache key because the ``cache_ok`` flag\n   is not set to True. Set this flag to True if this type\n   object\u0027s state is safe to use in a cache key, or False\n   to disable this warning.\n\n4. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n5. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n6. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/c38a5102b9d5e26f5d52af439d1078917a5b20ed"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/c38a5102b9d5e26f5d52af439d1078917a5b20ed"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"43cd63aa0055a4e1c5ac98081cea504f619460d9":{"kind":"REWORK","_number":4,"created":"2021-06-16 16:25:45.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/4"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-16 16:19:03.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/43cd63aa0055a4e1c5ac98081cea504f619460d9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/43cd63aa0055a4e1c5ac98081cea504f619460d9"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"0375db2d53607dce99612b9e1132f2be35981435":{"kind":"REWORK","_number":5,"created":"2021-06-28 12:45:02.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/5","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/5","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/5 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/5 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/5 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/5"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-28 12:44:04.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/0375db2d53607dce99612b9e1132f2be35981435"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/0375db2d53607dce99612b9e1132f2be35981435"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"a49e5aa9a9060fb5ecebb89019bce7fc6afd9305":{"kind":"REWORK","_number":6,"created":"2021-06-29 08:17:26.000000000","uploader":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"ref":"refs/changes/60/796160/6","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/6","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/6 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/6 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/6 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/6"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","date":"2021-06-29 08:17:18.000000000","tz":0},"subject":"[WIP] Fix migration for sqlalchemy 1.4","message":"[WIP] Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nSigned-off-by: Yasufumi Ogawa \u003cyasufum.o@gmail.com\u003e\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/a49e5aa9a9060fb5ecebb89019bce7fc6afd9305"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/a49e5aa9a9060fb5ecebb89019bce7fc6afd9305"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"ef620300351308800803971ccd445b89b8fa84e7":{"kind":"REWORK","_number":7,"created":"2021-06-30 02:00:14.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/7","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/7","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/7 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/7 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/7 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/7"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-30 01:59:45.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/ef620300351308800803971ccd445b89b8fa84e7"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/ef620300351308800803971ccd445b89b8fa84e7"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"466dad415e22b4db1a3139f535809fbcf28cec49":{"kind":"REWORK","_number":8,"created":"2021-06-30 04:49:54.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/8","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/8","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/8 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/8 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/8 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/8"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-30 04:47:42.000000000","tz":330},"subject":"[WIP]Fix migration for sqlalchemy 1.4","message":"[WIP]Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/466dad415e22b4db1a3139f535809fbcf28cec49"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/466dad415e22b4db1a3139f535809fbcf28cec49"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"514514fcaf7b87c22a398895f61ccb95c47305c9":{"kind":"REWORK","_number":9,"created":"2021-07-05 16:18:31.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/9","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/9","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/9 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/9 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/9 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/9"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-05 16:17:47.000000000","tz":330},"subject":"[WIP]Fix migration for sqlalchemy 1.4","message":"[WIP]Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/514514fcaf7b87c22a398895f61ccb95c47305c9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/514514fcaf7b87c22a398895f61ccb95c47305c9"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"d182ff90fbb9d0f3b25c18a705ffbf92658f8873":{"kind":"REWORK","_number":10,"created":"2021-07-08 15:39:32.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/10","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/10","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/10 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/10 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/10 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/10"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-08 15:30:46.000000000","tz":330},"subject":"Fix migration for sqlalchemy 1.4","message":"Fix migration for sqlalchemy 1.4\n\nThis patch fixes a database migration for sqlalchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in sqlalchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nThe tacker-functional-devstack-multinode-legacy test were failing due\nto aodh-client exception, added depend on the patch [8].\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n[8] https://review.opendev.org/c/openstack/aodh/+/799651\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nDepends-On: https://review.opendev.org/c/openstack/aodh/+/799651\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/d182ff90fbb9d0f3b25c18a705ffbf92658f8873"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/d182ff90fbb9d0f3b25c18a705ffbf92658f8873"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"73f866467cbd149d3147ed841be309738c3824fd":{"kind":"REWORK","_number":11,"created":"2021-07-09 09:31:42.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/11","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/11","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/11 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/11 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/11 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/11"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-09 09:26:39.000000000","tz":330},"subject":"Fix migration for SQLAlchemy 1.4","message":"Fix migration for SQLAlchemy 1.4\n\nThis patch fixes a database migration for SQLAlchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in SQLAlchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nThe tacker-functional-devstack-multinode-legacy and\ntacker-functional-devstack-multide-libs-master test were failing due\nto aodh-client exception, added depend on the patch [8].\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n[8] https://review.opendev.org/c/openstack/aodh/+/799651\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nDepends-On: https://review.opendev.org/c/openstack/aodh/+/799651\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/73f866467cbd149d3147ed841be309738c3824fd"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/73f866467cbd149d3147ed841be309738c3824fd"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"8c795ef182f0e4f150f18cd9fd38591d95656de1":{"kind":"REWORK","_number":12,"created":"2021-07-09 11:34:10.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/12","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/12","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/12 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/12 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/12 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/12"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-09 11:33:11.000000000","tz":330},"subject":"Fix migration for SQLAlchemy 1.4","message":"Fix migration for SQLAlchemy 1.4\n\nThis patch fixes a database migration for SQLAlchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in SQLAlchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nThe tacker-functional-devstack-multinode-legacy and\ntacker-functional-devstack-multide-libs-master test were failing due\nto aodh-client exception, added depend on the patch [8].\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n[8] https://review.opendev.org/c/openstack/aodh/+/799651\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nDepends-On: https://review.opendev.org/c/openstack/aodh/+/799651\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8c795ef182f0e4f150f18cd9fd38591d95656de1"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8c795ef182f0e4f150f18cd9fd38591d95656de1"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"1ed425d0c0db578dfdcc899ad5d6d73627e58126":{"kind":"NO_CODE_CHANGE","_number":13,"created":"2021-07-09 14:47:07.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/13","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/13","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/13 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/13 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/13 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/13"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-09 14:44:10.000000000","tz":330},"subject":"Fix migration for SQLAlchemy 1.4","message":"Fix migration for SQLAlchemy 1.4\n\nThis patch fixes a database migration for SQLAlchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in SQLAlchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1ed425d0c0db578dfdcc899ad5d6d73627e58126"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1ed425d0c0db578dfdcc899ad5d6d73627e58126"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"9acb1c66c5dd10e79bdf3da41734acc89fbaf98a":{"kind":"REWORK","_number":14,"created":"2021-07-10 00:50:16.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/14","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/14","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/14 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/14 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/14 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/14"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-10 00:48:52.000000000","tz":330},"subject":"Fix migration for SQLAlchemy 1.4","message":"Fix migration for SQLAlchemy 1.4\n\nThis patch fixes a database migration for SQLAlchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in SQLAlchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/9acb1c66c5dd10e79bdf3da41734acc89fbaf98a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/9acb1c66c5dd10e79bdf3da41734acc89fbaf98a"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"},"e0c09499a68bb21fbcd27200dba49de6de336291":{"kind":"REWORK","_number":15,"created":"2021-07-10 01:21:29.000000000","uploader":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"ref":"refs/changes/60/796160/15","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/796160/15","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/15 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/15 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/796160/15 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/796160/15"}}},"commit":{"parents":[{"commit":"8e79746b2819c87ee0dc1654f3478728a1aacad1","subject":"Merge \"Avoid FT errors caused by other projects change\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/8e79746b2819c87ee0dc1654f3478728a1aacad1"}]}],"author":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-06-13 03:20:05.000000000","tz":330},"committer":{"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","date":"2021-07-10 01:20:43.000000000","tz":330},"subject":"Fix migration for SQLAlchemy 1.4","message":"Fix migration for SQLAlchemy 1.4\n\nThis patch fixes a database migration for SQLAlchemy 1.4.\n\nIn tacker repository following issues are encounter:\n\n1. Replace deprecated SQLAlchemy \"with_lockmode\" method.\n   The method was deprecated in SQLAlchemy 0.9 [1][2]\n   and finally removed in version 1.4.\n   This patch replaces \"with_lockmode\" with new method\n   \"with_for_update\", which has no end-user impact.\n\n2. The clause column IN, in the new version it requires parameters\n   passed to operator either be a list of literal value\n   or a tuple, or an empty list [3].\n\n3. Observe an argument error in \u0027update\u0027 query.\n   Error: sqlalchemy.exc.ArgumentError: subject table for an INSERT,\n   UPDATE or DELETE expected, got Column(\u0027id\u0027, Uuid(length\u003d36),\n   table\u003d\u003cvnf_software_images\u003e, primary_key\u003dTrue, nullable\u003dFalse,\n   default\u003dColumnDefault(\u003cfunction generate_uuid at 0x7fb5be371d30\u003e))\n\n4. The INSERT statement requires values to add in table as a list,\n   tuple or dictionary [4].\n   Error: sqlalchemy.exc.ArgumentError: mapping or sequence expected\n          for parameters\n   This patch creates a dictionary of fields to be insert in\n   VnfLcmOpOccs table.\n\n5. Query fails on applying filters.\n   When applying query to list vnf package or vnf instance using\n   apply_filters() method exported from sqlalchemy_filters,\n   it failed.\n   AttributeError: \u0027Query\u0027 object has no attribute \u0027_join_entities\u0027\n\n   In SQLAlchemy 1.4 unification of \"query\" and \"select\" construct\n   took place [5][6].\n   The issue observe in tacker is an open bug of SQLAlchemy [7].\n   This patch drops \"sqlalchemy_filters\" and add customize method\n   to apply filters in query.\n\nNote: This patch address sqlalchemy errors, SAWarnings will be resolve\nin future patches.\n\n[1] https://docs.sqlalchemy.org/en/13/changelog/migration_09.html?highlight\u003dwith_lockmode#new-for-update-support-on-select-query\n[2] https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.with_lockmode\n[3] https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.in_\n[4] https://docs.sqlalchemy.org/en/14/core/dml.html#dml-class-documentation-constructors\n[5] https://github.com/sqlalchemy/sqlalchemy/issues/5159\n[6] https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/1599/\n[7] https://github.com/juliotrigo/sqlalchemy-filters/issues/61\n\nCo-Authored-By: Ayumu Ueha \u003cueha.ayumu@fujitsu.com\u003e\n\nChange-Id: Ifd1ae2753c639f22fc1afa020222416fe79469ef\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/e0c09499a68bb21fbcd27200dba49de6de336291"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/e0c09499a68bb21fbcd27200dba49de6de336291"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"8e79746b2819c87ee0dc1654f3478728a1aacad1","is_merged_in_target_branch":true}],"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"}}]}],"submit_requirements":[{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Workflow\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}}]}