# STDOUT:
---v---v---v---v---v---
Using /etc/ansible/ansible.cfg as config file

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

TASK [Gathering Facts] *********************************************************
Wednesday 31 August 2022  10:45:16 +0000 (0:00:00.020)       0:00:00.020 ****** 
ok: [sut]

TASK [create var file in caller that can override the one in called role] ******
Wednesday 31 August 2022  10:45:17 +0000 (0:00:01.239)       0:00:01.259 ****** 
changed: [sut -> localhost] => (item=RedHat-8.7) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "870b2314d3f4184a363b31373f07abb444f26444",
    "dest": "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/caller/vars/RedHat-8.7.yml",
    "gid": 1001,
    "group": "jenkins",
    "item": "RedHat-8.7",
    "md5sum": "5a57da448a1d752b982858b38aab344d",
    "mode": "0600",
    "owner": "jenkins",
    "size": 23,
    "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1661942718.01932-4672-274562246990498/source",
    "state": "file",
    "uid": 1000090000
}
changed: [sut -> localhost] => (item=RedHat-8) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "870b2314d3f4184a363b31373f07abb444f26444",
    "dest": "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/caller/vars/RedHat-8.yml",
    "gid": 1001,
    "group": "jenkins",
    "item": "RedHat-8",
    "md5sum": "5a57da448a1d752b982858b38aab344d",
    "mode": "0600",
    "owner": "jenkins",
    "size": 23,
    "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1661942718.832548-4672-280232341346444/source",
    "state": "file",
    "uid": 1000090000
}
changed: [sut -> localhost] => (item=RedHat_8.7) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "870b2314d3f4184a363b31373f07abb444f26444",
    "dest": "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/caller/vars/RedHat_8.7.yml",
    "gid": 1001,
    "group": "jenkins",
    "item": "RedHat_8.7",
    "md5sum": "5a57da448a1d752b982858b38aab344d",
    "mode": "0600",
    "owner": "jenkins",
    "size": 23,
    "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1661942719.3030815-4672-249923056065332/source",
    "state": "file",
    "uid": 1000090000
}
changed: [sut -> localhost] => (item=RedHat_8) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "870b2314d3f4184a363b31373f07abb444f26444",
    "dest": "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/caller/vars/RedHat_8.yml",
    "gid": 1001,
    "group": "jenkins",
    "item": "RedHat_8",
    "md5sum": "5a57da448a1d752b982858b38aab344d",
    "mode": "0600",
    "owner": "jenkins",
    "size": 23,
    "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1661942719.772924-4672-20919753985958/source",
    "state": "file",
    "uid": 1000090000
}
changed: [sut -> localhost] => (item=RedHat) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "870b2314d3f4184a363b31373f07abb444f26444",
    "dest": "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/caller/vars/RedHat.yml",
    "gid": 1001,
    "group": "jenkins",
    "item": "RedHat",
    "md5sum": "5a57da448a1d752b982858b38aab344d",
    "mode": "0600",
    "owner": "jenkins",
    "size": 23,
    "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1661942720.2585983-4672-37343250428679/source",
    "state": "file",
    "uid": 1000090000
}

TASK [include_role : {{ roletoinclude }}] **************************************
Wednesday 31 August 2022  10:45:20 +0000 (0:00:02.788)       0:00:04.048 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
Wednesday 31 August 2022  10:45:20 +0000 (0:00:00.145)       0:00:04.193 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  10:45:20 +0000 (0:00:00.042)       0:00:04.236 ****** 
ok: [sut]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.490)       0:00:04.726 ****** 
ok: [sut] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
ok: [sut] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [sut] => (item=RedHat_8.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item=RedHat_8.7.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.7.yml",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.087)       0:00:04.814 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.044)       0:00:04.858 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.044)       0:00:04.902 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.040)       0:00:04.943 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.043)       0:00:04.986 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.040)       0:00:05.026 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.040)       0:00:05.066 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.055)       0:00:05.122 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.052)       0:00:05.174 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.035)       0:00:05.209 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.032)       0:00:05.242 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
Wednesday 31 August 2022  10:45:21 +0000 (0:00:00.033)       0:00:05.276 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Gather package facts] *************************
Wednesday 31 August 2022  10:45:22 +0000 (0:00:00.037)       0:00:05.314 ****** 
ok: [sut] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
Wednesday 31 August 2022  10:45:24 +0000 (0:00:01.997)       0:00:07.311 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
Wednesday 31 August 2022  10:45:24 +0000 (0:00:00.052)       0:00:07.363 ****** 
changed: [sut] => {
    "changed": true
}

TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
Wednesday 31 August 2022  10:45:25 +0000 (0:00:01.009)       0:00:08.373 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
Wednesday 31 August 2022  10:45:25 +0000 (0:00:00.051)       0:00:08.425 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
Wednesday 31 August 2022  10:45:25 +0000 (0:00:00.052)       0:00:08.478 ****** 
changed: [sut] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
Wednesday 31 August 2022  10:45:25 +0000 (0:00:00.480)       0:00:08.958 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: gdb-8.2-19.el8.x86_64",
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-15.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: bzip2-1.0.6-26.el8.x86_64",
        "Installed: mssql-server-15.0.4249.2-1.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
Wednesday 31 August 2022  10:46:19 +0000 (0:00:54.064)       0:01:03.023 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
Wednesday 31 August 2022  10:46:19 +0000 (0:00:00.049)       0:01:03.073 ****** 
ok: [sut] => {
    "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.010888",
    "end": "2022-08-31 10:46:20.224572",
    "rc": 0,
    "start": "2022-08-31 10:46:20.213684"
}

TASK [linux-system-roles.mssql : Gather system services facts] *****************
Wednesday 31 August 2022  10:46:20 +0000 (0:00:00.502)       0:01:03.575 ****** 
ok: [sut] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
Wednesday 31 August 2022  10:46:23 +0000 (0:00:02.773)       0:01:06.349 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
Wednesday 31 August 2022  10:46:23 +0000 (0:00:00.092)       0:01:06.442 ****** 
changed: [sut] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "-n",
        "setup"
    ],
    "delta": "0:00:08.583082",
    "end": "2022-08-31 10:46:31.981629",
    "rc": 0,
    "start": "2022-08-31 10:46:23.398547"
}

STDOUT:


The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition].

ForceFlush is enabled for this instance. 

ForceFlush feature is enabled for log durability.

The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Configuring SQL Server...
Setup has completed successfully. SQL Server is now starting.


STDERR:

Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service.

TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
Wednesday 31 August 2022  10:46:32 +0000 (0:00:08.903)       0:01:15.346 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: tuned-profiles-mssql-2.19.0-1.el8.noarch"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] ***
Wednesday 31 August 2022  10:46:36 +0000 (0:00:04.412)       0:01:19.758 ****** 
ok: [sut] => {
    "changed": false,
    "enabled": true,
    "name": "tuned",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-31 10:36:16 UTC",
        "ActiveEnterTimestampMonotonic": "16174331",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "basic.target systemd-sysctl.service dbus.service sysinit.target system.slice systemd-journald.socket network.target dbus.socket",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-31 10:36:14 UTC",
        "AssertTimestampMonotonic": "14660800",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "[not set]",
        "CPUWeight": "[not set]",
        "CacheDirectoryMode": "0755",
        "CanFreeze": "yes",
        "CanIsolate": "no",
        "CanReload": "no",
        "CanStart": "yes",
        "CanStop": "yes",
        "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-31 10:36:14 UTC",
        "ConditionTimestampMonotonic": "14660798",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target tlp.service cpupower.service power-profiles-daemon.service auto-cpufreq.service",
        "ControlGroup": "/system.slice/tuned.service",
        "ControlPID": "0",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Dynamic System Tuning Daemon",
        "DevicePolicy": "auto",
        "Documentation": "man:tuned(8) man:tuned.conf(5) man:tuned-adm(8)",
        "DynamicUser": "no",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "745",
        "ExecMainStartTimestamp": "Wed 2022-08-31 10:36:14 UTC",
        "ExecMainStartTimestampMonotonic": "14662924",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-31 10:36:14 UTC",
        "InactiveExitTimestampMonotonic": "14663070",
        "InvocationID": "166cd2550f8b4605b77e019f93b7f029",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "262144",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "14143",
        "LimitNPROCSoft": "14143",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "14143",
        "LimitSIGPENDINGSoft": "14143",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "745",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "21274624",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PIDFile": "/run/tuned/tuned.pid",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "dbus.service polkit.service sysinit.target system.slice dbus.socket",
        "Restart": "no",
        "RestartUSec": "100ms",
        "RestrictNamespaces": "no",
        "RestrictRealtime": "no",
        "RestrictSUIDSGID": "no",
        "Result": "success",
        "RootDirectoryStartOnly": "no",
        "RuntimeDirectoryMode": "0755",
        "RuntimeDirectoryPreserve": "no",
        "RuntimeMaxUSec": "infinity",
        "SameProcessGroup": "no",
        "SecureBits": "0",
        "SendSIGHUP": "no",
        "SendSIGKILL": "yes",
        "Slice": "system.slice",
        "StandardError": "inherit",
        "StandardInput": "null",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-31 10:36:16 UTC",
        "StateChangeTimestampMonotonic": "16174331",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "5",
        "TasksMax": "22628",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "enabled",
        "UnitFileState": "enabled",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2022-08-31 10:36:16 UTC",
        "WatchdogTimestampMonotonic": "16174324",
        "WatchdogUSec": "0"
    }
}

TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
Wednesday 31 August 2022  10:46:37 +0000 (0:00:01.112)       0:01:20.871 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.392598",
    "end": "2022-08-31 10:46:38.385806",
    "rc": 0,
    "start": "2022-08-31 10:46:37.993208"
}

STDOUT:

Current active profile: virtual-guest

TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
Wednesday 31 August 2022  10:46:38 +0000 (0:00:00.884)       0:01:21.755 ****** 
changed: [sut] => {
    "changed": true,
    "cmd": [
        "tuned-adm",
        "profile",
        "virtual-guest",
        "mssql"
    ],
    "delta": "0:00:02.288090",
    "end": "2022-08-31 10:46:41.155935",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-31 10:46:38.867845"
}

TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
Wednesday 31 August 2022  10:46:41 +0000 (0:00:02.761)       0:01:24.516 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
Wednesday 31 August 2022  10:46:41 +0000 (0:00:00.057)       0:01:24.573 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
Wednesday 31 August 2022  10:46:41 +0000 (0:00:00.055)       0:01:24.629 ****** 
changed: [sut] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] ***
Wednesday 31 August 2022  10:46:41 +0000 (0:00:00.345)       0:01:24.975 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: unixODBC-devel-2.3.7-1.rh.x86_64",
        "Installed: mssql-tools-17.10.1.1-1.x86_64",
        "Installed: msodbcsql17-17.10.1.1-1.x86_64",
        "Installed: unixODBC-2.3.7-1.rh.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
Wednesday 31 August 2022  10:46:47 +0000 (0:00:05.603)       0:01:30.578 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the set password matches the existing password] ***
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.058)       0:01:30.636 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.056)       0:01:30.693 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.057)       0:01:30.751 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Pre-input SQL scripts to SQL Server] **********
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.086)       0:01:30.837 ****** 

TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] ***
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.048)       0:01:30.886 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.058)       0:01:30.945 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.058)       0:01:31.003 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the IP address setting] *************
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.058)       0:01:31.061 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.058)       0:01:31.120 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 1433 TCP port] **************************************************
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.056)       0:01:31.176 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
Wednesday 31 August 2022  10:46:47 +0000 (0:00:00.056)       0:01:31.233 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for sut

TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.088)       0:01:31.321 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.005667",
    "end": "2022-08-31 10:46:48.271663",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-31 10:46:48.265996"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.305)       0:01:31.627 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.160627",
    "end": "2022-08-31 10:46:48.742084",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-31 10:46:48.581457"
}

STDOUT:

Validation error on setting 'network.tcpport'
Port '1433' is already in use. Please use another port

