ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmpxn3yv_ek
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
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_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml

PLAY [Ensure that the role can input sql files to MSSQL] ***********************

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022  16:46:19 +0000 (0:00:00.013)       0:00:00.013 ****** 
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers

TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022  16:46:20 +0000 (0:00:01.365)       0:00:01.378 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022  16:46:20 +0000 (0:00:00.091)       0:00:01.470 ****** 
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/fedora-35.qcow2.snap

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  16:46:20 +0000 (0:00:00.033)       0:00:01.503 ****** 
ok: [/cache/fedora-35.qcow2.snap]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.598)       0:00:02.102 ****** 
ok: [/cache/fedora-35.qcow2.snap] => (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": [
        "/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:8
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.050)       0:00:02.152 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:12
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.030)       0:00:02.182 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:16
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.028)       0:00:02.211 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:22
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.023)       0:00:02.235 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:27
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.024)       0:00:02.260 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:39
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.044)       0:00:02.304 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:44
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.048)       0:00:02.352 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:55
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.036)       0:00:02.388 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:63
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.037)       0:00:02.426 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:72
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.034)       0:00:02.460 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Gather package facts] *************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:85
Wednesday 03 August 2022  16:46:21 +0000 (0:00:00.036)       0:00:02.497 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:90
Wednesday 03 August 2022  16:46:22 +0000 (0:00:01.092)       0:00:03.590 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:101
Wednesday 03 August 2022  16:46:22 +0000 (0:00:00.045)       0:00:03.635 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:107
Wednesday 03 August 2022  16:46:23 +0000 (0:00:00.769)       0:00:04.405 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:118
Wednesday 03 August 2022  16:46:23 +0000 (0:00:00.049)       0:00:04.455 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:124
Wednesday 03 August 2022  16:46:23 +0000 (0:00:00.051)       0:00:04.506 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022  16:46:24 +0000 (0:00:00.578)       0:00:05.084 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022  16:47:01 +0000 (0:00:37.417)       0:00:42.501 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: openldap-compat-2.4.59-3.fc35.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022  16:47:04 +0000 (0:00:02.331)       0:00:44.832 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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.005559",
    "end": "2022-08-03 16:47:03.300526",
    "rc": 0,
    "start": "2022-08-03 16:47:03.294967"
}

TASK [linux-system-roles.mssql : Gather system services facts] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:165
Wednesday 03 August 2022  16:47:04 +0000 (0:00:00.536)       0:00:45.369 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022  16:47:06 +0000 (0:00:02.025)       0:00:47.394 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:189
Wednesday 03 August 2022  16:47:06 +0000 (0:00:00.103)       0:00:47.497 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "-n",
        "setup"
    ],
    "delta": "0:00:04.885476",
    "end": "2022-08-03 16:47:10.752232",
    "rc": 0,
    "start": "2022-08-03 16:47:05.866756"
}

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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:198
Wednesday 03 August 2022  16:47:12 +0000 (0:00:05.348)       0:00:52.846 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: ethtool-2:5.18-1.fc35.x86_64",
        "Installed: python3-gobject-base-3.42.0-1.fc35.x86_64",
        "Installed: hdparm-9.63-1.fc35.x86_64",
        "Installed: kernel-tools-5.18.13-100.fc35.x86_64",
        "Installed: kernel-tools-libs-5.18.13-100.fc35.x86_64",
        "Installed: tuned-2.18.0-2.fc35.noarch",
        "Installed: python3-perf-5.18.13-100.fc35.x86_64",
        "Installed: gobject-introspection-1.70.0-1.fc35.x86_64",
        "Installed: tuned-profiles-mssql-2.18.0-2.fc35.noarch",
        "Installed: python3-linux-procfs-0.6.3-3.fc35.noarch",
        "Installed: python3-pyudev-0.22.0-6.fc35.noarch",
        "Installed: virt-what-1.24-1.fc35.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:203
Wednesday 03 August 2022  16:47:15 +0000 (0:00:03.641)       0:00:56.488 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "enabled": true,
    "name": "tuned",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "n/a",
        "ActiveEnterTimestampMonotonic": "0",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "inactive",
        "After": "sysinit.target systemd-journald.socket dbus.socket dbus-broker.service system.slice basic.target systemd-sysctl.service network.target",
        "AllowIsolate": "no",
        "AssertResult": "no",
        "AssertTimestamp": "n/a",
        "AssertTimestampMonotonic": "0",
        "Before": "shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "yes",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "no",
        "ConditionTimestamp": "n/a",
        "ConditionTimestampMonotonic": "0",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target auto-cpufreq.service tlp.service cpupower.service power-profiles-daemon.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "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",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "0",
        "ExecMainStartTimestamp": "n/a",
        "ExecMainStartTimestampMonotonic": "0",
        "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 }",
        "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "n/a",
        "InactiveExitTimestampMonotonic": "0",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "524288",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "15523",
        "LimitNPROCSoft": "15523",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "0",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "[not set]",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "PIDFile": "/run/tuned/tuned.pid",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "dbus-broker.service polkit.service sysinit.target system.slice dbus.socket",
        "Restart": "no",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "n/a",
        "StateChangeTimestampMonotonic": "0",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "dead",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "[not set]",
        "TasksMax": "4656",
        "TimeoutAbortUSec": "1min 30s",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "disabled",
        "UnitFileState": "disabled",
        "UtmpMode": "init",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "infinity"
    }
}

TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:209
Wednesday 03 August 2022  16:47:17 +0000 (0:00:01.342)       0:00:57.830 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.106106",
    "end": "2022-08-03 16:47:16.306425",
    "rc": 0,
    "start": "2022-08-03 16:47:16.200319"
}

STDOUT:

Current active profile: virtual-guest

TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:219
Wednesday 03 August 2022  16:47:17 +0000 (0:00:00.549)       0:00:58.380 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "cmd": [
        "tuned-adm",
        "profile",
        "virtual-guest",
        "mssql"
    ],
    "delta": "0:00:01.107010",
    "end": "2022-08-03 16:47:17.829539",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-03 16:47:16.722529"
}

TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:232
Wednesday 03 August 2022  16:47:19 +0000 (0:00:01.529)       0:00:59.909 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:241
Wednesday 03 August 2022  16:47:19 +0000 (0:00:00.039)       0:00:59.948 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:251
Wednesday 03 August 2022  16:47:19 +0000 (0:00:00.038)       0:00:59.987 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:258
Wednesday 03 August 2022  16:47:19 +0000 (0:00:00.430)       0:01:00.417 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: msodbcsql17-17.10.1.1-1.x86_64",
        "Installed: mssql-tools-17.10.1.1-1.x86_64",
        "Installed: unixODBC-2.3.9-4.fc35.x86_64",
        "Installed: unixODBC-devel-2.3.9-4.fc35.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:270
Wednesday 03 August 2022  16:47:22 +0000 (0:00:02.781)       0:01:03.198 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:275
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.041)       0:01:03.240 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:281
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.044)       0:01:03.284 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:288
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.041)       0:01:03.326 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:296
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.041)       0:01:03.367 ****** 
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap

TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.073)       0:01:03.440 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022  16:47:22 +0000 (0:00:00.124)       0:01:03.565 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.f44o7xyl",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [linux-system-roles.mssql : Copy the sql_script.sql file to the host] *****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022  16:47:23 +0000 (0:00:00.518)       0:01:04.083 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
    "dest": "/tmp/ansible.f44o7xyl",
    "gid": 0,
    "group": "root",
    "md5sum": "8edbc22195757a4f043b10e9367f131b",
    "mode": "0644",
    "owner": "root",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 391,
    "src": "/root/.ansible/tmp/ansible-tmp-1659545243.4188056-84291-69763973753938/source",
    "state": "file",
    "uid": 0
}

TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022  16:47:24 +0000 (0:00:01.028)       0:01:05.112 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022  16:47:24 +0000 (0:00:00.040)       0:01:05.153 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ActiveEnterTimestampMonotonic": "61981258",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "AssertTimestampMonotonic": "61977350",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "5107692000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ConditionTimestampMonotonic": "61977346",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2767",
        "ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ExecMainStartTimestampMonotonic": "61980637",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "InactiveExitTimestampMonotonic": "61981258",
        "InvocationID": "f833cbe64ce74be387f09529551b4a81",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2767",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "645103616",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "-.mount system.slice sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "StateChangeTimestampMonotonic": "61981258",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "143",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022  16:47:24 +0000 (0:00:00.565)       0:01:05.719 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "elapsed": 0,
    "gid": 992,
    "group": "mssql",
    "match_groupdict": {},
    "match_groups": [],
    "mode": "0660",
    "owner": "mssql",
    "path": "/var/opt/mssql/log/errorlog",
    "port": null,
    "search_regex": "SQL Server is now ready for client connections",
    "secontext": "system_u:object_r:var_t:s0",
    "size": 7697,
    "state": "file",
    "uid": 992
}

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022  16:47:25 +0000 (0:00:00.545)       0:01:06.264 ****** 
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml for /cache/fedora-35.qcow2.snap

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022  16:47:25 +0000 (0:00:00.100)       0:01:06.365 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ActiveEnterTimestampMonotonic": "61981258",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "AssertTimestampMonotonic": "61977350",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "5119409000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ConditionTimestampMonotonic": "61977346",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2767",
        "ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ExecMainStartTimestampMonotonic": "61980637",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "InactiveExitTimestampMonotonic": "61981258",
        "InvocationID": "f833cbe64ce74be387f09529551b4a81",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2767",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "645103616",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "-.mount system.slice sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "StateChangeTimestampMonotonic": "61981258",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "143",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [linux-system-roles.mssql : Check if a custom tcpport setting exist] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022  16:47:26 +0000 (0:00:00.569)       0:01:06.935 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003699",
    "end": "2022-08-03 16:47:25.285595",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 16:47:25.281896"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Check if a custom ipaddress setting exist] ****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022  16:47:26 +0000 (0:00:00.428)       0:01:07.363 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^ipaddress = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.004344",
    "end": "2022-08-03 16:47:25.699479",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 16:47:25.695135"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Set a fact with a password query] *************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022  16:47:27 +0000 (0:00:00.418)       0:01:07.782 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": "/opt/mssql-tools/bin/sqlcmd   -U sa -P p@55w0rD"
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022  16:47:27 +0000 (0:00:00.066)       0:01:07.849 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "/opt/mssql-tools/bin/sqlcmd",
        "-U",
        "sa",
        "-P",
        "p@55w0rD",
        "-i",
        "/tmp/ansible.f44o7xyl",
        "-b"
    ],
    "delta": "0:00:00.276306",
    "end": "2022-08-03 16:47:26.458123",
    "rc": 0,
    "start": "2022-08-03 16:47:26.181817"
}

