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

PLAY [Ensure that the role installs version 2017 and upgrades to 2019] *********

TASK [Gathering Facts] *********************************************************
Wednesday 31 August 2022  11:36:55 +0000 (0:00:00.020)       0:00:00.020 ****** 
ok: [sut]

TASK [Run the role with incorrect mssql_version] *******************************
Wednesday 31 August 2022  11:36:57 +0000 (0:00:01.089)       0:00:01.109 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:36:57 +0000 (0:00:00.041)       0:00:01.282 ****** 
ok: [sut]

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

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:36:57 +0000 (0:00:00.086)       0:00:01.844 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:36:57 +0000 (0:00:00.041)       0:00:01.885 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:36:57 +0000 (0:00:00.042)       0:00:01.928 ****** 
skipping: [sut] => {}

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

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:36:57 +0000 (0:00:00.035)       0:00:02.000 ****** 
skipping: [sut] => {}

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

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.034)       0:00:02.070 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.068)       0:00:02.138 ****** 
fatal: [sut]: FAILED! => {
    "assertion": "mssql_version | int == 2017 or mssql_version | int == 2019",
    "changed": false,
    "evaluated_to": false
}

MSG:

The mssql_version variable must be set to either 2017 or 2019.

TASK [Assert that the role failed with the correct message] ********************
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.064)       0:00:02.203 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Run the role with mssql_version 2017 and mssql_upgrade true] *************
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.047)       0:00:02.251 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.038)       0:00:02.407 ****** 
ok: [sut]

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

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.086)       0:00:02.939 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.040)       0:00:02.980 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:36:58 +0000 (0:00:00.041)       0:00:03.021 ****** 
skipping: [sut] => {}

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

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.036)       0:00:03.094 ****** 
skipping: [sut] => {}

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

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.036)       0:00:03.168 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.068)       0:00:03.236 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.069)       0:00:03.305 ****** 
fatal: [sut]: FAILED! => {
    "changed": false
}

MSG:

['You set mssql_upgrade to true and mssql_version to 2017.', 'If you want to upgrade, set the variables as such:', 'mssql_version: 2019', 'mssql_upgrade: true']

TASK [Assert that the role failed with the correct message] ********************
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.066)       0:00:03.372 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Set up MSSQL 2017] *******************************************************
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.045)       0:00:03.418 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:36:59 +0000 (0:00:00.039)       0:00:03.572 ****** 
ok: [sut]

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

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

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

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:37:00 +0000 (0:00:00.040)       0:00:04.201 ****** 
skipping: [sut] => {}

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

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:37:00 +0000 (0:00:00.035)       0:00:04.272 ****** 
skipping: [sut] => {}

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

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

MSG:

All assertions passed

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

MSG:

All assertions passed

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
Wednesday 31 August 2022  11:37:02 +0000 (0:00:00.086)       0:00:06.667 ****** 
changed: [sut] => {
    "changed": true
}

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

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

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2017 repository] ***
Wednesday 31 August 2022  11:37:03 +0000 (0:00:00.073)       0:00:07.847 ****** 
changed: [sut] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
Wednesday 31 August 2022  11:37:04 +0000 (0:00:00.480)       0:00:08.328 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-15.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: mssql-server-14.0.3451.2-1.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: python2-setuptools-39.0.1-13.module+el8.4.0+9442+27d0e81c.noarch",
        "Installed: python2-setuptools-wheel-39.0.1-13.module+el8.4.0+9442+27d0e81c.noarch",
        "Installed: bzip2-1.0.6-26.el8.x86_64",
        "Installed: python2-libs-2.7.18-11.module+el8.7.0+15681+7a92afba.x86_64",
        "Installed: python2-pip-9.0.3-19.module+el8.6.0+13001+ad200bd9.noarch",
        "Installed: python2-pip-wheel-9.0.3-19.module+el8.6.0+13001+ad200bd9.noarch",
        "Installed: python2-2.7.18-11.module+el8.7.0+15681+7a92afba.x86_64",
        "Installed: gdb-8.2-19.el8.x86_64"
    ]
}

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

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
Wednesday 31 August 2022  11:37:55 +0000 (0:00:00.048)       0:00:59.641 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.007893",
    "end": "2022-08-31 11:37:56.021945",
    "rc": 0,
    "start": "2022-08-31 11:37:56.014052"
}

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

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

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
Wednesday 31 August 2022  11:37:58 +0000 (0:00:00.175)       0:01:02.416 ****** 
changed: [sut] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "-n",
        "setup"
    ],
    "delta": "0:00:07.118619",
    "end": "2022-08-31 11:38:05.754190",
    "rc": 0,
    "start": "2022-08-31 11:37:58.635571"
}

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=855862&clcid=0x409

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

