)]}'
{"id":"openstack%2Ftacker~774893","triplet_id":"openstack%2Ftacker~master~I4b4e4dd0a4246a97d4bd0329e8a387f3d8b51700","project":"openstack/tacker","branch":"master","topic":"dnmpatch","hashtags":[],"change_id":"I4b4e4dd0a4246a97d4bd0329e8a387f3d8b51700","subject":"[DNM] Fix the incompatible query statement for mysql","status":"ABANDONED","created":"2021-02-10 16:33:17.000000000","updated":"2021-03-02 09:18:02.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"19cc4eeb31b250ec8651b9f0b1622b95b6d6c511","_number":774893,"virtual_id_number":774893,"owner":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2021-02-11 09:28:49.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-02-10 20:01:30.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"329698ede6dbb2105090a96e220d5a56f54e6dbf","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-02-10 16:33:17.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"0693e922b9fa2e67e5e639729ad5bb99b64fd83f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-10 20:01:30.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/6cc5ec906a954d23a6b6bc650c128279 : SUCCESS in 8m 52s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/f6dc61a61ed54d2c8e8a066dc9eae036 : SUCCESS in 13m 20s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ea838656adcb4c17ba5a241623461567 : SUCCESS in 4m 59s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e09e754e11f04ebd8c1ea6a5fc19fafd : SUCCESS in 10m 39s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/a262475f76ff4e4a9b9fbd58609b5ef3 : SUCCESS in 11m 08s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/96ffd13d648c4a21931cbef730f47aec : SUCCESS in 10m 49s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/885755c6a1824a308aa57a35a7faed11 : SUCCESS in 6m 54s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/0381de4e37aa4f399addd9212bb9423f : RETRY_LIMIT in 59m 22s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/56e0d787dc504866ba6bc59ab2cba180 : RETRY_LIMIT in 51m 29s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/39baf623bddf41c4b447cc7c4e99ea5a : RETRY_LIMIT in 57m 40s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/c4e1a14892ab43dbb3cfc624dd17afd0 : RETRY_LIMIT in 1h 04m 40s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"9e949fa5a0b31e215c4f49d3139fb21b7bbf9534","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-02-11 01:57:04.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"b8ead233bbe8af73e8a27de9180243366abe61eb","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-11 03:43:08.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/d297a8bdb00d420c81e483d383facb5f : SUCCESS in 6m 55s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/d9c58f9dd774433fa2abee0475e0d472 : SUCCESS in 13m 49s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/5ff925da2da8436aa162b14bc115a683 : SUCCESS in 7m 27s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f1b02cfffa3a4c889536709b7de08e28 : SUCCESS in 11m 55s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/b9ba9d34aa93406e920878951091de5f : SUCCESS in 10m 48s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/dc9d44f61cf24d558ed97c7a44c1e980 : SUCCESS in 10m 11s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8fc29dd6a8c248919595ad058f585e32 : SUCCESS in 6m 16s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/9d93a9fc5eae40778dd9cbecb4b1f096 : FAILURE in 1h 42m 31s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/54c32cd39132451ab226d59d9b4181cd : SUCCESS in 1h 40m 21s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/1dec1d90ee254abb9943ad9eb7e57c90 : SUCCESS in 59m 23s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/6c2884457f824c12a3fb5296d9cf04f7 : SUCCESS in 1h 16m 24s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"99b78493076d82331f444a314907a61e57bd8bbd","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-02-11 04:03:14.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"a03108e642df04ee200060e5e607d4f99c08de4c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-11 05:53:22.000000000","message":"Patch Set 2:\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/bf9a94f165214440a45c70466bc1275a : SUCCESS in 6m 19s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/8dedc0fd1c7b460b8a192676b2d6bc7e : SUCCESS in 11m 51s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ccc87f2041c945a4b1eeeb006d518634 : SUCCESS in 4m 20s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f27b05a71bc046dab78ed100ce388f01 : SUCCESS in 10m 10s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/18129774dc6c4251b89bbb6219449d4e : SUCCESS in 10m 14s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2c1aa6149c3f49f68bf3dbb6b1b72f76 : SUCCESS in 10m 31s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/77fbd83875df4f3594462f7d1fd90155 : SUCCESS in 8m 21s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/7b3e79554d8b42cf994a79cbb7953e84 : FAILURE in 1h 45m 06s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/a6e9f7f6e4034a7e9aa4b54823915e90 : SUCCESS in 1h 48m 26s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/f5a78f8c4e2847a28aab845fbe8e9561 : SUCCESS in 1h 17m 57s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/292cc99dcc15472cb79b73a846244d0d : SUCCESS in 1h 11m 21s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"7854f6238a5ce30bfa6626b9f4bf06396d6240dd","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-02-11 06:45:24.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"32461737781103feccd9a1303c5500e4e6616e12","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-02-11 07:22:35.000000000","message":"Uploaded patch set 3.","accounts_in_message":[],"_revision_number":3},{"id":"906aec240d0f04db24aed2bc3255d049da90ac50","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-11 09:28:49.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/f92a4f0907f1479babacc4356211c2c5 : SUCCESS in 7m 06s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/87e01172e8bc41a480bbd8b2036a1b9f : SUCCESS in 13m 19s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/cb461a3bc53f41b7aee78a8325a6365a : SUCCESS in 4m 34s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/0638ee7d1f1d4f3bb4f03536916174a9 : SUCCESS in 10m 58s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/3a44b70064944ceba65e5d4c1561ac2d : SUCCESS in 11m 00s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/d08efad556764b26b2302adb588cd9ca : SUCCESS in 11m 59s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9fbbf4173d6a4fafa60036449afe4825 : SUCCESS in 7m 22s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/2d2ed653e0db40db98114f7e964392d5 : SUCCESS in 1h 41m 02s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/b7b4953a61bd49e5bc3be964405e7f56 : SUCCESS in 1h 55m 31s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/98440016655841f9b3abc47903e60778 : SUCCESS in 1h 18m 12s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/2afc8ecf80a248d5a599cd4d851247dd : SUCCESS in 1h 10m 00s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"19cc4eeb31b250ec8651b9f0b1622b95b6d6c511","tag":"autogenerated:gerrit:abandon","author":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"date":"2021-03-02 09:18:02.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":3}],"current_revision_number":3,"current_revision":"2f1fc2a6b8077a7a2534d75ab75ce0af74088be2","revisions":{"51f1d8b7dcf65daf05b9d1dd3197f77603d518df":{"kind":"REWORK","_number":1,"created":"2021-02-10 16:33:17.000000000","uploader":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"ref":"refs/changes/93/774893/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/93/774893/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/93/774893/1"}}},"commit":{"parents":[{"commit":"092284048ffaf8311927df9e4abcf9ab3820fad6","subject":"Support enhancement for Subscription Post","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/092284048ffaf8311927df9e4abcf9ab3820fad6"}]}],"author":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-10 16:29:07.000000000","tz":540},"committer":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-10 16:29:07.000000000","tz":540},"subject":"[DNM] Fix the incompatible query statement for mysql","message":"[DNM] Fix the incompatible query statement for mysql\n\nChange-Id: I4b4e4dd0a4246a97d4bd0329e8a387f3d8b51700\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/51f1d8b7dcf65daf05b9d1dd3197f77603d518df"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/51f1d8b7dcf65daf05b9d1dd3197f77603d518df"}]},"branch":"refs/heads/master"},"1ee013d404cb1b6486cddecb63a792d9ccb24e82":{"kind":"REWORK","_number":2,"created":"2021-02-11 01:57:04.000000000","uploader":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"ref":"refs/changes/93/774893/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/93/774893/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/93/774893/2"}}},"commit":{"parents":[{"commit":"092284048ffaf8311927df9e4abcf9ab3820fad6","subject":"Support enhancement for Subscription Post","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/092284048ffaf8311927df9e4abcf9ab3820fad6"}]}],"author":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-10 16:29:07.000000000","tz":540},"committer":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-11 01:54:49.000000000","tz":540},"subject":"[DNM] Fix the incompatible query statement for mysql","message":"[DNM] Fix the incompatible query statement for mysql\n\nChange-Id: I4b4e4dd0a4246a97d4bd0329e8a387f3d8b51700\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1ee013d404cb1b6486cddecb63a792d9ccb24e82"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/1ee013d404cb1b6486cddecb63a792d9ccb24e82"}]},"branch":"refs/heads/master"},"2f1fc2a6b8077a7a2534d75ab75ce0af74088be2":{"kind":"REWORK","_number":3,"created":"2021-02-11 07:22:35.000000000","uploader":{"_account_id":32219,"name":"Aldinson C. Esto","email":"esto.aln@nec.com","username":"esto-aln"},"ref":"refs/changes/93/774893/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/93/774893/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/93/774893/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/93/774893/3"}}},"commit":{"parents":[{"commit":"092284048ffaf8311927df9e4abcf9ab3820fad6","subject":"Support enhancement for Subscription Post","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/092284048ffaf8311927df9e4abcf9ab3820fad6"}]}],"author":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-10 16:29:07.000000000","tz":540},"committer":{"name":"Aldinson Esto","email":"esto.aln@nec.com","date":"2021-02-11 07:19:50.000000000","tz":540},"subject":"[DNM] Fix the incompatible query statement for mysql","message":"[DNM] Fix the incompatible query statement for mysql\n\nChange-Id: I4b4e4dd0a4246a97d4bd0329e8a387f3d8b51700\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/2f1fc2a6b8077a7a2534d75ab75ce0af74088be2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/2f1fc2a6b8077a7a2534d75ab75ce0af74088be2"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}