STDOUT:

Changed database context to 'ExampleDB'.

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

TASK [linux-system-roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022  16:47:27 +0000 (0:00:00.697)       0:01:08.546 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "__mssql_sqlcmd_input_file.stdout_lines": [
        "Changed database context to 'ExampleDB'.",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)"
    ]
}

TASK [linux-system-roles.mssql : Remove the tempfile] **************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022  16:47:27 +0000 (0:00:00.105)       0:01:08.651 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022  16:47:27 +0000 (0:00:00.042)       0:01:08.694 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the mssql_pre_input_sql_file fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:302
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.042)       0:01:08.736 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "mssql_pre_input_sql_file": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:311
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.044)       0:01:08.781 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:324
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.042)       0:01:08.823 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:331
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.039)       0:01:08.863 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the IP address setting] *************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:340
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.038)       0:01:08.902 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:347
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.040)       0:01:08.943 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:354
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.050)       0:01:08.993 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:365
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.049)       0:01:09.043 ****** 
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for /cache/fedora-35.qcow2.snap

TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.063)       0:01:09.106 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003852",
    "end": "2022-08-03 16:47:27.467938",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 16:47:27.464086"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022  16:47:28 +0000 (0:00:00.440)       0:01:09.547 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.102656",
    "end": "2022-08-03 16:47:28.008387",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-03 16:47:27.905731"
}

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] ************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.550)       0:01:10.097 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:371
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.037)       0:01:10.135 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:389
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.051)       0:01:10.187 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-fts package] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:396
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.042)       0:01:10.230 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:403
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.040)       0:01:10.271 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:412
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.041)       0:01:10.313 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:418
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.040)       0:01:10.354 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the 3979 trace flag is enabled] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:427
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.039)       0:01:10.393 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:433
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.038)       0:01:10.432 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the 3979 traceflag] *********************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:439
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.040)       0:01:10.472 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:446
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.039)       0:01:10.511 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:452
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.040)       0:01:10.552 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:463
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.039)       0:01:10.592 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (item=None)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": null,
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:479
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.042)       0:01:10.634 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:488
Wednesday 03 August 2022  16:47:29 +0000 (0:00:00.040)       0:01:10.675 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:497
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.087)       0:01:10.762 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:504
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.040)       0:01:10.803 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:514
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.045)       0:01:10.848 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set host variables] ***************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:533
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.056)       0:01:10.905 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:544
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.050)       0:01:10.956 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:550
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.054)       0:01:11.010 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:557
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.049)       0:01:11.060 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:565
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.047)       0:01:11.107 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:570
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.049)       0:01:11.157 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate and private key files] *****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:576
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.047)       0:01:11.204 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:585
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.050)       0:01:11.255 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create and back up certificate] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:590
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.049)       0:01:11.304 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:596
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.050)       0:01:11.354 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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 : Create database mirroring endpoints] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:608
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.059)       0:01:11.414 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the] ***********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:613
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.051)       0:01:11.465 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:619
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.051)       0:01:11.517 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "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 : Create the  availability group] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:624
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.097)       0:01:11.615 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:629
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.052)       0:01:11.667 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Back up and replicate the  database] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:634
Wednesday 03 August 2022  16:47:30 +0000 (0:00:00.051)       0:01:11.718 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set a fact to indicate successful set up on the primary replica] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:641
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.056)       0:01:11.775 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Fail if the primary node failed] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:668
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.055)       0:01:11.830 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:675
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.053)       0:01:11.884 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:681
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.049)       0:01:11.933 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:688
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.048)       0:01:11.982 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:696
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.051)       0:01:12.034 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create master key encryption] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:701
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.048)       0:01:12.082 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:706
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.047)       0:01:12.130 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:718
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.058)       0:01:12.188 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restore certificate] **************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:724
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.048)       0:01:12.236 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create database mirroring endpoints] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:729
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.050)       0:01:12.287 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the  login] ****************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:734
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.054)       0:01:12.342 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Join synchronous and witness servers to the availability group] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:739
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.055)       0:01:12.397 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:744
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.051)       0:01:12.449 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the  database exists on secondaries] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:749
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.115)       0:01:12.565 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate and private key from the control node] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:756
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.081)       0:01:12.646 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (item=cert)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "cert",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:769
Wednesday 03 August 2022  16:47:31 +0000 (0:00:00.064)       0:01:12.710 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:780
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.055)       0:01:12.765 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the  database exists] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:785
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.054)       0:01:12.819 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:793
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.053)       0:01:12.873 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true
}

MSG:

Block inserted

TASK [linux-system-roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:802
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.660)       0:01:13.534 ****** 
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap

TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.071)       0:01:13.606 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022  16:47:32 +0000 (0:00:00.050)       0:01:13.656 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.0fiu_43f",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [linux-system-roles.mssql : Copy the sql_script.sql file to the host] *****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022  16:47:33 +0000 (0:00:00.407)       0:01:14.063 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
    "dest": "/tmp/ansible.0fiu_43f",
    "gid": 0,
    "group": "root",
    "md5sum": "8edbc22195757a4f043b10e9367f131b",
    "mode": "0644",
    "owner": "root",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 391,
    "src": "/root/.ansible/tmp/ansible-tmp-1659545253.4433212-84617-214991567097609/source",
    "state": "file",
    "uid": 0
}

TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022  16:47:34 +0000 (0:00:00.809)       0:01:14.872 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022  16:47:34 +0000 (0:00:00.043)       0:01:14.916 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ActiveEnterTimestampMonotonic": "61981258",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "AssertTimestampMonotonic": "61977350",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "5339878000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ConditionTimestampMonotonic": "61977346",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2767",
        "ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "ExecMainStartTimestampMonotonic": "61980637",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "InactiveExitTimestampMonotonic": "61981258",
        "InvocationID": "f833cbe64ce74be387f09529551b4a81",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2767",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "661016576",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "-.mount system.slice sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 16:47:10 UTC",
        "StateChangeTimestampMonotonic": "61981258",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "141",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022  16:47:34 +0000 (0:00:00.567)       0:01:15.484 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "elapsed": 0,
    "gid": 992,
    "group": "mssql",
    "match_groupdict": {},
    "match_groups": [],
    "mode": "0660",
    "owner": "mssql",
    "path": "/var/opt/mssql/log/errorlog",
    "port": null,
    "search_regex": "SQL Server is now ready for client connections",
    "secontext": "system_u:object_r:var_t:s0",
    "size": 8091,
    "state": "file",
    "uid": 992
}

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.414)       0:01:15.898 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.043)       0:01:15.941 ****** 
fatal: [/cache/fedora-35.qcow2.snap]: FAILED! => {
    "changed": false,
    "cmd": [
        "/opt/mssql-tools/bin/sqlcmd",
        "-U",
        "sa",
        "-P",
        "p@55w0rD",
        "-i",
        "/tmp/ansible.0fiu_43f",
        "-b"
    ],
    "delta": "0:00:00.025160",
    "end": "2022-08-03 16:47:34.294311",
    "rc": 1,
    "start": "2022-08-03 16:47:34.269151"
}

STDOUT:

Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1
The server principal 'MyLogin' already exists.
Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2
User, group, or role 'MyUser' already exists in the current database.
Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3
Database 'ExampleDB' already exists. Choose a different database name.


MSG:

non-zero return code

TASK [linux-system-roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.435)       0:01:16.376 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "__mssql_sqlcmd_input_file.stdout_lines": [
        "Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1",
        "The server principal 'MyLogin' already exists.",
        "Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2",
        "User, group, or role 'MyUser' already exists in the current database.",
        "Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3",
        "Database 'ExampleDB' already exists. Choose a different database name."
    ]
}

TASK [linux-system-roles.mssql : Remove the tempfile] **************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.158)       0:01:16.535 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.042)       0:01:16.578 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=48   changed=10   unreachable=0    failed=1    skipped=81   rescued=0    ignored=0   

Wednesday 03 August 2022  16:47:35 +0000 (0:00:00.018)       0:01:16.596 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 37.42s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Set up MSSQL --------------------------------- 5.35s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:189 ------
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.64s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:198 ------
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 2.78s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:258 ------
linux-system-roles.mssql : Ensure that the openldap-compat package is installed --- 2.33s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 ------
linux-system-roles.mssql : Gather system services facts ----------------- 2.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.53s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:219 ------
Gathering Facts --------------------------------------------------------- 1.37s
/tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:3 ------------------------
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.34s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:203 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.09s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 1.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24 
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 0.81s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24 
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.77s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.70s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60 
linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.66s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:793 ------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.60s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.58s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:3 
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41 
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41 
ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmpxn3yv_ek
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
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_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml

PLAY [Ensure that the role can input sql files to MSSQL] ***********************

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022  17:19:38 +0000 (0:00:00.013)       0:00:00.013 ****** 
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers

TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022  17:19:39 +0000 (0:00:01.355)       0:00:01.369 ****** 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 03 August 2022  17:19:39 +0000 (0:00:00.116)       0:00:01.485 ****** 
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/fedora-35.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  17:19:39 +0000 (0:00:00.032)       0:00:01.518 ****** 
ok: [/cache/fedora-35.qcow2.snap]

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.589)       0:00:02.107 ****** 
ok: [/cache/fedora-35.qcow2.snap] => (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": [
        "/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.053)       0:00:02.161 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.033)       0:00:02.194 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.031)       0:00:02.226 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.023)       0:00:02.249 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.025)       0:00:02.275 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.047)       0:00:02.322 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.046)       0:00:02.368 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.034)       0:00:02.403 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.033)       0:00:02.437 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.034)       0:00:02.472 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
Wednesday 03 August 2022  17:19:40 +0000 (0:00:00.034)       0:00:02.506 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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 : Verify if mssql_version is not smaller then the existing SQL Server version] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85
Wednesday 03 August 2022  17:19:42 +0000 (0:00:01.101)       0:00:03.607 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 03 August 2022  17:19:42 +0000 (0:00:00.057)       0:00:03.665 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102
Wednesday 03 August 2022  17:19:42 +0000 (0:00:00.792)       0:00:04.457 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113
Wednesday 03 August 2022  17:19:42 +0000 (0:00:00.047)       0:00:04.505 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119
Wednesday 03 August 2022  17:19:43 +0000 (0:00:00.051)       0:00:04.556 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
Wednesday 03 August 2022  17:19:43 +0000 (0:00:00.571)       0:00:05.127 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022  17:20:20 +0000 (0:00:36.929)       0:00:42.057 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: openldap-compat-2.4.59-3.fc35.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022  17:20:23 +0000 (0:00:02.661)       0:00:44.719 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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.005779",
    "end": "2022-08-03 17:20:22.290019",
    "rc": 0,
    "start": "2022-08-03 17:20:22.284240"
}

