Formatting '/cache/fedora-35.qcow2.snap', fmt=qcow2 cluster_size=65536 extended_l2=off compression_type=zlib size=4294967296 backing_file=/cache/fedora-35.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/tmpxn3yv_ek
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

PLAYBOOK: fedora-35_setup.yml **************************************************
1 plays in /cache/fedora-35_setup.yml

PLAY [Set up host for test playbooks] ******************************************

TASK [Gathering Facts] *********************************************************
task path: /cache/fedora-35_setup.yml:1
Wednesday 03 August 2022  16:31:24 +0000 (0:00:00.013)       0:00:00.013 ****** 
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers

TASK [Create EPEL 35 repo] *****************************************************
task path: /cache/fedora-35_setup.yml:5
Wednesday 03 August 2022  16:31:25 +0000 (0:00:01.202)       0:00:01.216 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Create yum cache] ********************************************************
task path: /cache/fedora-35_setup.yml:15
Wednesday 03 August 2022  16:31:25 +0000 (0:00:00.020)       0:00:01.236 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Create dnf cache] ********************************************************
task path: /cache/fedora-35_setup.yml:21
Wednesday 03 August 2022  16:31:25 +0000 (0:00:00.019)       0:00:01.255 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [Disable EPEL 7] **********************************************************
task path: /cache/fedora-35_setup.yml:27
Wednesday 03 August 2022  16:32:05 +0000 (0:00:39.944)       0:00:41.200 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Disable EPEL 8] **********************************************************
task path: /cache/fedora-35_setup.yml:35
Wednesday 03 August 2022  16:32:05 +0000 (0:00:00.020)       0:00:41.221 ****** 
skipping: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  16:32:05 +0000 (0:00:00.029)       0:00:41.250 ****** 
=============================================================================== 
Create dnf cache ------------------------------------------------------- 39.94s
/cache/fedora-35_setup.yml:21 -------------------------------------------------
Gathering Facts --------------------------------------------------------- 1.20s
/cache/fedora-35_setup.yml:1 --------------------------------------------------
Disable EPEL 8 ---------------------------------------------------------- 0.03s
/cache/fedora-35_setup.yml:35 -------------------------------------------------
Disable EPEL 7 ---------------------------------------------------------- 0.02s
/cache/fedora-35_setup.yml:27 -------------------------------------------------
Create EPEL 35 repo ----------------------------------------------------- 0.02s
/cache/fedora-35_setup.yml:5 --------------------------------------------------
Create yum cache -------------------------------------------------------- 0.02s
/cache/fedora-35_setup.yml:15 -------------------------------------------------

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

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:1
Wednesday 03 August 2022  16:32:05 +0000 (0:00:00.016)       0:00:41.267 ****** 
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers

TASK [Set facts used by role] **************************************************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:3
Wednesday 03 August 2022  16:32:06 +0000 (0:00:00.805)       0:00:42.073 ****** 

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

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

TASK [Deploy the GPG key for Microsoft repositories] ***************************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:9
Wednesday 03 August 2022  16:32:07 +0000 (0:00:00.056)       0:00:42.743 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true
}

TASK [Configure the Microsoft SQL Server Tools repository] *********************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:15
Wednesday 03 August 2022  16:32:08 +0000 (0:00:00.870)       0:00:43.613 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [Cache packages required for tests] ***************************************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:22
Wednesday 03 August 2022  16:32:08 +0000 (0:00:00.527)       0:00:44.141 ****** 
included: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml for /cache/fedora-35.qcow2.snap => (item=2017)
included: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml for /cache/fedora-35.qcow2.snap => (item=2019)

TASK [Configure the Microsoft SQL Server 2017 repository] **********************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3
Wednesday 03 August 2022  16:32:08 +0000 (0:00:00.036)       0:00:44.177 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "present"
}

