ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmp5m6ig2cl
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

PLAYBOOK: rhel-8_setup.yml *****************************************************
1 plays in /cache/rhel-8_setup.yml

PLAY [Setup repos] *************************************************************
META: ran handlers

TASK [set up internal repositories] ********************************************
task path: /cache/rhel-8_setup.yml:5
Wednesday 03 August 2022  15:19:45 +0000 (0:00:00.019)       0:00:00.019 ****** 
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/rhel-8.qcow2        : ok=1    changed=1    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   

Wednesday 03 August 2022  15:19:47 +0000 (0:00:01.333)       0:00:01.352 ****** 
=============================================================================== 
set up internal repositories -------------------------------------------- 1.33s
/cache/rhel-8_setup.yml:5 -----------------------------------------------------

PLAYBOOK: tests_accept_eula_2019.yml *******************************************
1 plays in /tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml

PLAY [Ensure that the role runs when EULA are accepted] ************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  15:19:47 +0000 (0:00:00.032)       0:00:01.385 ****** 
ok: [/cache/rhel-8.qcow2]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  15:19:48 +0000 (0:00:01.133)       0:00:02.519 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022  15:19:48 +0000 (0:00:00.089)       0:00:02.608 ****** 
included: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/rhel-8.qcow2

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  15:19:48 +0000 (0:00:00.029)       0:00:02.638 ****** 
ok: [/cache/rhel-8.qcow2]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022  15:19:49 +0000 (0:00:01.242)       0:00:03.880 ****** 
ok: [/cache/rhel-8.qcow2] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
ok: [/cache/rhel-8.qcow2] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/rhel-8.qcow2] => (item=RedHat_8.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/rhel-8.qcow2] => (item=RedHat_8.6.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.6.yml",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:8
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.082)       0:00:03.963 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:12
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.026)       0:00:03.989 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:16
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.029)       0:00:04.019 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:22
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.023)       0:00:04.043 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:27
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.025)       0:00:04.068 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:39
Wednesday 03 August 2022  15:19:49 +0000 (0:00:00.044)       0:00:04.112 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:44
Wednesday 03 August 2022  15:19:50 +0000 (0:00:00.044)       0:00:04.156 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:55
Wednesday 03 August 2022  15:19:50 +0000 (0:00:00.034)       0:00:04.190 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:63
Wednesday 03 August 2022  15:19:50 +0000 (0:00:00.030)       0:00:04.221 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:72
Wednesday 03 August 2022  15:19:50 +0000 (0:00:00.030)       0:00:04.252 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Gather package facts] *************************
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:85
Wednesday 03 August 2022  15:19:50 +0000 (0:00:00.030)       0:00:04.282 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:90
Wednesday 03 August 2022  15:19:52 +0000 (0:00:01.881)       0:00:06.163 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:101
Wednesday 03 August 2022  15:19:52 +0000 (0:00:00.052)       0:00:06.216 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true
}

TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:107
Wednesday 03 August 2022  15:19:52 +0000 (0:00:00.869)       0:00:07.085 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:118
Wednesday 03 August 2022  15:19:53 +0000 (0:00:00.076)       0:00:07.162 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:124
Wednesday 03 August 2022  15:19:53 +0000 (0:00:00.047)       0:00:07.210 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022  15:19:53 +0000 (0:00:00.408)       0:00:07.618 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64",
        "Installed: gdb-8.2-18.el8.x86_64",
        "Installed: python36-3.6.8-38.module+el8.5.0+12207+5c5719bc.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: gdb-headless-8.2-18.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: kernel-headers-4.18.0-372.9.1.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: python3-setuptools-39.2.0-6.el8.noarch",
        "Installed: isl-0.16.1-6.el8.x86_64",
        "Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: python3-pip-9.0.3-22.el8.noarch",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: gcc-8.5.0-10.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-10.el8.x86_64",
        "Installed: glibc-devel-2.28-189.1.el8.x86_64",
        "Installed: libmpc-1.1.0-9.1.el8.x86_64",
        "Installed: glibc-headers-2.28-189.1.el8.x86_64",
        "Installed: libatomic-8.5.0-10.el8.x86_64",
        "Installed: cpp-8.5.0-10.el8.x86_64",
        "Installed: binutils-2.30-113.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-3.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022  15:20:45 +0000 (0:00:51.573)       0:00:59.192 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022  15:20:45 +0000 (0:00:00.074)       0:00:59.266 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "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.005001",
    "end": "2022-08-03 11:20:45.453401",
    "rc": 0,
    "start": "2022-08-03 11:20:45.448400"
}

