ansible-playbook [core 2.17.14] config file = None configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.12/site-packages/ansible ansible collection location = /tmp/collections-m2v executable location = /usr/local/bin/ansible-playbook python version = 3.12.11 (main, Aug 14 2025, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-11)] (/usr/bin/python3.12) jinja version = 3.1.6 libyaml = True No config file found; using defaults running playbook inside collection fedora.linux_system_roles Skipping callback 'debug', 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 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: tests_2022_upgrade.yml *********************************************** 2 plays in /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_2022_upgrade.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_2022_upgrade.yml:5 Friday 24 October 2025 21:18:54 -0400 (0:00:00.018) 0:00:00.018 ******** 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-jxI/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that the role installs version 2017 and upgrades to 2019] ********* TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_2022_upgrade.yml:9 Friday 24 October 2025 21:18:54 -0400 (0:00:00.016) 0:00:00.035 ******** [WARNING]: Platform linux on host managed-node2 is using the discovered Python interpreter at /usr/bin/python3.9, but future installation of another Python interpreter could change the meaning of that path. See https://docs.ansible.com/ansible- core/2.17/reference_appendices/interpreter_discovery.html for more information. ok: [managed-node2] TASK [Assert fail on EL 7 with version=2022 and EL 9 with version!=2022] ******* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_2022_upgrade.yml:17 Friday 24 October 2025 21:18:56 -0400 (0:00:02.379) 0:00:02.414 ******** included: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node2 TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Friday 24 October 2025 21:18:56 -0400 (0:00:00.057) 0:00:02.472 ******** ok: [managed-node2] TASK [Run the role] ************************************************************ task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16 Friday 24 October 2025 21:18:57 -0400 (0:00:00.517) 0:00:02.990 ******** included: fedora.linux_system_roles.mssql for managed-node2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Friday 24 October 2025 21:18:57 -0400 (0:00:00.306) 0:00:03.297 ******** included: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Friday 24 October 2025 21:18:57 -0400 (0:00:00.052) 0:00:03.349 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Friday 24 October 2025 21:18:57 -0400 (0:00:00.050) 0:00:03.399 ******** 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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node2] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS.yml", "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Run systemctl] ************************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Friday 24 October 2025 21:18:58 -0400 (0:00:00.116) 0:00:03.515 ******** ok: [managed-node2] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.009165", "end": "2025-10-24 21:18:58.773489", "failed_when_result": false, "rc": 0, "start": "2025-10-24 21:18:58.764324" } STDOUT: running TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Friday 24 October 2025 21:18:58 -0400 (0:00:00.795) 0:00:04.311 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "\"No such file or directory\" in __is_system_running.msg | d(\"\")", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Friday 24 October 2025 21:18:58 -0400 (0:00:00.074) 0:00:04.386 ******** ok: [managed-node2] => { "ansible_facts": { "__mssql_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset internal role facts] ************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Friday 24 October 2025 21:18:58 -0400 (0:00:00.077) 0:00:04.464 ******** ok: [managed-node2] => { "ansible_facts": { "__mssql_is_active": null, "__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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Friday 24 October 2025 21:18:59 -0400 (0:00:00.075) 0:00:04.540 ******** skipping: [managed-node2] => { "false_condition": "mssql_input_sql_file is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:24 Friday 24 October 2025 21:18:59 -0400 (0:00:00.068) 0:00:04.609 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_input_sql_file is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:31 Friday 24 October 2025 21:18:59 -0400 (0:00:00.068) 0:00:04.677 ******** skipping: [managed-node2] => { "false_condition": "mssql_ha_listener_port is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:38 Friday 24 October 2025 21:18:59 -0400 (0:00:00.078) 0:00:04.755 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_listener_port is defined", "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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:45 Friday 24 October 2025 21:18:59 -0400 (0:00:00.073) 0:00:04.829 ******** skipping: [managed-node2] => { "false_condition": "mssql_ad_sql_user_name is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:52 Friday 24 October 2025 21:18:59 -0400 (0:00:00.087) 0:00:04.916 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ad_sql_user_name is defined", "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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:59 Friday 24 October 2025 21:18:59 -0400 (0:00:00.073) 0:00:04.989 ******** skipping: [managed-node2] => { "false_condition": "mssql_ha_cluster_run_role is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:66 Friday 24 October 2025 21:18:59 -0400 (0:00:00.098) 0:00:05.088 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_cluster_run_role is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] ***** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Friday 24 October 2025 21:18:59 -0400 (0:00:00.109) 0:00:05.197 ******** skipping: [managed-node2] => { "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] ************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Friday 24 October 2025 21:18:59 -0400 (0:00:00.090) 0:00:05.287 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined", "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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Friday 24 October 2025 21:18:59 -0400 (0:00:00.067) 0:00:05.355 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_distribution_major_version is version('10', '=')", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:95 Friday 24 October 2025 21:18:59 -0400 (0:00:00.105) 0:00:05.460 ******** 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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107 Friday 24 October 2025 21:19:00 -0400 (0:00:00.075) 0:00:05.535 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:115 Friday 24 October 2025 21:19:00 -0400 (0:00:00.116) 0:00:05.652 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124 Friday 24 October 2025 21:19:00 -0400 (0:00:00.074) 0:00:05.727 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133 Friday 24 October 2025 21:19:00 -0400 (0:00:00.060) 0:00:05.787 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:143 Friday 24 October 2025 21:19:00 -0400 (0:00:00.088) 0:00:05.876 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "not __mssql_confined_supported", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:152 Friday 24 October 2025 21:19:00 -0400 (0:00:00.081) 0:00:05.958 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_ag_is_contained is not provided with version 2017] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Friday 24 October 2025 21:19:00 -0400 (0:00:00.110) 0:00:06.069 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_ag_is_contained | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify fail reuse_system_db=true is not provided without ag_is_contained] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Friday 24 October 2025 21:19:00 -0400 (0:00:00.142) 0:00:06.211 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_ag_reuse_system_db | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Friday 24 October 2025 21:19:00 -0400 (0:00:00.123) 0:00:06.334 ******** ok: [managed-node2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 Friday 24 October 2025 21:19:02 -0400 (0:00:01.789) 0:00:08.125 ******** skipping: [managed-node2] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not bigger then the existing SQL Server version] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197 Friday 24 October 2025 21:19:02 -0400 (0:00:00.216) 0:00:08.342 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210 Friday 24 October 2025 21:19:02 -0400 (0:00:00.102) 0:00:08.445 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_version is none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 Friday 24 October 2025 21:19:03 -0400 (0:00:00.234) 0:00:08.680 ******** fatal: [managed-node2]: FAILED! => { "assertion": "mssql_version | int in __mssql_supported_versions", "changed": false, "evaluated_to": false } MSG: You must set the mssql_version variable to one of 2022 TASK [Assert that the role failed with mssql_version not supported] ************ task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:27 Friday 24 October 2025 21:19:03 -0400 (0:00:00.247) 0:00:08.928 ******** ok: [managed-node2] => { "changed": false } MSG: All assertions passed TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:36 Friday 24 October 2025 21:19:03 -0400 (0:00:00.188) 0:00:09.117 ******** included: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node2 TASK [Gather package facts] **************************************************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 Friday 24 October 2025 21:19:04 -0400 (0:00:00.595) 0:00:09.712 ******** ok: [managed-node2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [Set role variables needed for cleanup] *********************************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7 Friday 24 October 2025 21:19:05 -0400 (0:00:01.126) 0:00:10.839 ******** included: fedora.linux_system_roles.mssql for managed-node2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Friday 24 October 2025 21:19:05 -0400 (0:00:00.096) 0:00:10.935 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Friday 24 October 2025 21:19:05 -0400 (0:00:00.125) 0:00:11.061 ******** 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-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node2] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS.yml", "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Run systemctl] ************************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Friday 24 October 2025 21:19:05 -0400 (0:00:00.268) 0:00:11.329 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Friday 24 October 2025 21:19:06 -0400 (0:00:00.153) 0:00:11.483 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Friday 24 October 2025 21:19:06 -0400 (0:00:00.096) 0:00:11.580 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13 Friday 24 October 2025 21:19:06 -0400 (0:00:00.093) 0:00:11.673 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_facts.packages.pcs is defined", "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21 Friday 24 October 2025 21:19:06 -0400 (0:00:00.095) 0:00:11.769 ******** ok: [managed-node2] => { "ansible_python_version": "3.9.23" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 Friday 24 October 2025 21:19:06 -0400 (0:00:00.104) 0:00:11.874 ******** included: fedora.linux_system_roles.firewall for managed-node2 TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Friday 24 October 2025 21:19:06 -0400 (0:00:00.199) 0:00:12.073 ******** included: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for managed-node2 TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Friday 24 October 2025 21:19:06 -0400 (0:00:00.137) 0:00:12.211 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "__firewall_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Friday 24 October 2025 21:19:06 -0400 (0:00:00.125) 0:00:12.337 ******** ok: [managed-node2] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Friday 24 October 2025 21:19:07 -0400 (0:00:00.860) 0:00:13.198 ******** ok: [managed-node2] => { "ansible_facts": { "__firewall_is_ostree": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 Friday 24 October 2025 21:19:07 -0400 (0:00:00.069) 0:00:13.267 ******** ok: [managed-node2] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 Friday 24 October 2025 21:19:08 -0400 (0:00:00.493) 0:00:13.761 ******** ok: [managed-node2] => { "ansible_facts": { "__firewall_is_transactional": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Run systemctl] ********************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Friday 24 October 2025 21:19:08 -0400 (0:00:00.102) 0:00:13.864 ******** ok: [managed-node2] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.008219", "end": "2025-10-24 21:19:08.767578", "failed_when_result": false, "rc": 0, "start": "2025-10-24 21:19:08.759359" } STDOUT: running TASK [fedora.linux_system_roles.firewall : Require installed systemd] ********** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 Friday 24 October 2025 21:19:08 -0400 (0:00:00.467) 0:00:14.332 ******** skipping: [managed-node2] => { "changed": false, "false_condition": "\"No such file or directory\" in __is_system_running.msg | d(\"\")", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 Friday 24 October 2025 21:19:08 -0400 (0:00:00.100) 0:00:14.432 ******** ok: [managed-node2] => { "ansible_facts": { "__firewall_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Friday 24 October 2025 21:19:09 -0400 (0:00:00.107) 0:00:14.540 ******** fatal: [managed-node2]: FAILED! => { "changed": false, "rc": 1, "results": [] } MSG: Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried PLAY RECAP ********************************************************************* managed-node2 : ok=26 changed=0 unreachable=0 failed=1 skipped=31 rescued=1 ignored=0 SYSTEM ROLES ERRORS BEGIN v1 [ { "ansible_version": "2.17.14", "end_time": "2025-10-25T01:19:03.388912+00:00Z", "host": "managed-node2", "message": "You must set the mssql_version variable to one of 2022", "start_time": "2025-10-25T01:19:03.201936+00:00Z", "task_name": "Verify if the mssql_version variable is provided correctly", "task_path": "/tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217" }, { "ansible_version": "2.17.14", "end_time": "2025-10-25T01:19:22.262691+00:00Z", "host": "managed-node2", "message": "Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried", "rc": 1, "start_time": "2025-10-25T01:19:09.061330+00:00Z", "task_name": "Install firewalld", "task_path": "/tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51" } ] SYSTEM ROLES ERRORS END v1 TASKS RECAP ******************************************************************** Friday 24 October 2025 21:19:22 -0400 (0:00:13.204) 0:00:27.744 ******** =============================================================================== fedora.linux_system_roles.firewall : Install firewalld ----------------- 13.20s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Gathering Facts --------------------------------------------------------- 2.38s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_2022_upgrade.yml:9 fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.79s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Gather package facts ---------------------------------------------------- 1.13s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 fedora.linux_system_roles.firewall : Check if system is ostree ---------- 0.86s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.79s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Clean up after the role invocation -------------------------------------- 0.60s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:36 Ensure ansible_facts to get ansible_distribution ------------------------ 0.52s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin --- 0.49s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 fedora.linux_system_roles.firewall : Run systemctl ---------------------- 0.47s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Run the role ------------------------------------------------------------ 0.31s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.27s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.25s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it --- 0.23s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210 fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.22s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 Purge firewall configuration -------------------------------------------- 0.20s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 Assert that the role failed with mssql_version not supported ------------ 0.19s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:27 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.15s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 fedora.linux_system_roles.mssql : Verify that mssql_ha_ag_is_contained is not provided with version 2017 --- 0.14s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 fedora.linux_system_roles.firewall : Setup firewalld -------------------- 0.14s /tmp/collections-m2v/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Oct 24 21:18:54 managed-node2 sshd-session[7521]: Accepted publickey for root from 10.31.41.146 port 49344 ssh2: ECDSA SHA256:+DyLzn/1v6kmyoGG/W9ipp/rJhim9DjfKrY7/8E8Uxo Oct 24 21:18:54 managed-node2 systemd-logind[643]: New session 7 of user root. ░░ Subject: A new session 7 has been created for user root ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ Documentation: sd-login(3) ░░ ░░ A new session with the ID 7 has been created for the user root. ░░ ░░ The leading process of the session is 7521. Oct 24 21:18:54 managed-node2 systemd[1]: Started Session 7 of User root. ░░ Subject: A start job for unit session-7.scope has finished successfully ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ ░░ A start job for unit session-7.scope has finished successfully. ░░ ░░ The job identifier is 1038. Oct 24 21:18:54 managed-node2 sshd-session[7521]: pam_unix(sshd:session): session opened for user root(uid=0) by root(uid=0) Oct 24 21:18:56 managed-node2 python3.9[7698]: ansible-ansible.legacy.setup Invoked with gather_subset=['all'] gather_timeout=10 filter=[] fact_path=/etc/ansible/facts.d Oct 24 21:18:57 managed-node2 python3.9[7875]: ansible-setup Invoked with gather_subset=['min'] gather_timeout=10 filter=[] fact_path=/etc/ansible/facts.d Oct 24 21:18:58 managed-node2 python3.9[8028]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-system-running _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Oct 24 21:19:07 managed-node2 python3.9[8476]: ansible-stat Invoked with path=/run/ostree-booted follow=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Oct 24 21:19:08 managed-node2 python3.9[8625]: ansible-stat Invoked with path=/sbin/transactional-update follow=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Oct 24 21:19:08 managed-node2 python3.9[8774]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-system-running _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Oct 24 21:19:09 managed-node2 python3.9[8924]: ansible-ansible.legacy.dnf Invoked with name=['firewalld'] state=present allow_downgrade=False allowerasing=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 use_backend=auto best=None conf_file=None disable_excludes=None download_dir=None list=None nobest=None releasever=None Oct 24 21:19:22 managed-node2 sshd-session[9006]: Accepted publickey for root from 10.31.41.146 port 33168 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Oct 24 21:19:22 managed-node2 systemd-logind[643]: New session 8 of user root. ░░ Subject: A new session 8 has been created for user root ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ Documentation: sd-login(3) ░░ ░░ A new session with the ID 8 has been created for the user root. ░░ ░░ The leading process of the session is 9006. Oct 24 21:19:22 managed-node2 systemd[1]: Started Session 8 of User root. ░░ Subject: A start job for unit session-8.scope has finished successfully ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ ░░ A start job for unit session-8.scope has finished successfully. ░░ ░░ The job identifier is 1108. Oct 24 21:19:22 managed-node2 sshd-session[9006]: pam_unix(sshd:session): session opened for user root(uid=0) by root(uid=0) Oct 24 21:19:22 managed-node2 sshd-session[9009]: Received disconnect from 10.31.41.146 port 33168:11: disconnected by user Oct 24 21:19:22 managed-node2 sshd-session[9009]: Disconnected from user root 10.31.41.146 port 33168 Oct 24 21:19:22 managed-node2 sshd-session[9006]: pam_unix(sshd:session): session closed for user root Oct 24 21:19:22 managed-node2 systemd[1]: session-8.scope: Deactivated successfully. ░░ Subject: Unit succeeded ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ ░░ The unit session-8.scope has successfully entered the 'dead' state. Oct 24 21:19:22 managed-node2 systemd-logind[643]: Session 8 logged out. Waiting for processes to exit. Oct 24 21:19:22 managed-node2 systemd-logind[643]: Removed session 8. ░░ Subject: Session 8 has been terminated ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ Documentation: sd-login(3) ░░ ░░ A session with the ID 8 has been terminated. Oct 24 21:19:22 managed-node2 sshd-session[9034]: Accepted publickey for root from 10.31.41.146 port 33176 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Oct 24 21:19:22 managed-node2 systemd-logind[643]: New session 9 of user root. ░░ Subject: A new session 9 has been created for user root ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ Documentation: sd-login(3) ░░ ░░ A new session with the ID 9 has been created for the user root. ░░ ░░ The leading process of the session is 9034. Oct 24 21:19:22 managed-node2 systemd[1]: Started Session 9 of User root. ░░ Subject: A start job for unit session-9.scope has finished successfully ░░ Defined-By: systemd ░░ Support: https://access.redhat.com/support ░░ ░░ A start job for unit session-9.scope has finished successfully. ░░ ░░ The job identifier is 1177. Oct 24 21:19:22 managed-node2 sshd-session[9034]: pam_unix(sshd:session): session opened for user root(uid=0) by root(uid=0)