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-5Zj
  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 '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_tls_2019.yml ***************************************************
2 plays in /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml

PLAY [all] *********************************************************************

TASK [Include vault variables] *************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:5
Thursday 19 June 2025  12:12:24 -0400 (0:00:00.021)       0:00:00.021 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "mssql_password": {
            "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n"
        }
    },
    "ansible_included_var_files": [
        "/tmp/mssql-RVG/tests/vars/vault-variables.yml"
    ],
    "changed": false
}

PLAY [Ensure that tls encryption configuration works] **************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9
Thursday 19 June 2025  12:12:24 -0400 (0:00:00.021)       0:00:00.042 ********* 
[WARNING]: Platform linux on host managed-node3 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-node3]

TASK [Run tests_tls with SQL Server 2019] **************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:24
Thursday 19 June 2025  12:12:25 -0400 (0:00:01.185)       0:00:01.228 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml for managed-node3

TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:2
Thursday 19 June 2025  12:12:25 -0400 (0:00:00.044)       0:00:01.272 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node3

TASK [Ensure ansible_facts to get ansible_distribution] ************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2
Thursday 19 June 2025  12:12:25 -0400 (0:00:00.019)       0:00:01.291 ********* 
ok: [managed-node3]

TASK [Run the role] ************************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16
Thursday 19 June 2025  12:12:26 -0400 (0:00:00.465)       0:00:01.757 ********* 
included: fedora.linux_system_roles.mssql for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Thursday 19 June 2025  12:12:26 -0400 (0:00:00.313)       0:00:02.071 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Thursday 19 June 2025  12:12:26 -0400 (0:00:00.077)       0:00:02.149 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Thursday 19 June 2025  12:12:26 -0400 (0:00:00.065)       0:00:02.214 ********* 
ok: [managed-node3] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node3] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (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-node3] => (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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Thursday 19 June 2025  12:12:26 -0400 (0:00:00.114)       0:00:02.328 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-system-running"
    ],
    "delta": "0:00:00.007737",
    "end": "2025-06-19 12:12:27.379668",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-06-19 12:12:27.371931"
}

STDOUT:

running

TASK [fedora.linux_system_roles.mssql : Require installed systemd] *************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.542)       0:00:02.870 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.040)       0:00:02.911 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__mssql_is_booted": true
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset internal role facts] *************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.057)       0:00:02.969 ********* 
ok: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.044)       0:00:03.014 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:24
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.040)       0:00:03.054 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:31
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.045)       0:00:03.099 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:38
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.037)       0:00:03.136 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:45
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.036)       0:00:03.173 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:52
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.037)       0:00:03.210 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:59
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.037)       0:00:03.248 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:66
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.051)       0:00:03.300 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.046)       0:00:03.346 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.036)       0:00:03.383 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88
Thursday 19 June 2025  12:12:27 -0400 (0:00:00.038)       0:00:03.421 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:95
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.038)       0:00:03.460 ********* 
ok: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.043)       0:00:03.503 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:115
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.038)       0:00:03.542 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.037)       0:00:03.579 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.038)       0:00:03.617 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:143
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.060)       0:00:03.678 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:152
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.064)       0:00:03.742 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.066)       0:00:03.808 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.057)       0:00:03.866 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185
Thursday 19 June 2025  12:12:28 -0400 (0:00:00.069)       0:00:03.936 ********* 
ok: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189
Thursday 19 June 2025  12:12:29 -0400 (0:00:01.176)       0:00:05.112 ********* 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"].split(\".\") | first | int == item.value",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"].split(\".\") | first | int == item.value",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
ok: [managed-node3] => (item={'key': 2022, 'value': 16}) => {
    "ansible_facts": {
        "__mssql_current_version": "2022"
    },
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2022,
        "value": 16
    }
}

TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not bigger then the existing SQL Server version] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197
Thursday 19 June 2025  12:12:29 -0400 (0:00:00.100)       0:00:05.213 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_version | int > __mssql_current_version | int",
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210
Thursday 19 June 2025  12:12:29 -0400 (0:00:00.056)       0:00:05.270 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217
Thursday 19 June 2025  12:12:29 -0400 (0:00:00.056)       0:00:05.327 ********* 
fatal: [managed-node3]: 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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:27
Thursday 19 June 2025  12:12:29 -0400 (0:00:00.078)       0:00:05.405 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:33
Thursday 19 June 2025  12:12:30 -0400 (0:00:00.087)       0:00:05.493 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3
Thursday 19 June 2025  12:12:30 -0400 (0:00:00.211)       0:00:05.704 ********* 
ok: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.842)       0:00:06.547 ********* 
included: fedora.linux_system_roles.mssql for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.093)       0:00:06.640 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.062)       0:00:06.703 ********* 
ok: [managed-node3] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node3] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (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-node3] => (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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.084)       0:00:06.787 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.052)       0:00:06.840 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.054)       0:00:06.894 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [Purge cluster configuration] *********************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.067)       0:00:06.961 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.057)       0:00:07.018 ********* 
ok: [managed-node3] => {
    "ansible_python_version": "3.9.21"
}

