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 'jsonl', 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 ****************************** 1 plays in /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml PLAY [Verify HA functionality with external clusters and templates] ************ [WARNING]: Failure using method (v2_playbook_on_play_start) in callback plugin (): 'Play' object has no attribute 'get_path' TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:15 Wednesday 14 May 2025 12:12:22 -0400 (0:00:00.027) 0:00:00.027 ********* [WARNING]: Failure using method (v2_runner_on_start) in callback plugin (): 'module' object has no attribute 'timezone' ok: [managed-node2] ok: [managed-node3] ok: [managed-node1] META: ran handlers TASK [Run the role] ************************************************************ task path: /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:113 Wednesday 14 May 2025 12:12:23 -0400 (0:00:01.213) 0:00:01.240 ********* TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.407) 0:00:01.648 ********* included: /tmp/collections-A42/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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.126) 0:00:01.774 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.113) 0:00:01.888 ********* 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-A42/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-A42/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-A42/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-A42/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-A42/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-A42/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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.281) 0:00:02.169 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.112) 0:00:02.281 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.105) 0:00:02.387 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.109) 0:00:02.496 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Wednesday 14 May 2025 12:12:24 -0400 (0:00:00.109) 0:00:02.606 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.109) 0:00:02.716 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.104) 0:00:02.821 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.103) 0:00:02.924 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.107) 0:00:03.031 ********* 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 variable is deprecated] ***** task path: /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.105) 0:00:03.137 ********* skipping: [managed-node1] => {} skipping: [managed-node3] => {} skipping: [managed-node2] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] ************** task path: /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.105) 0:00:03.242 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.104) 0:00:03.346 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.112) 0:00:03.459 ********* 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-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Wednesday 14 May 2025 12:12:25 -0400 (0:00:00.126) 0:00:03.585 ********* fatal: [managed-node1]: FAILED! => { "changed": false } MSG: mssql_ha_configure=true does not support running against EL 7 hosts [WARNING]: Failure using method (v2_runner_on_failed) in callback plugin (): 'CallbackModule' object has no attribute '_current_task' 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-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:123 Wednesday 14 May 2025 12:12:26 -0400 (0:00:00.132) 0:00:03.718 ********* 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-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:129 Wednesday 14 May 2025 12:12:26 -0400 (0:00:00.112) 0:00:03.830 ********* 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=6 changed=0 unreachable=0 failed=0 skipped=13 rescued=1 ignored=0 managed-node2 : ok=6 changed=0 unreachable=0 failed=0 skipped=13 rescued=1 ignored=0 managed-node3 : ok=6 changed=0 unreachable=0 failed=0 skipped=13 rescued=1 ignored=0 SYSTEM ROLES ERRORS BEGIN v1 [] SYSTEM ROLES ERRORS END v1 TASKS RECAP ******************************************************************** Wednesday 14 May 2025 12:12:26 -0400 (0:00:00.150) 0:00:03.981 ********* =============================================================================== Gathering Facts --------------------------------------------------------- 1.21s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:15 Run the role ------------------------------------------------------------ 0.41s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:113 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.28s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Clean up after the role invocation -------------------------------------- 0.15s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:129 fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.13s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.13s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.13s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Assert that the role failed with EL 7 not supported --------------------- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_external.yml:123 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.11s /tmp/collections-A42/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.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated --- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 fedora.linux_system_roles.mssql : Print that variable is deprecated ----- 0.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact --- 0.11s /tmp/collections-A42/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.11s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.10s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Link the deprecated fact -------------- 0.10s /tmp/collections-A42/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83