)]}'
{"id":"openstack%2Fpuppet-openstack-integration~483056","triplet_id":"openstack%2Fpuppet-openstack-integration~master~If0338362f9b7b9c90390a836a40b0036adc958a3","project":"openstack/puppet-openstack-integration","branch":"master","topic":"fix-watcher","hashtags":[],"change_id":"If0338362f9b7b9c90390a836a40b0036adc958a3","subject":"Disable watcher create_schema","status":"MERGED","created":"2017-07-12 17:52:06.000000000","updated":"2017-07-13 04:08:04.000000000","submitted":"2017-07-13 04:08:04.000000000","submitter":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"ce34b9655c87263739fb5ef9c0725ed1cd77c392","_number":483056,"virtual_id_number":483056,"owner":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"value":0,"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},{"value":2,"date":"2017-07-13 04:08:04.000000000","post_submit":true,"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},{"value":0,"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"}],"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":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"all":[{"value":2,"date":"2017-07-12 19:03:32.000000000","_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},{"value":0,"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},{"value":2,"date":"2017-07-12 21:56:54.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"},"all":[{"value":0,"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},{"value":0,"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},{"value":1,"date":"2017-07-12 21:56:54.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},{"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"},{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2017-07-12 19:03:32.000000000","updated_by":{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"reviewer":{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"state":"REVIEWER"},{"updated":"2017-07-12 21:56:54.000000000","updated_by":{"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"},"reviewer":{"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"},"state":"REVIEWER"},{"updated":"2017-07-13 04:08:04.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"}],"messages":[{"id":"5a3f54a50631b9b8e4b435b44696ebbfc3b43106","author":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"date":"2017-07-12 17:52:06.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"17a614ea2ebb6cf0d8f86657e131a5710c22871b","author":{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"date":"2017-07-12 18:43:25.000000000","message":"Patch Set 1: Code-Review-1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"9636bd82e04847196c6bee3a2a2df97007d15f2f","author":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"date":"2017-07-12 18:47:17.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"bc95d63ed424a567d21ec82fd102d15af13ddd29","author":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"date":"2017-07-12 19:01:14.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"b7e890bcb2e63d7aa07590845d60fb65d496b507","author":{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"date":"2017-07-12 19:03:32.000000000","message":"Patch Set 2: Code-Review+2","accounts_in_message":[],"_revision_number":2},{"id":"aca687615ed7835bca94d74b4b8f41706cf9ae7a","author":{"_account_id":3153,"name":"Emilien Macchi","email":"emilien@redhat.com","username":"emilienm"},"date":"2017-07-12 19:03:48.000000000","message":"Patch Set 2:\n\nyeah I just want us to use the default values when possible","accounts_in_message":[],"_revision_number":2},{"id":"f9a3002919a2af88f45dff8617303ee6efc72642","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2017-07-12 19:51:32.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- gate-puppet-openstack-integration-puppet-lint http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-puppet-lint/263537a/ : SUCCESS in 3m 12s\n- gate-puppet-openstack-integration-puppet-syntax-4-centos-7 http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-puppet-syntax-4-centos-7/8160fd7/ : SUCCESS in 5m 55s\n- gate-puppet-openstack-integration-4-scenario001-tempest-centos-7 http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario001-tempest-centos-7/9314204/ : SUCCESS in 37m 34s\n- gate-puppet-openstack-integration-4-scenario002-tempest-centos-7 http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario002-tempest-centos-7/e7012bb/ : SUCCESS in 39m 06s\n- gate-puppet-openstack-integration-4-scenario003-tempest-centos-7 http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario003-tempest-centos-7/db1f2d1/ : SUCCESS in 46m 31s\n- gate-puppet-openstack-integration-4-scenario004-tempest-centos-7 http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario004-tempest-centos-7/d01b7d6/ : SUCCESS in 35m 50s\n- gate-puppet-openstack-integration-4-scenario001-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario001-tempest-ubuntu-xenial/30bf740/ : SUCCESS in 33m 35s\n- gate-puppet-openstack-integration-4-scenario002-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario002-tempest-ubuntu-xenial/8ceed54/ : SUCCESS in 35m 15s\n- gate-puppet-openstack-integration-4-scenario003-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario003-tempest-ubuntu-xenial/c0fabc1/ : SUCCESS in 36m 08s\n- gate-puppet-openstack-integration-4-scenario004-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/check/gate-puppet-openstack-integration-4-scenario004-tempest-ubuntu-xenial/fbc2788/ : SUCCESS in 25m 12s","accounts_in_message":[],"_revision_number":2},{"id":"c8c44d2b71be9029705142ab7d601ce540acf66d","author":{"_account_id":14985,"name":"Alex Schultz","email":"aschultz@next-development.com","username":"mwhahaha"},"date":"2017-07-12 21:56:54.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"11d7fc97763f81a992fb3da19e8183a83807c8c4","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2017-07-12 21:57:05.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.\nhttp://status.openstack.org/zuul/","accounts_in_message":[],"_revision_number":2},{"id":"50c1abd7be198bf37d495c7b5473dc4d2be98f59","date":"2017-07-13 04:08:04.000000000","message":"Change has been successfully merged into the git repository by Jenkins","accounts_in_message":[],"_revision_number":2},{"id":"345ad1d516a38525b6995df270bc67d5003244de","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2017-07-13 04:08:04.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- gate-puppet-openstack-integration-puppet-lint http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-puppet-lint/3ebdb82/ : SUCCESS in 2m 50s\n- gate-puppet-openstack-integration-puppet-syntax-4-centos-7 http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-puppet-syntax-4-centos-7/1961c66/ : SUCCESS in 3m 54s\n- gate-puppet-openstack-integration-4-scenario001-tempest-centos-7 http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario001-tempest-centos-7/1bb901f/ : SUCCESS in 35m 45s\n- gate-puppet-openstack-integration-4-scenario002-tempest-centos-7 http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario002-tempest-centos-7/0489d28/ : SUCCESS in 58m 09s\n- gate-puppet-openstack-integration-4-scenario003-tempest-centos-7 http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario003-tempest-centos-7/3a487b9/ : SUCCESS in 54m 33s\n- gate-puppet-openstack-integration-4-scenario004-tempest-centos-7 http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario004-tempest-centos-7/97b613a/ : SUCCESS in 29m 52s\n- gate-puppet-openstack-integration-4-scenario001-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario001-tempest-ubuntu-xenial/a6f7b4c/ : SUCCESS in 38m 36s\n- gate-puppet-openstack-integration-4-scenario002-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario002-tempest-ubuntu-xenial/f3dc1ff/ : SUCCESS in 32m 26s\n- gate-puppet-openstack-integration-4-scenario003-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario003-tempest-ubuntu-xenial/af48fbc/ : SUCCESS in 25m 19s\n- gate-puppet-openstack-integration-4-scenario004-tempest-ubuntu-xenial http://logs.openstack.org/56/483056/2/gate/gate-puppet-openstack-integration-4-scenario004-tempest-ubuntu-xenial/23c8d1d/ : SUCCESS in 31m 49s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"85d0a023a4004bc57186bc1e4f2af95da0b2b966","revisions":{"dabc63b285b47a3e6ff3980c6e863497f5e32b99":{"kind":"REWORK","_number":1,"created":"2017-07-12 17:52:06.000000000","uploader":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"ref":"refs/changes/56/483056/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/puppet-openstack-integration","ref":"refs/changes/56/483056/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/1"}}},"commit":{"parents":[{"commit":"efa50a1193848276c2a3e92ffd24d467d54db5e3","subject":"Create m1.tiny flavor for murano jobs","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/efa50a1193848276c2a3e92ffd24d467d54db5e3"}]}],"author":{"name":"Alfredo Moralejo","email":"amoralej@redhat.com","date":"2017-07-12 17:41:43.000000000","tz":120},"committer":{"name":"Alfredo Moralejo","email":"amoralej@redhat.com","date":"2017-07-12 17:41:43.000000000","tz":120},"subject":"Disable watcher create_schema","message":"Disable watcher create_schema\n\nAccording to https://review.openstack.org/#/c/419031/ the only\ncommand to be executed to populate watcher DB is:\n\nwatcher-db-manage --config-file /etc/watcher/watcher.conf upgrade head\n\ncreate_schema command is not longer needed, and in fact is not\ncreating table apscheduler_jobs properly.\n\nNote that p-o-i jobs keep working because the version of APScheduler\ncurrently in RDO creates table apscheduler_jobs automatically\nin SQLAlchemyJobStore initialization. This is not longer true\nin recent versions, so it will break as soon as APScheduler is\nupdated, so let\u0027s fix it.\n\n[1] https://github.com/agronholm/apscheduler/commit/bf99bff8ea683b98756313ff34a22320d141186c#diff-c47a8d544459e39b2dc3dfeb50a4ec6bR55\n\nChange-Id: If0338362f9b7b9c90390a836a40b0036adc958a3\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/dabc63b285b47a3e6ff3980c6e863497f5e32b99"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/dabc63b285b47a3e6ff3980c6e863497f5e32b99"}]},"branch":"refs/heads/master"},"85d0a023a4004bc57186bc1e4f2af95da0b2b966":{"kind":"REWORK","_number":2,"created":"2017-07-12 19:01:14.000000000","uploader":{"_account_id":16312,"name":"Alfredo Moralejo","email":"amoralej@redhat.com","username":"amoralej"},"ref":"refs/changes/56/483056/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/puppet-openstack-integration","ref":"refs/changes/56/483056/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/puppet-openstack-integration refs/changes/56/483056/2"}}},"commit":{"parents":[{"commit":"efa50a1193848276c2a3e92ffd24d467d54db5e3","subject":"Create m1.tiny flavor for murano jobs","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/efa50a1193848276c2a3e92ffd24d467d54db5e3"}]}],"author":{"name":"Alfredo Moralejo","email":"amoralej@redhat.com","date":"2017-07-12 17:41:43.000000000","tz":120},"committer":{"name":"Alfredo Moralejo","email":"amoralej@redhat.com","date":"2017-07-12 19:00:58.000000000","tz":120},"subject":"Disable watcher create_schema","message":"Disable watcher create_schema\n\nAccording to https://review.openstack.org/#/c/419031/ the only\ncommand to be executed to populate watcher DB is:\n\nwatcher-db-manage --config-file /etc/watcher/watcher.conf upgrade head\n\ncreate_schema command is not longer needed, and in fact is not\ncreating table apscheduler_jobs properly.\n\nNote that p-o-i jobs keep working because the version of APScheduler\ncurrently in RDO creates table apscheduler_jobs automatically\nin SQLAlchemyJobStore initialization. This is not longer true\nin recent versions, so it will break as soon as APScheduler is\nupdated, so let\u0027s fix it.\n\n[1] https://github.com/agronholm/apscheduler/commit/bf99bff8ea683b98756313ff34a22320d141186c#diff-c47a8d544459e39b2dc3dfeb50a4ec6bR55\n\nChange-Id: If0338362f9b7b9c90390a836a40b0036adc958a3\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/85d0a023a4004bc57186bc1e4f2af95da0b2b966"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/puppet-openstack-integration/commit/85d0a023a4004bc57186bc1e4f2af95da0b2b966"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}
