ansible-playbook [core 2.17.12]
  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-OFW
  executable location = /usr/local/bin/ansible-playbook
  python version = 3.12.10 (main, May  9 2025, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-5)] (/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_idempotency_2019.yml *******************************************
1 plays in /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml

PLAY [Ensure that the role is idempotent] **************************************

TASK [Run tests_idempotency with SQL Server 2019] ******************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:15
Friday 23 May 2025  21:22:07 -0400 (0:00:00.066)       0:00:00.066 ************ 
included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml for managed-node2

TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:2
Friday 23 May 2025  21:22:07 -0400 (0:00:00.029)       0:00:00.095 ************ 
included: /tmp/collections-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2
Friday 23 May 2025  21:22:07 -0400 (0:00:00.030)       0:00:00.126 ************ 
[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 [Run the role] ************************************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17
Friday 23 May 2025  21:22:08 -0400 (0:00:00.777)       0:00:00.903 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Friday 23 May 2025  21:22:08 -0400 (0:00:00.176)       0:00:01.080 ************ 
included: /tmp/collections-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Friday 23 May 2025  21:22:08 -0400 (0:00:00.044)       0:00:01.124 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Friday 23 May 2025  21:22:08 -0400 (0:00:00.038)       0:00:01.163 ************ 
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-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Friday 23 May 2025  21:22:08 -0400 (0:00:00.064)       0:00:01.227 ************ 
ok: [managed-node2] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-system-running"
    ],
    "delta": "0:00:00.007675",
    "end": "2025-05-23 21:22:09.254422",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-23 21:22:09.246747"
}

STDOUT:

running

