)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":7219,"name":"git-harry","email":"git-harry@live.co.uk","username":"git-harry"},"change_message_id":"8f85246e46d3887f6ad6aacfa74fe3b492ff7fbc","unresolved":false,"context_lines":[{"line_number":8,"context_line":""},{"line_number":9,"context_line":"This change adds a retry to the mysql_upgrade command when performing"},{"line_number":10,"context_line":"an upgrade. This is required in circumstances when the wsrep service"},{"line_number":11,"context_line":"is not ready for application use. This is a common issue directly when"},{"line_number":12,"context_line":"restarting the mysql service directly after package installation."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Example Error:"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":4,"id":"1af94dfe_8066cf4e","line":11,"range":{"start_line":11,"start_character":57,"end_line":11,"end_character":65},"updated":"2016-03-18 15:19:02.000000000","message":"I think this word should be removed.","commit_id":"83f378c85f9f6babccb7694fd54dcd9cdef5f947"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"01a6bd882ed6eeebb6d24ec6606dc71a15a1eb5f","unresolved":false,"context_lines":[{"line_number":8,"context_line":""},{"line_number":9,"context_line":"This change adds a retry to the mysql_upgrade command when performing"},{"line_number":10,"context_line":"an upgrade. This is required in circumstances when the wsrep service"},{"line_number":11,"context_line":"is not ready for application use. This is a common issue directly when"},{"line_number":12,"context_line":"restarting the mysql service directly after package installation."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Example Error:"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":4,"id":"1af94dfe_b5e0662a","line":11,"range":{"start_line":11,"start_character":57,"end_line":11,"end_character":65},"in_reply_to":"1af94dfe_8066cf4e","updated":"2016-03-18 16:08:23.000000000","message":"Done","commit_id":"83f378c85f9f6babccb7694fd54dcd9cdef5f947"}],"tasks/galera_running_check.yml":[{"author":{"_account_id":7219,"name":"git-harry","email":"git-harry@live.co.uk","username":"git-harry"},"change_message_id":"8f85246e46d3887f6ad6aacfa74fe3b492ff7fbc","unresolved":false,"context_lines":[{"line_number":26,"context_line":"    - galera-cluster-state-check"},{"line_number":27,"context_line":"    - galera-bootstrap"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"- name: Check that WSREP is ready"},{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when:"},{"line_number":32,"context_line":"    - _mysql_ready.rc !\u003d 0"}],"source_content_type":"text/x-yaml","patch_set":4,"id":"1af94dfe_40a84777","line":29,"updated":"2016-03-18 15:19:02.000000000","message":"There are two changed_when in this task.","commit_id":"83f378c85f9f6babccb7694fd54dcd9cdef5f947"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"01a6bd882ed6eeebb6d24ec6606dc71a15a1eb5f","unresolved":false,"context_lines":[{"line_number":26,"context_line":"    - galera-cluster-state-check"},{"line_number":27,"context_line":"    - galera-bootstrap"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"- name: Check that WSREP is ready"},{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when:"},{"line_number":32,"context_line":"    - _mysql_ready.rc !\u003d 0"}],"source_content_type":"text/x-yaml","patch_set":4,"id":"1af94dfe_d5e1b22b","line":29,"in_reply_to":"1af94dfe_40a84777","updated":"2016-03-18 16:08:23.000000000","message":"Done","commit_id":"83f378c85f9f6babccb7694fd54dcd9cdef5f947"},{"author":{"_account_id":7219,"name":"git-harry","email":"git-harry@live.co.uk","username":"git-harry"},"change_message_id":"5c87198a5b767efa5cda8e02f2fb40d802cb5e1b","unresolved":false,"context_lines":[{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when: \u003e"},{"line_number":32,"context_line":"    _mysql_ready.rc !\u003d 0 or"},{"line_number":33,"context_line":"    not (_mysql_ready.stdout).find(\"ON\") or"},{"line_number":34,"context_line":"    not (_mysql_ready.stdout).find(\"OPERATIONAL\")"},{"line_number":35,"context_line":"  register: _mysql_ready"},{"line_number":36,"context_line":"  until:"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"fa0719c6_25186784","line":33,"updated":"2016-03-21 12:04:16.000000000","message":"\u0027ON\u0027 is in \u0027OPERATIONAL\u0027 and so the line above this comment will always be true if the line below is.","commit_id":"bb2760290fca3d8833191d93b56af4ccb060ada3"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"cb08fe3ab51276e875bdfea923ecd54b91e6decf","unresolved":false,"context_lines":[{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when: \u003e"},{"line_number":32,"context_line":"    _mysql_ready.rc !\u003d 0 or"},{"line_number":33,"context_line":"    not (_mysql_ready.stdout).find(\"ON\") or"},{"line_number":34,"context_line":"    not (_mysql_ready.stdout).find(\"OPERATIONAL\")"},{"line_number":35,"context_line":"  register: _mysql_ready"},{"line_number":36,"context_line":"  until:"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"ba0121b8_8401f2b1","line":33,"in_reply_to":"fa0719c6_25186784","updated":"2016-03-31 06:02:26.000000000","message":"Done","commit_id":"bb2760290fca3d8833191d93b56af4ccb060ada3"},{"author":{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},"change_message_id":"014209eb9de1fabf03971cea97e55c2509838c2e","unresolved":false,"context_lines":[{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when: \u003e"},{"line_number":32,"context_line":"    _mysql_ready.rc !\u003d 0 or"},{"line_number":33,"context_line":"    not (_mysql_ready.stdout).find(\"ON\")"},{"line_number":34,"context_line":"  register: _mysql_ready"},{"line_number":35,"context_line":"  until:"},{"line_number":36,"context_line":"    - _mysql_ready.rc \u003d\u003d 0"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_9d0bca7c","line":33,"updated":"2016-04-01 06:40:05.000000000","message":"Is this changed_when necessary?","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"6f2651719e42c21fac527d9a2968486099817bac","unresolved":false,"context_lines":[{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when: \u003e"},{"line_number":32,"context_line":"    _mysql_ready.rc !\u003d 0 or"},{"line_number":33,"context_line":"    not (_mysql_ready.stdout).find(\"ON\")"},{"line_number":34,"context_line":"  register: _mysql_ready"},{"line_number":35,"context_line":"  until:"},{"line_number":36,"context_line":"    - _mysql_ready.rc \u003d\u003d 0"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_02e0e7cb","line":33,"in_reply_to":"ba0121b8_9d0bca7c","updated":"2016-04-01 13:06:54.000000000","message":"No, Done.","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},"change_message_id":"014209eb9de1fabf03971cea97e55c2509838c2e","unresolved":false,"context_lines":[{"line_number":34,"context_line":"  register: _mysql_ready"},{"line_number":35,"context_line":"  until:"},{"line_number":36,"context_line":"    - _mysql_ready.rc \u003d\u003d 0"},{"line_number":37,"context_line":"    - (_mysql_ready.stdout).find(\"ON\")"},{"line_number":38,"context_line":"  retries: \"{{ num_retries }}\""},{"line_number":39,"context_line":"  delay: \"{{ wait_delay }}\""},{"line_number":40,"context_line":"  failed_when: false"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_fd1ac6c4","line":37,"updated":"2016-04-01 06:40:05.000000000","message":"This should be: _mysql_ready.stdout.find(\"ON\") !\u003d -1\nfind returns the starting position of the match within stdout or -1, this will always pass as is.\nIt\u0027s not documented by Ansible very well.","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"6f2651719e42c21fac527d9a2968486099817bac","unresolved":false,"context_lines":[{"line_number":34,"context_line":"  register: _mysql_ready"},{"line_number":35,"context_line":"  until:"},{"line_number":36,"context_line":"    - _mysql_ready.rc \u003d\u003d 0"},{"line_number":37,"context_line":"    - (_mysql_ready.stdout).find(\"ON\")"},{"line_number":38,"context_line":"  retries: \"{{ num_retries }}\""},{"line_number":39,"context_line":"  delay: \"{{ wait_delay }}\""},{"line_number":40,"context_line":"  failed_when: false"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_82d4f7eb","line":37,"in_reply_to":"ba0121b8_fd1ac6c4","updated":"2016-04-01 13:06:54.000000000","message":"Done","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":14805,"name":"Jimmy McCrory","email":"jimmy.mccrory@gmail.com","username":"jimmy-mccrory"},"change_message_id":"014209eb9de1fabf03971cea97e55c2509838c2e","unresolved":false,"context_lines":[{"line_number":37,"context_line":"    - (_mysql_ready.stdout).find(\"ON\")"},{"line_number":38,"context_line":"  retries: \"{{ num_retries }}\""},{"line_number":39,"context_line":"  delay: \"{{ wait_delay }}\""},{"line_number":40,"context_line":"  failed_when: false"},{"line_number":41,"context_line":"  tags:"},{"line_number":42,"context_line":"    - galera-cluster-state-check"},{"line_number":43,"context_line":"    - galera-bootstrap"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_bdd96ef5","line":40,"updated":"2016-04-01 06:40:05.000000000","message":"Not sure what this does exactly, the task should fail if the until conditions aren\u0027t met.","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":7353,"name":"Kevin Carter","email":"kevin@cloudnull.com","username":"cloudnull"},"change_message_id":"6f2651719e42c21fac527d9a2968486099817bac","unresolved":false,"context_lines":[{"line_number":37,"context_line":"    - (_mysql_ready.stdout).find(\"ON\")"},{"line_number":38,"context_line":"  retries: \"{{ num_retries }}\""},{"line_number":39,"context_line":"  delay: \"{{ wait_delay }}\""},{"line_number":40,"context_line":"  failed_when: false"},{"line_number":41,"context_line":"  tags:"},{"line_number":42,"context_line":"    - galera-cluster-state-check"},{"line_number":43,"context_line":"    - galera-bootstrap"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"ba0121b8_c2da6f16","line":40,"in_reply_to":"ba0121b8_bdd96ef5","updated":"2016-04-01 13:06:54.000000000","message":"removed","commit_id":"2336c9cd0b8244ca37ea10b0e83c13f1bedf9a15"},{"author":{"_account_id":7219,"name":"git-harry","email":"git-harry@live.co.uk","username":"git-harry"},"change_message_id":"e4f6a860d4480a85df3549995b5cbb05f525cbbb","unresolved":false,"context_lines":[{"line_number":26,"context_line":"    - galera-cluster-state-check"},{"line_number":27,"context_line":"    - galera-bootstrap"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"- name: Check that WSREP is ready"},{"line_number":30,"context_line":"  shell: \"/usr/bin/mysqladmin --defaults-file\u003d/etc/mysql/debian.cnf extended-status | egrep \u0027(wsrep_ready|wsrep_evs_state)\u0027\""},{"line_number":31,"context_line":"  changed_when: \u003e"},{"line_number":32,"context_line":"    _mysql_ready.rc !\u003d 0"}],"source_content_type":"text/x-yaml","patch_set":7,"id":"ba0121b8_1e3f94b4","line":29,"updated":"2016-04-01 16:45:02.000000000","message":"Based on the current failure I think this needs a conditional, something like:\n\nwhen: _mysql_running.rc \u003d\u003d 0","commit_id":"63464d8756f98dc74884d4d5fec70373746ae364"}]}