Input encoding cannot be detected. SQL Server will attempt to decode input as UTF-8
Configuring SQL Server...
Setup has completed successfully. SQL Server is now starting.


STDERR:

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

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

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

TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
Wednesday 31 August 2022  11:38:10 +0000 (0:00:01.090)       0:01:14.865 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.267778",
    "end": "2022-08-31 11:38:11.482906",
    "rc": 0,
    "start": "2022-08-31 11:38:11.215128"
}

STDOUT:

Current active profile: virtual-guest

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

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

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

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Pre-input SQL scripts to SQL Server] **********
Wednesday 31 August 2022  11:38:19 +0000 (0:00:00.059)       0:01:23.255 ****** 

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

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

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

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

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

TASK [Open the 1433 TCP port] **************************************************
Wednesday 31 August 2022  11:38:19 +0000 (0:00:00.071)       0:01:23.617 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
Wednesday 31 August 2022  11:38:19 +0000 (0:00:00.085)       0:01:23.775 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.004401",
    "end": "2022-08-31 11:38:19.987493",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-31 11:38:19.983092"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
Wednesday 31 August 2022  11:38:20 +0000 (0:00:00.298)       0:01:24.073 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.059881",
    "end": "2022-08-31 11:38:20.349163",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-31 11:38:20.289282"
}

STDOUT:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Create the] ***********************************
Wednesday 31 August 2022  11:38:22 +0000 (0:00:00.069)       0:01:26.452 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

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

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

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

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

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Restore certificate] **************************
Wednesday 31 August 2022  11:38:23 +0000 (0:00:00.071)       0:01:27.415 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

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

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

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

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

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

TASK [Run ha_cluster to configure pacemaker] ***********************************
Wednesday 31 August 2022  11:38:23 +0000 (0:00:00.072)       0:01:27.934 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
Wednesday 31 August 2022  11:38:24 +0000 (0:00:00.070)       0:01:28.076 ****** 
changed: [sut] => {
    "changed": true
}

MSG:

Block inserted

TASK [linux-system-roles.mssql : Flush handlers prior to inputting post SQL scripts] ***
Wednesday 31 August 2022  11:38:24 +0000 (0:00:00.536)       0:01:28.613 ****** 

TASK [linux-system-roles.mssql : Post-input SQL scripts to SQL Server] *********
Wednesday 31 August 2022  11:38:24 +0000 (0:00:00.030)       0:01:28.644 ****** 

TASK [Upgrade to 2019] *********************************************************
Wednesday 31 August 2022  11:38:24 +0000 (0:00:00.079)       0:01:28.724 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:38:24 +0000 (0:00:00.081)       0:01:29.027 ****** 
ok: [sut]

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

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:38:25 +0000 (0:00:00.110)       0:01:29.621 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:38:25 +0000 (0:00:00.067)       0:01:29.688 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:38:25 +0000 (0:00:00.168)       0:01:29.856 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
Wednesday 31 August 2022  11:38:25 +0000 (0:00:00.059)       0:01:29.916 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:38:25 +0000 (0:00:00.062)       0:01:29.978 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
Wednesday 31 August 2022  11:38:26 +0000 (0:00:00.058)       0:01:30.037 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  11:38:26 +0000 (0:00:00.057)       0:01:30.094 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  11:38:26 +0000 (0:00:00.091)       0:01:30.185 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
Wednesday 31 August 2022  11:38:28 +0000 (0:00:00.073)       0:01:32.265 ****** 
ok: [sut] => {
    "changed": false
}

TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
Wednesday 31 August 2022  11:38:28 +0000 (0:00:00.593)       0:01:32.858 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
Wednesday 31 August 2022  11:38:29 +0000 (0:00:01.105)       0:01:33.964 ****** 
changed: [sut] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "absent"
}

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

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
Wednesday 31 August 2022  11:38:30 +0000 (0:00:00.316)       0:01:34.580 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4249.2-1.x86_64",
        "Removed: mssql-server-14.0.3451.2-1.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
Wednesday 31 August 2022  11:39:16 +0000 (0:00:45.704)       0:02:20.285 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
Wednesday 31 August 2022  11:39:16 +0000 (0:00:00.054)       0:02:20.340 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.013666",
    "end": "2022-08-31 11:39:16.725725",
    "rc": 0,
    "start": "2022-08-31 11:39:16.712059"
}

STDOUT:

/var/opt/mssql/log/errorlog

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

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
Wednesday 31 August 2022  11:39:20 +0000 (0:00:04.177)       0:02:24.996 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
Wednesday 31 August 2022  11:39:21 +0000 (0:00:00.125)       0:02:25.122 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
Wednesday 31 August 2022  11:39:21 +0000 (0:00:00.087)       0:02:25.209 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

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

TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
Wednesday 31 August 2022  11:39:25 +0000 (0:00:00.747)       0:02:29.253 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.264292",
    "end": "2022-08-31 11:39:25.830047",
    "rc": 0,
    "start": "2022-08-31 11:39:25.565755"
}

STDOUT:

Current active profile: virtual-guest mssql

TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
Wednesday 31 August 2022  11:39:25 +0000 (0:00:00.676)       0:02:29.929 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
Wednesday 31 August 2022  11:39:25 +0000 (0:00:00.086)       0:02:30.016 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
Wednesday 31 August 2022  11:39:26 +0000 (0:00:00.053)       0:02:30.070 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
Wednesday 31 August 2022  11:39:26 +0000 (0:00:00.052)       0:02:30.122 ****** 
ok: [sut] => {
    "changed": false,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] ***
Wednesday 31 August 2022  11:39:26 +0000 (0:00:00.336)       0:02:30.459 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
Wednesday 31 August 2022  11:39:29 +0000 (0:00:02.803)       0:02:33.263 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the set password matches the existing password] ***
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.061)       0:02:33.324 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.059)       0:02:33.384 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.100)       0:02:33.484 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Pre-input SQL scripts to SQL Server] **********
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.063)       0:02:33.548 ****** 

TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] ***
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.050)       0:02:33.599 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.062)       0:02:33.662 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.062)       0:02:33.724 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the IP address setting] *************
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.063)       0:02:33.788 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.059)       0:02:33.847 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 1433 TCP port] **************************************************
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.072)       0:02:33.920 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
Wednesday 31 August 2022  11:39:29 +0000 (0:00:00.073)       0:02:33.994 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for sut

TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
Wednesday 31 August 2022  11:39:30 +0000 (0:00:00.087)       0:02:34.082 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.005514",
    "end": "2022-08-31 11:39:30.336972",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-31 11:39:30.331458"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
Wednesday 31 August 2022  11:39:30 +0000 (0:00:00.344)       0:02:34.427 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.271677",
    "end": "2022-08-31 11:39:30.971141",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-31 11:39:30.699464"
}

STDOUT:

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