TASK [fedora.linux_system_roles.mssql : Require installed systemd] *************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Friday 23 May 2025  21:22:09 -0400 (0:00:00.452)       0:00:01.680 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Friday 23 May 2025  21:22:09 -0400 (0:00:00.038)       0:00:01.718 ************ 
ok: [managed-node2] => {
    "ansible_facts": {
        "__mssql_is_booted": true
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Friday 23 May 2025  21:22:09 -0400 (0:00:00.040)       0:00:01.759 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:01.797 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:01.834 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:01.872 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:01.909 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:01.946 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51
Friday 23 May 2025  21:22:09 -0400 (0:00:00.038)       0:00:01.984 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58
Friday 23 May 2025  21:22:09 -0400 (0:00:00.038)       0:00:02.023 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:02.061 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:02.098 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83
Friday 23 May 2025  21:22:09 -0400 (0:00:00.035)       0:00:02.134 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87
Friday 23 May 2025  21:22:09 -0400 (0:00:00.036)       0:00:02.171 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94
Friday 23 May 2025  21:22:09 -0400 (0:00:00.037)       0:00:02.208 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106
Friday 23 May 2025  21:22:09 -0400 (0:00:00.041)       0:00:02.250 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114
Friday 23 May 2025  21:22:09 -0400 (0:00:00.036)       0:00:02.286 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123
Friday 23 May 2025  21:22:09 -0400 (0:00:00.035)       0:00:02.322 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132
Friday 23 May 2025  21:22:09 -0400 (0:00:00.035)       0:00:02.358 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142
Friday 23 May 2025  21:22:10 -0400 (0:00:00.037)       0:00:02.395 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151
Friday 23 May 2025  21:22:10 -0400 (0:00:00.039)       0:00:02.434 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162
Friday 23 May 2025  21:22:10 -0400 (0:00:00.043)       0:00:02.478 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166
Friday 23 May 2025  21:22:11 -0400 (0:00:01.094)       0:00:03.573 ************ 
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 : Set mssql_version variable if user does not define it] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Friday 23 May 2025  21:22:11 -0400 (0:00:00.133)       0:00:03.706 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181
Friday 23 May 2025  21:22:11 -0400 (0:00:00.088)       0:00:03.794 ************ 
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 EL < 8 not supported] *******************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:28
Friday 23 May 2025  21:22:11 -0400 (0:00:00.115)       0:00:03.909 ************ 
ok: [managed-node2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:34
Friday 23 May 2025  21:22:11 -0400 (0:00:00.082)       0:00:03.992 ************ 
included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node2

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2
Friday 23 May 2025  21:22:11 -0400 (0:00:00.270)       0:00:04.263 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6
Friday 23 May 2025  21:22:12 -0400 (0:00:00.942)       0:00:05.206 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Friday 23 May 2025  21:22:12 -0400 (0:00:00.148)       0:00:05.354 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Friday 23 May 2025  21:22:13 -0400 (0:00:00.092)       0:00:05.446 ************ 
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-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Friday 23 May 2025  21:22:13 -0400 (0:00:00.192)       0:00:05.639 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Friday 23 May 2025  21:22:13 -0400 (0:00:00.126)       0:00:05.765 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Friday 23 May 2025  21:22:13 -0400 (0:00:00.096)       0:00:05.862 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:12
Friday 23 May 2025  21:22:13 -0400 (0:00:00.117)       0:00:05.979 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:20
Friday 23 May 2025  21:22:13 -0400 (0:00:00.063)       0:00:06.043 ************ 
ok: [managed-node2] => {
    "ansible_python_version": "3.9.21"
}

TASK [Purge firewall configuration] ********************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24
Friday 23 May 2025  21:22:13 -0400 (0:00:00.055)       0:00:06.098 ************ 
included: fedora.linux_system_roles.firewall for managed-node2

TASK [fedora.linux_system_roles.firewall : Setup firewalld] ********************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2
Friday 23 May 2025  21:22:13 -0400 (0:00:00.115)       0:00:06.214 ************ 
included: /tmp/collections-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2
Friday 23 May 2025  21:22:13 -0400 (0:00:00.120)       0:00:06.334 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10
Friday 23 May 2025  21:22:14 -0400 (0:00:00.091)       0:00:06.426 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15
Friday 23 May 2025  21:22:14 -0400 (0:00:00.772)       0:00:07.199 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22
Friday 23 May 2025  21:22:14 -0400 (0:00:00.104)       0:00:07.303 ************ 
ok: [managed-node2] => {
    "changed": false,
    "stat": {
        "exists": false
    }
}

TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27
Friday 23 May 2025  21:22:15 -0400 (0:00:00.510)       0:00:07.814 ************ 
ok: [managed-node2] => {
    "ansible_facts": {
        "__firewall_is_transactional": false
    },
    "changed": false
}

TASK [fedora.linux_system_roles.firewall : Run systemctl] **********************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34
Friday 23 May 2025  21:22:15 -0400 (0:00:00.095)       0:00:07.909 ************ 
ok: [managed-node2] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-system-running"
    ],
    "delta": "0:00:00.007429",
    "end": "2025-05-23 21:22:15.897178",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-23 21:22:15.889749"
}

STDOUT:

running

TASK [fedora.linux_system_roles.firewall : Require installed systemd] **********
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41
Friday 23 May 2025  21:22:15 -0400 (0:00:00.429)       0:00:08.339 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46
Friday 23 May 2025  21:22:16 -0400 (0:00:00.132)       0:00:08.471 ************ 
ok: [managed-node2] => {
    "ansible_facts": {
        "__firewall_is_booted": true
    },
    "changed": false
}

TASK [fedora.linux_system_roles.firewall : Install firewalld] ******************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51
Friday 23 May 2025  21:22:16 -0400 (0:00:00.094)       0:00:08.566 ************ 
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

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:18
Friday 23 May 2025  21:22:20 -0400 (0:00:04.571)       0:00:13.137 ************ 
included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node2

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2
Friday 23 May 2025  21:22:20 -0400 (0:00:00.081)       0:00:13.218 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6
Friday 23 May 2025  21:22:21 -0400 (0:00:00.842)       0:00:14.061 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Friday 23 May 2025  21:22:21 -0400 (0:00:00.107)       0:00:14.168 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Friday 23 May 2025  21:22:21 -0400 (0:00:00.136)       0:00:14.305 ************ 
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-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Friday 23 May 2025  21:22:22 -0400 (0:00:00.128)       0:00:14.433 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Friday 23 May 2025  21:22:22 -0400 (0:00:00.058)       0:00:14.492 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Friday 23 May 2025  21:22:22 -0400 (0:00:00.064)       0:00:14.556 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:12
Friday 23 May 2025  21:22:22 -0400 (0:00:00.109)       0:00:14.666 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:20
Friday 23 May 2025  21:22:22 -0400 (0:00:00.041)       0:00:14.708 ************ 
ok: [managed-node2] => {
    "ansible_python_version": "3.9.21"
}

