[DEPRECATION WARNING]: ANSIBLE_COLLECTIONS_PATHS option, does not fit var naming standard, use the singular form ANSIBLE_COLLECTIONS_PATH instead. This feature will be removed from ansible-core in version 2.19. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. ansible-playbook [core 2.17.3] 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-nJi executable location = /usr/local/bin/ansible-playbook python version = 3.12.5 (main, Aug 23 2024, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-2)] (/usr/bin/python3.12) jinja version = 3.1.4 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-nJi/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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Thursday 29 August 2024 10:15:40 -0400 (0:00:00.012) 0:00:00.012 ******* 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-Pvo/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Verify HA functionality with read-scale clusters] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:24 Thursday 29 August 2024 10:15:40 -0400 (0:00:00.028) 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:54 Thursday 29 August 2024 10:15:41 -0400 (0:00:01.143) 0:00:01.185 ******* 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 [Run the role] ************************************************************ task path: /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:63 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.022) 0:00:01.207 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:69 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.014) 0:00:01.222 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:79 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.014) 0:00:01.236 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:84 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.013) 0:00:01.250 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:87 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.007) 0:00:01.257 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:94 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.013) 0:00:01.270 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:98 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.014) 0:00:01.284 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:118 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.013) 0:00:01.298 ******* 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-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:124 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.013) 0:00:01.311 ******* 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 Thursday 29 August 2024 10:15:41 -0400 (0:00:00.019) 0:00:01.330 ******* =============================================================================== Gathering Facts --------------------------------------------------------- 1.14s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:24 Include vault variables ------------------------------------------------- 0.03s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Clusters of a read_scale type must not have a witness node -------------- 0.02s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:54 Clean up after the role invocation -------------------------------------- 0.02s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:124 Run the role ------------------------------------------------------------ 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:63 Run on all hosts to configure read-scale cluster ------------------------ 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:94 Unreachable task -------------------------------------------------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:69 Clean up after the role invocation -------------------------------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:79 Set facts to create test DBs on primary as a pre task ------------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:87 Verify that the database exists on the secondary servers ---------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:98 Assert that the template reported changed state ------------------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:118 End EL 7 host ----------------------------------------------------------- 0.01s /tmp/collections-nJi/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:84