Formatting '/cache/fedora-36.qcow2.snap', fmt=qcow2 cluster_size=65536 extended_l2=off compression_type=zlib size=4294967296 backing_file=/cache/fedora-36.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/tmpnbi8pp9n 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-36_setup.yml ************************************************** 1 plays in /cache/fedora-36_setup.yml PLAY [Set up host for test playbooks] ****************************************** TASK [Gathering Facts] ********************************************************* task path: /cache/fedora-36_setup.yml:1 Wednesday 03 August 2022 15:21:04 +0000 (0:00:00.013) 0:00:00.013 ****** ok: [/cache/fedora-36.qcow2.snap] META: ran handlers TASK [Create EPEL 36 repo] ***************************************************** task path: /cache/fedora-36_setup.yml:5 Wednesday 03 August 2022 15:21:05 +0000 (0:00:01.217) 0:00:01.231 ****** skipping: [/cache/fedora-36.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-36_setup.yml:15 Wednesday 03 August 2022 15:21:05 +0000 (0:00:00.020) 0:00:01.251 ****** skipping: [/cache/fedora-36.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-36_setup.yml:21 Wednesday 03 August 2022 15:21:05 +0000 (0:00:00.019) 0:00:01.270 ****** changed: [/cache/fedora-36.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-36_setup.yml:27 Wednesday 03 August 2022 15:21:43 +0000 (0:00:38.280) 0:00:39.551 ****** skipping: [/cache/fedora-36.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-36_setup.yml:35 Wednesday 03 August 2022 15:21:43 +0000 (0:00:00.023) 0:00:39.575 ****** skipping: [/cache/fedora-36.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-36.qcow2.snap : ok=2 changed=1 unreachable=0 failed=0 skipped=4 rescued=0 ignored=0 Wednesday 03 August 2022 15:21:43 +0000 (0:00:00.029) 0:00:39.604 ****** =============================================================================== Create dnf cache ------------------------------------------------------- 38.28s /cache/fedora-36_setup.yml:21 ------------------------------------------------- Gathering Facts --------------------------------------------------------- 1.22s /cache/fedora-36_setup.yml:1 -------------------------------------------------- Disable EPEL 8 ---------------------------------------------------------- 0.03s /cache/fedora-36_setup.yml:35 ------------------------------------------------- Disable EPEL 7 ---------------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:27 ------------------------------------------------- Create EPEL 36 repo ----------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:5 -------------------------------------------------- Create yum cache -------------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:15 ------------------------------------------------- PLAYBOOK: setup-snapshot.yml *************************************************** 1 plays in /tmp/tmprd71dlcu/tests/setup-snapshot.yml PLAY [all] ********************************************************************* TASK [Gathering Facts] ********************************************************* task path: /tmp/tmprd71dlcu/tests/setup-snapshot.yml:1 Wednesday 03 August 2022 15:21:43 +0000 (0:00:00.016) 0:00:39.621 ****** ok: [/cache/fedora-36.qcow2.snap] META: ran handlers TASK [Set facts used by role] ************************************************** task path: /tmp/tmprd71dlcu/tests/setup-snapshot.yml:3 Wednesday 03 August 2022 15:21:44 +0000 (0:00:00.856) 0:00:40.477 ****** TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /tmp/tmprd71dlcu/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 15:21:44 +0000 (0:00:00.032) 0:00:40.510 ****** ok: [/cache/fedora-36.qcow2.snap] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmprd71dlcu/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 Wednesday 03 August 2022 15:21:45 +0000 (0:00:00.570) 0:00:41.080 ****** ok: [/cache/fedora-36.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/tmprd71dlcu/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } META: role_complete for /cache/fedora-36.qcow2.snap TASK [Deploy the GPG key for Microsoft repositories] *************************** task path: /tmp/tmprd71dlcu/tests/setup-snapshot.yml:9 Wednesday 03 August 2022 15:21:45 +0000 (0:00:00.057) 0:00:41.137 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true } TASK [Configure the Microsoft SQL Server Tools repository] ********************* task path: /tmp/tmprd71dlcu/tests/setup-snapshot.yml:15 Wednesday 03 August 2022 15:21:46 +0000 (0:00:00.948) 0:00:42.086 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [Cache packages required for tests] *************************************** task path: /tmp/tmprd71dlcu/tests/setup-snapshot.yml:22 Wednesday 03 August 2022 15:21:46 +0000 (0:00:00.533) 0:00:42.619 ****** included: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml for /cache/fedora-36.qcow2.snap => (item=2017) included: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml for /cache/fedora-36.qcow2.snap => (item=2019) TASK [Configure the Microsoft SQL Server 2017 repository] ********************** task path: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:3 Wednesday 03 August 2022 15:21:46 +0000 (0:00:00.034) 0:00:42.654 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "present" } TASK [Install required packages] *********************************************** task path: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:10 Wednesday 03 August 2022 15:21:47 +0000 (0:00:00.452) 0:00:43.106 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true, "rc": 0, "results": [ "Installed: avahi-libs-0.8-15.fc36.x86_64", "Installed: libtool-ltdl-2.4.7-1.fc36.x86_64", "Installed: tcl-1:8.6.12-2.fc36.x86_64", "Installed: libbabeltrace-1.5.8-9.fc36.x86_64", "Installed: openssl1.1-1:1.1.1q-1.fc36.x86_64", "Installed: gc-8.0.6-3.fc36.x86_64", "Installed: ncurses-compat-libs-6.2-9.20210508.fc36.x86_64", "Installed: libverto-libev-0.3.2-3.fc36.x86_64", "Installed: xml-common-0.6.3-58.fc36.noarch", "Installed: libnfsidmap-1:2.6.1-2.rc8.fc36.x86_64", "Installed: libatomic-12.1.1-1.fc36.x86_64", "Installed: keyutils-1.6.1-4.fc36.x86_64", "Installed: at-3.2.5-3.fc36.x86_64", "Installed: source-highlight-3.1.9-12.fc36.1.x86_64", "Installed: jansson-2.13.1-4.fc36.x86_64", "Installed: patch-2.7.6-16.fc36.x86_64", "Installed: resource-agents-4.11.0-1.fc36.x86_64", "Installed: libipt-2.0.5-1.fc36.x86_64", "Installed: python2.7-2.7.18-22.fc36.x86_64", "Installed: spax-1.6-6.fc36.x86_64", "Installed: quota-1:4.06-7.fc36.x86_64", "Installed: quota-nls-1:4.06-7.fc36.noarch", "Installed: fontconfig-2.14.0-1.fc36.x86_64", "Installed: gdb-12.1-1.fc36.x86_64", "Installed: gdb-headless-12.1-1.fc36.x86_64", "Installed: ctags-5.9-3.20220206.0.fc36.x86_64", "Installed: device-mapper-event-1.02.175-7.fc36.x86_64", "Installed: device-mapper-event-libs-1.02.175-7.fc36.x86_64", "Installed: nfs-utils-1:2.6.1-2.rc8.fc36.x86_64", "Installed: numactl-libs-2.0.14-5.fc36.x86_64", "Installed: device-mapper-persistent-data-0.9.0-7.fc36.x86_64", "Installed: lvm2-2.03.11-7.fc36.x86_64", "Installed: guile22-2.2.7-5.fc36.x86_64", "Installed: lvm2-libs-2.03.11-7.fc36.x86_64", "Installed: libX11-1.7.3.1-2.fc36.x86_64", "Installed: libX11-common-1.7.3.1-2.fc36.noarch", "Installed: libpkgconf-1.8.0-2.fc36.x86_64", "Installed: libXau-1.0.9-8.fc36.x86_64", "Installed: bc-1.07.1-15.fc36.x86_64", "Installed: powershell-7.2.5-1.rh.x86_64", "Installed: binutils-2.37-27.fc36.x86_64", "Installed: binutils-gold-2.37-27.fc36.x86_64", "Installed: info-6.8-3.fc36.x86_64", "Installed: libXft-2.3.4-2.fc36.x86_64", "Installed: rpcbind-1.2.6-2.fc36.x86_64", "Installed: libXrender-0.9.10-16.fc36.x86_64", "Installed: time-1.9-18.fc36.x86_64", "Installed: libxcb-1.13.1-9.fc36.x86_64", "Installed: cyrus-sasl-2.1.27-18.fc36.x86_64", "Installed: m4-1.4.19-3.fc36.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-18.fc36.x86_64", "Installed: libesmtp-1.0.6-24.fc36.x86_64", "Installed: libev-4.33-5.fc36.x86_64", "Installed: mailx-12.5-41.fc36.x86_64", "Installed: util-linux-user-2.38-1.fc36.x86_64", "Installed: make-1:4.3-7.fc36.x86_64", "Installed: gssproxy-0.8.4-7.fc36.x86_64", "Installed: tix-1:8.4.3-33.fc36.x86_64", "Installed: tk-1:8.6.12-2.fc36.x86_64", "Installed: libaio-0.3.111-13.fc36.x86_64", "Installed: boost-regex-1.76.0-12.fc36.x86_64", "Installed: mssql-server-14.0.3451.2-1.x86_64", "Installed: cronie-1.5.7-5.fc36.x86_64", "Installed: cronie-anacron-1.5.7-5.fc36.x86_64", "Installed: crontabs-1.11-27.20190603git.fc36.noarch", "Installed: mssql-server-fts-14.0.3451.2-1.x86_64", "Installed: redhat-lsb-core-4.1-56.fc36.x86_64", "Installed: bzip2-1.0.8-11.fc36.x86_64", "Installed: mssql-server-ha-14.0.3451.2-1.x86_64", "Installed: redhat-lsb-submod-security-4.1-56.fc36.x86_64", "Installed: ed-1.14.2-12.fc36.x86_64", "Installed: pkgconf-1.8.0-2.fc36.x86_64", "Installed: pkgconf-m4-1.8.0-2.fc36.noarch", "Installed: cups-client-1:2.4.2-1.fc36.x86_64", "Installed: pkgconf-pkg-config-1.8.0-2.fc36.x86_64", "Installed: cups-libs-1:2.4.2-1.fc36.x86_64", "Installed: esmtp-1.2-19.fc36.x86_64", "Installed: sssd-nfs-idmap-2.7.3-1.fc36.x86_64", "Installed: liblockfile-1.17-2.fc36.x86_64" ] } TASK [Remove mssql packages to keep them in cache only] ************************ task path: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:17 Wednesday 03 August 2022 15:23:01 +0000 (0:01:14.477) 0:01:57.584 ****** changed: [/cache/fedora-36.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/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:22 Wednesday 03 August 2022 15:23:07 +0000 (0:00:05.275) 0:02:02.859 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "absent" } TASK [Configure the Microsoft SQL Server 2019 repository] ********************** task path: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:3 Wednesday 03 August 2022 15:23:07 +0000 (0:00:00.457) 0:02:03.316 ****** changed: [/cache/fedora-36.qcow2.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [Install required packages] *********************************************** task path: /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:10 Wednesday 03 August 2022 15:23:08 +0000 (0:00:00.458) 0:02:03.774 ****** fatal: [/cache/fedora-36.qcow2.snap]: FAILED! => { "changed": false, "failures": [], "rc": 1, "results": [] } MSG: Unknown Error occurred: Transaction test error: installing package powershell-7.2.5-1.rh.x86_64 needs 3MB more space on the / filesystem Error Summary ------------- Disk Requirements: At least 3MB more space needed on the / filesystem. PLAY RECAP ********************************************************************* /cache/fedora-36.qcow2.snap : ok=14 changed=8 unreachable=0 failed=1 skipped=4 rescued=0 ignored=0 Wednesday 03 August 2022 15:23:25 +0000 (0:00:16.945) 0:02:20.719 ****** =============================================================================== Install required packages ---------------------------------------------- 74.48s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:10 ----------------- Create dnf cache ------------------------------------------------------- 38.28s /cache/fedora-36_setup.yml:21 ------------------------------------------------- Install required packages ---------------------------------------------- 16.95s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:10 ----------------- Remove mssql packages to keep them in cache only ------------------------ 5.28s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:17 ----------------- Gathering Facts --------------------------------------------------------- 1.22s /cache/fedora-36_setup.yml:1 -------------------------------------------------- Deploy the GPG key for Microsoft repositories --------------------------- 0.95s /tmp/tmprd71dlcu/tests/setup-snapshot.yml:9 ----------------------------------- Gathering Facts --------------------------------------------------------- 0.86s /tmp/tmprd71dlcu/tests/setup-snapshot.yml:1 ----------------------------------- linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.57s /tmp/tmprd71dlcu/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- Configure the Microsoft SQL Server Tools repository --------------------- 0.53s /tmp/tmprd71dlcu/tests/setup-snapshot.yml:15 ---------------------------------- Configure the Microsoft SQL Server 2019 repository ---------------------- 0.46s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:3 ------------------ Remove the Microsoft SQL Server 2017 repository ------------------------- 0.46s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:22 ----------------- Configure the Microsoft SQL Server 2017 repository ---------------------- 0.45s /tmp/tmprd71dlcu/tests/tasks/snapshot_install_packages.yml:3 ------------------ linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s /tmp/tmprd71dlcu/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 --- Cache packages required for tests --------------------------------------- 0.03s /tmp/tmprd71dlcu/tests/setup-snapshot.yml:22 ---------------------------------- Set facts used by role -------------------------------------------------- 0.03s /tmp/tmprd71dlcu/tests/setup-snapshot.yml:3 ----------------------------------- Disable EPEL 8 ---------------------------------------------------------- 0.03s /cache/fedora-36_setup.yml:35 ------------------------------------------------- Disable EPEL 7 ---------------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:27 ------------------------------------------------- Create EPEL 36 repo ----------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:5 -------------------------------------------------- Create yum cache -------------------------------------------------------- 0.02s /cache/fedora-36_setup.yml:15 ------------------------------------------------- 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/tmpnbi8pp9n 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/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml:3 Wednesday 03 August 2022 15:45:18 +0000 (0:00:00.013) 0:00:00.013 ****** ok: [/cache/fedora-36.qcow2.snap] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml:12 Wednesday 03 August 2022 15:45:20 +0000 (0:00:01.362) 0:00:01.376 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.114) 0:00:01.491 ****** included: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/fedora-36.qcow2.snap TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.033) 0:00:01.524 ****** ok: [/cache/fedora-36.qcow2.snap] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.604) 0:00:02.129 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/fedora-36.qcow2.snap] => (item=Fedora_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.050) 0:00:02.179 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.029) 0:00:02.209 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Wednesday 03 August 2022 15:45:20 +0000 (0:00:00.027) 0:00:02.236 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.021) 0:00:02.257 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.021) 0:00:02.279 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.042) 0:00:02.322 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.039) 0:00:02.362 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.031) 0:00:02.393 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.029) 0:00:02.422 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.028) 0:00:02.451 ****** skipping: [/cache/fedora-36.qcow2.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 Wednesday 03 August 2022 15:45:21 +0000 (0:00:00.028) 0:00:02.479 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 Wednesday 03 August 2022 15:45:22 +0000 (0:00:01.205) 0:00:03.685 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 Wednesday 03 August 2022 15:45:22 +0000 (0:00:00.046) 0:00:03.731 ****** ok: [/cache/fedora-36.qcow2.snap] => { "changed": false } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 Wednesday 03 August 2022 15:45:23 +0000 (0:00:00.881) 0:00:04.613 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 Wednesday 03 August 2022 15:45:23 +0000 (0:00:00.052) 0:00:04.665 ****** skipping: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 Wednesday 03 August 2022 15:45:23 +0000 (0:00:00.046) 0:00:04.712 ****** changed: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 Wednesday 03 August 2022 15:45:24 +0000 (0:00:00.578) 0:00:05.290 ****** changed: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Wednesday 03 August 2022 15:46:00 +0000 (0:00:36.560) 0:00:41.851 ****** ok: [/cache/fedora-36.qcow2.snap] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 Wednesday 03 August 2022 15:46:02 +0000 (0:00:02.094) 0:00:43.946 ****** ok: [/cache/fedora-36.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.006342", "end": "2022-08-03 15:46:02.716854", "rc": 0, "start": "2022-08-03 15:46:02.710512" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 Wednesday 03 August 2022 15:46:03 +0000 (0:00:00.556) 0:00:44.502 ****** ok: [/cache/fedora-36.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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Wednesday 03 August 2022 15:46:05 +0000 (0:00:02.338) 0:00:46.840 ****** fatal: [/cache/fedora-36.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/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml:21 Wednesday 03 August 2022 15:46:05 +0000 (0:00:00.072) 0:00:46.913 ****** ok: [/cache/fedora-36.qcow2.snap] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/fedora-36.qcow2.snap : ok=16 changed=2 unreachable=0 failed=0 skipped=9 rescued=1 ignored=0 Wednesday 03 August 2022 15:46:05 +0000 (0:00:00.068) 0:00:46.981 ****** =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 36.56s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.34s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 2.09s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Gathering Facts --------------------------------------------------------- 1.36s /tmp/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml:3 --------------------- fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.21s /tmp/tmpnbi8pp9n/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.88s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.60s /tmp/tmpnbi8pp9n/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.58s /tmp/tmpnbi8pp9n/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.56s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 Run the role with default parameters ------------------------------------ 0.12s /tmp/tmpecxeutlk/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.07s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Assert that the role failed with variables undefined -------------------- 0.07s /tmp/tmpecxeutlk/tests/mssql/tests_accept_eula_2019.yml:21 -------------------- fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.05s /tmp/tmpnbi8pp9n/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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s /tmp/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s /tmp/tmpnbi8pp9n/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/tmpnbi8pp9n/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44