TASK [Install required packages] ***********************************************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10
Wednesday 03 August 2022  16:32:09 +0000 (0:00:00.440)       0:00:44.618 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: tcl-1:8.6.10-6.fc35.x86_64",
        "Installed: libaio-0.3.111-12.fc35.x86_64",
        "Installed: powershell-7.2.5-1.rh.x86_64",
        "Installed: bc-1.07.1-14.fc35.x86_64",
        "Installed: patch-2.7.6-15.fc35.x86_64",
        "Installed: liblockfile-1.17-2.fc35.x86_64",
        "Installed: libsss_certmap-2.7.3-1.fc35.x86_64",
        "Installed: libsss_idmap-2.7.3-1.fc35.x86_64",
        "Installed: libsss_nss_idmap-2.7.3-1.fc35.x86_64",
        "Installed: ncurses-compat-libs-6.2-8.20210508.fc35.x86_64",
        "Installed: fontconfig-2.13.94-5.fc35.x86_64",
        "Installed: libsss_sudo-2.7.3-1.fc35.x86_64",
        "Installed: binutils-2.37-17.fc35.x86_64",
        "Installed: binutils-gold-2.37-17.fc35.x86_64",
        "Installed: gssproxy-0.8.4-4.fc35.x86_64",
        "Installed: device-mapper-event-1.02.175-6.fc35.x86_64",
        "Installed: ctags-5.9-1.20210725.0.fc35.x86_64",
        "Installed: time-1.9-17.fc35.x86_64",
        "Installed: device-mapper-event-libs-1.02.175-6.fc35.x86_64",
        "Installed: libverto-libev-0.3.2-2.fc35.x86_64",
        "Installed: device-mapper-persistent-data-0.9.0-6.fc35.x86_64",
        "Installed: libtool-ltdl-2.4.6-50.fc35.x86_64",
        "Installed: util-linux-user-2.37.4-1.fc35.x86_64",
        "Installed: python2.7-2.7.18-22.fc35.x86_64",
        "Installed: libbabeltrace-1.5.8-8.fc35.x86_64",
        "Installed: tix-1:8.4.3-32.fc35.x86_64",
        "Installed: tk-1:8.6.10-7.fc35.x86_64",
        "Installed: mssql-server-14.0.3451.2-1.x86_64",
        "Installed: mssql-server-fts-14.0.3451.2-1.x86_64",
        "Installed: numactl-libs-2.0.14-4.fc35.x86_64",
        "Installed: quota-1:4.06-6.fc35.x86_64",
        "Installed: quota-nls-1:4.06-6.fc35.noarch",
        "Installed: mssql-server-ha-14.0.3451.2-1.x86_64",
        "Installed: libipt-2.0.4-3.fc35.x86_64",
        "Installed: lvm2-2.03.11-6.fc35.x86_64",
        "Installed: lvm2-libs-2.03.11-6.fc35.x86_64",
        "Installed: keyutils-1.6.1-3.fc35.x86_64",
        "Installed: libpkgconf-1.8.0-1.fc35.x86_64",
        "Installed: boost-regex-1.76.0-5.fc35.x86_64",
        "Installed: sssd-client-2.7.3-1.fc35.x86_64",
        "Installed: sssd-common-2.7.3-1.fc35.x86_64",
        "Installed: sssd-kcm-2.7.3-1.fc35.x86_64",
        "Installed: sssd-nfs-idmap-2.7.3-1.fc35.x86_64",
        "Installed: pkgconf-1.8.0-1.fc35.x86_64",
        "Installed: pkgconf-m4-1.8.0-1.fc35.noarch",
        "Installed: pkgconf-pkg-config-1.8.0-1.fc35.x86_64",
        "Installed: jansson-2.13.1-3.fc35.x86_64",
        "Installed: xxhash-libs-0.8.1-1.fc35.x86_64",
        "Installed: rpcbind-1.2.6-1.fc35.x86_64",
        "Installed: gc-8.0.4-6.fc35.x86_64",
        "Installed: xml-common-0.6.3-57.fc35.noarch",
        "Installed: libXau-1.0.9-7.fc35.x86_64",
        "Installed: cronie-1.5.7-4.fc35.x86_64",
        "Installed: cronie-anacron-1.5.7-4.fc35.x86_64",
        "Installed: crontabs-1.11-26.20190603git.fc35.noarch",
        "Installed: resource-agents-4.11.0-1.fc35.x86_64",
        "Installed: ed-1.14.2-11.fc35.x86_64",
        "Installed: m4-1.4.19-2.fc35.x86_64",
        "Installed: libxcb-1.13.1-8.fc35.x86_64",
        "Installed: bzip2-1.0.8-9.fc35.x86_64",
        "Installed: libX11-1.7.3.1-1.fc35.x86_64",
        "Installed: libX11-common-1.7.3.1-1.fc35.noarch",
        "Installed: gdb-12.1-1.fc35.x86_64",
        "Installed: at-3.2.5-3.fc35.x86_64",
        "Installed: gdb-headless-12.1-1.fc35.x86_64",
        "Installed: libXft-2.3.3-7.fc35.x86_64",
        "Installed: libnfsidmap-1:2.5.4-2.rc3.fc35.x86_64",
        "Installed: nfs-utils-1:2.5.4-2.rc3.fc35.x86_64",
        "Installed: esmtp-1.2-18.fc35.x86_64",
        "Installed: mailx-12.5-38.fc35.x86_64",
        "Installed: cups-client-1:2.3.3op2-18.fc35.x86_64",
        "Installed: make-1:4.3-6.fc35.x86_64",
        "Installed: cups-libs-1:2.3.3op2-18.fc35.x86_64",
        "Installed: source-highlight-3.1.9-11.fc35.x86_64",
        "Installed: guile22-2.2.7-3.fc35.x86_64",
        "Installed: libXrender-0.9.10-15.fc35.x86_64",
        "Installed: libatomic-11.3.1-2.fc35.x86_64",
        "Installed: libesmtp-1.0.6-22.fc35.x86_64",
        "Installed: libicu-69.1-6.fc35.x86_64",
        "Installed: cyrus-sasl-2.1.27-14.fc35.x86_64",
        "Installed: libev-4.33-4.fc35.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-14.fc35.x86_64",
        "Installed: redhat-lsb-core-4.1-55.fc35.x86_64",
        "Installed: openssl-1:1.1.1q-1.fc35.x86_64",
        "Installed: redhat-lsb-submod-security-4.1-55.fc35.x86_64",
        "Installed: openssl-libs-1:1.1.1q-1.fc35.x86_64",
        "Installed: info-6.8-2.fc35.x86_64",
        "Installed: spax-1.6-5.fc35.x86_64",
        "Installed: avahi-libs-0.8-14.fc35.x86_64",
        "Removed: sssd-client-2.7.1-2.fc35.x86_64",
        "Removed: openssl-libs-1:1.1.1o-1.fc35.x86_64",
        "Removed: sssd-common-2.7.1-2.fc35.x86_64",
        "Removed: sssd-kcm-2.7.1-2.fc35.x86_64",
        "Removed: libsss_certmap-2.7.1-2.fc35.x86_64",
        "Removed: libsss_idmap-2.7.1-2.fc35.x86_64",
        "Removed: libsss_nss_idmap-2.7.1-2.fc35.x86_64",
        "Removed: libsss_sudo-2.7.1-2.fc35.x86_64"
    ]
}

