)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":6816,"name":"Jesse Pretorius","email":"jesse@odyssey4.me","username":"jesse-pretorius"},"change_message_id":"bb703eebf5b748ba1b285b625344a5bc63f8949c","unresolved":false,"context_lines":[{"line_number":12,"context_line":""},{"line_number":13,"context_line":"The changes have been added to the run upgrade script and documenation"},{"line_number":14,"context_line":"has been created the new upgrade utility playbook."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"Change-Id: Iac7d1efc0c2e7237ab40988cfb79b6f95592b2cb"},{"line_number":17,"context_line":"Closes-Bug: #1577245"},{"line_number":18,"context_line":"Signed-off-by: Kevin Carter \u003ckevin.carter@rackspace.com\u003e"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"dab17558_9c352d48","line":15,"updated":"2016-05-06 15:29:57.000000000","message":"Please add:\n\nImplements: blueprint upgrade-liberty-mitaka","commit_id":"f5c836b051ba0eced9db3d9a63e29dd3b560458c"}],"doc/source/upgrade-guide/manual-upgrade.rst":[{"author":{"_account_id":10607,"name":"Alexandra Settle","email":"a.settle@outlook.com","username":"asettle"},"change_message_id":"4091a87a36ceb82edd4a924a56dc8df1f65f5cf5","unresolved":false,"context_lines":[{"line_number":158,"context_line":"Clean up Databases for RFC 1034 and 1035"},{"line_number":159,"context_line":"----------------------------------------"},{"line_number":160,"context_line":""},{"line_number":161,"context_line":"Use the ``rfc1034_1035_cleanup.yml`` playbook to remove hostnames that may still"},{"line_number":162,"context_line":"be within the databases which were invalid."},{"line_number":163,"context_line":""},{"line_number":164,"context_line":"See :ref:`rfc1034-1035-cleanup` for details."}],"source_content_type":"text/x-rst","patch_set":4,"id":"dab17558_e35c284d","line":161,"range":{"start_line":161,"start_character":56,"end_line":161,"end_character":65},"updated":"2016-05-16 10:44:08.000000000","message":"\"...to remove invalid hostnames that may still be within the databases.\"","commit_id":"45f1af5c20404d13f0512049cfee340d292707b4"}],"doc/source/upgrade-guide/upgrade-playbooks.rst":[{"author":{"_account_id":6816,"name":"Jesse Pretorius","email":"jesse@odyssey4.me","username":"jesse-pretorius"},"change_message_id":"f9af6929bb225fa7cbc1723989aa8e88362b6fb9","unresolved":false,"context_lines":[{"line_number":91,"context_line":"------------------------"},{"line_number":92,"context_line":""},{"line_number":93,"context_line":"This playbook ensures the OpenStack service databases for Heat, Nova, Neutron,"},{"line_number":94,"context_line":"and  Cinder are cleaned up with regard to actively registered services. These"},{"line_number":95,"context_line":"OpenStack services register nodes within the environment using the hostname as"},{"line_number":96,"context_line":"a unique key and in previous releases containers had invalid hostnames. This"},{"line_number":97,"context_line":"playbook will remove invalid service/agent entries that are found within the"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1a122d0e_85f01268","line":94,"range":{"start_line":94,"start_character":3,"end_line":94,"end_character":5},"updated":"2016-05-04 10:24:03.000000000","message":"double-space","commit_id":"f5c836b051ba0eced9db3d9a63e29dd3b560458c"},{"author":{"_account_id":6816,"name":"Jesse Pretorius","email":"jesse@odyssey4.me","username":"jesse-pretorius"},"change_message_id":"f9af6929bb225fa7cbc1723989aa8e88362b6fb9","unresolved":false,"context_lines":[{"line_number":98,"context_line":"database and meet the invalid hostname criteria. Before performing any action"},{"line_number":99,"context_line":"to cleanup the environment the playbook will execute a database backup storing"},{"line_number":100,"context_line":"everything in ``/var/backup/${DATESTAMP}``."},{"line_number":101,"context_line":""},{"line_number":102,"context_line":".. _rfc1034-1035-cleanup:"},{"line_number":103,"context_line":""},{"line_number":104,"context_line":"--------------"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1a122d0e_05ab621f","line":101,"updated":"2016-05-04 10:24:03.000000000","message":"Perhaps it makes sense to simply use the API to disable these hosts? Or instead to rename the hosts? Wanton deleting of entries seems quite destructive to me.","commit_id":"f5c836b051ba0eced9db3d9a63e29dd3b560458c"},{"author":{"_account_id":10607,"name":"Alexandra Settle","email":"a.settle@outlook.com","username":"asettle"},"change_message_id":"4091a87a36ceb82edd4a924a56dc8df1f65f5cf5","unresolved":false,"context_lines":[{"line_number":77,"context_line":"rfc1034_1035_cleanup.yml"},{"line_number":78,"context_line":"------------------------"},{"line_number":79,"context_line":""},{"line_number":80,"context_line":"This playbook ensures the OpenStack service databases for Heat, Nova, Neutron,"},{"line_number":81,"context_line":"and  Cinder are cleaned up with regard to actively registered services. These"},{"line_number":82,"context_line":"OpenStack services register nodes within the environment using the hostname as"},{"line_number":83,"context_line":"a unique key and in previous releases containers had invalid hostnames. This"},{"line_number":84,"context_line":"playbook will remove invalid service/agent entries that are found within the"}],"source_content_type":"text/x-rst","patch_set":4,"id":"dab17558_83327c0e","line":81,"range":{"start_line":80,"start_character":58,"end_line":81,"end_character":11},"updated":"2016-05-16 10:44:08.000000000","message":"Ensure these are all lowercase project names and remove the double space between \u0027and\u0027 and \u0027Cinder\u0027.","commit_id":"45f1af5c20404d13f0512049cfee340d292707b4"},{"author":{"_account_id":10607,"name":"Alexandra Settle","email":"a.settle@outlook.com","username":"asettle"},"change_message_id":"4091a87a36ceb82edd4a924a56dc8df1f65f5cf5","unresolved":false,"context_lines":[{"line_number":83,"context_line":"a unique key and in previous releases containers had invalid hostnames. This"},{"line_number":84,"context_line":"playbook will remove invalid service/agent entries that are found within the"},{"line_number":85,"context_line":"database and meet the invalid hostname criteria. Before performing any action"},{"line_number":86,"context_line":"to cleanup the environment the playbook will execute a database backup storing"},{"line_number":87,"context_line":"everything in ``/var/backup/${DATESTAMP}``."},{"line_number":88,"context_line":""},{"line_number":89,"context_line":".. _rfc1034-1035-cleanup:"}],"source_content_type":"text/x-rst","patch_set":4,"id":"dab17558_633798ff","line":86,"updated":"2016-05-16 10:44:08.000000000","message":"comma after environment","commit_id":"45f1af5c20404d13f0512049cfee340d292707b4"}],"scripts/upgrade-utilities/playbooks/rfc1034_1035_cleanup.yml":[{"author":{"_account_id":17068,"name":"Jean-Philippe Evrard","email":"openstack@a.spamming.party","username":"evrardjp"},"change_message_id":"db7513da82cb2b1f34cf53ce87699f43bc5bc203","unresolved":false,"context_lines":[{"line_number":22,"context_line":"      command: \"innobackupex --parallel\u003d8 /var/backup/\""},{"line_number":23,"context_line":"    - name: Run database clean up for rfc1034/5"},{"line_number":24,"context_line":"      command: \u003e"},{"line_number":25,"context_line":"        mysql --verbose --unbuffered -e \"delete from {{ item.table }} where host like \u0027%\\_%\u0027;\" {{ item.database }}"},{"line_number":26,"context_line":"      with_items:"},{"line_number":27,"context_line":"        - { table: \"service\", database: \"heat\" }"},{"line_number":28,"context_line":"        - { table: \"services\", database: \"cinder\" }"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"7aa08908_aaa63f0c","line":25,"range":{"start_line":25,"start_character":41,"end_line":25,"end_character":93},"updated":"2016-06-14 08:46:28.000000000","message":"whouldn\u0027t be\n\nUPDATE {{ item.table}} SET host \u003d REPLACE(host, \u0027_\u0027, \u0027-\u0027);\n\nbetter?","commit_id":"9724fc9c41664c0d533701cf8a8893445ef32f42"},{"author":{"_account_id":6816,"name":"Jesse Pretorius","email":"jesse@odyssey4.me","username":"jesse-pretorius"},"change_message_id":"fbbb416fece7ae58ac6082cc910d46ac3a0665bb","unresolved":false,"context_lines":[{"line_number":22,"context_line":"      command: \"innobackupex --parallel\u003d8 /var/backup/\""},{"line_number":23,"context_line":"    - name: Run database clean up for rfc1034/5"},{"line_number":24,"context_line":"      command: \u003e"},{"line_number":25,"context_line":"        mysql --verbose --unbuffered -e \"delete from {{ item.table }} where host like \u0027%\\_%\u0027;\" {{ item.database }}"},{"line_number":26,"context_line":"      with_items:"},{"line_number":27,"context_line":"        - { table: \"service\", database: \"heat\" }"},{"line_number":28,"context_line":"        - { table: \"services\", database: \"cinder\" }"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"3aaa91ec_ec55cbc2","line":25,"range":{"start_line":25,"start_character":41,"end_line":25,"end_character":93},"in_reply_to":"3aaa91ec_769d2765","updated":"2016-07-01 13:04:36.000000000","message":"This is rather awful, but if it must be done then it must be done. What happens to stuff that is attached to a scheduler - for example cinder-volumes are tied to an agent, as are neutron routers/networks/etc? I expect that we will need to move the cinder ones at least. What sort of down-time does this cause on the data plane?","commit_id":"9724fc9c41664c0d533701cf8a8893445ef32f42"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"0a9613f809f13bfa7cf5da7ad463dd16d71d079c","unresolved":false,"context_lines":[{"line_number":22,"context_line":"      command: \"innobackupex --parallel\u003d8 /var/backup/\""},{"line_number":23,"context_line":"    - name: Run database clean up for rfc1034/5"},{"line_number":24,"context_line":"      command: \u003e"},{"line_number":25,"context_line":"        mysql --verbose --unbuffered -e \"delete from {{ item.table }} where host like \u0027%\\_%\u0027;\" {{ item.database }}"},{"line_number":26,"context_line":"      with_items:"},{"line_number":27,"context_line":"        - { table: \"service\", database: \"heat\" }"},{"line_number":28,"context_line":"        - { table: \"services\", database: \"cinder\" }"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"3aaa91ec_769d2765","line":25,"range":{"start_line":25,"start_character":41,"end_line":25,"end_character":93},"in_reply_to":"7aa08908_aaa63f0c","updated":"2016-07-01 12:50:55.000000000","message":"If we update at this time we\u0027ll create duplicate services and if we update before this time the services themselves will create a duplicate entries when they check back in.","commit_id":"9724fc9c41664c0d533701cf8a8893445ef32f42"},{"author":{"_account_id":6816,"name":"Jesse Pretorius","email":"jesse@odyssey4.me","username":"jesse-pretorius"},"change_message_id":"3078083cd4f6a086a179de99afe8dd9473691de5","unresolved":false,"context_lines":[{"line_number":24,"context_line":"      command: \u003e"},{"line_number":25,"context_line":"        mysql --verbose --unbuffered -e \"delete from {{ item.table }} where host like \u0027%\\_%\u0027;\" {{ item.database }}"},{"line_number":26,"context_line":"      with_items:"},{"line_number":27,"context_line":"        - { table: \"service\", database: \"heat\" }"},{"line_number":28,"context_line":"        - { table: \"services\", database: \"cinder\" }"},{"line_number":29,"context_line":"        - { table: \"agents\", database: \"neutron\" }"},{"line_number":30,"context_line":"        - { table: \"services\", database: \"nova\" }"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"3aaa91ec_56474ba2","line":27,"updated":"2016-07-01 12:56:10.000000000","message":"These database tables have customisable names. Shouldn\u0027t we use the var if it exists, but default to these values?","commit_id":"9724fc9c41664c0d533701cf8a8893445ef32f42"}]}
