Formatting '/cache/centos-7.qcow2c.snap', fmt=qcow2 cluster_size=65536 extended_l2=off compression_type=zlib size=8589934592 backing_file=/cache/centos-7.qcow2c 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/tmp1kc47jky 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: centos-7_setup.yml *************************************************** 1 plays in /cache/centos-7_setup.yml PLAY [Set up host for test playbooks] ****************************************** TASK [Gathering Facts] ********************************************************* task path: /cache/centos-7_setup.yml:1 Wednesday 03 August 2022 15:18:58 +0000 (0:00:00.013) 0:00:00.013 ****** ok: [/cache/centos-7.qcow2c.snap] META: ran handlers TASK [Create EPEL 7 repo] ****************************************************** task path: /cache/centos-7_setup.yml:5 Wednesday 03 August 2022 15:18:59 +0000 (0:00:01.058) 0:00:01.071 ****** changed: [/cache/centos-7.qcow2c.snap] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } TASK [Create yum cache] ******************************************************** task path: /cache/centos-7_setup.yml:15 Wednesday 03 August 2022 15:19:01 +0000 (0:00:01.935) 0:00:03.006 ****** changed: [/cache/centos-7.qcow2c.snap] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } TASK [Create dnf cache] ******************************************************** task path: /cache/centos-7_setup.yml:21 Wednesday 03 August 2022 15:19:53 +0000 (0:00:51.894) 0:00:54.901 ****** skipping: [/cache/centos-7.qcow2c.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 7] ********************************************************** task path: /cache/centos-7_setup.yml:27 Wednesday 03 August 2022 15:19:53 +0000 (0:00:00.022) 0:00:54.924 ****** changed: [/cache/centos-7.qcow2c.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 8] ********************************************************** task path: /cache/centos-7_setup.yml:35 Wednesday 03 August 2022 15:19:54 +0000 (0:00:00.493) 0:00:55.418 ****** skipping: [/cache/centos-7.qcow2c.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/centos-7.qcow2c.snap : ok=4 changed=3 unreachable=0 failed=0 skipped=2 rescued=0 ignored=0 Wednesday 03 August 2022 15:19:54 +0000 (0:00:00.030) 0:00:55.448 ****** =============================================================================== Create yum cache ------------------------------------------------------- 51.89s /cache/centos-7_setup.yml:15 -------------------------------------------------- Create EPEL 7 repo ------------------------------------------------------ 1.94s /cache/centos-7_setup.yml:5 --------------------------------------------------- Gathering Facts --------------------------------------------------------- 1.06s /cache/centos-7_setup.yml:1 --------------------------------------------------- Disable EPEL 7 ---------------------------------------------------------- 0.49s /cache/centos-7_setup.yml:27 -------------------------------------------------- Disable EPEL 8 ---------------------------------------------------------- 0.03s /cache/centos-7_setup.yml:35 -------------------------------------------------- Create dnf cache -------------------------------------------------------- 0.02s /cache/centos-7_setup.yml:21 -------------------------------------------------- PLAYBOOK: setup-snapshot.yml *************************************************** 1 plays in /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml PLAY [all] ********************************************************************* TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:1 Wednesday 03 August 2022 15:19:54 +0000 (0:00:00.016) 0:00:55.465 ****** ok: [/cache/centos-7.qcow2c.snap] META: ran handlers TASK [Set facts used by role] ************************************************** task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:3 Wednesday 03 August 2022 15:19:55 +0000 (0:00:00.720) 0:00:56.186 ****** TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 15:19:55 +0000 (0:00:00.033) 0:00:56.219 ****** ok: [/cache/centos-7.qcow2c.snap] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 Wednesday 03 August 2022 15:19:55 +0000 (0:00:00.398) 0:00:56.617 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } META: role_complete for /cache/centos-7.qcow2c.snap TASK [Deploy the GPG key for Microsoft repositories] *************************** task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:9 Wednesday 03 August 2022 15:19:55 +0000 (0:00:00.103) 0:00:56.720 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true } TASK [Configure the Microsoft SQL Server Tools repository] ********************* task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:15 Wednesday 03 August 2022 15:19:56 +0000 (0:00:00.708) 0:00:57.429 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [Cache packages required for tests] *************************************** task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:22 Wednesday 03 August 2022 15:19:56 +0000 (0:00:00.441) 0:00:57.870 ****** included: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml for /cache/centos-7.qcow2c.snap => (item=2017) included: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml for /cache/centos-7.qcow2c.snap => (item=2019) TASK [Configure the Microsoft SQL Server 2017 repository] ********************** task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 Wednesday 03 August 2022 15:19:56 +0000 (0:00:00.034) 0:00:57.905 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "present" } TASK [Install required packages] *********************************************** task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 Wednesday 03 August 2022 15:19:57 +0000 (0:00:00.359) 0:00:58.264 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "installed": [ "mssql-server", "mssql-server-fts", "mssql-server-ha", "powershell" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.metrocast.net\n * extras: forksystems.mm.fcix.net\n * updates: mirrors.tripadvisor.com\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:14.0.3451.2-1 will be installed\n--> Processing Dependency: libatomic for package: mssql-server-14.0.3451.2-1.x86_64\n--> Processing Dependency: bzip2 for package: mssql-server-14.0.3451.2-1.x86_64\n--> Processing Dependency: gdb for package: mssql-server-14.0.3451.2-1.x86_64\n--> Processing Dependency: libsss_nss_idmap for package: mssql-server-14.0.3451.2-1.x86_64\n--> Processing Dependency: cyrus-sasl for package: mssql-server-14.0.3451.2-1.x86_64\n--> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-14.0.3451.2-1.x86_64\n---> Package mssql-server-fts.x86_64 0:14.0.3451.2-1 will be installed\n---> Package mssql-server-ha.x86_64 0:14.0.3451.2-1 will be installed\n--> Processing Dependency: resource-agents for package: mssql-server-ha-14.0.3451.2-1.x86_64\n---> Package powershell.x86_64 0:7.2.5-1.rh will be installed\n--> Processing Dependency: libicu for package: powershell-7.2.5-1.rh.x86_64\n--> Running transaction check\n---> Package bzip2.x86_64 0:1.0.6-13.el7 will be installed\n---> Package cyrus-sasl.x86_64 0:2.1.26-24.el7_9 will be installed\n--> Processing Dependency: cyrus-sasl-lib(x86-64) = 2.1.26-24.el7_9 for package: cyrus-sasl-2.1.26-24.el7_9.x86_64\n---> Package cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 will be installed\n---> Package gdb.x86_64 0:7.6.1-120.el7 will be installed\n---> Package libatomic.x86_64 0:4.8.5-44.el7 will be installed\n---> Package libicu.x86_64 0:50.2-4.el7_7 will be installed\n---> Package libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.13 will be installed\n---> Package resource-agents.x86_64 0:4.1.1-61.el7_9.15 will be installed\n--> Processing Dependency: psmisc for package: resource-agents-4.1.1-61.el7_9.15.x86_64\n--> Processing Dependency: /usr/sbin/mount.cifs for package: resource-agents-4.1.1-61.el7_9.15.x86_64\n--> Processing Dependency: /usr/sbin/lvm for package: resource-agents-4.1.1-61.el7_9.15.x86_64\n--> Processing Dependency: /usr/sbin/fuser for package: resource-agents-4.1.1-61.el7_9.15.x86_64\n--> Running transaction check\n---> Package cifs-utils.x86_64 0:6.2-10.el7 will be installed\n--> Processing Dependency: libwbclient.so.0(WBCLIENT_0.9)(64bit) for package: cifs-utils-6.2-10.el7.x86_64\n--> Processing Dependency: libtalloc.so.2(TALLOC_2.0.2)(64bit) for package: cifs-utils-6.2-10.el7.x86_64\n--> Processing Dependency: libwbclient.so.0()(64bit) for package: cifs-utils-6.2-10.el7.x86_64\n--> Processing Dependency: libtalloc.so.2()(64bit) for package: cifs-utils-6.2-10.el7.x86_64\n---> Package cyrus-sasl-lib.x86_64 0:2.1.26-23.el7 will be updated\n---> Package cyrus-sasl-lib.x86_64 0:2.1.26-24.el7_9 will be an update\n---> Package lvm2.x86_64 7:2.02.187-6.el7_9.5 will be installed\n--> Processing Dependency: lvm2-libs = 7:2.02.187-6.el7_9.5 for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: device-mapper-persistent-data >= 0.7.0-0.1.rc6 for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: liblvm2app.so.2.2(Base)(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: libdevmapper-event.so.1.02(Base)(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: liblvm2app.so.2.2()(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: libdevmapper-event.so.1.02()(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n--> Processing Dependency: libaio.so.1()(64bit) for package: 7:lvm2-2.02.187-6.el7_9.5.x86_64\n---> Package psmisc.x86_64 0:22.20-17.el7 will be installed\n--> Running transaction check\n---> Package device-mapper-event-libs.x86_64 7:1.02.170-6.el7_9.5 will be installed\n---> Package device-mapper-persistent-data.x86_64 0:0.8.5-3.el7_9.2 will be installed\n---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed\n---> Package libtalloc.x86_64 0:2.1.16-1.el7 will be installed\n---> Package libwbclient.x86_64 0:4.10.16-19.el7_9 will be installed\n--> Processing Dependency: samba-client-libs = 4.10.16-19.el7_9 for package: libwbclient-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libreplace-samba4.so(SAMBA_4.10.16)(64bit) for package: libwbclient-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libreplace-samba4.so()(64bit) for package: libwbclient-4.10.16-19.el7_9.x86_64\n---> Package lvm2-libs.x86_64 7:2.02.187-6.el7_9.5 will be installed\n--> Processing Dependency: device-mapper-event = 7:1.02.170-6.el7_9.5 for package: 7:lvm2-libs-2.02.187-6.el7_9.5.x86_64\n--> Running transaction check\n---> Package device-mapper-event.x86_64 7:1.02.170-6.el7_9.5 will be installed\n---> Package samba-client-libs.x86_64 0:4.10.16-19.el7_9 will be installed\n--> Processing Dependency: samba-common-libs = 4.10.16-19.el7_9 for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: samba-common = 4.10.16-19.el7_9 for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: samba-common = 4.10.16-19.el7_9 for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.9)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.37)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.31)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.30)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.21)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.20)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.16)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.14)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.13)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0(TEVENT_0.9.12)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.3.17)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.3.11)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.3.0)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.2.5)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.2.2)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1(TDB_1.2.1)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_1.3.0)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_1.1.30)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_1.1.19)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_1.1.1)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_0.9.23)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_0.9.15)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1(LDB_0.9.10)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libgnutls.so.28(GNUTLS_3_1_0)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libgnutls.so.28(GNUTLS_1_4)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libaesni-intel-samba4.so(SAMBA_4.10.16)(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtevent.so.0()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libtdb.so.1()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libldb.so.1()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libgnutls.so.28()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libcups.so.2()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libcluster-samba4.so()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libavahi-common.so.3()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libavahi-client.so.3()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Processing Dependency: libaesni-intel-samba4.so()(64bit) for package: samba-client-libs-4.10.16-19.el7_9.x86_64\n--> Running transaction check\n---> Package avahi-libs.x86_64 0:0.6.31-20.el7 will be installed\n---> Package cups-libs.x86_64 1:1.6.3-51.el7 will be installed\n---> Package gnutls.x86_64 0:3.3.29-9.el7_6 will be installed\n--> Processing Dependency: trousers >= 0.3.11.2 for package: gnutls-3.3.29-9.el7_6.x86_64\n--> Processing Dependency: libnettle.so.4()(64bit) for package: gnutls-3.3.29-9.el7_6.x86_64\n--> Processing Dependency: libhogweed.so.2()(64bit) for package: gnutls-3.3.29-9.el7_6.x86_64\n---> Package libldb.x86_64 0:1.5.4-2.el7 will be installed\n---> Package libtdb.x86_64 0:1.3.18-1.el7 will be installed\n---> Package libtevent.x86_64 0:0.9.39-1.el7 will be installed\n---> Package samba-common.noarch 0:4.10.16-19.el7_9 will be installed\n---> Package samba-common-libs.x86_64 0:4.10.16-19.el7_9 will be installed\n--> Running transaction check\n---> Package nettle.x86_64 0:2.7.1-9.el7_9 will be installed\n---> Package trousers.x86_64 0:0.3.14-2.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server x86_64 14.0.3451.2-1 packages-microsoft-com-mssql-server-2017\n 200 M\n mssql-server-fts x86_64 14.0.3451.2-1 packages-microsoft-com-mssql-server-2017\n 225 M\n mssql-server-ha x86_64 14.0.3451.2-1 packages-microsoft-com-mssql-server-2017\n 2.6 M\n powershell x86_64 7.2.5-1.rh packages-microsoft-com-prod\n 66 M\nInstalling for dependencies:\n avahi-libs x86_64 0.6.31-20.el7 base 62 k\n bzip2 x86_64 1.0.6-13.el7 base 52 k\n cifs-utils x86_64 6.2-10.el7 base 85 k\n cups-libs x86_64 1:1.6.3-51.el7 base 359 k\n cyrus-sasl x86_64 2.1.26-24.el7_9 updates 88 k\n cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 updates 41 k\n device-mapper-event x86_64 7:1.02.170-6.el7_9.5 updates 192 k\n device-mapper-event-libs x86_64 7:1.02.170-6.el7_9.5 updates 192 k\n device-mapper-persistent-data x86_64 0.8.5-3.el7_9.2 updates 423 k\n gdb x86_64 7.6.1-120.el7 base 2.4 M\n gnutls x86_64 3.3.29-9.el7_6 base 680 k\n libaio x86_64 0.3.109-13.el7 base 24 k\n libatomic x86_64 4.8.5-44.el7 base 51 k\n libicu x86_64 50.2-4.el7_7 base 6.9 M\n libldb x86_64 1.5.4-2.el7 updates 149 k\n libsss_nss_idmap x86_64 1.16.5-10.el7_9.13 updates 169 k\n libtalloc x86_64 2.1.16-1.el7 base 33 k\n libtdb x86_64 1.3.18-1.el7 base 49 k\n libtevent x86_64 0.9.39-1.el7 base 41 k\n libwbclient x86_64 4.10.16-19.el7_9 updates 116 k\n lvm2 x86_64 7:2.02.187-6.el7_9.5 updates 1.3 M\n lvm2-libs x86_64 7:2.02.187-6.el7_9.5 updates 1.1 M\n nettle x86_64 2.7.1-9.el7_9 updates 328 k\n psmisc x86_64 22.20-17.el7 base 141 k\n resource-agents x86_64 4.1.1-61.el7_9.15 updates 480 k\n samba-client-libs x86_64 4.10.16-19.el7_9 updates 5.0 M\n samba-common noarch 4.10.16-19.el7_9 updates 216 k\n samba-common-libs x86_64 4.10.16-19.el7_9 updates 183 k\n trousers x86_64 0.3.14-2.el7 base 289 k\nUpdating for dependencies:\n cyrus-sasl-lib x86_64 2.1.26-24.el7_9 updates 156 k\n\nTransaction Summary\n================================================================================\nInstall 4 Packages (+29 Dependent packages)\nUpgrade ( 1 Dependent package)\n\nTotal download size: 515 M\nDownloading packages:\nDelta RPMs disabled because /usr/bin/applydeltarpm not installed.\nPublic key for bzip2-1.0.6-13.el7.x86_64.rpm is not installed\nPublic key for cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64.rpm is not installed\n--------------------------------------------------------------------------------\nTotal 61 MB/s | 515 MB 00:08 \nRetrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : libtalloc-2.1.16-1.el7.x86_64 1/35 \n Installing : libtevent-0.9.39-1.el7.x86_64 2/35 \n Installing : libaio-0.3.109-13.el7.x86_64 3/35 \n Installing : 7:device-mapper-event-libs-1.02.170-6.el7_9.5.x86_64 4/35 \n Installing : libtdb-1.3.18-1.el7.x86_64 5/35 \n Installing : libldb-1.5.4-2.el7.x86_64 6/35 \n Installing : avahi-libs-0.6.31-20.el7.x86_64 7/35 \n Installing : 1:cups-libs-1.6.3-51.el7.x86_64 8/35 \n Updating : cyrus-sasl-lib-2.1.26-24.el7_9.x86_64 9/35 \n Installing : samba-common-4.10.16-19.el7_9.noarch 10/35 \n Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 11/35 \n Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 12/35 \n Installing : 7:device-mapper-event-1.02.170-6.el7_9.5.x86_64 13/35 \n Installing : 7:lvm2-libs-2.02.187-6.el7_9.5.x86_64 14/35 \n Installing : device-mapper-persistent-data-0.8.5-3.el7_9.2.x86_64 15/35 \n Installing : 7:lvm2-2.02.187-6.el7_9.5.x86_64 16/35 \n Installing : psmisc-22.20-17.el7.x86_64 17/35 \n Installing : nettle-2.7.1-9.el7_9.x86_64 18/35 \n Installing : libatomic-4.8.5-44.el7.x86_64 19/35 \n Installing : libicu-50.2-4.el7_7.x86_64 20/35 \n Installing : gdb-7.6.1-120.el7.x86_64 21/35 \n Installing : bzip2-1.0.6-13.el7.x86_64 22/35 \n Installing : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 23/35 \n Installing : mssql-server-14.0.3451.2-1.x86_64 24/35 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\nSQL Server needs to be restarted in order to apply this setting. Please run\n'systemctl restart mssql-server.service'.\n Installing : trousers-0.3.14-2.el7.x86_64 25/35 \n Installing : gnutls-3.3.29-9.el7_6.x86_64 26/35 \n Installing : libwbclient-4.10.16-19.el7_9.x86_64 27/35 \n Installing : samba-client-libs-4.10.16-19.el7_9.x86_64 28/35 \n Installing : samba-common-libs-4.10.16-19.el7_9.x86_64 29/35 \n Installing : cifs-utils-6.2-10.el7.x86_64 30/35 \n Installing : resource-agents-4.1.1-61.el7_9.15.x86_64 31/35 \n Installing : mssql-server-ha-14.0.3451.2-1.x86_64 32/35 \n Installing : mssql-server-fts-14.0.3451.2-1.x86_64 33/35 \n Installing : powershell-7.2.5-1.rh.x86_64 34/35 \n Cleanup : cyrus-sasl-lib-2.1.26-23.el7.x86_64 35/35 \n Verifying : trousers-0.3.14-2.el7.x86_64 1/35 \n Verifying : 7:device-mapper-event-1.02.170-6.el7_9.5.x86_64 2/35 \n Verifying : libtevent-0.9.39-1.el7.x86_64 3/35 \n Verifying : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 4/35 \n Verifying : libtdb-1.3.18-1.el7.x86_64 5/35 \n Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 6/35 \n Verifying : resource-agents-4.1.1-61.el7_9.15.x86_64 7/35 \n Verifying : 1:cups-libs-1.6.3-51.el7.x86_64 8/35 \n Verifying : bzip2-1.0.6-13.el7.x86_64 9/35 \n Verifying : libldb-1.5.4-2.el7.x86_64 10/35 \n Verifying : samba-common-4.10.16-19.el7_9.noarch 11/35 \n Verifying : gdb-7.6.1-120.el7.x86_64 12/35 \n Verifying : libicu-50.2-4.el7_7.x86_64 13/35 \n Verifying : libwbclient-4.10.16-19.el7_9.x86_64 14/35 \n Verifying : 7:lvm2-2.02.187-6.el7_9.5.x86_64 15/35 \n Verifying : gnutls-3.3.29-9.el7_6.x86_64 16/35 \n Verifying : libatomic-4.8.5-44.el7.x86_64 17/35 \n Verifying : 7:lvm2-libs-2.02.187-6.el7_9.5.x86_64 18/35 \n Verifying : samba-client-libs-4.10.16-19.el7_9.x86_64 19/35 \n Verifying : libtalloc-2.1.16-1.el7.x86_64 20/35 \n Verifying : cifs-utils-6.2-10.el7.x86_64 21/35 \n Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 22/35 \n Verifying : samba-common-libs-4.10.16-19.el7_9.x86_64 23/35 \n Verifying : 7:device-mapper-event-libs-1.02.170-6.el7_9.5.x86_64 24/35 \n Verifying : nettle-2.7.1-9.el7_9.x86_64 25/35 \n Verifying : libaio-0.3.109-13.el7.x86_64 26/35 \n Verifying : mssql-server-14.0.3451.2-1.x86_64 27/35 \n Verifying : mssql-server-fts-14.0.3451.2-1.x86_64 28/35 \n Verifying : device-mapper-persistent-data-0.8.5-3.el7_9.2.x86_64 29/35 \n Verifying : mssql-server-ha-14.0.3451.2-1.x86_64 30/35 \n Verifying : cyrus-sasl-lib-2.1.26-24.el7_9.x86_64 31/35 \n Verifying : psmisc-22.20-17.el7.x86_64 32/35 \n Verifying : powershell-7.2.5-1.rh.x86_64 33/35 \n Verifying : avahi-libs-0.6.31-20.el7.x86_64 34/35 \n Verifying : cyrus-sasl-lib-2.1.26-23.el7.x86_64 35/35 \n\nInstalled:\n mssql-server.x86_64 0:14.0.3451.2-1 \n mssql-server-fts.x86_64 0:14.0.3451.2-1 \n mssql-server-ha.x86_64 0:14.0.3451.2-1 \n powershell.x86_64 0:7.2.5-1.rh \n\nDependency Installed:\n avahi-libs.x86_64 0:0.6.31-20.el7 \n bzip2.x86_64 0:1.0.6-13.el7 \n cifs-utils.x86_64 0:6.2-10.el7 \n cups-libs.x86_64 1:1.6.3-51.el7 \n cyrus-sasl.x86_64 0:2.1.26-24.el7_9 \n cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 \n device-mapper-event.x86_64 7:1.02.170-6.el7_9.5 \n device-mapper-event-libs.x86_64 7:1.02.170-6.el7_9.5 \n device-mapper-persistent-data.x86_64 0:0.8.5-3.el7_9.2 \n gdb.x86_64 0:7.6.1-120.el7 \n gnutls.x86_64 0:3.3.29-9.el7_6 \n libaio.x86_64 0:0.3.109-13.el7 \n libatomic.x86_64 0:4.8.5-44.el7 \n libicu.x86_64 0:50.2-4.el7_7 \n libldb.x86_64 0:1.5.4-2.el7 \n libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.13 \n libtalloc.x86_64 0:2.1.16-1.el7 \n libtdb.x86_64 0:1.3.18-1.el7 \n libtevent.x86_64 0:0.9.39-1.el7 \n libwbclient.x86_64 0:4.10.16-19.el7_9 \n lvm2.x86_64 7:2.02.187-6.el7_9.5 \n lvm2-libs.x86_64 7:2.02.187-6.el7_9.5 \n nettle.x86_64 0:2.7.1-9.el7_9 \n psmisc.x86_64 0:22.20-17.el7 \n resource-agents.x86_64 0:4.1.1-61.el7_9.15 \n samba-client-libs.x86_64 0:4.10.16-19.el7_9 \n samba-common.noarch 0:4.10.16-19.el7_9 \n samba-common-libs.x86_64 0:4.10.16-19.el7_9 \n trousers.x86_64 0:0.3.14-2.el7 \n\nDependency Updated:\n cyrus-sasl-lib.x86_64 0:2.1.26-24.el7_9 \n\nComplete!\n" ] } MSG: warning: /var/cache/yum/x86_64/7/base/packages/bzip2-1.0.6-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY Importing GPG key 0xF4A80EB5: Userid : "CentOS-7 Key (CentOS 7 Official Signing Key) " Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5 Package : centos-release-7-9.2009.1.el7.centos.x86_64 (installed) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 TASK [Remove mssql packages to keep them in cache only] ************************ task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 Wednesday 03 August 2022 15:21:04 +0000 (0:01:07.696) 0:02:05.961 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "removed": [ "mssql-server", "mssql-server-fts", "mssql-server-ha", "powershell" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:14.0.3451.2-1 will be erased\n---> Package mssql-server-fts.x86_64 0:14.0.3451.2-1 will be erased\n---> Package mssql-server-ha.x86_64 0:14.0.3451.2-1 will be erased\n---> Package powershell.x86_64 0:7.2.5-1.rh will be erased\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nRemoving:\n mssql-server x86_64 14.0.3451.2-1\n @packages-microsoft-com-mssql-server-2017 1.0 G\n mssql-server-fts\n x86_64 14.0.3451.2-1\n @packages-microsoft-com-mssql-server-2017 554 M\n mssql-server-ha\n x86_64 14.0.3451.2-1\n @packages-microsoft-com-mssql-server-2017 9.3 M\n powershell x86_64 7.2.5-1.rh @packages-microsoft-com-prod 183 M\n\nTransaction Summary\n================================================================================\nRemove 4 Packages\n\nInstalled size: 1.7 G\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Erasing : mssql-server-fts-14.0.3451.2-1.x86_64 1/4 \n Erasing : mssql-server-ha-14.0.3451.2-1.x86_64 2/4 \n Erasing : mssql-server-14.0.3451.2-1.x86_64 3/4 \n Erasing : powershell-7.2.5-1.rh.x86_64 4/4 \n Verifying : mssql-server-14.0.3451.2-1.x86_64 1/4 \n Verifying : mssql-server-ha-14.0.3451.2-1.x86_64 2/4 \n Verifying : powershell-7.2.5-1.rh.x86_64 3/4 \n Verifying : mssql-server-fts-14.0.3451.2-1.x86_64 4/4 \n\nRemoved:\n mssql-server.x86_64 0:14.0.3451.2-1 \n mssql-server-fts.x86_64 0:14.0.3451.2-1 \n mssql-server-ha.x86_64 0:14.0.3451.2-1 \n powershell.x86_64 0:7.2.5-1.rh \n\nComplete!\n" ] } TASK [Remove the Microsoft SQL Server 2017 repository] ************************* task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 Wednesday 03 August 2022 15:21:06 +0000 (0:00:01.768) 0:02:07.729 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "absent" } TASK [Configure the Microsoft SQL Server 2019 repository] ********************** task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 Wednesday 03 August 2022 15:21:06 +0000 (0:00:00.359) 0:02:08.089 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [Install required packages] *********************************************** task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 Wednesday 03 August 2022 15:21:07 +0000 (0:00:00.309) 0:02:08.398 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "installed": [ "mssql-server", "mssql-server-fts", "mssql-server-ha", "powershell" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.metrocast.net\n * extras: forksystems.mm.fcix.net\n * updates: mirrors.tripadvisor.com\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed\n--> Processing Dependency: python3 for package: mssql-server-15.0.4236.7-1.x86_64\n---> Package mssql-server-fts.x86_64 0:15.0.4236.7-1 will be installed\n---> Package mssql-server-ha.x86_64 0:15.0.4236.7-1 will be installed\n---> Package powershell.x86_64 0:7.2.5-1.rh will be installed\n--> Running transaction check\n---> Package python3.x86_64 0:3.6.8-18.el7 will be installed\n--> Processing Dependency: python3-libs(x86-64) = 3.6.8-18.el7 for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-setuptools for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-pip for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-18.el7.x86_64\n--> Running transaction check\n---> Package python3-libs.x86_64 0:3.6.8-18.el7 will be installed\n---> Package python3-pip.noarch 0:9.0.3-8.el7 will be installed\n---> Package python3-setuptools.noarch 0:39.2.0-10.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019\n 254 M\n mssql-server-fts x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019\n 225 M\n mssql-server-ha x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019\n 2.6 M\n powershell x86_64 7.2.5-1.rh packages-microsoft-com-prod 66 M\nInstalling for dependencies:\n python3 x86_64 3.6.8-18.el7 updates 70 k\n python3-libs x86_64 3.6.8-18.el7 updates 6.9 M\n python3-pip noarch 9.0.3-8.el7 base 1.6 M\n python3-setuptools noarch 39.2.0-10.el7 base 629 k\n\nTransaction Summary\n================================================================================\nInstall 4 Packages (+4 Dependent packages)\n\nTotal size: 556 M\nTotal download size: 491 M\nInstalled size: 2.0 G\nDownloading packages:\n--------------------------------------------------------------------------------\nTotal 49 MB/s | 491 MB 00:09 \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : python3-libs-3.6.8-18.el7.x86_64 1/8 \n Installing : python3-3.6.8-18.el7.x86_64 2/8 \n Installing : python3-setuptools-39.2.0-10.el7.noarch 3/8 \n Installing : python3-pip-9.0.3-8.el7.noarch 4/8 \n Installing : mssql-server-15.0.4236.7-1.x86_64 5/8 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\n Installing : mssql-server-fts-15.0.4236.7-1.x86_64 6/8 \n Installing : mssql-server-ha-15.0.4236.7-1.x86_64 7/8 \n Installing : powershell-7.2.5-1.rh.x86_64 8/8 \n Verifying : mssql-server-fts-15.0.4236.7-1.x86_64 1/8 \n Verifying : python3-setuptools-39.2.0-10.el7.noarch 2/8 \n Verifying : python3-libs-3.6.8-18.el7.x86_64 3/8 \n Verifying : mssql-server-ha-15.0.4236.7-1.x86_64 4/8 \n Verifying : mssql-server-15.0.4236.7-1.x86_64 5/8 \n Verifying : python3-3.6.8-18.el7.x86_64 6/8 \n Verifying : python3-pip-9.0.3-8.el7.noarch 7/8 \n Verifying : powershell-7.2.5-1.rh.x86_64 8/8 \n\nInstalled:\n mssql-server.x86_64 0:15.0.4236.7-1 \n mssql-server-fts.x86_64 0:15.0.4236.7-1 \n mssql-server-ha.x86_64 0:15.0.4236.7-1 \n powershell.x86_64 0:7.2.5-1.rh \n\nDependency Installed:\n python3.x86_64 0:3.6.8-18.el7 python3-libs.x86_64 0:3.6.8-18.el7 \n python3-pip.noarch 0:9.0.3-8.el7 python3-setuptools.noarch 0:39.2.0-10.el7 \n\nComplete!\n" ] } TASK [Remove mssql packages to keep them in cache only] ************************ task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 Wednesday 03 August 2022 15:22:18 +0000 (0:01:10.846) 0:03:19.245 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "removed": [ "mssql-server", "mssql-server-fts", "mssql-server-ha", "powershell" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be erased\n---> Package mssql-server-fts.x86_64 0:15.0.4236.7-1 will be erased\n---> Package mssql-server-ha.x86_64 0:15.0.4236.7-1 will be erased\n---> Package powershell.x86_64 0:7.2.5-1.rh will be erased\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nRemoving:\n mssql-server x86_64 15.0.4236.7-1\n @packages-microsoft-com-mssql-server-2019 1.2 G\n mssql-server-fts\n x86_64 15.0.4236.7-1\n @packages-microsoft-com-mssql-server-2019 554 M\n mssql-server-ha\n x86_64 15.0.4236.7-1\n @packages-microsoft-com-mssql-server-2019 9.4 M\n powershell x86_64 7.2.5-1.rh @packages-microsoft-com-prod 183 M\n\nTransaction Summary\n================================================================================\nRemove 4 Packages\n\nInstalled size: 1.9 G\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Erasing : mssql-server-ha-15.0.4236.7-1.x86_64 1/4 \n Erasing : mssql-server-fts-15.0.4236.7-1.x86_64 2/4 \n Erasing : mssql-server-15.0.4236.7-1.x86_64 3/4 \n Erasing : powershell-7.2.5-1.rh.x86_64 4/4 \n Verifying : mssql-server-fts-15.0.4236.7-1.x86_64 1/4 \n Verifying : mssql-server-15.0.4236.7-1.x86_64 2/4 \n Verifying : powershell-7.2.5-1.rh.x86_64 3/4 \n Verifying : mssql-server-ha-15.0.4236.7-1.x86_64 4/4 \n\nRemoved:\n mssql-server.x86_64 0:15.0.4236.7-1 \n mssql-server-fts.x86_64 0:15.0.4236.7-1 \n mssql-server-ha.x86_64 0:15.0.4236.7-1 \n powershell.x86_64 0:7.2.5-1.rh \n\nComplete!\n" ] } TASK [Remove the Microsoft SQL Server 2019 repository] ************************* task path: /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 Wednesday 03 August 2022 15:22:20 +0000 (0:00:01.943) 0:03:21.189 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "absent" } TASK [Remove the Microsoft SQL Server Tools repository] ************************ task path: /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:35 Wednesday 03 August 2022 15:22:20 +0000 (0:00:00.331) 0:03:21.520 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "absent" } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/centos-7.qcow2c.snap : ok=20 changed=14 unreachable=0 failed=0 skipped=2 rescued=0 ignored=0 Wednesday 03 August 2022 15:22:20 +0000 (0:00:00.320) 0:03:21.841 ****** =============================================================================== Install required packages ---------------------------------------------- 70.85s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 ----------------- Install required packages ---------------------------------------------- 67.70s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 ----------------- Create yum cache ------------------------------------------------------- 51.89s /cache/centos-7_setup.yml:15 -------------------------------------------------- Remove mssql packages to keep them in cache only ------------------------ 1.94s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 ----------------- Create EPEL 7 repo ------------------------------------------------------ 1.94s /cache/centos-7_setup.yml:5 --------------------------------------------------- Remove mssql packages to keep them in cache only ------------------------ 1.77s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 ----------------- Gathering Facts --------------------------------------------------------- 1.06s /cache/centos-7_setup.yml:1 --------------------------------------------------- Gathering Facts --------------------------------------------------------- 0.72s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:1 ----------------------------------- Deploy the GPG key for Microsoft repositories --------------------------- 0.71s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:9 ----------------------------------- Disable EPEL 7 ---------------------------------------------------------- 0.49s /cache/centos-7_setup.yml:27 -------------------------------------------------- Configure the Microsoft SQL Server Tools repository --------------------- 0.44s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:15 ---------------------------------- linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.40s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- Remove the Microsoft SQL Server 2017 repository ------------------------- 0.36s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 ----------------- Configure the Microsoft SQL Server 2017 repository ---------------------- 0.36s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 ------------------ Remove the Microsoft SQL Server 2019 repository ------------------------- 0.33s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 ----------------- Remove the Microsoft SQL Server Tools repository ------------------------ 0.32s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:35 ---------------------------------- Configure the Microsoft SQL Server 2019 repository ---------------------- 0.31s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 ------------------ linux-system-roles.mssql : Set platform/version specific variables ------ 0.10s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 --- Cache packages required for tests --------------------------------------- 0.03s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:22 ---------------------------------- Set facts used by role -------------------------------------------------- 0.03s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:3 ----------------------------------- PLAYBOOK: centos-7_post_setup.yml ********************************************** 1 plays in /cache/centos-7_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/centos-7_post_setup.yml:5 Wednesday 03 August 2022 15:22:20 +0000 (0:00:00.020) 0:03:21.862 ****** changed: [/cache/centos-7.qcow2c.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/centos-7_post_setup.yml:8 Wednesday 03 August 2022 15:22:21 +0000 (0:00:00.332) 0:03:22.194 ****** changed: [/cache/centos-7.qcow2c.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/centos-7.qcow2c.snap : ok=22 changed=16 unreachable=0 failed=0 skipped=2 rescued=0 ignored=0 Wednesday 03 August 2022 15:22:21 +0000 (0:00:00.478) 0:03:22.673 ****** =============================================================================== Install required packages ---------------------------------------------- 70.85s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 ----------------- Install required packages ---------------------------------------------- 67.70s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:10 ----------------- Create yum cache ------------------------------------------------------- 51.89s /cache/centos-7_setup.yml:15 -------------------------------------------------- Remove mssql packages to keep them in cache only ------------------------ 1.94s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 ----------------- Create EPEL 7 repo ------------------------------------------------------ 1.94s /cache/centos-7_setup.yml:5 --------------------------------------------------- Remove mssql packages to keep them in cache only ------------------------ 1.77s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:17 ----------------- Gathering Facts --------------------------------------------------------- 1.06s /cache/centos-7_setup.yml:1 --------------------------------------------------- Gathering Facts --------------------------------------------------------- 0.72s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:1 ----------------------------------- Deploy the GPG key for Microsoft repositories --------------------------- 0.71s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:9 ----------------------------------- Disable EPEL 7 ---------------------------------------------------------- 0.49s /cache/centos-7_setup.yml:27 -------------------------------------------------- shutdown guest ---------------------------------------------------------- 0.48s /cache/centos-7_post_setup.yml:8 ---------------------------------------------- Configure the Microsoft SQL Server Tools repository --------------------- 0.44s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:15 ---------------------------------- linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.40s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- Remove the Microsoft SQL Server 2017 repository ------------------------- 0.36s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 ----------------- Configure the Microsoft SQL Server 2017 repository ---------------------- 0.36s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 ------------------ force sync of filesystems - ensure setup changes are made to snapshot --- 0.33s /cache/centos-7_post_setup.yml:5 ---------------------------------------------- Remove the Microsoft SQL Server 2019 repository ------------------------- 0.33s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:22 ----------------- Remove the Microsoft SQL Server Tools repository ------------------------ 0.32s /tmp/tmpqg2s4pwm/tests/setup-snapshot.yml:35 ---------------------------------- Configure the Microsoft SQL Server 2019 repository ---------------------- 0.31s /tmp/tmpqg2s4pwm/tests/tasks/snapshot_install_packages.yml:3 ------------------ linux-system-roles.mssql : Set platform/version specific variables ------ 0.10s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 --- 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/tmp1kc47jky 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/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:3 Wednesday 03 August 2022 15:23:07 +0000 (0:00:00.013) 0:00:00.013 ****** ok: [/cache/centos-7.qcow2c.snap] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:12 Wednesday 03 August 2022 15:23:08 +0000 (0:00:01.182) 0:00:01.195 ****** TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Wednesday 03 August 2022 15:23:08 +0000 (0:00:00.110) 0:00:01.306 ****** included: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/centos-7.qcow2c.snap TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 15:23:08 +0000 (0:00:00.030) 0:00:01.336 ****** ok: [/cache/centos-7.qcow2c.snap] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.410) 0:00:01.747 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.061) 0:00:01.808 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:12 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.028) 0:00:01.837 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:16 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.028) 0:00:01.865 ****** skipping: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:22 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.022) 0:00:01.887 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.021) 0:00:01.909 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.041) 0:00:01.951 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.040) 0:00:01.991 ****** skipping: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:55 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.031) 0:00:02.023 ****** skipping: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:63 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.028) 0:00:02.052 ****** skipping: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:72 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.029) 0:00:02.082 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Gather package facts] ************************* task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 Wednesday 03 August 2022 15:23:09 +0000 (0:00:00.032) 0:00:02.115 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 Wednesday 03 August 2022 15:23:10 +0000 (0:00:01.217) 0:00:03.332 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 Wednesday 03 August 2022 15:23:10 +0000 (0:00:00.045) 0:00:03.377 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 Wednesday 03 August 2022 15:23:11 +0000 (0:00:00.694) 0:00:04.072 ****** skipping: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 Wednesday 03 August 2022 15:23:11 +0000 (0:00:00.045) 0:00:04.117 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 Wednesday 03 August 2022 15:23:11 +0000 (0:00:00.042) 0:00:04.160 ****** changed: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 Wednesday 03 August 2022 15:23:11 +0000 (0:00:00.451) 0:00:04.611 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.metrocast.net\n * extras: forksystems.mm.fcix.net\n * updates: mirrors.tripadvisor.com\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server\n x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019 254 M\n\nTransaction Summary\n================================================================================\nInstall 1 Package\n\nTotal size: 254 M\nInstalled size: 1.2 G\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : mssql-server-15.0.4236.7-1.x86_64 1/1 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\n Verifying : mssql-server-15.0.4236.7-1.x86_64 1/1 \n\nInstalled:\n mssql-server.x86_64 0:15.0.4236.7-1 \n\nComplete!\n" ] } TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 Wednesday 03 August 2022 15:23:48 +0000 (0:00:36.598) 0:00:41.210 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 Wednesday 03 August 2022 15:23:48 +0000 (0:00:00.028) 0:00:41.238 ****** ok: [/cache/centos-7.qcow2c.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.006277", "end": "2022-08-03 15:23:48.476423", "rc": 0, "start": "2022-08-03 15:23:48.470146" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 Wednesday 03 August 2022 15:23:49 +0000 (0:00:00.435) 0:00:41.674 ****** ok: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 Wednesday 03 August 2022 15:23:50 +0000 (0:00:01.091) 0:00:42.766 ****** fatal: [/cache/centos-7.qcow2c.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/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:21 Wednesday 03 August 2022 15:23:50 +0000 (0:00:00.065) 0:00:42.831 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/centos-7.qcow2c.snap : ok=15 changed=2 unreachable=0 failed=0 skipped=10 rescued=1 ignored=0 Wednesday 03 August 2022 15:23:50 +0000 (0:00:00.064) 0:00:42.896 ****** =============================================================================== linux-system-roles.mssql : Ensure the mssql-server package ------------- 36.60s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------ linux-system-roles.mssql : Gather package facts ------------------------- 1.22s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 ------- Gathering Facts --------------------------------------------------------- 1.18s /tmp/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:3 --------------------------- linux-system-roles.mssql : Gather system services facts ----------------- 1.09s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------ linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.69s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------ linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.45s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------ linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.44s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------ linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.41s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- Run the role with default parameters ------------------------------------ 0.11s /tmp/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:12 -------------------------- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------ Assert that the role failed with variables undefined -------------------- 0.06s /tmp/tmpqg2s4pwm/tests/tests_accept_eula_2019.yml:21 -------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 --- linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------ linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 ------- linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.04s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------ linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpqg2s4pwm/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/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 ------- linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.03s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:72 ------- linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 ------- linux-system-roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s /tmp/tmpqg2s4pwm/tests/roles/linux-system-roles.mssql/tasks/main.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/tmp1kc47jky 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/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:3 Wednesday 03 August 2022 15:45:35 +0000 (0:00:00.012) 0:00:00.012 ****** ok: [/cache/centos-7.qcow2c.snap] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:12 Wednesday 03 August 2022 15:45:36 +0000 (0:00:01.235) 0:00:01.248 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 03 August 2022 15:45:36 +0000 (0:00:00.144) 0:00:01.393 ****** included: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/centos-7.qcow2c.snap TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 15:45:36 +0000 (0:00:00.034) 0:00:01.427 ****** ok: [/cache/centos-7.qcow2c.snap] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.434) 0:00:01.862 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [/cache/centos-7.qcow2c.snap] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.071) 0:00:01.934 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.028) 0:00:01.963 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.030) 0:00:01.994 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.024) 0:00:02.018 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.025) 0:00:02.043 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.047) 0:00:02.091 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.047) 0:00:02.138 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.034) 0:00:02.173 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.039) 0:00:02.212 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.035) 0:00:02.248 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 Wednesday 03 August 2022 15:45:37 +0000 (0:00:00.031) 0:00:02.280 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 Wednesday 03 August 2022 15:45:38 +0000 (0:00:01.227) 0:00:03.507 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 Wednesday 03 August 2022 15:45:38 +0000 (0:00:00.085) 0:00:03.593 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 Wednesday 03 August 2022 15:45:39 +0000 (0:00:00.732) 0:00:04.325 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 Wednesday 03 August 2022 15:45:39 +0000 (0:00:00.045) 0:00:04.371 ****** skipping: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 Wednesday 03 August 2022 15:45:39 +0000 (0:00:00.042) 0:00:04.413 ****** changed: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 Wednesday 03 August 2022 15:45:40 +0000 (0:00:00.491) 0:00:04.905 ****** changed: [/cache/centos-7.qcow2c.snap] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.metrocast.net\n * extras: forksystems.mm.fcix.net\n * updates: mirrors.tripadvisor.com\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server\n x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019 254 M\n\nTransaction Summary\n================================================================================\nInstall 1 Package\n\nTotal size: 254 M\nInstalled size: 1.2 G\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : mssql-server-15.0.4236.7-1.x86_64 1/1 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\n Verifying : mssql-server-15.0.4236.7-1.x86_64 1/1 \n\nInstalled:\n mssql-server.x86_64 0:15.0.4236.7-1 \n\nComplete!\n" ] } TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Wednesday 03 August 2022 15:46:16 +0000 (0:00:36.547) 0:00:41.453 ****** skipping: [/cache/centos-7.qcow2c.snap] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 Wednesday 03 August 2022 15:46:16 +0000 (0:00:00.030) 0:00:41.483 ****** ok: [/cache/centos-7.qcow2c.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.006017", "end": "2022-08-03 15:46:16.352078", "rc": 0, "start": "2022-08-03 15:46:16.346061" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 Wednesday 03 August 2022 15:46:17 +0000 (0:00:00.448) 0:00:41.932 ****** ok: [/cache/centos-7.qcow2c.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/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Wednesday 03 August 2022 15:46:18 +0000 (0:00:01.082) 0:00:43.015 ****** fatal: [/cache/centos-7.qcow2c.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/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:21 Wednesday 03 August 2022 15:46:18 +0000 (0:00:00.065) 0:00:43.081 ****** ok: [/cache/centos-7.qcow2c.snap] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/centos-7.qcow2c.snap : ok=15 changed=2 unreachable=0 failed=0 skipped=10 rescued=1 ignored=0 Wednesday 03 August 2022 15:46:18 +0000 (0:00:00.063) 0:00:43.144 ****** =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 36.55s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 Gathering Facts --------------------------------------------------------- 1.24s /tmp/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:3 --------------------- fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.23s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.08s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.73s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.49s /tmp/tmp1kc47jky/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.45s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.44s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Run the role with default parameters ------------------------------------ 0.14s /tmp/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:12 -------------------- fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.09s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.07s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Assert that the role failed with variables undefined -------------------- 0.06s /tmp/tmplq_pq1x0/tests/mssql/tests_accept_eula_2019.yml:21 -------------------- fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.05s /tmp/tmp1kc47jky/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.05s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.04s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.04s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.04s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63 fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s /tmp/tmp1kc47jky/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44