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_external.yml ****************************** 2 plays in /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:5 Wednesday 16 October 2024 05:43:03 -0400 (0:00:00.021) 0:00:00.021 ***** 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-eaT/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-eaT/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-eaT/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Verify HA functionality with external clusters and templates] ************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:21 Wednesday 16 October 2024 05:43:03 -0400 (0:00:00.061) 0:00:00.083 ***** ok: [managed-node2] ok: [managed-node3] ok: [managed-node1] META: ran handlers TASK [Run the role] ************************************************************ task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:119 Wednesday 16 October 2024 05:43:04 -0400 (0:00:00.916) 0:00:00.999 ***** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 16 October 2024 05:43:04 -0400 (0:00:00.379) 0:00:01.379 ***** included: /tmp/collections-rXu/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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.120) 0:00:01.499 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.112) 0:00:01.612 ***** 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-rXu/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-rXu/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-rXu/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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } 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-rXu/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" } skipping: [managed-node2] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.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-rXu/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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.241) 0:00:01.853 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.102) 0:00:01.956 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.099) 0:00:02.056 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.100) 0:00:02.156 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.098) 0:00:02.255 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.100) 0:00:02.356 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Wednesday 16 October 2024 05:43:05 -0400 (0:00:00.098) 0:00:02.455 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.099) 0:00:02.555 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.098) 0:00:02.653 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.103) 0:00:02.756 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.109) 0:00:02.866 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.120) 0:00:02.987 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:129 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.116) 0:00:03.104 ***** 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-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:135 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.105) 0:00:03.210 ***** 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 Wednesday 16 October 2024 05:43:06 -0400 (0:00:00.140) 0:00:03.350 ***** =============================================================================== Gathering Facts --------------------------------------------------------- 0.92s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:21 Run the role ------------------------------------------------------------ 0.38s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:119 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.24s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Clean up after the role invocation -------------------------------------- 0.14s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:135 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.12s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.12s /tmp/collections-rXu/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.12s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.11s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported --- 0.11s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 Assert that the role failed with EL 7 not supported --------------------- 0.11s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:129 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.10s /tmp/collections-rXu/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.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated --- 0.10s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Include vault variables ------------------------------------------------- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:5