TASK [Remove mssql packages to keep them in cache only] ************************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:17
Wednesday 03 August 2022  16:33:25 +0000 (0:01:16.145)       0:02:00.763 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Removed: mssql-server-14.0.3451.2-1.x86_64",
        "Removed: mssql-server-fts-14.0.3451.2-1.x86_64",
        "Removed: mssql-server-ha-14.0.3451.2-1.x86_64",
        "Removed: powershell-7.2.5-1.rh.x86_64"
    ]
}

TASK [Remove the Microsoft SQL Server 2017 repository] *************************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22
Wednesday 03 August 2022  16:33:30 +0000 (0:00:05.450)       0:02:06.213 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2017",
    "state": "absent"
}

TASK [Configure the Microsoft SQL Server 2019 repository] **********************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3
Wednesday 03 August 2022  16:33:31 +0000 (0:00:00.424)       0:02:06.638 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [Install required packages] ***********************************************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10
Wednesday 03 August 2022  16:33:31 +0000 (0:00:00.435)       0:02:07.074 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "rc": 0,
    "results": [
        "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",
        "Installed: mssql-server-15.0.4236.7-1.x86_64"
    ]
}

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

TASK [Remove the Microsoft SQL Server 2019 repository] *************************
task path: /tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22
Wednesday 03 August 2022  16:34:38 +0000 (0:00:03.165)       0:03:14.530 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "absent"
}

TASK [Remove the Microsoft SQL Server Tools repository] ************************
task path: /tmp/tmpc9fejdi1/tests/setup-snapshot.yml:35
Wednesday 03 August 2022  16:34:39 +0000 (0:00:00.406)       0:03:14.937 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "absent"
}
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=18   changed=12   unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   