TASK [linux-system-roles.mssql : Unset the network tcpport setting] ************
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.485)       0:01:32.112 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Close the previously set SQL Server TCP port if it changed] **************
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.055)       0:01:32.168 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.057)       0:01:32.226 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-fts package] **********
Wednesday 31 August 2022  10:46:48 +0000 (0:00:00.060)       0:01:32.286 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.099)       0:01:32.385 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.062)       0:01:32.448 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.064)       0:01:32.512 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the 3979 trace flag is enabled] ******
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.062)       0:01:32.574 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.062)       0:01:32.637 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the 3979 traceflag] *********************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.060)       0:01:32.697 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.062)       0:01:32.760 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.060)       0:01:32.820 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Copy certificate and private_key files to the host] ***
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.059)       0:01:32.880 ****** 
skipping: [sut] => (item=None)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": null,
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item=None)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": null,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlscert setting] ****************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.068)       0:01:32.949 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.060)       0:01:33.010 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.060)       0:01:33.070 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.061)       0:01:33.132 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.062)       0:01:33.194 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set host variables] ***************************
Wednesday 31 August 2022  10:46:49 +0000 (0:00:00.057)       0:01:33.251 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.060)       0:01:33.312 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.059)       0:01:33.372 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.129)       0:01:33.501 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.060)       0:01:33.562 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.078)       0:01:33.641 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate and private key files] *****
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.065)       0:01:33.706 ****** 
skipping: [sut] => (item=/var/opt/mssql/data/.cer)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "/var/opt/mssql/data/.cer",
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item=/var/opt/mssql/data/.pvk)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "/var/opt/mssql/data/.pvk",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.068)       0:01:33.774 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create and back up certificate] ***************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.057)       0:01:33.831 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Fetch certificate and private key from the primary node to the control node] ***
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.063)       0:01:33.895 ****** 
skipping: [sut] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": "cert",
        "value": "/var/opt/mssql/data/.cer"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": "key",
        "value": "/var/opt/mssql/data/.pvk"
    },
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.069)       0:01:33.964 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the] ***********************************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.063)       0:01:34.028 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Get mssql-server version to see if WRITE_LEASE_VALIDITY is available] ***
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.055)       0:01:34.084 ****** 
skipping: [sut] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [linux-system-roles.mssql : Configure the  availability group] ************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.058)       0:01:34.142 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.057)       0:01:34.199 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Back up and replicate databases] **************
Wednesday 31 August 2022  10:46:50 +0000 (0:00:00.057)       0:01:34.256 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.060)       0:01:34.317 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.060)       0:01:34.377 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.059)       0:01:34.436 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.109)       0:01:34.545 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.061)       0:01:34.607 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Distribute certificate and private key to managed nodes] ***
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.065)       0:01:34.672 ****** 
skipping: [sut] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": "cert",
        "value": "/var/opt/mssql/data/.cer"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": "key",
        "value": "/var/opt/mssql/data/.pvk"
    },
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.075)       0:01:34.748 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restore certificate] **************************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.074)       0:01:34.822 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.098)       0:01:34.920 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the  login] ****************************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.101)       0:01:35.021 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Join synchronous and witness servers to the availability group] ***
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.086)       0:01:35.107 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  10:46:51 +0000 (0:00:00.081)       0:01:35.188 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate and private key from the control node] ***
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.135)       0:01:35.324 ****** 
skipping: [sut] => (item=cert)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "cert",
    "skip_reason": "Conditional result was False"
}
skipping: [sut] => (item=key)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "key",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Save credentials for the  SQL Server login] ***
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.088)       0:01:35.412 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.060)       0:01:35.473 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure a listener for the  availability group] ***
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.065)       0:01:35.538 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.059)       0:01:35.598 ****** 
changed: [sut] => {
    "changed": true
}

MSG:

Block inserted

TASK [linux-system-roles.mssql : Flush handlers prior to inputting post SQL scripts] ***
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.563)       0:01:36.161 ****** 

TASK [linux-system-roles.mssql : Post-input SQL scripts to SQL Server] *********
Wednesday 31 August 2022  10:46:52 +0000 (0:00:00.073)       0:01:36.235 ****** 

TASK [caller : assert] *********************************************************
Wednesday 31 August 2022  10:46:53 +0000 (0:00:00.084)       0:01:36.320 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

PLAY RECAP *********************************************************************
sut                        : ok=28   changed=10   unreachable=0    failed=0    skipped=76   rescued=0    ignored=0   

Wednesday 31 August 2022  10:46:53 +0000 (0:00:00.157)       0:01:36.477 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 54.06s
linux-system-roles.mssql : Set up MSSQL --------------------------------- 8.90s
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 5.60s
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 4.41s
create var file in caller that can override the one in called role ------ 2.79s
linux-system-roles.mssql : Gather system services facts ----------------- 2.77s
linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 2.76s
linux-system-roles.mssql : Gather package facts ------------------------- 2.00s
Gathering Facts --------------------------------------------------------- 1.24s
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.11s
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.01s
linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.88s
linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.56s
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.50s
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.49s
linux-system-roles.mssql : Configure the network tcpport setting -------- 0.49s
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.48s
linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.35s
linux-system-roles.mssql : Get the network tcpport setting -------------- 0.31s
caller : assert --------------------------------------------------------- 0.16s

---^---^---^---^---^---

# STDERR:
---v---v---v---v---v---
[DEPRECATION WARNING]: [defaults]callback_whitelist option, normalizing names 
to new standard, use callbacks_enabled instead. This feature will be removed 
from ansible-core in version 2.15. Deprecation warnings can be disabled by 
setting deprecation_warnings=False in ansible.cfg.

---^---^---^---^---^---