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-rXu/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-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5 Wednesday 16 October 2024 05:42:57 -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 read-scale clusters] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:21 Wednesday 16 October 2024 05:42:57 -0400 (0:00:00.038) 0:00:00.060 ***** ok: [managed-node2] ok: [managed-node3] ok: [managed-node1] META: ran handlers META: TASK [Run the role] ************************************************************ task path: /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:60 Wednesday 16 October 2024 05:42:59 -0400 (0:00:01.673) 0:00:01.734 ***** 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:42:59 -0400 (0:00:00.388) 0:00:02.122 ***** 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:00 -0400 (0:00:00.090) 0:00:02.213 ***** 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:00 -0400 (0:00:00.068) 0:00:02.282 ***** 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:00 -0400 (0:00:00.230) 0:00:02.512 ***** 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:00 -0400 (0:00:00.067) 0:00:02.580 ***** 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:00 -0400 (0:00:00.061) 0:00:02.641 ***** 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:00 -0400 (0:00:00.061) 0:00:02.703 ***** 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:00 -0400 (0:00:00.062) 0:00:02.766 ***** 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:00 -0400 (0:00:00.062) 0:00:02.829 ***** 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:00 -0400 (0:00:00.061) 0:00:02.891 ***** 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:00 -0400 (0:00:00.065) 0:00:02.956 ***** 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:00 -0400 (0:00:00.061) 0:00:03.018 ***** 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:00 -0400 (0:00:00.062) 0:00:03.080 ***** 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:00 -0400 (0:00:00.068) 0:00:03.149 ***** 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:01 -0400 (0:00:00.077) 0:00:03.226 ***** 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_read_scale.yml:70 Wednesday 16 October 2024 05:43:01 -0400 (0:00:00.081) 0:00:03.308 ***** 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_read_scale.yml:76 Wednesday 16 October 2024 05:43:01 -0400 (0:00:00.073) 0:00:03.382 ***** 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:01 -0400 (0:00:00.091) 0:00:03.473 ***** =============================================================================== Gathering Facts --------------------------------------------------------- 1.67s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:21 Run the role ------------------------------------------------------------ 0.39s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:60 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.23s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Clean up after the role invocation -------------------------------------- 0.09s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:76 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.09s /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.08s /tmp/collections-rXu/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.08s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Assert that the role failed with EL 7 not supported --------------------- 0.07s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:70 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.07s /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.07s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.07s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact --- 0.07s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact --- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.06s /tmp/collections-rXu/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.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.06s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Include vault variables ------------------------------------------------- 0.04s /tmp/collections-rXu/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_configure_ha_cluster_read_scale.yml:5