TASK [Purge firewall configuration] ********************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.056)       0:00:07.075 ********* 
ERROR! the role 'fedora.linux_system_roles.firewall' was not found in fedora.linux_system_roles:ansible.legacy:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/roles:/root/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql

The error appears to be in '/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml': line 30, column 11, but may
be elsewhere in the file depending on the exact syntax problem.

The offending line appears to be:

  include_role:
    name: fedora.linux_system_roles.firewall
          ^ here
fatal: [managed-node3]: FAILED! => {
    "changed": false,
    "reason": "the role 'fedora.linux_system_roles.firewall' was not found in fedora.linux_system_roles:ansible.legacy:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/roles:/root/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql\n\nThe error appears to be in '/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml': line 30, column 11, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n  include_role:\n    name: fedora.linux_system_roles.firewall\n          ^ here\n"
}

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:27
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.084)       0:00:07.159 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3
Thursday 19 June 2025  12:12:31 -0400 (0:00:00.056)       0:00:07.216 ********* 
ok: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.853)       0:00:08.070 ********* 
included: fedora.linux_system_roles.mssql for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.067)       0:00:08.138 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.053)       0:00:08.191 ********* 
ok: [managed-node3] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node3] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (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-node3] => (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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.052)       0:00:08.243 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.042)       0:00:08.285 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.070)       0:00:08.355 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [Purge cluster configuration] *********************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13
Thursday 19 June 2025  12:12:32 -0400 (0:00:00.083)       0:00:08.439 ********* 
skipping: [managed-node3] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21
Thursday 19 June 2025  12:12:33 -0400 (0:00:00.068)       0:00:08.508 ********* 
ok: [managed-node3] => {
    "ansible_python_version": "3.9.21"
}

TASK [Purge firewall configuration] ********************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25
Thursday 19 June 2025  12:12:33 -0400 (0:00:00.064)       0:00:08.572 ********* 
fatal: [managed-node3]: FAILED! => {
    "changed": false,
    "reason": "the role 'fedora.linux_system_roles.firewall' was not found in fedora.linux_system_roles:ansible.legacy:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/roles:/root/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql\n\nThe error appears to be in '/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml': line 30, column 11, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n  include_role:\n    name: fedora.linux_system_roles.firewall\n          ^ here\n"
}

PLAY RECAP *********************************************************************
managed-node3              : ok=25   changed=0    unreachable=0    failed=2    skipped=33   rescued=1    ignored=0   

SYSTEM ROLES ERRORS BEGIN v1
[
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-06-19T16:12:29.933137+00:00Z",
        "host": "managed-node3",
        "message": "You must set the mssql_version variable to one of 2022",
        "start_time": "2025-06-19T16:12:29.886521+00:00Z",
        "task_name": "Verify if the mssql_version variable is provided correctly",
        "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217"
    },
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-06-19T16:12:31.702988+00:00Z",
        "host": "managed-node3",
        "message": "No message could be found",
        "start_time": "2025-06-19T16:12:31.635012+00:00Z",
        "task_name": "Purge firewall configuration",
        "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25"
    },
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-06-19T16:12:33.194266+00:00Z",
        "host": "managed-node3",
        "message": "No message could be found",
        "start_time": "2025-06-19T16:12:33.132544+00:00Z",
        "task_name": "Purge firewall configuration",
        "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25"
    }
]
SYSTEM ROLES ERRORS END v1

TASKS RECAP ********************************************************************
Thursday 19 June 2025  12:12:33 -0400 (0:00:00.063)       0:00:08.636 ********* 
=============================================================================== 
Gathering Facts --------------------------------------------------------- 1.19s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.18s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 
Gather package facts ---------------------------------------------------- 0.85s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 
Gather package facts ---------------------------------------------------- 0.84s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 
fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.54s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 
Ensure ansible_facts to get ansible_distribution ------------------------ 0.47s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 
Run the role ------------------------------------------------------------ 0.31s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16 
Clean up after the role invocation -------------------------------------- 0.21s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:33 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.11s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 
fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.10s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 
Set role variables needed for cleanup ----------------------------------- 0.09s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7 
Assert that the role failed with mssql_version not supported ------------ 0.09s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:27 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.08s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 
Purge firewall configuration -------------------------------------------- 0.08s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 
fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available --- 0.08s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 
fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.08s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 
fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.08s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 
fedora.linux_system_roles.mssql : Require installed systemd ------------- 0.07s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 
fedora.linux_system_roles.mssql : Verify fail reuse_system_db=true is not provided without ag_is_contained --- 0.07s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 
Purge cluster configuration --------------------------------------------- 0.07s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13