Formatting '/cache/rhel-8-y.qcow2.snap', fmt=qcow2 cluster_size=65536 extended_l2=off compression_type=zlib size=10737418240 backing_file=/cache/rhel-8-y.qcow2 backing_fmt=qcow2 lazy_refcounts=off refcount_bits=16
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/tmpf_49pz1i
  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-y_setup.yml ***************************************************
2 plays in /cache/rhel-8-y_setup.yml

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

TASK [set up internal repositories] ********************************************
task path: /cache/rhel-8-y_setup.yml:5
Wednesday 03 August 2022  16:13:46 +0000 (0:00:00.017)       0:00:00.017 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => (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-y.qcow2.snap] => (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-y.qcow2.snap] => (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-y.qcow2.snap] => {
    "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 [Set up host for test playbooks] ******************************************

TASK [Gathering Facts] *********************************************************
task path: /cache/rhel-8-y_setup.yml:19
Wednesday 03 August 2022  16:13:48 +0000 (0:00:01.457)       0:00:01.475 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]
META: ran handlers

TASK [Create EPEL 8 repo] ******************************************************
task path: /cache/rhel-8-y_setup.yml:23
Wednesday 03 August 2022  16:13:49 +0000 (0:00:01.098)       0:00:02.573 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [Create yum cache] ********************************************************
task path: /cache/rhel-8-y_setup.yml:33
Wednesday 03 August 2022  16:13:55 +0000 (0:00:06.418)       0:00:08.992 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Create dnf cache] ********************************************************
task path: /cache/rhel-8-y_setup.yml:39
Wednesday 03 August 2022  16:13:55 +0000 (0:00:00.020)       0:00:09.012 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [Disable EPEL 7] **********************************************************
task path: /cache/rhel-8-y_setup.yml:45
Wednesday 03 August 2022  16:14:02 +0000 (0:00:06.897)       0:00:15.910 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Disable EPEL 8] **********************************************************
task path: /cache/rhel-8-y_setup.yml:53
Wednesday 03 August 2022  16:14:02 +0000 (0:00:00.022)       0:00:15.932 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "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-y.qcow2.snap : ok=5    changed=4    unreachable=0    failed=0    skipped=2    rescued=0    ignored=0   

Wednesday 03 August 2022  16:14:03 +0000 (0:00:00.796)       0:00:16.729 ****** 
=============================================================================== 
Create dnf cache -------------------------------------------------------- 6.90s
/cache/rhel-8-y_setup.yml:39 --------------------------------------------------
Create EPEL 8 repo ------------------------------------------------------ 6.42s
/cache/rhel-8-y_setup.yml:23 --------------------------------------------------
set up internal repositories -------------------------------------------- 1.46s
/cache/rhel-8-y_setup.yml:5 ---------------------------------------------------
Gathering Facts --------------------------------------------------------- 1.10s
/cache/rhel-8-y_setup.yml:19 --------------------------------------------------
Disable EPEL 8 ---------------------------------------------------------- 0.80s
/cache/rhel-8-y_setup.yml:53 --------------------------------------------------
Disable EPEL 7 ---------------------------------------------------------- 0.02s
/cache/rhel-8-y_setup.yml:45 --------------------------------------------------
Create yum cache -------------------------------------------------------- 0.02s
/cache/rhel-8-y_setup.yml:33 --------------------------------------------------

PLAYBOOK: setup-snapshot.yml ***************************************************
1 plays in /tmp/tmpbm0vecr7/tests/setup-snapshot.yml

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:1
Wednesday 03 August 2022  16:14:03 +0000 (0:00:00.014)       0:00:16.743 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]
META: ran handlers

TASK [Set facts used by role] **************************************************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:3
Wednesday 03 August 2022  16:14:04 +0000 (0:00:00.818)       0:00:17.562 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  16:14:04 +0000 (0:00:00.032)       0:00:17.594 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022  16:14:04 +0000 (0:00:00.558)       0:00:18.152 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
ok: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat_8.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat_8.7.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.7.yml",
    "skip_reason": "Conditional result was False"
}
META: role_complete for /cache/rhel-8-y.qcow2.snap

TASK [Deploy the GPG key for Microsoft repositories] ***************************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:9
Wednesday 03 August 2022  16:14:04 +0000 (0:00:00.067)       0:00:18.219 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true
}

TASK [Configure the Microsoft SQL Server Tools repository] *********************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:15
Wednesday 03 August 2022  16:14:05 +0000 (0:00:00.787)       0:00:19.007 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [Cache packages required for tests] ***************************************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:22
Wednesday 03 August 2022  16:14:06 +0000 (0:00:00.381)       0:00:19.389 ****** 
included: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml for /cache/rhel-8-y.qcow2.snap => (item=2017)
included: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml for /cache/rhel-8-y.qcow2.snap => (item=2019)

