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_idempotency_2022.yml *******************************************
1 plays in /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2022.yml

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

TASK [Run tests_idempotency with SQL Server 2022] ******************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2022.yml:16
Thursday 19 June 2025  12:09:49 -0400 (0:00:00.062)       0:00:00.062 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml for managed-node1

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_idempotency.yml:2
Thursday 19 June 2025  12:09:49 -0400 (0:00:00.024)       0:00:00.086 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node1

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:09:49 -0400 (0:00:00.025)       0:00:00.112 ********* 
[WARNING]: Platform linux on host managed-node1 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-node1]

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:09:50 -0400 (0:00:00.891)       0:00:01.003 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)",
    "skip_reason": "Conditional result was False"
}

TASK [Unreachable task] ********************************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:23
Thursday 19 June 2025  12:09:50 -0400 (0:00:00.052)       0:00:01.056 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)",
    "skip_reason": "Conditional result was False"
}

TASK [Run on a fresh host and set all parameters] ******************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:5
Thursday 19 June 2025  12:09:50 -0400 (0:00:00.053)       0:00:01.110 ********* 
included: fedora.linux_system_roles.mssql for managed-node1

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:09:50 -0400 (0:00:00.205)       0:00:01.315 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node1

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:09:50 -0400 (0:00:00.021)       0:00:01.337 ********* 
skipping: [managed-node1] => {
    "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:09:50 -0400 (0:00:00.051)       0:00:01.389 ********* 
ok: [managed-node1] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node1] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node1] => (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-node1] => (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:09:50 -0400 (0:00:00.056)       0:00:01.446 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-system-running"
    ],
    "delta": "0:00:00.008109",
    "end": "2025-06-19 12:09:51.043104",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-06-19 12:09:51.034995"
}

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:09:51 -0400 (0:00:00.528)       0:00:01.975 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.053)       0:00:02.029 ********* 
ok: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.030)       0:00:02.059 ********* 
ok: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.021)       0:00:02.080 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.024)       0:00:02.104 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.017)       0:00:02.122 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.020)       0:00:02.142 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.015)       0:00:02.157 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.019)       0:00:02.177 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.017)       0:00:02.195 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.019)       0:00:02.215 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.021)       0:00:02.236 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.016)       0:00:02.253 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.018)       0:00:02.272 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.015)       0:00:02.288 ********* 
ok: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.035)       0:00:02.323 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.029)       0:00:02.353 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.031)       0:00:02.384 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.030)       0:00:02.414 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.031)       0:00:02.445 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.046)       0:00:02.492 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "not mssql_run_selinux_confined",
    "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:09:51 -0400 (0:00:00.033)       0:00:02.525 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.029)       0:00:02.555 ********* 