TASK [Purge firewall configuration] ********************************************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24
Friday 23 May 2025  21:22:22 -0400 (0:00:00.033)       0:00:14.741 ************ 
included: fedora.linux_system_roles.firewall for managed-node2

TASK [fedora.linux_system_roles.firewall : Setup firewalld] ********************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2
Friday 23 May 2025  21:22:22 -0400 (0:00:00.125)       0:00:14.866 ************ 
included: /tmp/collections-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2
Friday 23 May 2025  21:22:22 -0400 (0:00:00.127)       0:00:14.994 ************ 
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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10
Friday 23 May 2025  21:22:22 -0400 (0:00:00.081)       0:00:15.076 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "__firewall_is_ostree is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15
Friday 23 May 2025  21:22:22 -0400 (0:00:00.040)       0:00:15.116 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "__firewall_is_ostree is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22
Friday 23 May 2025  21:22:22 -0400 (0:00:00.049)       0:00:15.165 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "not __firewall_is_transactional is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] ***
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27
Friday 23 May 2025  21:22:22 -0400 (0:00:00.041)       0:00:15.207 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "not __firewall_is_transactional is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Run systemctl] **********************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34
Friday 23 May 2025  21:22:22 -0400 (0:00:00.061)       0:00:15.268 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "__firewall_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Require installed systemd] **********
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41
Friday 23 May 2025  21:22:22 -0400 (0:00:00.070)       0:00:15.338 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "__firewall_is_booted is not defined",
    "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-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46
Friday 23 May 2025  21:22:23 -0400 (0:00:00.051)       0:00:15.390 ************ 
skipping: [managed-node2] => {
    "changed": false,
    "false_condition": "__firewall_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.firewall : Install firewalld] ******************
task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51
Friday 23 May 2025  21:22:23 -0400 (0:00:00.047)       0:00:15.437 ************ 
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=32   changed=0    unreachable=0    failed=2    skipped=41   rescued=1    ignored=0   

SYSTEM ROLES ERRORS BEGIN v1
[
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-05-24T01:22:11.505387+00:00Z",
        "host": "managed-node2",
        "message": "You must set the mssql_version variable to one of 2022",
        "start_time": "2025-05-24T01:22:11.417293+00:00Z",
        "task_name": "Verify if the mssql_version variable is provided correctly",
        "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181"
    },
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-05-24T01:22:20.726558+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-05-24T01:22:16.189253+00:00Z",
        "task_name": "Install firewalld",
        "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51"
    },
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-05-24T01:22:27.150146+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-05-24T01:22:23.060501+00:00Z",
        "task_name": "Install firewalld",
        "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51"
    }
]
SYSTEM ROLES ERRORS END v1

TASKS RECAP ********************************************************************
Friday 23 May 2025  21:22:27 -0400 (0:00:04.092)       0:00:19.530 ************ 
=============================================================================== 
fedora.linux_system_roles.firewall : Install firewalld ------------------ 4.57s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 
fedora.linux_system_roles.firewall : Install firewalld ------------------ 4.09s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.09s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 
Gather package facts ---------------------------------------------------- 0.94s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 
Gather package facts ---------------------------------------------------- 0.84s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 
Ensure ansible_facts to get ansible_distribution ------------------------ 0.78s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 
fedora.linux_system_roles.firewall : Check if system is ostree ---------- 0.77s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 
fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin --- 0.51s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 
fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.45s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 
fedora.linux_system_roles.firewall : Run systemctl ---------------------- 0.43s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 
Clean up after the role invocation -------------------------------------- 0.27s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:34 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.19s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 
Run the role ------------------------------------------------------------ 0.18s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17 
Set role variables needed for cleanup ----------------------------------- 0.15s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6 
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.14s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 
fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.13s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 
fedora.linux_system_roles.firewall : Require installed systemd ---------- 0.13s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.13s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 
fedora.linux_system_roles.firewall : Setup firewalld -------------------- 0.13s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 
fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.13s
/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22