TASK [fedora.linux_system_roles.mssql : Gather system services facts] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
Wednesday 03 August 2022  17:20:23 +0000 (0:00:00.539)       0:00:45.258 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "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 : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022  17:20:25 +0000 (0:00:02.078)       0:00:47.336 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
Wednesday 03 August 2022  17:20:25 +0000 (0:00:00.148)       0:00:47.485 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "-n",
        "setup"
    ],
    "delta": "0:00:04.435949",
    "end": "2022-08-03 17:20:29.392638",
    "rc": 0,
    "start": "2022-08-03 17:20:24.956689"
}

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 [fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193
Wednesday 03 August 2022  17:20:30 +0000 (0:00:04.888)       0:00:52.373 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: ethtool-2:5.18-1.fc35.x86_64",
        "Installed: python3-gobject-base-3.42.0-1.fc35.x86_64",
        "Installed: hdparm-9.63-1.fc35.x86_64",
        "Installed: kernel-tools-5.18.13-100.fc35.x86_64",
        "Installed: kernel-tools-libs-5.18.13-100.fc35.x86_64",
        "Installed: tuned-2.18.0-2.fc35.noarch",
        "Installed: python3-perf-5.18.13-100.fc35.x86_64",
        "Installed: gobject-introspection-1.70.0-1.fc35.x86_64",
        "Installed: tuned-profiles-mssql-2.18.0-2.fc35.noarch",
        "Installed: python3-linux-procfs-0.6.3-3.fc35.noarch",
        "Installed: python3-pyudev-0.22.0-6.fc35.noarch",
        "Installed: virt-what-1.24-1.fc35.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
Wednesday 03 August 2022  17:20:34 +0000 (0:00:03.377)       0:00:55.751 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "enabled": true,
    "name": "tuned",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "n/a",
        "ActiveEnterTimestampMonotonic": "0",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "inactive",
        "After": "systemd-sysctl.service network.target system.slice dbus.socket dbus-broker.service basic.target systemd-journald.socket sysinit.target",
        "AllowIsolate": "no",
        "AssertResult": "no",
        "AssertTimestamp": "n/a",
        "AssertTimestampMonotonic": "0",
        "Before": "shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "yes",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "no",
        "ConditionTimestamp": "n/a",
        "ConditionTimestampMonotonic": "0",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "auto-cpufreq.service cpupower.service tlp.service power-profiles-daemon.service shutdown.target",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "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",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "0",
        "ExecMainStartTimestamp": "n/a",
        "ExecMainStartTimestampMonotonic": "0",
        "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 }",
        "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "n/a",
        "InactiveExitTimestampMonotonic": "0",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "524288",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "15523",
        "LimitNPROCSoft": "15523",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "0",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "[not set]",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "PIDFile": "/run/tuned/tuned.pid",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "polkit.service sysinit.target dbus-broker.service dbus.socket system.slice",
        "Restart": "no",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "n/a",
        "StateChangeTimestampMonotonic": "0",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "dead",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "[not set]",
        "TasksMax": "4656",
        "TimeoutAbortUSec": "1min 30s",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "disabled",
        "UnitFileState": "disabled",
        "UtmpMode": "init",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "infinity"
    }
}

TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:204
Wednesday 03 August 2022  17:20:35 +0000 (0:00:01.391)       0:00:57.142 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.108923",
    "end": "2022-08-03 17:20:34.747340",
    "rc": 0,
    "start": "2022-08-03 17:20:34.638417"
}

STDOUT:

Current active profile: virtual-guest

TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214
Wednesday 03 August 2022  17:20:36 +0000 (0:00:00.581)       0:00:57.724 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "cmd": [
        "tuned-adm",
        "profile",
        "virtual-guest",
        "mssql"
    ],
    "delta": "0:00:01.109160",
    "end": "2022-08-03 17:20:36.316165",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-03 17:20:35.207005"
}

TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:227
Wednesday 03 August 2022  17:20:37 +0000 (0:00:01.571)       0:00:59.295 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:236
Wednesday 03 August 2022  17:20:37 +0000 (0:00:00.039)       0:00:59.335 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:246
Wednesday 03 August 2022  17:20:37 +0000 (0:00:00.035)       0:00:59.370 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253
Wednesday 03 August 2022  17:20:38 +0000 (0:00:00.429)       0:00:59.800 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: msodbcsql17-17.10.1.1-1.x86_64",
        "Installed: mssql-tools-17.10.1.1-1.x86_64",
        "Installed: unixODBC-2.3.9-4.fc35.x86_64",
        "Installed: unixODBC-devel-2.3.9-4.fc35.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:265
