# STDOUT: ---v---v---v---v---v--- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = ['/home/jenkins/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /opt/ansible-2.9/lib/python3.9/site-packages/ansible executable location = /opt/ansible-2.9/bin/ansible-playbook python version = 3.9.18 (main, Sep 7 2023, 00:00:00) [GCC 11.4.1 20230605 (Red Hat 11.4.1-2)] Using /etc/ansible/ansible.cfg as config file 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 /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:4 Saturday 08 June 2024 01:29:47 +0000 (0:00:00.013) 0:00:00.013 ********* ok: [sut] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-cimmt93l2g/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: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:9 Saturday 08 June 2024 01:29:47 +0000 (0:00:00.042) 0:00:00.056 ********* ok: [sut] META: ran handlers TASK [Run the role] ************************************************************ task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:110 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.697) 0:00:00.753 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:116 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.018) 0:00:00.772 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Clean up after the role invocation] ************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:126 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.017) 0:00:00.789 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } META: end_host conditional evaluated to false, continuing execution for sut TASK [Run role with mssql_replica_type=primary not defined] ******************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:137 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.038) 0:00:00.828 ********* TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.163) 0:00:00.992 ********* included: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.033) 0:00:01.025 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.025) 0:00:01.051 ********* ok: [sut] => (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": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [sut] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [sut] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.035) 0:00:01.087 ********* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.011) 0:00:01.098 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.011) 0:00:01.109 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.009) 0:00:01.119 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.019) 0:00:01.138 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.011) 0:00:01.150 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:51 Saturday 08 June 2024 01:29:48 +0000 (0:00:00.025) 0:00:01.175 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:58 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.011) 0:00:01.186 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:65 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.009) 0:00:01.196 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:69 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.009) 0:00:01.205 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:81 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.017) 0:00:01.223 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:89 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.012) 0:00:01.235 ********* fatal: [sut]: FAILED! => { "assertion": "mssql_ha_replica_type in __mssql_ha_replica_types_all", "changed": false, "evaluated_to": false } MSG: You must set the mssql_ha_replica_type variable to one of primary, synchronous, asynchronous, witness, absent TASK [Assert that the role failed with EL < 8 not supported] ******************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:145 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.013) 0:00:01.248 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [Set the mssql_ha_replica_type fact to appear in hostvars] **************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:152 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.013) 0:00:01.262 ********* ok: [sut] => { "ansible_facts": { "mssql_ha_replica_type": "primary" }, "changed": false } TASK [Set facts to create test DBs on primary as a pre task] ******************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:159 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.010) 0:00:01.273 ********* ok: [sut] => { "ansible_facts": { "mssql_pre_input_sql_file": [ "create_ExampleDB1.sql", "create_ExampleDB2.sql" ] }, "changed": false } TASK [Run on all hosts to configure read-scale cluster] ************************ task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:167 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.018) 0:00:01.291 ********* TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.091) 0:00:01.383 ********* included: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.016) 0:00:01.399 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.025) 0:00:01.424 ********* ok: [sut] => (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": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [sut] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [sut] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.060) 0:00:01.485 ********* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.027) 0:00:01.512 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.020) 0:00:01.533 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.022) 0:00:01.555 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.035) 0:00:01.591 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.032) 0:00:01.624 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:51 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.029) 0:00:01.653 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:58 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.026) 0:00:01.680 ********* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:65 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.016) 0:00:01.696 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:69 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.023) 0:00:01.720 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:81 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.026) 0:00:01.746 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:89 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.016) 0:00:01.763 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:98 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.024) 0:00:01.788 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:111 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.021) 0:00:01.809 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:122 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.022) 0:00:01.832 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:131 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.011) 0:00:01.843 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Gather package facts] ************************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 Saturday 08 June 2024 01:29:49 +0000 (0:00:00.018) 0:00:01.861 ********* ok: [sut] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [linux-system-roles.mssql : Set fact with the currently installed SQL Server version if any] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:146 Saturday 08 June 2024 01:29:51 +0000 (0:00:01.554) 0:00:03.416 ********* skipping: [sut] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set mssql_version variable if user does not define it] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:155 Saturday 08 June 2024 01:29:51 +0000 (0:00:00.039) 0:00:03.455 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:162 Saturday 08 June 2024 01:29:51 +0000 (0:00:00.018) 0:00:03.474 ********* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:169 Saturday 08 June 2024 01:29:51 +0000 (0:00:00.021) 0:00:03.496 ********* skipping: [sut] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:184 Saturday 08 June 2024 01:29:51 +0000 (0:00:00.035) 0:00:03.531 ********* changed: [sut] => { "attempts": 1, "changed": true } TASK [linux-system-roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:198 Saturday 08 June 2024 01:29:52 +0000 (0:00:01.306) 0:00:04.837 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Get yum repositories] ************************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:208 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.021) 0:00:04.858 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:219 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.034) 0:00:04.893 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:233 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.021) 0:00:04.914 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Get zypper repositories] ********************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:242 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.024) 0:00:04.939 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:254 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.022) 0:00:04.961 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2022] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:261 Saturday 08 June 2024 01:29:52 +0000 (0:00:00.057) 0:00:05.018 ********* changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2022", "state": "present" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2022] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:273 Saturday 08 June 2024 01:29:53 +0000 (0:00:00.294) 0:00:05.313 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure to run as a confined application with SELinux] *** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:286 Saturday 08 June 2024 01:29:53 +0000 (0:00:00.028) 0:00:05.341 ********* fatal: [sut]: FAILED! => { "changed": false, "rc": 1, "results": [] } MSG: Failed to download metadata for repo 'appstream': Cannot prepare internal mirrorlist: No URLs in mirrorlist TASK [Clean up after the role invocation] ************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:1005 Saturday 08 June 2024 01:29:54 +0000 (0:00:00.893) 0:00:06.235 ********* included: /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml for sut TASK [Gather package facts] **************************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:2 Saturday 08 June 2024 01:29:54 +0000 (0:00:00.063) 0:00:06.299 ********* ok: [sut] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [Purge cluster configuration] ********************************************* task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:6 Saturday 08 June 2024 01:29:55 +0000 (0:00:01.309) 0:00:07.608 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:14 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.023) 0:00:07.632 ********* ok: [sut] => { "ansible_python_version": "3.6.8" } TASK [Purge firewall configuration] ******************************************** task path: /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:18 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.021) 0:00:07.653 ********* TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.065) 0:00:07.719 ********* included: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for sut TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.036) 0:00:07.755 ********* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.025) 0:00:07.781 ********* ok: [sut] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] *** task path: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.296) 0:00:08.078 ********* ok: [sut] => { "ansible_facts": { "__firewall_is_ostree": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:19 Saturday 08 June 2024 01:29:55 +0000 (0:00:00.021) 0:00:08.099 ********* fatal: [sut]: FAILED! => { "changed": false, "rc": 1, "results": [] } MSG: Failed to download metadata for repo 'appstream': Cannot prepare internal mirrorlist: No URLs in mirrorlist to retry, use: --limit @/tmp/tests_configure_ha_cluster_external.retry PLAY RECAP ********************************************************************* sut : ok=25 changed=2 unreachable=0 failed=2 skipped=38 rescued=1 ignored=0 Saturday 08 June 2024 01:29:56 +0000 (0:00:00.798) 0:00:08.898 ********* =============================================================================== linux-system-roles.mssql : Gather package facts ------------------------- 1.55s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 Gather package facts ---------------------------------------------------- 1.31s /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:2 ---------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.31s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:184 linux-system-roles.mssql : Configure to run as a confined application with SELinux --- 0.89s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:286 fedora.linux_system_roles.firewall : Install firewalld ------------------ 0.80s /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:19 Gathering Facts --------------------------------------------------------- 0.70s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:9 fedora.linux_system_roles.firewall : Check if system is ostree ---------- 0.30s /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2022 --- 0.29s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:261 Run role with mssql_replica_type=primary not defined -------------------- 0.16s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:137 Run on all hosts to configure read-scale cluster ------------------------ 0.09s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:167 Purge firewall configuration -------------------------------------------- 0.07s /WORKDIR/git-weekly-cimmt93l2g/tests/tasks/cleanup.yml:18 --------------------- Clean up after the role invocation -------------------------------------- 0.06s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:1005 linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 linux-system-roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022 --- 0.06s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:254 Include vault variables ------------------------------------------------- 0.04s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:4 linux-system-roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.04s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:146 Clean up after the role invocation -------------------------------------- 0.04s /WORKDIR/git-weekly-cimmt93l2g/tests/tests_configure_ha_cluster_external.yml:126 fedora.linux_system_roles.firewall : Setup firewalld -------------------- 0.04s /WORKDIR/git-weekly-cimmt93l2g/.collection/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 linux-system-roles.mssql : Set platform/version specific variables ------ 0.04s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 linux-system-roles.mssql : Print that the variable is deprecated -------- 0.04s /WORKDIR/git-weekly-cimmt93l2g/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- ---^---^---^---^---^---