TASK [linux-system-roles.mssql : Unset the network tcpport setting] ************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.692)       0:02:35.119 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Close the previously set SQL Server TCP port if it changed] **************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.053)       0:02:35.173 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.073)       0:02:35.246 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.060)       0:02:35.367 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.059)       0:02:35.426 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.063)       0:02:35.490 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.059)       0:02:35.608 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.064)       0:02:35.732 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.061)       0:02:35.794 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the tlscert setting] ****************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.064)       0:02:35.919 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
Wednesday 31 August 2022  11:39:31 +0000 (0:00:00.062)       0:02:35.982 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.107)       0:02:36.090 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.060)       0:02:36.150 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.059)       0:02:36.210 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set host variables] ***************************
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.076)       0:02:36.287 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.072)       0:02:36.360 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.072)       0:02:36.432 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.071)       0:02:36.504 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.076)       0:02:36.580 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.073)       0:02:36.653 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.079)       0:02:36.805 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create and back up certificate] ***************
Wednesday 31 August 2022  11:39:32 +0000 (0:00:00.074)       0:02:36.879 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.083)       0:02:37.034 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the] ***********************************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.073)       0:02:37.107 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the  availability group] ************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.076)       0:02:37.304 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.074)       0:02:37.379 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Back up and replicate databases] **************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.071)       0:02:37.450 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.074)       0:02:37.525 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.071)       0:02:37.596 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.072)       0:02:37.669 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.072)       0:02:37.741 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.073)       0:02:37.814 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  11:39:33 +0000 (0:00:00.084)       0:02:37.972 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restore certificate] **************************
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.072)       0:02:38.045 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.072)       0:02:38.118 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the  login] ****************************
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.073)       0:02:38.191 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Join synchronous and witness servers to the availability group] ***
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.072)       0:02:38.264 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.142)       0:02:38.406 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Save credentials for the  SQL Server login] ***
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.081)       0:02:38.569 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.074)       0:02:38.643 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure a listener for the  availability group] ***
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.073)       0:02:38.716 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
Wednesday 31 August 2022  11:39:34 +0000 (0:00:00.075)       0:02:38.792 ****** 
ok: [sut] => {
    "changed": false
}

TASK [linux-system-roles.mssql : Flush handlers prior to inputting post SQL scripts] ***
Wednesday 31 August 2022  11:39:35 +0000 (0:00:00.464)       0:02:39.256 ****** 

TASK [linux-system-roles.mssql : Post-input SQL scripts to SQL Server] *********
Wednesday 31 August 2022  11:39:35 +0000 (0:00:00.031)       0:02:39.287 ****** 

TASK [Upgrade again to test idempotency - should report not changed] ***********
Wednesday 31 August 2022  11:39:35 +0000 (0:00:00.082)       0:02:39.370 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:39:35 +0000 (0:00:00.084)       0:02:39.729 ****** 
ok: [sut]

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

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.111)       0:02:40.512 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.067)       0:02:40.579 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.066)       0:02:40.646 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.059)       0:02:40.706 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.059)       0:02:40.766 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.059)       0:02:40.825 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.059)       0:02:40.885 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  11:39:36 +0000 (0:00:00.091)       0:02:40.976 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
Wednesday 31 August 2022  11:39:39 +0000 (0:00:00.074)       0:02:43.846 ****** 
ok: [sut] => {
    "changed": false
}

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

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
Wednesday 31 August 2022  11:39:40 +0000 (0:00:00.101)       0:02:44.772 ****** 
ok: [sut] => {
    "changed": false,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "absent"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
Wednesday 31 August 2022  11:39:41 +0000 (0:00:00.392)       0:02:45.165 ****** 
ok: [sut] => {
    "changed": false,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
Wednesday 31 August 2022  11:39:41 +0000 (0:00:00.379)       0:02:45.544 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
Wednesday 31 August 2022  11:39:44 +0000 (0:00:02.676)       0:02:48.221 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
Wednesday 31 August 2022  11:39:44 +0000 (0:00:00.092)       0:02:48.313 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.009531",
    "end": "2022-08-31 11:39:44.596275",
    "rc": 0,
    "start": "2022-08-31 11:39:44.586744"
}

STDOUT:

/var/opt/mssql/log/errorlog

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

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
Wednesday 31 August 2022  11:39:47 +0000 (0:00:02.901)       0:02:51.594 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
Wednesday 31 August 2022  11:39:47 +0000 (0:00:00.085)       0:02:51.679 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
Wednesday 31 August 2022  11:39:47 +0000 (0:00:00.084)       0:02:51.764 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

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

TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
Wednesday 31 August 2022  11:39:51 +0000 (0:00:00.674)       0:02:55.210 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "tuned-adm",
        "active"
    ],
    "delta": "0:00:00.206181",
    "end": "2022-08-31 11:39:51.680656",
    "rc": 0,
    "start": "2022-08-31 11:39:51.474475"
}