Wednesday 03 August 2022  16:34:39 +0000 (0:00:00.389)       0:03:15.326 ****** 
=============================================================================== 
Install required packages ---------------------------------------------- 76.15s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10 -----------------
Install required packages ---------------------------------------------- 64.29s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10 -----------------
Create dnf cache ------------------------------------------------------- 39.94s
/cache/fedora-35_setup.yml:21 -------------------------------------------------
Remove mssql packages to keep them in cache only ------------------------ 5.45s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:17 -----------------
Remove mssql packages to keep them in cache only ------------------------ 3.17s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:17 -----------------
Gathering Facts --------------------------------------------------------- 1.20s
/cache/fedora-35_setup.yml:1 --------------------------------------------------
Deploy the GPG key for Microsoft repositories --------------------------- 0.87s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:9 -----------------------------------
Gathering Facts --------------------------------------------------------- 0.81s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:1 -----------------------------------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.58s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
Configure the Microsoft SQL Server Tools repository --------------------- 0.53s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:15 ----------------------------------
Configure the Microsoft SQL Server 2017 repository ---------------------- 0.44s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3 ------------------
Configure the Microsoft SQL Server 2019 repository ---------------------- 0.44s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3 ------------------
Remove the Microsoft SQL Server 2017 repository ------------------------- 0.42s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22 -----------------
Remove the Microsoft SQL Server 2019 repository ------------------------- 0.41s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22 -----------------
Remove the Microsoft SQL Server Tools repository ------------------------ 0.39s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:35 ----------------------------------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
Cache packages required for tests --------------------------------------- 0.04s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:22 ----------------------------------
Set facts used by role -------------------------------------------------- 0.03s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:3 -----------------------------------
Disable EPEL 8 ---------------------------------------------------------- 0.03s
/cache/fedora-35_setup.yml:35 -------------------------------------------------
Disable EPEL 7 ---------------------------------------------------------- 0.02s
/cache/fedora-35_setup.yml:27 -------------------------------------------------

PLAYBOOK: fedora-35_post_setup.yml *********************************************
1 plays in /cache/fedora-35_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/fedora-35_post_setup.yml:5
Wednesday 03 August 2022  16:34:39 +0000 (0:00:00.019)       0:03:15.346 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [shutdown guest] **********************************************************
task path: /cache/fedora-35_post_setup.yml:8
Wednesday 03 August 2022  16:34:40 +0000 (0:00:00.408)       0:03:15.754 ****** 
changed: [/cache/fedora-35.qcow2.snap] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=20   changed=14   unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   

Wednesday 03 August 2022  16:34:40 +0000 (0:00:00.579)       0:03:16.333 ****** 
=============================================================================== 
Install required packages ---------------------------------------------- 76.15s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10 -----------------
Install required packages ---------------------------------------------- 64.29s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:10 -----------------
Create dnf cache ------------------------------------------------------- 39.94s
/cache/fedora-35_setup.yml:21 -------------------------------------------------
Remove mssql packages to keep them in cache only ------------------------ 5.45s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:17 -----------------
Remove mssql packages to keep them in cache only ------------------------ 3.17s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:17 -----------------
Gathering Facts --------------------------------------------------------- 1.20s
/cache/fedora-35_setup.yml:1 --------------------------------------------------
Deploy the GPG key for Microsoft repositories --------------------------- 0.87s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:9 -----------------------------------
Gathering Facts --------------------------------------------------------- 0.81s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:1 -----------------------------------
shutdown guest ---------------------------------------------------------- 0.58s
/cache/fedora-35_post_setup.yml:8 ---------------------------------------------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.58s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
Configure the Microsoft SQL Server Tools repository --------------------- 0.53s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:15 ----------------------------------
Configure the Microsoft SQL Server 2017 repository ---------------------- 0.44s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3 ------------------
Configure the Microsoft SQL Server 2019 repository ---------------------- 0.44s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:3 ------------------
Remove the Microsoft SQL Server 2017 repository ------------------------- 0.42s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22 -----------------
force sync of filesystems - ensure setup changes are made to snapshot --- 0.41s
/cache/fedora-35_post_setup.yml:5 ---------------------------------------------
Remove the Microsoft SQL Server 2019 repository ------------------------- 0.41s
/tmp/tmpc9fejdi1/tests/tasks/snapshot_install_packages.yml:22 -----------------
Remove the Microsoft SQL Server Tools repository ------------------------ 0.39s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:35 ----------------------------------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
Cache packages required for tests --------------------------------------- 0.04s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:22 ----------------------------------
Set facts used by role -------------------------------------------------- 0.03s
/tmp/tmpc9fejdi1/tests/setup-snapshot.yml:3 -----------------------------------
ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmpxn3yv_ek
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022  16:35:27 +0000 (0:00:00.591)       0:00:02.122 ****** 
ok: [/cache/fedora-35.qcow2.snap] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/"
    },
    "ansible_included_var_files": [
        "/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "Fedora_35.yml",
    "skip_reason": "Conditional result was False"
}

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

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

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

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

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

