all:
  children:
    zuul_unreachable:
      hosts: {}
  hosts:
    debian-bookworm:
      ansible_connection: ssh
      ansible_host: 2a13:1a81:8000:3124:f816:3eff:fe2d:37fd
      ansible_port: 22
      ansible_python_interpreter: auto
      ansible_user: zuul
      nodepool:
        az: nova
        cloud: regiocloud-a-ci
        external_id: 8c0d34c0-a36a-4462-ab0b-8e0c24635547
        host_id: 82101243836454d7401d5893feae9e2c5df7cc291646d8a99b33b53b
        interface_ip: 2a13:1a81:8000:3124:f816:3eff:fe2d:37fd
        label: debian-bookworm
        node_properties: {}
        private_ipv4: 10.128.7.201
        private_ipv6: null
        provider: regiocloud-a
        public_ipv4: 81.163.192.224
        public_ipv6: 2a13:1a81:8000:3124:f816:3eff:fe2d:37fd
        region: null
        slot: null
  vars:
    zuul:
      _inheritance_path:
      - '<Job base explicit: None implied: {MatchAny:{ImpliedBranchMatcher:main}}
        source: osism/zuul-config/zuul.d/jobs.yaml@main#2>'
      - '<Job python-black explicit: None implied: {MatchAny:{ImpliedBranchMatcher:main}}
        source: osism/zuul-jobs/.zuul.yaml@main#54>'
      - '<Job python-black explicit: None implied: None source: osism/testbed/.zuul.yaml@main#324>'
      ansible_version: '9'
      attempts: 1
      branch: main
      build: 061c6174f2a14c32841f880761516052
      build_refs:
      - branch: main
        change: '2890'
        change_message: "check: use mariadb-client instead of mysql-client\n\n## Summary\n\n-
          On Ubuntu, `mysql-client` resolves to the MySQL 8.0 client, which sends
          `utf8mb4_0900_ai_ci` in SQL query packets. MariaDB rejects that collation
          with `ERROR 1273 (HY000)` on versions before 11.4.5; kolla 2024.2 ships
          MariaDB 10.11.\n- The `check_galera_cluster` nagios plugin's first real
          SQL query fails silently, leaving `wsrep_cluster_state_uuid` empty and causing
          the plugin to report `CRITICAL: node is not part of a cluster` even when
          the cluster is healthy.\n- Replace the Ubuntu/Debian split (`mysql-client`
          / `mariadb-client`) with `mariadb-client` unconditionally. `mariadb-client`
          provides a `mysql` compatibility symlink, so the `check_executable mysql`
          check in the plugin continues to work. The package is available in Ubuntu
          universe on 20.04, 22.04, and 24.04.\n\n## Test plan\n\n- [x] Deployed testbed
          at `--version-manager 9.5.0` (so `MANAGER_VERSION=9.5.0` in `/opt/manager-vars.sh`,
          which triggers the `check_galera_cluster` path in `200-infrastructure.sh`
          rather than `osism status database`)\n- [x] Post-upgrade `check.sh` ran
          `check_galera_cluster` with `mariadb-client` installed \u2014 returned `OK:
          number of NODES = 3` with no collation error\n- [x] Overall upgrade run
          status: success\n\n\U0001F916 Generated with [Claude Code](https://claude.com/claude-code)"
        change_url: https://github.com/osism/testbed/pull/2890
        commit_id: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        patchset: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        project:
          canonical_hostname: github.com
          canonical_name: github.com/osism/testbed
          name: osism/testbed
          short_name: testbed
        src_dir: src/github.com/osism/testbed
        topic: null
      buildset: a120e1427a10434c8ea78f3a9b3a1d66
      buildset_refs:
      - branch: main
        change: '2890'
        change_message: "check: use mariadb-client instead of mysql-client\n\n## Summary\n\n-
          On Ubuntu, `mysql-client` resolves to the MySQL 8.0 client, which sends
          `utf8mb4_0900_ai_ci` in SQL query packets. MariaDB rejects that collation
          with `ERROR 1273 (HY000)` on versions before 11.4.5; kolla 2024.2 ships
          MariaDB 10.11.\n- The `check_galera_cluster` nagios plugin's first real
          SQL query fails silently, leaving `wsrep_cluster_state_uuid` empty and causing
          the plugin to report `CRITICAL: node is not part of a cluster` even when
          the cluster is healthy.\n- Replace the Ubuntu/Debian split (`mysql-client`
          / `mariadb-client`) with `mariadb-client` unconditionally. `mariadb-client`
          provides a `mysql` compatibility symlink, so the `check_executable mysql`
          check in the plugin continues to work. The package is available in Ubuntu
          universe on 20.04, 22.04, and 24.04.\n\n## Test plan\n\n- [x] Deployed testbed
          at `--version-manager 9.5.0` (so `MANAGER_VERSION=9.5.0` in `/opt/manager-vars.sh`,
          which triggers the `check_galera_cluster` path in `200-infrastructure.sh`
          rather than `osism status database`)\n- [x] Post-upgrade `check.sh` ran
          `check_galera_cluster` with `mariadb-client` installed \u2014 returned `OK:
          number of NODES = 3` with no collation error\n- [x] Overall upgrade run
          status: success\n\n\U0001F916 Generated with [Claude Code](https://claude.com/claude-code)"
        change_url: https://github.com/osism/testbed/pull/2890
        commit_id: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        patchset: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        project:
          canonical_hostname: github.com
          canonical_name: github.com/osism/testbed
          name: osism/testbed
          short_name: testbed
        src_dir: src/github.com/osism/testbed
        topic: null
      change: '2890'
      change_message: "check: use mariadb-client instead of mysql-client\n\n## Summary\n\n-
        On Ubuntu, `mysql-client` resolves to the MySQL 8.0 client, which sends `utf8mb4_0900_ai_ci`
        in SQL query packets. MariaDB rejects that collation with `ERROR 1273 (HY000)`
        on versions before 11.4.5; kolla 2024.2 ships MariaDB 10.11.\n- The `check_galera_cluster`
        nagios plugin's first real SQL query fails silently, leaving `wsrep_cluster_state_uuid`
        empty and causing the plugin to report `CRITICAL: node is not part of a cluster`
        even when the cluster is healthy.\n- Replace the Ubuntu/Debian split (`mysql-client`
        / `mariadb-client`) with `mariadb-client` unconditionally. `mariadb-client`
        provides a `mysql` compatibility symlink, so the `check_executable mysql`
        check in the plugin continues to work. The package is available in Ubuntu
        universe on 20.04, 22.04, and 24.04.\n\n## Test plan\n\n- [x] Deployed testbed
        at `--version-manager 9.5.0` (so `MANAGER_VERSION=9.5.0` in `/opt/manager-vars.sh`,
        which triggers the `check_galera_cluster` path in `200-infrastructure.sh`
        rather than `osism status database`)\n- [x] Post-upgrade `check.sh` ran `check_galera_cluster`
        with `mariadb-client` installed \u2014 returned `OK: number of NODES = 3`
        with no collation error\n- [x] Overall upgrade run status: success\n\n\U0001F916
        Generated with [Claude Code](https://claude.com/claude-code)"
      change_url: https://github.com/osism/testbed/pull/2890
      child_jobs: []
      commit_id: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
      event_id: 6e857ac0-5060-11f1-9ab8-97abe5d60244
      executor:
        hostname: 521e9411259a
        inventory_file: /var/lib/zuul/builds/061c6174f2a14c32841f880761516052/ansible/inventory.yaml
        log_root: /var/lib/zuul/builds/061c6174f2a14c32841f880761516052/work/logs
        result_data_file: /var/lib/zuul/builds/061c6174f2a14c32841f880761516052/work/results.json
        src_root: /var/lib/zuul/builds/061c6174f2a14c32841f880761516052/work/src
        work_root: /var/lib/zuul/builds/061c6174f2a14c32841f880761516052/work
      include_vars: []
      items:
      - branch: main
        change: '2890'
        change_message: "check: use mariadb-client instead of mysql-client\n\n## Summary\n\n-
          On Ubuntu, `mysql-client` resolves to the MySQL 8.0 client, which sends
          `utf8mb4_0900_ai_ci` in SQL query packets. MariaDB rejects that collation
          with `ERROR 1273 (HY000)` on versions before 11.4.5; kolla 2024.2 ships
          MariaDB 10.11.\n- The `check_galera_cluster` nagios plugin's first real
          SQL query fails silently, leaving `wsrep_cluster_state_uuid` empty and causing
          the plugin to report `CRITICAL: node is not part of a cluster` even when
          the cluster is healthy.\n- Replace the Ubuntu/Debian split (`mysql-client`
          / `mariadb-client`) with `mariadb-client` unconditionally. `mariadb-client`
          provides a `mysql` compatibility symlink, so the `check_executable mysql`
          check in the plugin continues to work. The package is available in Ubuntu
          universe on 20.04, 22.04, and 24.04.\n\n## Test plan\n\n- [x] Deployed testbed
          at `--version-manager 9.5.0` (so `MANAGER_VERSION=9.5.0` in `/opt/manager-vars.sh`,
          which triggers the `check_galera_cluster` path in `200-infrastructure.sh`
          rather than `osism status database`)\n- [x] Post-upgrade `check.sh` ran
          `check_galera_cluster` with `mariadb-client` installed \u2014 returned `OK:
          number of NODES = 3` with no collation error\n- [x] Overall upgrade run
          status: success\n\n\U0001F916 Generated with [Claude Code](https://claude.com/claude-code)"
        change_url: https://github.com/osism/testbed/pull/2890
        commit_id: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        patchset: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
        project:
          canonical_hostname: github.com
          canonical_name: github.com/osism/testbed
          name: osism/testbed
          short_name: testbed
          src_dir: src/github.com/osism/testbed
        topic: null
      job: python-black
      jobtags: []
      max_attempts: 3
      message: Y2hlY2s6IHVzZSBtYXJpYWRiLWNsaWVudCBpbnN0ZWFkIG9mIG15c3FsLWNsaWVudAoKIyMgU3VtbWFyeQoKLSBPbiBVYnVudHUsIGBteXNxbC1jbGllbnRgIHJlc29sdmVzIHRvIHRoZSBNeVNRTCA4LjAgY2xpZW50LCB3aGljaCBzZW5kcyBgdXRmOG1iNF8wOTAwX2FpX2NpYCBpbiBTUUwgcXVlcnkgcGFja2V0cy4gTWFyaWFEQiByZWplY3RzIHRoYXQgY29sbGF0aW9uIHdpdGggYEVSUk9SIDEyNzMgKEhZMDAwKWAgb24gdmVyc2lvbnMgYmVmb3JlIDExLjQuNTsga29sbGEgMjAyNC4yIHNoaXBzIE1hcmlhREIgMTAuMTEuCi0gVGhlIGBjaGVja19nYWxlcmFfY2x1c3RlcmAgbmFnaW9zIHBsdWdpbidzIGZpcnN0IHJlYWwgU1FMIHF1ZXJ5IGZhaWxzIHNpbGVudGx5LCBsZWF2aW5nIGB3c3JlcF9jbHVzdGVyX3N0YXRlX3V1aWRgIGVtcHR5IGFuZCBjYXVzaW5nIHRoZSBwbHVnaW4gdG8gcmVwb3J0IGBDUklUSUNBTDogbm9kZSBpcyBub3QgcGFydCBvZiBhIGNsdXN0ZXJgIGV2ZW4gd2hlbiB0aGUgY2x1c3RlciBpcyBoZWFsdGh5LgotIFJlcGxhY2UgdGhlIFVidW50dS9EZWJpYW4gc3BsaXQgKGBteXNxbC1jbGllbnRgIC8gYG1hcmlhZGItY2xpZW50YCkgd2l0aCBgbWFyaWFkYi1jbGllbnRgIHVuY29uZGl0aW9uYWxseS4gYG1hcmlhZGItY2xpZW50YCBwcm92aWRlcyBhIGBteXNxbGAgY29tcGF0aWJpbGl0eSBzeW1saW5rLCBzbyB0aGUgYGNoZWNrX2V4ZWN1dGFibGUgbXlzcWxgIGNoZWNrIGluIHRoZSBwbHVnaW4gY29udGludWVzIHRvIHdvcmsuIFRoZSBwYWNrYWdlIGlzIGF2YWlsYWJsZSBpbiBVYnVudHUgdW5pdmVyc2Ugb24gMjAuMDQsIDIyLjA0LCBhbmQgMjQuMDQuCgojIyBUZXN0IHBsYW4KCi0gW3hdIERlcGxveWVkIHRlc3RiZWQgYXQgYC0tdmVyc2lvbi1tYW5hZ2VyIDkuNS4wYCAoc28gYE1BTkFHRVJfVkVSU0lPTj05LjUuMGAgaW4gYC9vcHQvbWFuYWdlci12YXJzLnNoYCwgd2hpY2ggdHJpZ2dlcnMgdGhlIGBjaGVja19nYWxlcmFfY2x1c3RlcmAgcGF0aCBpbiBgMjAwLWluZnJhc3RydWN0dXJlLnNoYCByYXRoZXIgdGhhbiBgb3Npc20gc3RhdHVzIGRhdGFiYXNlYCkKLSBbeF0gUG9zdC11cGdyYWRlIGBjaGVjay5zaGAgcmFuIGBjaGVja19nYWxlcmFfY2x1c3RlcmAgd2l0aCBgbWFyaWFkYi1jbGllbnRgIGluc3RhbGxlZCDigJQgcmV0dXJuZWQgYE9LOiBudW1iZXIgb2YgTk9ERVMgPSAzYCB3aXRoIG5vIGNvbGxhdGlvbiBlcnJvcgotIFt4XSBPdmVyYWxsIHVwZ3JhZGUgcnVuIHN0YXR1czogc3VjY2VzcwoK8J+kliBHZW5lcmF0ZWQgd2l0aCBbQ2xhdWRlIENvZGVdKGh0dHBzOi8vY2xhdWRlLmNvbS9jbGF1ZGUtY29kZSk=
      patchset: 8ab6bdd1749bab1f65b4355a2e86edc6df83cba5
      pipeline: check
      playbook_context:
        playbook_projects:
          trusted/project_0/github.com/osism/zuul-config:
            canonical_name: github.com/osism/zuul-config
            checkout: main
            commit: 58f24f5b479e15eb2d520850d27e3b1b6fc66aa6
          trusted/project_1/github.com/osism/openinfra-zuul-jobs:
            canonical_name: github.com/osism/openinfra-zuul-jobs
            checkout: master
            commit: 038dd8b856c62af4433c8477c5cb3d0480847059
          trusted/project_2/github.com/osism/zuul-jobs:
            canonical_name: github.com/osism/zuul-jobs
            checkout: main
            commit: 0c74c57cedff2b36bb37ca68a5338d1c49991496
          untrusted/project_0/github.com/osism/zuul-jobs:
            canonical_name: github.com/osism/zuul-jobs
            checkout: main
            commit: 0c74c57cedff2b36bb37ca68a5338d1c49991496
          untrusted/project_1/github.com/osism/zuul-config:
            canonical_name: github.com/osism/zuul-config
            checkout: main
            commit: 58f24f5b479e15eb2d520850d27e3b1b6fc66aa6
          untrusted/project_2/github.com/osism/openinfra-zuul-jobs:
            canonical_name: github.com/osism/openinfra-zuul-jobs
            checkout: master
            commit: 038dd8b856c62af4433c8477c5cb3d0480847059
        playbooks:
        - path: untrusted/project_0/github.com/osism/zuul-jobs/playbooks/python-black/run.yml
          roles:
          - checkout: main
            checkout_description: zuul branch
            link_name: ansible/playbook_0/role_0/zuul-config
            link_target: untrusted/project_1/github.com/osism/zuul-config
            role_path: ansible/playbook_0/role_0/zuul-config/roles
          - checkout: master
            checkout_description: project default branch
            link_name: ansible/playbook_0/role_1/openinfra-zuul-jobs
            link_target: untrusted/project_2/github.com/osism/openinfra-zuul-jobs
            role_path: ansible/playbook_0/role_1/openinfra-zuul-jobs/roles
          - checkout: main
            checkout_description: playbook branch
            link_name: ansible/playbook_0/role_2/zuul-jobs
            link_target: untrusted/project_0/github.com/osism/zuul-jobs
            role_path: ansible/playbook_0/role_2/zuul-jobs/roles
      post_review: false
      post_timeout: null
      pre_timeout: null
      project:
        canonical_hostname: github.com
        canonical_name: github.com/osism/testbed
        name: osism/testbed
        short_name: testbed
        src_dir: src/github.com/osism/testbed
      projects:
        github.com/osism/testbed:
          canonical_hostname: github.com
          canonical_name: github.com/osism/testbed
          checkout: main
          checkout_description: zuul branch
          commit: 81f9f696b903b5a5e890bb1f29d773c968438cc7
          name: osism/testbed
          required: false
          short_name: testbed
          src_dir: src/github.com/osism/testbed
      ref: refs/pull/2890/head
      resources: {}
      tenant: osism
      timeout: 1800
      topic: null
      voting: true