TASK [linux-system-roles.mssql : Gather system services facts] *****************
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:165
Wednesday 03 August 2022  15:20:45 +0000 (0:00:00.492)       0:00:59.759 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022  15:20:47 +0000 (0:00:01.772)       0:01:01.531 ****** 
fatal: [/cache/rhel-8.qcow2]: FAILED! => {
    "assertion": "mssql_password is not none",
    "changed": false,
    "evaluated_to": false
}

MSG:

['You must define the following variables to set up MSSQL:', 'mssql_password', 'mssql_edition']

TASK [Assert that the role failed with variables undefined] ********************
task path: /tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  15:20:47 +0000 (0:00:00.071)       0:01:01.602 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/rhel-8.qcow2        : ok=16   changed=4    unreachable=0    failed=0    skipped=10   rescued=1    ignored=0   

Wednesday 03 August 2022  15:20:47 +0000 (0:00:00.068)       0:01:01.670 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 51.57s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.88s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Gather system services facts ----------------- 1.77s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
set up internal repositories -------------------------------------------- 1.33s
/cache/rhel-8_setup.yml:5 -----------------------------------------------------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 1.24s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
Gathering Facts --------------------------------------------------------- 1.13s
/tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:3 ---------------------------
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.87s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.49s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.41s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
Run the role with default parameters ------------------------------------ 0.09s
/tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:12 --------------------------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.08s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.08s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------
linux-system-roles.mssql : Ensure that the openldap-compat package is installed --- 0.07s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 ------
linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------
Assert that the role failed with variables undefined -------------------- 0.07s
/tmp/tmpwrabcf_7/tests/tests_accept_eula_2019.yml:21 --------------------------
linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 -------
linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------
linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 -------
linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 -------
linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s
/tmp/tmpwrabcf_7/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 -------
ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmp5m6ig2cl
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

PLAYBOOK: rhel-8_setup.yml *****************************************************
1 plays in /cache/rhel-8_setup.yml

PLAY [Setup repos] *************************************************************
META: ran handlers

TASK [set up internal repositories] ********************************************
task path: /cache/rhel-8_setup.yml:5
Wednesday 03 August 2022  15:51:40 +0000 (0:00:00.018)       0:00:00.018 ****** 
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => (item=None) => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
changed: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/rhel-8.qcow2        : ok=1    changed=1    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   

Wednesday 03 August 2022  15:51:41 +0000 (0:00:01.333)       0:00:01.351 ****** 
=============================================================================== 
set up internal repositories -------------------------------------------- 1.33s
/cache/rhel-8_setup.yml:5 -----------------------------------------------------

PLAYBOOK: tests_accept_eula_2019.yml *******************************************
1 plays in /tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml

PLAY [Ensure that the role runs when EULA are accepted] ************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  15:51:41 +0000 (0:00:00.028)       0:00:01.380 ****** 
ok: [/cache/rhel-8.qcow2]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  15:51:42 +0000 (0:00:01.427)       0:00:02.807 ****** 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 03 August 2022  15:51:42 +0000 (0:00:00.115)       0:00:02.923 ****** 
included: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/rhel-8.qcow2

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  15:51:42 +0000 (0:00:00.030)       0:00:02.954 ****** 
ok: [/cache/rhel-8.qcow2]

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10
Wednesday 03 August 2022  15:51:44 +0000 (0:00:01.486)       0:00:04.440 ****** 
ok: [/cache/rhel-8.qcow2] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
ok: [/cache/rhel-8.qcow2] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/rhel-8.qcow2] => (item=RedHat_8.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/rhel-8.qcow2] => (item=RedHat_8.6.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.6.yml",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.118)       0:00:04.559 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.052)       0:00:04.611 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.048)       0:00:04.659 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.027)       0:00:04.686 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.030)       0:00:04.717 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.050)       0:00:04.767 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.043)       0:00:04.810 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.030)       0:00:04.841 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.029)       0:00:04.870 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.029)       0:00:04.900 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
Wednesday 03 August 2022  15:51:44 +0000 (0:00:00.033)       0:00:04.934 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85
Wednesday 03 August 2022  15:51:46 +0000 (0:00:01.545)       0:00:06.480 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 03 August 2022  15:51:46 +0000 (0:00:00.046)       0:00:06.526 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102
Wednesday 03 August 2022  15:51:47 +0000 (0:00:00.856)       0:00:07.383 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113
Wednesday 03 August 2022  15:51:47 +0000 (0:00:00.043)       0:00:07.427 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119
Wednesday 03 August 2022  15:51:47 +0000 (0:00:00.048)       0:00:07.475 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] *******
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
Wednesday 03 August 2022  15:51:47 +0000 (0:00:00.409)       0:00:07.885 ****** 
changed: [/cache/rhel-8.qcow2] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64",
        "Installed: gdb-8.2-18.el8.x86_64",
        "Installed: python36-3.6.8-38.module+el8.5.0+12207+5c5719bc.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: gdb-headless-8.2-18.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: kernel-headers-4.18.0-372.9.1.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: python3-setuptools-39.2.0-6.el8.noarch",
        "Installed: isl-0.16.1-6.el8.x86_64",
        "Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: python3-pip-9.0.3-22.el8.noarch",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: gcc-8.5.0-10.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-10.el8.x86_64",
        "Installed: glibc-devel-2.28-189.1.el8.x86_64",
        "Installed: libmpc-1.1.0-9.1.el8.x86_64",
        "Installed: glibc-headers-2.28-189.1.el8.x86_64",
        "Installed: libatomic-8.5.0-10.el8.x86_64",
        "Installed: cpp-8.5.0-10.el8.x86_64",
        "Installed: binutils-2.30-113.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-3.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022  15:52:39 +0000 (0:00:51.715)       0:00:59.601 ****** 
skipping: [/cache/rhel-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022  15:52:39 +0000 (0:00:00.032)       0:00:59.634 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "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.005633",
    "end": "2022-08-03 11:52:38.996983",
    "rc": 0,
    "start": "2022-08-03 11:52:38.991350"
}

TASK [fedora.linux_system_roles.mssql : Gather system services facts] **********
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
Wednesday 03 August 2022  15:52:40 +0000 (0:00:00.524)       0:01:00.158 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022  15:52:41 +0000 (0:00:01.723)       0:01:01.882 ****** 
fatal: [/cache/rhel-8.qcow2]: FAILED! => {
    "assertion": "mssql_password is not none",
    "changed": false,
    "evaluated_to": false
}

MSG:

['You must define the following variables to set up MSSQL:', 'mssql_password', 'mssql_edition']

TASK [Assert that the role failed with variables undefined] ********************
task path: /tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  15:52:41 +0000 (0:00:00.068)       0:01:01.951 ****** 
ok: [/cache/rhel-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/rhel-8.qcow2        : ok=16   changed=4    unreachable=0    failed=0    skipped=10   rescued=1    ignored=0   

Wednesday 03 August 2022  15:52:42 +0000 (0:00:00.077)       0:01:02.028 ****** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 51.72s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 
fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.72s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.55s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 1.49s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 
Gathering Facts --------------------------------------------------------- 1.43s
/tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:3 ---------------------
set up internal repositories -------------------------------------------- 1.33s
/cache/rhel-8_setup.yml:5 -----------------------------------------------------
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.86s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 
fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.52s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.41s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.12s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 
Run the role with default parameters ------------------------------------ 0.12s
/tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:12 --------------------
Assert that the role failed with variables undefined -------------------- 0.08s
/tmp/tmpxtlv9cld/tests/mssql/tests_accept_eula_2019.yml:21 --------------------
fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 
fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.05s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 
fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.05s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 
fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 
fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.05s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 
fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 
fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.04s
/tmp/tmp5m6ig2cl/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102