Wednesday 03 August 2022  17:20:41 +0000 (0:00:02.764)       0:01:02.564 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:270
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.040)       0:01:02.605 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:276
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.075)       0:01:02.680 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Change the password of the sa user] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:283
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.041)       0:01:02.721 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.040)       0:01:02.762 ****** 
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.076)       0:01:02.839 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.049)       0:01:02.888 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.wvicbmlb",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022  17:20:41 +0000 (0:00:00.554)       0:01:03.443 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
    "dest": "/tmp/ansible.wvicbmlb",
    "gid": 0,
    "group": "root",
    "md5sum": "8edbc22195757a4f043b10e9367f131b",
    "mode": "0644",
    "owner": "root",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 391,
    "src": "/root/.ansible/tmp/ansible-tmp-1659547241.9869304-111183-14924172117700/source",
    "state": "file",
    "uid": 0
}

TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022  17:20:42 +0000 (0:00:01.018)       0:01:04.461 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022  17:20:42 +0000 (0:00:00.042)       0:01:04.504 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ActiveEnterTimestampMonotonic": "61676748",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "AssertTimestampMonotonic": "61674996",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "4978862000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ConditionTimestampMonotonic": "61674994",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2769",
        "ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ExecMainStartTimestampMonotonic": "61676336",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "InactiveExitTimestampMonotonic": "61676748",
        "InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2769",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "643018752",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "system.slice -.mount sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "StateChangeTimestampMonotonic": "61676748",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "142",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022  17:20:43 +0000 (0:00:00.594)       0:01:05.098 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "elapsed": 0,
    "gid": 992,
    "group": "mssql",
    "match_groupdict": {},
    "match_groups": [],
    "mode": "0660",
    "owner": "mssql",
    "path": "/var/opt/mssql/log/errorlog",
    "port": null,
    "search_regex": "SQL Server is now ready for client connections",
    "secontext": "system_u:object_r:var_t:s0",
    "size": 7697,
    "state": "file",
    "uid": 992
}

TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022  17:20:44 +0000 (0:00:00.521)       0:01:05.620 ****** 
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml for /cache/fedora-35.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022  17:20:44 +0000 (0:00:00.068)       0:01:05.689 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ActiveEnterTimestampMonotonic": "61676748",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "AssertTimestampMonotonic": "61674996",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "4985254000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ConditionTimestampMonotonic": "61674994",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2769",
        "ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ExecMainStartTimestampMonotonic": "61676336",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "InactiveExitTimestampMonotonic": "61676748",
        "InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2769",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "643018752",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "system.slice -.mount sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "StateChangeTimestampMonotonic": "61676748",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "142",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [fedora.linux_system_roles.mssql : Check if a custom tcpport setting exist] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022  17:20:44 +0000 (0:00:00.571)       0:01:06.260 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003797",
    "end": "2022-08-03 17:20:43.710076",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 17:20:43.706279"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Check if a custom ipaddress setting exist] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022  17:20:45 +0000 (0:00:00.421)       0:01:06.682 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^ipaddress = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003368",
    "end": "2022-08-03 17:20:44.114195",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 17:20:44.110827"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Set a fact with a password query] ******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022  17:20:45 +0000 (0:00:00.400)       0:01:07.083 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": "/opt/mssql-tools/bin/sqlcmd   -U sa -P p@55w0rD"
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022  17:20:45 +0000 (0:00:00.066)       0:01:07.150 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "/opt/mssql-tools/bin/sqlcmd",
        "-U",
        "sa",
        "-P",
        "p@55w0rD",
        "-i",
        "/tmp/ansible.wvicbmlb",
        "-b"
    ],
    "delta": "0:00:00.285789",
    "end": "2022-08-03 17:20:44.903712",
    "rc": 0,
    "start": "2022-08-03 17:20:44.617923"
}

STDOUT:

Changed database context to 'ExampleDB'.

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

TASK [fedora.linux_system_roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.734)       0:01:07.884 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "__mssql_sqlcmd_input_file.stdout_lines": [
        "Changed database context to 'ExampleDB'.",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)",
        "",
        "(1 rows affected)"
    ]
}

TASK [fedora.linux_system_roles.mssql : Remove the tempfile] *******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.070)       0:01:07.954 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.044)       0:01:07.999 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the mssql_pre_input_sql_file fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:297
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.042)       0:01:08.042 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "ansible_facts": {
        "mssql_pre_input_sql_file": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:306
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.050)       0:01:08.092 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:319
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.041)       0:01:08.134 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Change the edition of MSSQL] ***********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:326
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.041)       0:01:08.176 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the IP address setting] ******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:335
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.051)       0:01:08.227 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:342
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.044)       0:01:08.272 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:349
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.048)       0:01:08.321 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:360
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.090)       0:01:08.411 ****** 
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for /cache/fedora-35.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Get the network tcpport setting] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022  17:20:46 +0000 (0:00:00.063)       0:01:08.474 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003325",
    "end": "2022-08-03 17:20:45.936770",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-03 17:20:45.933445"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the network tcpport setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022  17:20:47 +0000 (0:00:00.433)       0:01:08.907 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.095544",
    "end": "2022-08-03 17:20:46.454896",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-03 17:20:46.359352"
}

STDOUT:

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

