ansible-playbook [core 2.17.11] config file = None configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.12/site-packages/ansible ansible collection location = /tmp/collections-geD executable location = /usr/local/bin/ansible-playbook python version = 3.12.10 (main, Apr 22 2025, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-5)] (/usr/bin/python3.12) jinja version = 3.1.6 libyaml = True No config file found; using defaults running playbook inside collection fedora.linux_system_roles redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug redirecting (type: callback) ansible.builtin.profile_tasks to ansible.posix.profile_tasks Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: tests_configure_ha_cluster_read_scale.yml **************************** 2 plays in /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Friday 16 May 2025 00:49:15 -0400 (0:00:00.013) 0:00:00.013 ************ ok: [managed-node2] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/tmp/mssql-OaY/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Verify HA functionality with read-scale clusters] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:21 Friday 16 May 2025 00:49:15 -0400 (0:00:00.027) 0:00:00.041 ************ [WARNING]: Platform linux on host managed-node2 is using the discovered Python interpreter at /usr/bin/python3.9, but future installation of another Python interpreter could change the meaning of that path. See https://docs.ansible.com/ansible- core/2.17/reference_appendices/interpreter_discovery.html for more information. ok: [managed-node2] TASK [Clusters of a read_scale type must not have a witness node] ************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:51 Friday 16 May 2025 00:49:16 -0400 (0:00:01.232) 0:00:01.274 ************ META: end_play conditional evaluated to False, continuing play skipping: [managed-node2] => { "skip_reason": "end_play conditional evaluated to False, continuing play" } MSG: end_play TASK [Run the role] ************************************************************ task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:60 Friday 16 May 2025 00:49:16 -0400 (0:00:00.062) 0:00:01.336 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:66 Friday 16 May 2025 00:49:16 -0400 (0:00:00.025) 0:00:01.362 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:76 Friday 16 May 2025 00:49:16 -0400 (0:00:00.019) 0:00:01.382 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [End EL 7 host] *********************************************************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:81 Friday 16 May 2025 00:49:16 -0400 (0:00:00.015) 0:00:01.397 ************ META: end_host conditional evaluated to False, continuing execution for managed-node2 skipping: [managed-node2] => { "skip_reason": "end_host conditional evaluated to False, continuing execution for managed-node2" } MSG: end_host conditional evaluated to false, continuing execution for managed-node2 TASK [Set facts to create test DBs on primary as a pre task] ******************* task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:84 Friday 16 May 2025 00:49:16 -0400 (0:00:00.010) 0:00:01.408 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Run on all hosts to configure read-scale cluster] ************************ task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:91 Friday 16 May 2025 00:49:16 -0400 (0:00:00.019) 0:00:01.427 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Verify that the database exists on the secondary servers] **************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:95 Friday 16 May 2025 00:49:16 -0400 (0:00:00.017) 0:00:01.445 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Assert that the template reported changed state] ************************* task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:115 Friday 16 May 2025 00:49:16 -0400 (0:00:00.017) 0:00:01.462 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:121 Friday 16 May 2025 00:49:16 -0400 (0:00:00.016) 0:00:01.479 ************ skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_play_hosts_all | length >= 3", "skip_reason": "Conditional result was False" } PLAY RECAP ********************************************************************* managed-node2 : ok=2 changed=0 unreachable=0 failed=0 skipped=8 rescued=0 ignored=0 TASKS RECAP ******************************************************************** Friday 16 May 2025 00:49:16 -0400 (0:00:00.011) 0:00:01.490 ************ =============================================================================== Gathering Facts --------------------------------------------------------- 1.23s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:21 Clusters of a read_scale type must not have a witness node -------------- 0.06s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:51 Include vault variables ------------------------------------------------- 0.03s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Run the role ------------------------------------------------------------ 0.03s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:60 Unreachable task -------------------------------------------------------- 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:66 Set facts to create test DBs on primary as a pre task ------------------- 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:84 Verify that the database exists on the secondary servers ---------------- 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:95 Run on all hosts to configure read-scale cluster ------------------------ 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:91 Assert that the template reported changed state ------------------------- 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:115 Clean up after the role invocation -------------------------------------- 0.02s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:76 Clean up after the role invocation -------------------------------------- 0.01s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:121 End EL 7 host ----------------------------------------------------------- 0.01s /tmp/collections-geD/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:81