TASK [Configure the Microsoft SQL Server 2017 repository] **********************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3
Wednesday 03 August 2022  16:14:06 +0000 (0:00:00.035)       0:00:19.425 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "present"
}

TASK [Install required packages] ***********************************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10
Wednesday 03 August 2022  16:14:06 +0000 (0:00:00.422)       0:00:19.847 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.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: guile-5:2.0.14-7.el8.x86_64",
        "Installed: lvm2-8:2.03.14-5.el8.x86_64",
        "Installed: lvm2-libs-8:2.03.14-5.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: mssql-server-14.0.3451.2-1.x86_64",
        "Installed: python3-pip-9.0.3-22.el8.noarch",
        "Installed: mssql-server-fts-14.0.3451.2-1.x86_64",
        "Installed: mssql-server-ha-14.0.3451.2-1.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: resource-agents-4.9.0-27.el8.x86_64",
        "Installed: device-mapper-8:1.02.181-5.el8.x86_64",
        "Installed: gdb-8.2-19.el8.x86_64",
        "Installed: device-mapper-event-8:1.02.181-5.el8.x86_64",
        "Installed: device-mapper-event-libs-8:1.02.181-5.el8.x86_64",
        "Installed: python3-setuptools-39.2.0-6.el8.noarch",
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: device-mapper-libs-8:1.02.181-5.el8.x86_64",
        "Installed: device-mapper-persistent-data-0.9.0-7.el8.x86_64",
        "Installed: python2-2.7.18-11.module+el8.7.0+15681+7a92afba.x86_64",
        "Installed: libaio-0.3.112-1.el8.x86_64",
        "Installed: powershell-7.2.5-1.rh.x86_64",
        "Installed: python36-3.6.8-38.module+el8.5.0+12207+5c5719bc.x86_64",
        "Installed: libicu-60.3-2.el8_1.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: python2-libs-2.7.18-11.module+el8.7.0+15681+7a92afba.x86_64",
        "Removed: device-mapper-libs-8:1.02.181-3.el8.x86_64",
        "Removed: device-mapper-8:1.02.181-3.el8.x86_64"
    ]
}

TASK [Remove mssql packages to keep them in cache only] ************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17
Wednesday 03 August 2022  16:15:10 +0000 (0:01:04.400)       0:01:24.247 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Removed: mssql-server-ha-14.0.3451.2-1.x86_64",
        "Removed: powershell-7.2.5-1.rh.x86_64",
        "Removed: mssql-server-14.0.3451.2-1.x86_64",
        "Removed: mssql-server-fts-14.0.3451.2-1.x86_64"
    ]
}

TASK [Remove the Microsoft SQL Server 2017 repository] *************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22
Wednesday 03 August 2022  16:15:13 +0000 (0:00:02.264)       0:01:26.512 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "absent"
}

TASK [Configure the Microsoft SQL Server 2019 repository] **********************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3
Wednesday 03 August 2022  16:15:13 +0000 (0:00:00.405)       0:01:26.917 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [Install required packages] ***********************************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10
Wednesday 03 August 2022  16:15:13 +0000 (0:00:00.414)       0:01:27.332 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64",
        "Installed: mssql-server-fts-15.0.4236.7-1.x86_64",
        "Installed: mssql-server-ha-15.0.4236.7-1.x86_64",
        "Installed: powershell-7.2.5-1.rh.x86_64"
    ]
}

TASK [Remove mssql packages to keep them in cache only] ************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17
Wednesday 03 August 2022  16:16:16 +0000 (0:01:02.321)       0:02:29.653 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Removed: mssql-server-ha-15.0.4236.7-1.x86_64",
        "Removed: powershell-7.2.5-1.rh.x86_64",
        "Removed: mssql-server-15.0.4236.7-1.x86_64",
        "Removed: mssql-server-fts-15.0.4236.7-1.x86_64"
    ]
}

TASK [Remove the Microsoft SQL Server 2019 repository] *************************
task path: /tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22
Wednesday 03 August 2022  16:16:18 +0000 (0:00:02.458)       0:02:32.112 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "absent"
}

TASK [Remove the Microsoft SQL Server Tools repository] ************************
task path: /tmp/tmpbm0vecr7/tests/setup-snapshot.yml:35
Wednesday 03 August 2022  16:16:19 +0000 (0:00:00.405)       0:02:32.518 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "absent"
}
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/rhel-8-y.qcow2.snap : ok=21   changed=15   unreachable=0    failed=0    skipped=2    rescued=0    ignored=0   