MSG:

All assertions passed

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

MSG:

All assertions passed

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

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

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

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

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

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

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022  16:36:10 +0000 (0:00:02.956)       0:00:45.751 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.006389",
    "end": "2022-08-03 16:36:10.228874",
    "rc": 0,
    "start": "2022-08-03 16:36:10.222485"
}

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

TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022  16:36:13 +0000 (0:00:02.148)       0:00:48.435 ****** 
fatal: [/cache/fedora-35.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/tmpc9fejdi1/tests/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  16:36:13 +0000 (0:00:00.140)       0:00:48.575 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=16   changed=3    unreachable=0    failed=0    skipped=9    rescued=1    ignored=0   

Wednesday 03 August 2022  16:36:13 +0000 (0:00:00.074)       0:00:48.650 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 37.71s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Ensure that the openldap-compat package is installed --- 2.96s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 ------
linux-system-roles.mssql : Gather system services facts ----------------- 2.15s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
Gathering Facts --------------------------------------------------------- 1.39s
/tmp/tmpc9fejdi1/tests/tests_accept_eula_2019.yml:3 ---------------------------
linux-system-roles.mssql : Gather package facts ------------------------- 1.09s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.79s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.59s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.53s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------
linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.14s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------
Run the role with default parameters ------------------------------------ 0.09s
/tmp/tmpc9fejdi1/tests/tests_accept_eula_2019.yml:12 --------------------------
Assert that the role failed with variables undefined -------------------- 0.07s
/tmp/tmpc9fejdi1/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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 -------
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.05s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------
linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.05s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 -------
linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 -------
linux-system-roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 --------
linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:72 -------
ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmpxn3yv_ek
  executable location = /usr/bin/ansible-playbook
  python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
  jinja version = 2.11.3
  libyaml = True
Using /etc/ansible/ansible.cfg as config file
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

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

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

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

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmphentkgqr/tests/mssql/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  17:02:41 +0000 (0:00:01.401)       0:00:01.415 ****** 

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

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

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

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

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

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

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

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

MSG:

All assertions passed

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

MSG:

All assertions passed

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

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

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

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

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

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

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

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

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

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

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

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

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022  17:03:25 +0000 (0:00:02.415)       0:00:44.950 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.005861",
    "end": "2022-08-03 17:03:24.852898",
    "rc": 0,
    "start": "2022-08-03 17:03:24.847037"
}

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

TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022  17:03:27 +0000 (0:00:02.068)       0:00:47.556 ****** 
fatal: [/cache/fedora-35.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/tmphentkgqr/tests/mssql/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  17:03:27 +0000 (0:00:00.075)       0:00:47.632 ****** 
ok: [/cache/fedora-35.qcow2.snap] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=16   changed=3    unreachable=0    failed=0    skipped=9    rescued=1    ignored=0   

Wednesday 03 August 2022  17:03:27 +0000 (0:00:00.072)       0:00:47.704 ****** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 37.32s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 
fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 2.42s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 
fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.07s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 
Gathering Facts --------------------------------------------------------- 1.40s
/tmp/tmphentkgqr/tests/mssql/tests_accept_eula_2019.yml:3 ---------------------
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.09s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.82s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.61s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.56s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 
fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.54s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 
Run the role with default parameters ------------------------------------ 0.12s
/tmp/tmphentkgqr/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.08s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 
Assert that the role failed with variables undefined -------------------- 0.07s
/tmp/tmphentkgqr/tests/mssql/tests_accept_eula_2019.yml:21 --------------------
fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.06s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.06s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.05s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 
fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 
fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpxn3yv_ek/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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 
fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.04s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71 
fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.03s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55