ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, Nov 14 2023, 16:14:06) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] Using /etc/ansible/ansible.cfg as config file [WARNING]: running playbook inside collection fedora.linux_system_roles Skipping callback 'actionable', as we already have a stdout callback. Skipping callback 'counter_enabled', as we already have a stdout callback. Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'full_skip', as we already have a stdout callback. Skipping callback 'json', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'null', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. Skipping callback 'selective', as we already have a stdout callback. Skipping callback 'skippy', as we already have a stdout callback. Skipping callback 'stderr', as we already have a stdout callback. Skipping callback 'unixy', as we already have a stdout callback. Skipping callback 'yaml', as we already have a stdout callback. PLAYBOOK: tests_configure_ha_cluster_read_scale.yml **************************** 2 plays in /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Thursday 05 September 2024 05:34:22 -0400 (0:00:00.143) 0:00:00.143 **** ok: [managed-node1] => {"ansible_facts": {"mssql_password": {"__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n"}}, "ansible_included_var_files": ["/tmp/mssql-N0d/tests/vars/vault-variables.yml"], "changed": false} ok: [managed-node3] => {"ansible_facts": {"mssql_password": {"__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n"}}, "ansible_included_var_files": ["/tmp/mssql-N0d/tests/vars/vault-variables.yml"], "changed": false} 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-N0d/tests/vars/vault-variables.yml"], "changed": false} META: ran handlers META: ran handlers PLAY [Verify HA functionality with read-scale clusters] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:24 Thursday 05 September 2024 05:34:22 -0400 (0:00:00.044) 0:00:00.188 **** ok: [managed-node2] ok: [managed-node3] ok: [managed-node1] META: ran handlers META: TASK [Run the role] ************************************************************ task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:62 Thursday 05 September 2024 05:34:24 -0400 (0:00:01.756) 0:00:01.944 **** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Thursday 05 September 2024 05:34:24 -0400 (0:00:00.403) 0:00:02.347 **** included: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node1, managed-node3, managed-node2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Thursday 05 September 2024 05:34:24 -0400 (0:00:00.087) 0:00:02.435 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Thursday 05 September 2024 05:34:24 -0400 (0:00:00.073) 0:00:02.509 **** ok: [managed-node1] => (item=RedHat.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2022], "__mssql_tuned_supported": true}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [managed-node1] => (item=CentOS.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False"} ok: [managed-node1] => (item=CentOS_7.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2017, 2019]}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml"], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml"} skipping: [managed-node1] => (item=CentOS_7.9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False"} ok: [managed-node3] => (item=RedHat.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2022], "__mssql_tuned_supported": true}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} ok: [managed-node2] => (item=RedHat.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2022], "__mssql_tuned_supported": true}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [managed-node2] => (item=CentOS.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False"} skipping: [managed-node3] => (item=CentOS.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False"} ok: [managed-node3] => (item=CentOS_7.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2017, 2019]}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml"], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml"} skipping: [managed-node3] => (item=CentOS_7.9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False"} ok: [managed-node2] => (item=CentOS_7.yml) => {"ansible_facts": {"__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [2017, 2019]}, "ansible_included_var_files": ["/tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml"], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml"} skipping: [managed-node2] => (item=CentOS_7.9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Thursday 05 September 2024 05:34:24 -0400 (0:00:00.239) 0:00:02.748 **** ok: [managed-node1] => {"ansible_facts": {"__mssql_sqlcmd_login_cmd": null}, "changed": false} ok: [managed-node3] => {"ansible_facts": {"__mssql_sqlcmd_login_cmd": null}, "changed": false} ok: [managed-node2] => {"ansible_facts": {"__mssql_sqlcmd_login_cmd": null}, "changed": false} TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Thursday 05 September 2024 05:34:24 -0400 (0:00:00.073) 0:00:02.822 **** skipping: [managed-node1] => {} skipping: [managed-node3] => {} skipping: [managed-node2] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.067) 0:00:02.889 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.068) 0:00:02.957 **** skipping: [managed-node1] => {} skipping: [managed-node3] => {} skipping: [managed-node2] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.066) 0:00:03.024 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.071) 0:00:03.095 **** skipping: [managed-node1] => {} skipping: [managed-node3] => {} skipping: [managed-node2] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.068) 0:00:03.163 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.069) 0:00:03.233 **** skipping: [managed-node1] => {} skipping: [managed-node3] => {} skipping: [managed-node2] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.067) 0:00:03.300 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.067) 0:00:03.368 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.072) 0:00:03.440 **** ok: [managed-node1] => { "changed": false, "msg": "All assertions passed" } ok: [managed-node3] => { "changed": false, "msg": "All assertions passed" } ok: [managed-node2] => { "changed": false, "msg": "All assertions passed" } TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.085) 0:00:03.525 **** fatal: [managed-node1]: FAILED! => {"changed": false, "msg": "mssql_ha_configure=true does not support running against EL 7 hosts"} fatal: [managed-node3]: FAILED! => {"changed": false, "msg": "mssql_ha_configure=true does not support running against EL 7 hosts"} fatal: [managed-node2]: FAILED! => {"changed": false, "msg": "mssql_ha_configure=true does not support running against EL 7 hosts"} TASK [Assert that the role failed with EL 7 not supported] ********************* task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:72 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.086) 0:00:03.612 **** ok: [managed-node1] => { "changed": false, "msg": "All assertions passed" } ok: [managed-node3] => { "changed": false, "msg": "All assertions passed" } ok: [managed-node2] => { "changed": false, "msg": "All assertions passed" } TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:78 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.078) 0:00:03.690 **** skipping: [managed-node1] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node3] => {"changed": false, "skip_reason": "Conditional result was False"} skipping: [managed-node2] => {"changed": false, "skip_reason": "Conditional result was False"} META: ending play for managed-node1 META: ending play for managed-node3 META: ending play for managed-node2 PLAY RECAP ********************************************************************* managed-node1 : ok=7 changed=0 unreachable=0 failed=0 skipped=11 rescued=1 ignored=0 managed-node2 : ok=7 changed=0 unreachable=0 failed=0 skipped=11 rescued=1 ignored=0 managed-node3 : ok=7 changed=0 unreachable=0 failed=0 skipped=11 rescued=1 ignored=0 Thursday 05 September 2024 05:34:25 -0400 (0:00:00.096) 0:00:03.786 **** =============================================================================== Gathering Facts --------------------------------------------------------- 1.76s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:24 Run the role ------------------------------------------------------------ 0.40s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:62 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.24s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Clean up after the role invocation -------------------------------------- 0.10s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:78 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.09s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.09s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.09s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Assert that the role failed with EL 7 not supported --------------------- 0.08s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:72 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.07s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Include vault variables ------------------------------------------------- 0.04s /tmp/collections-dTx/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5