{"id":246,"sha1":"e8c7884b7f636cca875e604596b280bd8581ef93","playbook":{"id":3,"items":{"plays":37,"tasks":589,"results":576,"hosts":7,"files":222,"records":0},"arguments":{"version":null,"verbosity":0,"private_key_file":null,"remote_user":null,"connection":"openstack.osa.ssh","timeout":null,"ssh_common_args":null,"sftp_extra_args":null,"scp_extra_args":null,"ssh_extra_args":null,"ask_pass":false,"connection_password_file":null,"force_handlers":true,"flush_cache":false,"become":false,"become_method":"sudo","become_user":null,"become_ask_pass":false,"become_password_file":null,"tags":["all"],"skip_tags":[],"check":false,"diff":false,"inventory":["/home/zuul/src/opendev.org/openstack/openstack-ansible/inventory/dynamic_inventory.py","/home/zuul/src/opendev.org/openstack/openstack-ansible/inventory/inventory.ini","/etc/openstack_deploy/inventory.ini"],"listhosts":false,"subset":null,"extra_vars":"Not saved by ARA as configured by 'ignored_arguments'","vault_ids":[],"ask_vault_pass":false,"vault_password_files":[],"forks":4,"module_path":null,"syntax":false,"listtasks":false,"listtags":false,"step":false,"start_at_task":null,"args":["setup-infrastructure.yml"]},"labels":[{"id":1,"name":"check:False"},{"id":2,"name":"tags:all"}],"started":"2025-12-08T13:50:33.014895Z","ended":"2025-12-08T13:57:00.819740Z","duration":"00:06:27.804845","name":null,"ansible_version":"2.18.6","client_version":"1.7.4","python_version":"3.12.11","server_version":"1.7.4","status":"completed","path":"/home/zuul/src/opendev.org/openstack/openstack-ansible/playbooks/setup-infrastructure.yml","controller":"aio1.openstack.local","user":"root"},"content":"---\n# Copyright 2015, Rackspace US, Inc.\n#\n# Licensed under the Apache License, Version 2.0 (the \"License\");\n# you may not use this file except in compliance with the License.\n# You may obtain a copy of the License at\n#\n#     http://www.apache.org/licenses/LICENSE-2.0\n#\n# Unless required by applicable law or agreed to in writing, software\n# distributed under the License is distributed on an \"AS IS\" BASIS,\n# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n# See the License for the specific language governing permissions and\n# limitations under the License.\n\n- name: Check node status\n  ansible.builtin.command: >\n    {{ galera_mariadb_client_binary }} --silent --skip-column-names --connect-timeout=10 -e 'SHOW STATUS LIKE \"wsrep_local_state\";'\n  failed_when: false\n  changed_when: false\n  register: node_status\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Check if node is in the cluster\n  ansible.builtin.command: >\n    {{ galera_mariadb_client_binary }} --silent --skip-column-names --connect-timeout=10 -e 'SHOW STATUS LIKE \"wsrep_incoming_addresses\";'\n  failed_when: false\n  changed_when: false\n  register: incoming_addresses\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Set incoming addresses fact (primary)\n  ansible.builtin.set_fact:\n    galera_incoming_addresses: \"{{ (incoming_addresses.stdout.split()[-1] | default('')).split(',') }}\"\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Set node status fact\n  ansible.builtin.set_fact:\n    galera_cluster_ready: \"{{ (galera_wsrep_address_port in galera_incoming_addresses) or ((node_status.stdout.split()[-1] | default(false)) in ['2', '4']) }}\"\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Stop mysql\n  ansible.builtin.service:\n    name: \"{{ galera_mariadb_service_name }}\"\n    state: stopped\n    enabled: true\n  changed_when: true\n  listen:\n    - Restart all mysql\n    - cert installed\n  when:\n    - galera_install_server | bool\n    - not galera_cluster_ready | bool or galera_force_bootstrap | bool\n\n- name: Start new cluster\n  ansible.builtin.command: /usr/local/bin/galera_new_cluster\n  failed_when: not start_new_cluster.rc in [0, 3]\n  changed_when: start_new_cluster.rc == 3\n  register: start_new_cluster\n  delegate_to: \"{{ galera_server_bootstrap_node }}\"\n  run_once: true\n  when:\n    - galera_install_server | bool\n    - not galera_cluster_ready | bool or galera_force_bootstrap | bool\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Restart mysql (All)\n  ansible.builtin.service:\n    name: \"{{ galera_mariadb_service_name }}\"\n    state: \"{{ (not hostvars[item]['galera_cluster_ready'] | bool or galera_force_bootstrap | bool) | ternary('started', 'restarted') }}\"\n    enabled: true\n  environment:\n    MYSQLD_STARTUP_TIMEOUT: 180\n  register: galera_restart\n  until: galera_restart is success\n  retries: 6\n  delay: 5\n  delegate_to: \"{{ item }}\"\n  when:\n    - galera_install_server | bool\n    - hostvars[item]['galera_cluster_ready'] is defined\n    - hostvars[item]['galera_deployed'] | default(false) | bool\n  with_items:\n    - \"{{ ansible_play_hosts }}\"\n  run_once: true\n  listen:\n    - Restart all mysql\n    - cert installed\n\n- name: Delete encryption keyfile after starting Galera\n  ansible.builtin.file:\n    path: \"/tmp/.keyfile.key\"\n    state: absent\n  when: galera_restart is changed\n  listen:\n    - Restart all mysql\n    - cert installed\n","created":"2025-12-08T13:50:36.113917Z","updated":"2025-12-08T13:50:36.113930Z","path":"/home/zuul/src/opendev.org/openstack/openstack-ansible-galera_server/handlers/main.yml"}