skipping: [managed-node1] => {
    "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:09:51 -0400 (0:00:00.031)       0:00:02.586 ********* 
ok: [managed-node1] => {
    "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:09:52 -0400 (0:00:01.091)       0:00:03.677 ********* 
skipping: [managed-node1] => (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-node1] => (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-node1] => (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-node1] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197
Thursday 19 June 2025  12:09:52 -0400 (0:00:00.077)       0:00:03.755 ********* 
skipping: [managed-node1] => {
    "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210
Thursday 19 June 2025  12:09:52 -0400 (0:00:00.038)       0:00:03.794 ********* 
skipping: [managed-node1] => {
    "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:09:52 -0400 (0:00:00.034)       0:00:03.828 ********* 
ok: [managed-node1] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:224
Thursday 19 June 2025  12:09:53 -0400 (0:00:00.060)       0:00:03.889 ********* 
skipping: [managed-node1] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node1] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node1] => (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-node1] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238
Thursday 19 June 2025  12:09:53 -0400 (0:00:00.069)       0:00:03.959 ********* 
changed: [managed-node1] => {
    "attempts": 1,
    "changed": true
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:252
Thursday 19 June 2025  12:09:53 -0400 (0:00:00.834)       0:00:04.794 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get yum repositories] ******************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:262
Thursday 19 June 2025  12:09:53 -0400 (0:00:00.049)       0:00:04.843 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.054)       0:00:04.897 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:287
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.051)       0:00:04.949 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get zypper repositories] ***************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.051)       0:00:05.001 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:308
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.085)       0:00:05.086 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.052)       0:00:05.139 ********* 
redirecting (type: action) ansible.builtin.yum to ansible.builtin.dnf
changed: [managed-node1] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2022",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:327
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.550)       0:00:05.690 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340
Thursday 19 June 2025  12:09:54 -0400 (0:00:00.046)       0:00:05.736 ********* 
changed: [managed-node1] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: libbabeltrace-1.5.8-10.el9.x86_64",
        "Installed: bzip2-1.0.8-10.el9.x86_64",
        "Installed: policycoreutils-python-utils-3.6-3.el9.noarch",
        "Installed: cyrus-sasl-2.1.27-21.el9.x86_64",
        "Installed: libicu-67.1-9.el9.x86_64",
        "Installed: gdb-headless-14.2-4.1.el9.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-21.el9.x86_64",
        "Installed: mssql-server-16.0.4195.2-4.x86_64",
        "Installed: libipt-2.0.4-3.el9.x86_64",
        "Installed: source-highlight-3.1.9-12.el9.x86_64",
        "Installed: mssql-server-selinux-16.0.4195.2-4.x86_64",
        "Installed: lsof-4.94.0-3.el9.x86_64",
        "Installed: libatomic-11.5.0-7.el9.x86_64",
        "Installed: gdb-14.2-4.1.el9.x86_64",
        "Installed: boost-regex-1.75.0-11.el9.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] *******
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345
Thursday 19 June 2025  12:11:21 -0400 (0:01:26.224)       0:01:31.961 ********* 
ok: [managed-node1] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350
Thursday 19 June 2025  12:11:22 -0400 (0:00:01.379)       0:01:33.340 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.005118",
    "end": "2025-06-19 12:11:22.787637",
    "rc": 0,
    "start": "2025-06-19 12:11:22.782519"
}

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367
Thursday 19 June 2025  12:11:22 -0400 (0:00:00.406)       0:01:33.747 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-enabled",
        "mssql-server.service"
    ],
    "delta": "0:00:00.011193",
    "end": "2025-06-19 12:11:23.193921",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-06-19 12:11:23.182728"
}

STDOUT:

disabled


MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374
Thursday 19 June 2025  12:11:23 -0400 (0:00:00.389)       0:01:34.136 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-active",
        "mssql-server.service"
    ],
    "delta": "0:00:00.008558",
    "end": "2025-06-19 12:11:23.567667",
    "failed_when_result": false,
    "rc": 3,
    "start": "2025-06-19 12:11:23.559109"
}

STDOUT:

inactive


MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:381
Thursday 19 June 2025  12:11:23 -0400 (0:00:00.371)       0:01:34.507 ********* 
ok: [managed-node1] => {
    "ansible_facts": {
        "__mssql_is_setup": false
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:388
Thursday 19 June 2025  12:11:23 -0400 (0:00:00.048)       0:01:34.556 ********* 
ok: [managed-node1] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404
Thursday 19 June 2025  12:11:23 -0400 (0:00:00.037)       0:01:34.594 ********* 
changed: [managed-node1] => {
    "attempts": 1,
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions for datadir and logdir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:434
Thursday 19 June 2025  12:11:30 -0400 (0:00:06.570)       0:01:41.165 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 => (item={'path': '/tmp/mssql_data', 'mode': '755', 'setting': 'defaultdatadir'})
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 => (item={'path': '/tmp/mssql_log', 'mode': '755', 'setting': 'defaultlogdir'})

TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3
Thursday 19 June 2025  12:11:30 -0400 (0:00:00.104)       0:01:41.269 ********* 
changed: [managed-node1] => {
    "changed": true,
    "gid": 995,
    "group": "mssql",
    "mode": "0755",
    "owner": "mssql",
    "path": "/tmp/mssql_data",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 6,
    "state": "directory",
    "uid": 995
}

TASK [fedora.linux_system_roles.mssql : Append facts for the selinux role] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12
Thursday 19 June 2025  12:11:30 -0400 (0:00:00.513)       0:01:41.782 ********* 
ok: [managed-node1] => {
    "ansible_facts": {
        "selinux_fcontexts": [
            {
                "ftype": "d",
                "setype": "mssql_var_t",
                "state": "present",
                "target": "/tmp/mssql_data"
            }
        ],
        "selinux_restore_dirs": [
            "/tmp/mssql_data"
        ]
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Configure the setting defaultdatadir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28
Thursday 19 June 2025  12:11:31 -0400 (0:00:00.096)       0:01:41.878 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1

TASK [fedora.linux_system_roles.mssql : Get the setting filelocation defaultdatadir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Thursday 19 June 2025  12:11:31 -0400 (0:00:00.078)       0:01:41.957 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": [
        "grep",
        "^defaultdatadir = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003873",
    "end": "2025-06-19 12:11:31.486925",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-06-19 12:11:31.483052"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultdatadir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Thursday 19 June 2025  12:11:31 -0400 (0:00:00.492)       0:01:42.450 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node1] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "filelocation.defaultdatadir",
        "/tmp/mssql_data"
    ],
    "delta": "0:00:00.113791",
    "end": "2025-06-19 12:11:32.037283",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-06-19 12:11:31.923492"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting filelocation defaultdatadir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Thursday 19 June 2025  12:11:32 -0400 (0:00:00.540)       0:01:42.990 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_log] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3
Thursday 19 June 2025  12:11:32 -0400 (0:00:00.028)       0:01:43.018 ********* 
changed: [managed-node1] => {
    "changed": true,
    "gid": 995,
    "group": "mssql",
    "mode": "0755",
    "owner": "mssql",
    "path": "/tmp/mssql_log",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 6,
    "state": "directory",
    "uid": 995
}

TASK [fedora.linux_system_roles.mssql : Append facts for the selinux role] *****
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12
Thursday 19 June 2025  12:11:32 -0400 (0:00:00.361)       0:01:43.380 ********* 
ok: [managed-node1] => {
    "ansible_facts": {
        "selinux_fcontexts": [
            {
                "ftype": "d",
                "setype": "mssql_var_t",
                "state": "present",
                "target": "/tmp/mssql_data"
            },
            {
                "ftype": "d",
                "setype": "mssql_db_t",
                "state": "present",
                "target": "/tmp/mssql_log"
            }
        ],
        "selinux_restore_dirs": [
            "/tmp/mssql_data",
            "/tmp/mssql_log"
        ]
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Configure the setting defaultlogdir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28
Thursday 19 June 2025  12:11:32 -0400 (0:00:00.119)       0:01:43.499 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1

TASK [fedora.linux_system_roles.mssql : Get the setting filelocation defaultlogdir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Thursday 19 June 2025  12:11:32 -0400 (0:00:00.059)       0:01:43.559 ********* 
ok: [managed-node1] => {
    "changed": false,
    "cmd": [
        "grep",
        "^defaultlogdir = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003787",
    "end": "2025-06-19 12:11:33.060876",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-06-19 12:11:33.057089"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultlogdir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Thursday 19 June 2025  12:11:33 -0400 (0:00:00.457)       0:01:44.017 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node1] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "filelocation.defaultlogdir",
        "/tmp/mssql_log"
    ],
    "delta": "0:00:00.166136",
    "end": "2025-06-19 12:11:33.754904",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-06-19 12:11:33.588768"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting filelocation defaultlogdir] ***
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Thursday 19 June 2025  12:11:33 -0400 (0:00:00.694)       0:01:44.711 ********* 
skipping: [managed-node1] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set selinux role facts for ports] ******
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:449
Thursday 19 June 2025  12:11:33 -0400 (0:00:00.027)       0:01:44.738 ********* 
ok: [managed-node1] => {
    "ansible_facts": {
        "selinux_ports": [
            {
                "local": true,
                "ports": "1433 ",
                "proto": "tcp",
                "setype": "mssql_port_t",
                "state": "present"
            }
        ]
    },
    "changed": false
}

TASK [Ensure correct SELinux context for storage paths and ports] **************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:463
Thursday 19 June 2025  12:11:33 -0400 (0:00:00.053)       0:01:44.792 ********* 
ERROR! the role 'fedora.linux_system_roles.selinux' 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/roles/mssql/tasks/main.yml': line 472, 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.selinux
          ^ here
fatal: [managed-node1]: FAILED! => {
    "changed": false,
    "reason": "the role 'fedora.linux_system_roles.selinux' 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/roles/mssql/tasks/main.yml': line 472, 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.selinux\n          ^ here\n"
}

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2022.yml:19
Thursday 19 June 2025  12:11:34 -0400 (0:00:00.099)       0:01:44.891 ********* 
included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node1

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:11:34 -0400 (0:00:00.061)       0:01:44.953 ********* 
ok: [managed-node1] => {
    "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:11:34 -0400 (0:00:00.889)       0:01:45.843 ********* 
included: fedora.linux_system_roles.mssql for managed-node1

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:11:35 -0400 (0:00:00.056)       0:01:45.899 ********* 
skipping: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.054)       0:01:45.954 ********* 
ok: [managed-node1] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node1] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node1] => (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-node1] => (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:11:35 -0400 (0:00:00.071)       0:01:46.026 ********* 
skipping: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.051)       0:01:46.077 ********* 
skipping: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.052)       0:01:46.130 ********* 
skipping: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.099)       0:01:46.229 ********* 
skipping: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.044)       0:01:46.274 ********* 
ok: [managed-node1] => {
    "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:11:35 -0400 (0:00:00.033)       0:01:46.308 ********* 
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-node1]: 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-node1              : ok=40   changed=8    unreachable=0    failed=2    skipped=41   rescued=0    ignored=0   

SYSTEM ROLES ERRORS BEGIN v1
[
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-06-19T16:11:33.988692+00:00Z",
        "host": "managed-node1",
        "message": "No message could be found",
        "start_time": "2025-06-19T16:11:33.915919+00:00Z",
        "task_name": "Ensure correct SELinux context for storage paths and ports",
        "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:463"
    },
    {
        "ansible_version": "2.17.12",
        "end_time": "2025-06-19T16:11:35.484120+00:00Z",
        "host": "managed-node1",
        "message": "No message could be found",
        "start_time": "2025-06-19T16:11:35.431731+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:11:35 -0400 (0:00:00.053)       0:01:46.362 ********* 
=============================================================================== 
fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux -- 86.22s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 
fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 6.57s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404 
fedora.linux_system_roles.mssql : Ensure the package mssql-server ------- 1.38s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.09s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 
Ensure ansible_facts to get ansible_distribution ------------------------ 0.89s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 
Gather package facts ---------------------------------------------------- 0.89s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.84s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 
fedora.linux_system_roles.mssql : Configure the setting filelocation defaultlogdir --- 0.69s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022 --- 0.55s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 
fedora.linux_system_roles.mssql : Configure the setting filelocation defaultdatadir --- 0.54s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 
fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.53s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 
fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data --- 0.51s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 
fedora.linux_system_roles.mssql : Get the setting filelocation defaultdatadir --- 0.49s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 
fedora.linux_system_roles.mssql : Get the setting filelocation defaultlogdir --- 0.46s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 
fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.41s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350 
fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled --- 0.39s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367 
fedora.linux_system_roles.mssql : Check if mssql-server.service is running --- 0.37s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374 
fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_log --- 0.36s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 
Run on a fresh host and set all parameters ------------------------------ 0.21s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:5 
fedora.linux_system_roles.mssql : Append facts for the selinux role ----- 0.12s
/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12