STDOUT:

Current active profile: virtual-guest mssql

TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
Wednesday 31 August 2022  11:39:51 +0000 (0:00:00.565)       0:02:55.776 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
Wednesday 31 August 2022  11:39:51 +0000 (0:00:00.055)       0:02:55.832 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
Wednesday 31 August 2022  11:39:51 +0000 (0:00:00.056)       0:02:55.888 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
Wednesday 31 August 2022  11:39:51 +0000 (0:00:00.055)       0:02:55.944 ****** 
ok: [sut] => {
    "changed": false,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] ***
Wednesday 31 August 2022  11:39:52 +0000 (0:00:00.383)       0:02:56.327 ****** 
ok: [sut] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
Wednesday 31 August 2022  11:39:55 +0000 (0:00:02.911)       0:02:59.238 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the set password matches the existing password] ***
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.061)       0:02:59.300 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.061)       0:02:59.362 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.062)       0:02:59.425 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Pre-input SQL scripts to SQL Server] **********
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.064)       0:02:59.490 ****** 

TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] ***
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.049)       0:02:59.540 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.063)       0:02:59.603 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.062)       0:02:59.666 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the IP address setting] *************
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.060)       0:02:59.726 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.060)       0:02:59.787 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 1433 TCP port] **************************************************
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.075)       0:02:59.863 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
Wednesday 31 August 2022  11:39:55 +0000 (0:00:00.073)       0:02:59.937 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for sut

TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
Wednesday 31 August 2022  11:39:56 +0000 (0:00:00.132)       0:03:00.070 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.005292",
    "end": "2022-08-31 11:39:56.375677",
    "failed_when_result": false,
    "rc": 1,
    "start": "2022-08-31 11:39:56.370385"
}

MSG:

non-zero return code

TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
Wednesday 31 August 2022  11:39:56 +0000 (0:00:00.400)       0:03:00.470 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.174080",
    "end": "2022-08-31 11:39:56.946187",
    "failed_when_result": false,
    "rc": 0,
    "start": "2022-08-31 11:39:56.772107"
}

STDOUT:

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

TASK [linux-system-roles.mssql : Unset the network tcpport setting] ************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.579)       0:03:01.050 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.073)       0:03:01.179 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-fts package] **********
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.062)       0:03:01.241 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.060)       0:03:01.302 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.060)       0:03:01.425 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the 3979 trace flag is enabled] ******
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.059)       0:03:01.485 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.058)       0:03:01.544 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the 3979 traceflag] *********************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.058)       0:03:01.602 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.102)       0:03:01.705 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.062)       0:03:01.768 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the tlscert setting] ****************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.066)       0:03:01.895 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.061)       0:03:01.957 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
Wednesday 31 August 2022  11:39:57 +0000 (0:00:00.061)       0:03:02.019 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.060)       0:03:02.079 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.063)       0:03:02.143 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Set host variables] ***************************
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.073)       0:03:02.216 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.075)       0:03:02.292 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.071)       0:03:02.364 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.072)       0:03:02.436 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.071)       0:03:02.508 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.072)       0:03:02.581 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.129)       0:03:02.782 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create and back up certificate] ***************
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.073)       0:03:02.855 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  11:39:58 +0000 (0:00:00.087)       0:03:03.015 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the] ***********************************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.075)       0:03:03.090 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Configure the  availability group] ************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.075)       0:03:03.242 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.073)       0:03:03.315 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Back up and replicate databases] **************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.073)       0:03:03.389 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.075)       0:03:03.465 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.074)       0:03:03.539 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.072)       0:03:03.611 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.073)       0:03:03.685 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create master key encryption] *****************
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.074)       0:03:03.760 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
Wednesday 31 August 2022  11:39:59 +0000 (0:00:00.156)       0:03:03.990 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Restore certificate] **************************
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.072)       0:03:04.063 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure database mirroring endpoints] *******
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.074)       0:03:04.137 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Create the  login] ****************************
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.073)       0:03:04.211 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Grant permissions to the  login] **************
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.073)       0:03:04.355 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

