{"id":387,"sha1":"c8d5216f40762c32d3bdb13df3e7e286a81cf4dd","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 2014, 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: Run mysql_upgrade\n  block:\n    - name: Fail if upgrade is needed\n      ansible.builtin.command: /usr/bin/mariadb-upgrade --check-if-upgrade-is-needed\n      register: galera_upgrade_check\n      failed_when: galera_upgrade_check.rc == 0\n      changed_when: false\n  rescue:\n    - name: Run MySQL Upgrade\n      ansible.builtin.command: /usr/bin/mariadb-upgrade\n      register: galera_mysql_upgrade\n      changed_when:\n        - not galera_mysql_upgrade.stdout is search(\"already upgraded\")\n      until: galera_mysql_upgrade is success\n      retries: 3\n      delay: 10\n\n# NOTE(noonedeadpunk): We don't need to verify hostname when connectig to socket\n- name: Create galera users\n  community.mysql.mysql_user:\n    name: \"{{ item.name }}\"\n    host: \"{{ item.host }}\"\n    password: \"{{ item.password }}\"\n    priv: \"{{ item.priv }}\"\n    state: \"{{ item.state }}\"\n    resource_limits: \"{{ item.resource_limits | default(omit) }}\"\n    login_unix_socket: \"{{ galera_unix_socket }}\"\n    check_hostname: false\n  with_items: \"{{ galera_setup_users }}\"\n  register: galera_users\n  until: galera_users is success\n  retries: 3\n  delay: 10\n  no_log: true\n","created":"2025-12-08T13:54:15.643162Z","updated":"2025-12-08T13:54:15.643174Z","path":"/home/zuul/src/opendev.org/openstack/openstack-ansible-galera_server/tasks/galera_server_setup.yml"}