TASK [fedora.linux_system_roles.mssql : Unset the network tcpport setting] *****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022  17:20:47 +0000 (0:00:00.526)       0:01:09.434 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:366
Wednesday 03 August 2022  17:20:47 +0000 (0:00:00.037)       0:01:09.472 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:384
Wednesday 03 August 2022  17:20:47 +0000 (0:00:00.053)       0:01:09.525 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-fts package] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:391
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.048)       0:01:09.574 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the powershell package] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:398
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.043)       0:01:09.618 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:407
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.041)       0:01:09.659 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the hadrenabled setting] *****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:413
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.038)       0:01:09.698 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the 3979 trace flag is enabled] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:422
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.038)       0:01:09.737 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set the 3979 traceflag] ****************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:428
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.088)       0:01:09.826 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the 3979 traceflag] **************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:434
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.041)       0:01:09.867 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:441
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.043)       0:01:09.911 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the writethrough setting] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:447
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.042)       0:01:09.954 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:458
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.043)       0:01:09.998 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (item=None)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": null,
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=None)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": null,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:474
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.045)       0:01:10.043 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:483
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.040)       0:01:10.083 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:492
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.038)       0:01:10.122 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:499
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.038)       0:01:10.160 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:509
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.038)       0:01:10.199 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set host variables] ********************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:528
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.044)       0:01:10.243 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:539
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.049)       0:01:10.292 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:545
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.061)       0:01:10.353 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:552
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.049)       0:01:10.403 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:559
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.051)       0:01:10.455 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:564
Wednesday 03 August 2022  17:20:48 +0000 (0:00:00.052)       0:01:10.508 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate and private key files] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:570
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.049)       0:01:10.557 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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 [fedora.linux_system_roles.mssql : Create master key encryption] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:579
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.127)       0:01:10.685 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create and back up certificate] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:584
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.051)       0:01:10.737 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Fetch certificate and private key from the primary node to the control node] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:590
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.052)       0:01:10.789 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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 [fedora.linux_system_roles.mssql : Create database mirroring endpoints] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:602
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.053)       0:01:10.843 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create the] ****************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:607
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.046)       0:01:10.889 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get mssql-server version to see if WRITE_LEASE_VALIDITY is available] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:613
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.045)       0:01:10.935 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "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 : Create the  availability group] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:618
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.046)       0:01:10.982 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Grant permissions to the  login] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:623
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.051)       0:01:11.033 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Back up and replicate the  database] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:628
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.060)       0:01:11.094 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set a fact to indicate successful set up on the primary replica] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:635
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.057)       0:01:11.151 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Fail if the primary node failed] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:662
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.058)       0:01:11.209 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:669
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.052)       0:01:11.262 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:675
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.052)       0:01:11.314 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:682
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.047)       0:01:11.362 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:689
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.047)       0:01:11.409 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create master key encryption] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:694
Wednesday 03 August 2022  17:20:49 +0000 (0:00:00.091)       0:01:11.501 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:699
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.048)       0:01:11.549 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (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: [/cache/fedora-35.qcow2.snap] => (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 [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:711
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.058)       0:01:11.608 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Restore certificate] *******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:717
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.052)       0:01:11.661 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create database mirroring endpoints] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:722
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.052)       0:01:11.713 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create the  login] *********************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:727
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.054)       0:01:11.768 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Join synchronous and witness servers to the availability group] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:732
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.050)       0:01:11.818 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Grant permissions to the  login] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:737
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.050)       0:01:11.869 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify if the  database exists on secondaries] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:742
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.049)       0:01:11.919 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate and private key from the control node] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:749
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.054)       0:01:11.973 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => (item=cert)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "cert",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=key)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "key",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Save credentials for the  SQL Server login] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:762
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.055)       0:01:12.028 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:773
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.049)       0:01:12.077 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify if the  database exists] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:778
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.052)       0:01:12.130 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786
Wednesday 03 August 2022  17:20:50 +0000 (0:00:00.051)       0:01:12.182 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true
}

MSG:

Block inserted

TASK [fedora.linux_system_roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:795
Wednesday 03 August 2022  17:20:51 +0000 (0:00:00.676)       0:01:12.858 ****** 
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022  17:20:51 +0000 (0:00:00.077)       0:01:12.936 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022  17:20:51 +0000 (0:00:00.052)       0:01:12.988 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.w8cpvbce",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022  17:20:51 +0000 (0:00:00.414)       0:01:13.402 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
    "dest": "/tmp/ansible.w8cpvbce",
    "gid": 0,
    "group": "root",
    "md5sum": "8edbc22195757a4f043b10e9367f131b",
    "mode": "0644",
    "owner": "root",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 391,
    "src": "/root/.ansible/tmp/ansible-tmp-1659547251.9384842-111509-196464898166544/source",
    "state": "file",
    "uid": 0
}

TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022  17:20:52 +0000 (0:00:00.774)       0:01:14.177 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022  17:20:52 +0000 (0:00:00.048)       0:01:14.226 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ActiveEnterTimestampMonotonic": "61676748",
        "ActiveExitTimestamp": "n/a",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
        "AllowIsolate": "no",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "AssertTimestampMonotonic": "61674996",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "yes",
        "CPUAffinityFromNUMA": "no",
        "CPUQuotaPerSecUSec": "infinity",
        "CPUQuotaPeriodUSec": "infinity",
        "CPUSchedulingPolicy": "0",
        "CPUSchedulingPriority": "0",
        "CPUSchedulingResetOnFork": "no",
        "CPUShares": "[not set]",
        "CPUUsageNSec": "5187712000",
        "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 cap_checkpoint_restore",
        "CleanResult": "success",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ConditionTimestampMonotonic": "61674994",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "CoredumpFilter": "0x33",
        "DefaultDependencies": "yes",
        "DefaultMemoryLow": "0",
        "DefaultMemoryMin": "0",
        "Delegate": "no",
        "Description": "Microsoft SQL Server Database Engine",
        "DevicePolicy": "auto",
        "Documentation": "https://docs.microsoft.com/en-us/sql/linux",
        "DynamicUser": "no",
        "ExecMainCode": "0",
        "ExecMainExitTimestamp": "n/a",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "2769",
        "ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "ExecMainStartTimestampMonotonic": "61676336",
        "ExecMainStatus": "0",
        "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FinalKillSignal": "9",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "992",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOReadBytes": "18446744073709551615",
        "IOReadOperations": "18446744073709551615",
        "IOSchedulingClass": "2",
        "IOSchedulingPriority": "4",
        "IOWeight": "[not set]",
        "IOWriteBytes": "18446744073709551615",
        "IOWriteOperations": "18446744073709551615",
        "IPAccounting": "no",
        "IPEgressBytes": "[no data]",
        "IPEgressPackets": "[no data]",
        "IPIngressBytes": "[no data]",
        "IPIngressPackets": "[no data]",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "n/a",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "InactiveExitTimestampMonotonic": "61676748",
        "InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "infinity",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "8388608",
        "LimitMEMLOCKSoft": "8388608",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "15523",
        "LimitSIGPENDINGSoft": "15523",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "2769",
        "ManagedOOMMemoryPressure": "auto",
        "ManagedOOMMemoryPressureLimit": "0",
        "ManagedOOMPreference": "none",
        "ManagedOOMSwap": "auto",
        "MemoryAccounting": "yes",
        "MemoryAvailable": "infinity",
        "MemoryCurrent": "659394560",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMPolicy": "stop",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "OnSuccessJobMode": "fail",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateIPC": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProcSubset": "all",
        "ProtectClock": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectHostname": "no",
        "ProtectKernelLogs": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectProc": "default",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "ReloadResult": "success",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "system.slice -.mount sysinit.target",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "RestartKillSignal": "15",
        "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",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2022-08-03 17:20:29 UTC",
        "StateChangeTimestampMonotonic": "61676748",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "2147483646",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "141",
        "TasksMax": "infinity",
        "TimeoutAbortUSec": "30min",
        "TimeoutCleanUSec": "infinity",
        "TimeoutStartFailureMode": "terminate",
        "TimeoutStartUSec": "30min",
        "TimeoutStopFailureMode": "terminate",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "992",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogSignal": "6",
        "WatchdogTimestamp": "n/a",
        "WatchdogTimestampMonotonic": "0",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022  17:20:53 +0000 (0:00:00.553)       0:01:14.779 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "elapsed": 0,
    "gid": 992,
    "group": "mssql",
    "match_groupdict": {},
    "match_groups": [],
    "mode": "0660",
    "owner": "mssql",
    "path": "/var/opt/mssql/log/errorlog",
    "port": null,
    "search_regex": "SQL Server is now ready for client connections",
    "secontext": "system_u:object_r:var_t:s0",
    "size": 8091,
    "state": "file",
    "uid": 992
}

TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022  17:20:53 +0000 (0:00:00.442)       0:01:15.221 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022  17:20:53 +0000 (0:00:00.041)       0:01:15.263 ****** 
fatal: [/cache/fedora-35.qcow2.snap]: FAILED! => {
    "changed": false,
    "cmd": [
        "/opt/mssql-tools/bin/sqlcmd",
        "-U",
        "sa",
        "-P",
        "p@55w0rD",
        "-i",
        "/tmp/ansible.w8cpvbce",
        "-b"
    ],
    "delta": "0:00:00.023602",
    "end": "2022-08-03 17:20:52.720741",
    "rc": 1,
    "start": "2022-08-03 17:20:52.697139"
}

STDOUT:

Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1
The server principal 'MyLogin' already exists.
Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2
User, group, or role 'MyUser' already exists in the current database.
Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3
Database 'ExampleDB' already exists. Choose a different database name.


MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022  17:20:54 +0000 (0:00:00.432)       0:01:15.696 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "__mssql_sqlcmd_input_file.stdout_lines": [
        "Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1",
        "The server principal 'MyLogin' already exists.",
        "Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2",
        "User, group, or role 'MyUser' already exists in the current database.",
        "Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3",
        "Database 'ExampleDB' already exists. Choose a different database name."
    ]
}

TASK [fedora.linux_system_roles.mssql : Remove the tempfile] *******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022  17:20:54 +0000 (0:00:00.068)       0:01:15.765 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022  17:20:54 +0000 (0:00:00.042)       0:01:15.807 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=48   changed=10   unreachable=0    failed=1    skipped=81   rescued=0    ignored=0   

Wednesday 03 August 2022  17:20:54 +0000 (0:00:00.018)       0:01:15.826 ****** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 36.93s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 
fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 4.89s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184 
fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.38s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193 
fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 2.76s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253 
fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 2.66s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 
fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.08s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 
fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214 
fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled --- 1.39s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198 
Gathering Facts --------------------------------------------------------- 1.36s
/tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:3 ------------------
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.10s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 1.02s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.79s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 0.77s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24 
fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.73s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60 
fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.68s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786 
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.59s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41 
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.59s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 
fedora.linux_system_roles.mssql : Get the active Tuned profiles --------- 0.58s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:204 
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119