TASK [linux-system-roles.mssql : Save credentials for the  SQL Server login] ***
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.080)       0:03:04.516 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.070)       0:03:04.587 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure a listener for the  availability group] ***
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.075)       0:03:04.662 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
Wednesday 31 August 2022  11:40:00 +0000 (0:00:00.075)       0:03:04.738 ****** 
ok: [sut] => {
    "changed": false
}

TASK [linux-system-roles.mssql : Flush handlers prior to inputting post SQL scripts] ***
Wednesday 31 August 2022  11:40:01 +0000 (0:00:00.372)       0:03:05.111 ****** 

TASK [linux-system-roles.mssql : Post-input SQL scripts to SQL Server] *********
Wednesday 31 August 2022  11:40:01 +0000 (0:00:00.032)       0:03:05.143 ****** 

TASK [Run the role with mssql_version 2017 on SQL Server 2019] *****************
Wednesday 31 August 2022  11:40:01 +0000 (0:00:00.131)       0:03:05.275 ****** 

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

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  11:40:01 +0000 (0:00:00.085)       0:03:05.527 ****** 
ok: [sut]

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

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.114)       0:03:06.149 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.067)       0:03:06.216 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.065)       0:03:06.282 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.059)       0:03:06.341 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.059)       0:03:06.400 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.107)       0:03:06.508 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.060)       0:03:06.569 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  11:40:02 +0000 (0:00:00.099)       0:03:06.668 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

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

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

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

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

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

TASK [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
Wednesday 31 August 2022  11:40:04 +0000 (0:00:01.618)       0:03:08.685 ****** 
fatal: [sut]: FAILED! => {
    "changed": false
}

MSG:

['You set mssql_version to 2017, but your SQL Server is version 2019.', 'The role does not support downgrading SQL Server.']

TASK [Assert that the role failed with the correct message] ********************
Wednesday 31 August 2022  11:40:04 +0000 (0:00:00.183)       0:03:08.869 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Check the ansible_managed header in the configuration file] **************
Wednesday 31 August 2022  11:40:04 +0000 (0:00:00.073)       0:03:08.942 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/tasks/check_header.yml for sut

TASK [Grep the ansible_managed header in /var/opt/mssql/mssql.conf] ************
Wednesday 31 August 2022  11:40:04 +0000 (0:00:00.082)       0:03:09.025 ****** 
ok: [sut] => {
    "changed": false,
    "cmd": [
        "grep",
        "Ansible managed\n",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.004004",
    "end": "2022-08-31 11:40:05.308269",
    "rc": 0,
    "start": "2022-08-31 11:40:05.304265"
}

STDOUT:

# BEGIN ANSIBLE MANAGED BLOCK
#
# Ansible managed
#
# END ANSIBLE MANAGED BLOCK
[sqlagent]
enabled = false

[EULA]
accepteula = Y

PLAY RECAP *********************************************************************
sut                        : ok=99   changed=12   unreachable=0    failed=0    skipped=247  rescued=3    ignored=0   

Wednesday 31 August 2022  11:40:05 +0000 (0:00:00.406)       0:03:09.432 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 51.26s
linux-system-roles.mssql : Ensure the mssql-server package ------------- 48.38s
linux-system-roles.mssql : Set up MSSQL --------------------------------- 7.43s
linux-system-roles.mssql : Gather system services facts ----------------- 7.08s
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 6.07s
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 5.71s
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 5.14s
linux-system-roles.mssql : Gather package facts ------------------------- 3.99s
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.93s
linux-system-roles.mssql : Gather system services facts ----------------- 2.14s
linux-system-roles.mssql : Gather package facts ------------------------- 1.90s
linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.83s
linux-system-roles.mssql : Gather package facts ------------------------- 1.62s
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.42s
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.42s
linux-system-roles.mssql : Get the active Tuned profiles ---------------- 1.24s
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 1.21s
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.09s
Gathering Facts --------------------------------------------------------- 1.09s
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.03s

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

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

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