Wednesday 03 August 2022  16:16:19 +0000 (0:00:00.372)       0:02:32.891 ****** 
=============================================================================== 
Install required packages ---------------------------------------------- 64.40s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10 -----------------
Install required packages ---------------------------------------------- 62.32s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10 -----------------
Create dnf cache -------------------------------------------------------- 6.90s
/cache/rhel-8-y_setup.yml:39 --------------------------------------------------
Create EPEL 8 repo ------------------------------------------------------ 6.42s
/cache/rhel-8-y_setup.yml:23 --------------------------------------------------
Remove mssql packages to keep them in cache only ------------------------ 2.46s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17 -----------------
Remove mssql packages to keep them in cache only ------------------------ 2.26s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17 -----------------
set up internal repositories -------------------------------------------- 1.46s
/cache/rhel-8-y_setup.yml:5 ---------------------------------------------------
Gathering Facts --------------------------------------------------------- 1.10s
/cache/rhel-8-y_setup.yml:19 --------------------------------------------------
Gathering Facts --------------------------------------------------------- 0.82s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:1 -----------------------------------
Disable EPEL 8 ---------------------------------------------------------- 0.80s
/cache/rhel-8-y_setup.yml:53 --------------------------------------------------
Deploy the GPG key for Microsoft repositories --------------------------- 0.79s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:9 -----------------------------------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.56s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
Configure the Microsoft SQL Server 2017 repository ---------------------- 0.42s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3 ------------------
Configure the Microsoft SQL Server 2019 repository ---------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3 ------------------
Remove the Microsoft SQL Server 2019 repository ------------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22 -----------------
Remove the Microsoft SQL Server 2017 repository ------------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22 -----------------
Configure the Microsoft SQL Server Tools repository --------------------- 0.38s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:15 ----------------------------------
Remove the Microsoft SQL Server Tools repository ------------------------ 0.37s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:35 ----------------------------------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
Cache packages required for tests --------------------------------------- 0.04s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:22 ----------------------------------

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

PLAY [Post setup - these happen last] ******************************************
META: ran handlers

TASK [force sync of filesystems - ensure setup changes are made to snapshot] ***
task path: /cache/rhel-8-y_post_setup.yml:5
Wednesday 03 August 2022  16:16:19 +0000 (0:00:00.019)       0:02:32.910 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [shutdown guest] **********************************************************
task path: /cache/rhel-8-y_post_setup.yml:8
Wednesday 03 August 2022  16:16:20 +0000 (0:00:01.383)       0:02:34.294 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "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-y.qcow2.snap : ok=23   changed=17   unreachable=0    failed=0    skipped=2    rescued=0    ignored=0   

Wednesday 03 August 2022  16:16:21 +0000 (0:00:00.556)       0:02:34.851 ****** 
=============================================================================== 
Install required packages ---------------------------------------------- 64.40s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10 -----------------
Install required packages ---------------------------------------------- 62.32s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:10 -----------------
Create dnf cache -------------------------------------------------------- 6.90s
/cache/rhel-8-y_setup.yml:39 --------------------------------------------------
Create EPEL 8 repo ------------------------------------------------------ 6.42s
/cache/rhel-8-y_setup.yml:23 --------------------------------------------------
Remove mssql packages to keep them in cache only ------------------------ 2.46s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17 -----------------
Remove mssql packages to keep them in cache only ------------------------ 2.26s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:17 -----------------
set up internal repositories -------------------------------------------- 1.46s
/cache/rhel-8-y_setup.yml:5 ---------------------------------------------------
force sync of filesystems - ensure setup changes are made to snapshot --- 1.38s
/cache/rhel-8-y_post_setup.yml:5 ----------------------------------------------
Gathering Facts --------------------------------------------------------- 1.10s
/cache/rhel-8-y_setup.yml:19 --------------------------------------------------
Gathering Facts --------------------------------------------------------- 0.82s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:1 -----------------------------------
Disable EPEL 8 ---------------------------------------------------------- 0.80s
/cache/rhel-8-y_setup.yml:53 --------------------------------------------------
Deploy the GPG key for Microsoft repositories --------------------------- 0.79s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:9 -----------------------------------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.56s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
shutdown guest ---------------------------------------------------------- 0.56s
/cache/rhel-8-y_post_setup.yml:8 ----------------------------------------------
Configure the Microsoft SQL Server 2017 repository ---------------------- 0.42s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3 ------------------
Configure the Microsoft SQL Server 2019 repository ---------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:3 ------------------
Remove the Microsoft SQL Server 2019 repository ------------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22 -----------------
Remove the Microsoft SQL Server 2017 repository ------------------------- 0.41s
/tmp/tmpbm0vecr7/tests/tasks/snapshot_install_packages.yml:22 -----------------
Configure the Microsoft SQL Server Tools repository --------------------- 0.38s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:15 ----------------------------------
Remove the Microsoft SQL Server Tools repository ------------------------ 0.37s
/tmp/tmpbm0vecr7/tests/setup-snapshot.yml:35 ----------------------------------
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/tmpf_49pz1i
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

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

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  16:17:05 +0000 (0:00:00.014)       0:00:00.014 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  16:17:06 +0000 (0:00:01.308)       0:00:01.323 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.122)       0:00:01.445 ****** 
included: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/rhel-8-y.qcow2.snap

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.033)       0:00:01.479 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.535)       0:00:02.014 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
ok: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/rhel-8-y.qcow2.snap] => (item=RedHat_8.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/rhel-8-y.qcow2.snap] => (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] ******
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:8
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.058)       0:00:02.072 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

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

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

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:22
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.024)       0:00:02.149 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:39
Wednesday 03 August 2022  16:17:07 +0000 (0:00:00.046)       0:00:02.221 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:101
Wednesday 03 August 2022  16:17:09 +0000 (0:00:00.055)       0:00:04.008 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

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

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

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

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022  16:17:11 +0000 (0:00:00.555)       0:00:05.475 ****** 
changed: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: mssql-server-15.0.4236.7-1.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022  16:17:46 +0000 (0:00:35.794)       0:00:41.270 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "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/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022  16:17:46 +0000 (0:00:00.035)       0:00:41.306 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.007507",
    "end": "2022-08-03 12:17:47.225798",
    "rc": 0,
    "start": "2022-08-03 12:17:47.218291"
}

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

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022  16:17:49 +0000 (0:00:01.815)       0:00:43.677 ****** 
fatal: [/cache/rhel-8-y.qcow2.snap]: 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/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  16:17:49 +0000 (0:00:00.122)       0:00:43.800 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  16:17:49 +0000 (0:00:00.065)       0:00:43.866 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 35.79s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Gather system services facts ----------------- 1.82s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.56s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
Gathering Facts --------------------------------------------------------- 1.31s
/tmp/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:3 ---------------------------
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.81s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.56s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.56s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.54s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.12s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------
Run the role with default parameters ------------------------------------ 0.12s
/tmp/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:12 --------------------------
Assert that the role failed with variables undefined -------------------- 0.07s
/tmp/tmpbm0vecr7/tests/tests_accept_eula_2019.yml:21 --------------------------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.06s
/tmp/tmpbm0vecr7/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/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------
linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.05s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 -------
linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.05s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 -------
linux-system-roles.mssql : Ensure that the openldap-compat package is installed --- 0.04s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 ------
linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.04s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 -------
linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.03s
/tmp/tmpbm0vecr7/tests/roles/linux-system-roles.mssql/tasks/main.yml:55 -------
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/tmpf_49pz1i
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

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

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  16:35:11 +0000 (0:00:00.012)       0:00:00.012 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  16:35:12 +0000 (0:00:01.372)       0:00:01.385 ****** 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.116)       0:00:01.501 ****** 
included: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/rhel-8-y.qcow2.snap

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.034)       0:00:01.535 ****** 
ok: [/cache/rhel-8-y.qcow2.snap]

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

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.061)       0:00:02.111 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.029)       0:00:02.141 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

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

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.025)       0:00:02.196 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

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

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39
Wednesday 03 August 2022  16:35:13 +0000 (0:00:00.046)       0:00:02.269 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed

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

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

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

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

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

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

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 03 August 2022  16:35:15 +0000 (0:00:00.049)       0:00:04.037 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

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

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

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

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

TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022  16:35:52 +0000 (0:00:35.679)       0:00:41.161 ****** 
skipping: [/cache/rhel-8-y.qcow2.snap] => {
    "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/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022  16:35:52 +0000 (0:00:00.032)       0:00:41.194 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.006564",
    "end": "2022-08-03 12:35:53.414478",
    "rc": 0,
    "start": "2022-08-03 12:35:53.407914"
}

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

TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022  16:35:55 +0000 (0:00:01.830)       0:00:43.537 ****** 
fatal: [/cache/rhel-8-y.qcow2.snap]: 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/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  16:35:55 +0000 (0:00:00.102)       0:00:43.639 ****** 
ok: [/cache/rhel-8-y.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  16:35:55 +0000 (0:00:00.135)       0:00:43.774 ****** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 35.68s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 
fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.83s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.54s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 
Gathering Facts --------------------------------------------------------- 1.37s
/tmp/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:3 ---------------------
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.80s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.55s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.51s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 
fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.51s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 
Assert that the role failed with variables undefined -------------------- 0.14s
/tmp/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:21 --------------------
Run the role with default parameters ------------------------------------ 0.12s
/tmp/tmpixyi654g/tests/mssql/tests_accept_eula_2019.yml:12 --------------------
fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.10s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.06s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 
fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 
fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.05s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 
fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 
fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.05s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 
fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 
fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 
fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.03s
/tmp/tmpf_49pz1i/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63