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/tmpn59lzvet
  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-8_setup.yml ***************************************************
1 plays in /cache/centos-8_setup.yml

PLAY [Enable HA repos] *********************************************************
META: ran handlers

TASK [Enable HA repos] *********************************************************
task path: /cache/centos-8_setup.yml:5
Wednesday 03 August 2022  15:20:38 +0000 (0:00:00.019)       0:00:00.019 ****** 
changed: [/cache/centos-8.qcow2] => {
    "ansible_facts": {
        "discovered_interpreter_python": "/usr/libexec/platform-python"
    },
    "changed": true,
    "cmd": [
        "dnf",
        "config-manager",
        "--set-enabled",
        "ha"
    ],
    "delta": "0:00:00.374836",
    "end": "2022-08-03 15:20:39.952348",
    "rc": 0,
    "start": "2022-08-03 15:20:39.577512"
}
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  15:20:39 +0000 (0:00:01.034)       0:00:01.053 ****** 
=============================================================================== 
Enable HA repos --------------------------------------------------------- 1.03s
/cache/centos-8_setup.yml:5 ---------------------------------------------------

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

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpek3rdkcs/tests/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  15:20:39 +0000 (0:00:00.009)       0:00:01.063 ****** 
ok: [/cache/centos-8.qcow2]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpek3rdkcs/tests/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  15:20:40 +0000 (0:00:01.106)       0:00:02.170 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022  15:20:41 +0000 (0:00:00.091)       0:00:02.261 ****** 
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/centos-8.qcow2

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  15:20:41 +0000 (0:00:00.030)       0:00:02.291 ****** 
ok: [/cache/centos-8.qcow2]

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

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

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

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

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

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

MSG:

All assertions passed

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

MSG:

All assertions passed

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

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

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

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

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

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

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

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

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

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

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022  15:20:46 +0000 (0:00:00.561)       0:00:07.941 ****** 
changed: [/cache/centos-8.qcow2] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: libpkgconf-1.4.2-1.el8.x86_64",
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: pkgconf-1.4.2-1.el8.x86_64",
        "Installed: pkgconf-m4-1.4.2-1.el8.noarch",
        "Installed: pkgconf-pkg-config-1.4.2-1.el8.x86_64",
        "Installed: glibc-headers-2.28-184.el8.x86_64",
        "Installed: isl-0.16.1-6.el8.x86_64",
        "Installed: python36-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64",
        "Installed: binutils-2.30-117.el8.x86_64",
        "Installed: libmpc-1.1.0-9.1.el8.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: mssql-server-15.0.4236.7-1.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: python3-setuptools-39.2.0-6.el8.noarch",
        "Installed: gcc-8.5.0-7.el8.x86_64",
        "Installed: gdb-8.2-19.el8.x86_64",
        "Installed: kernel-headers-4.18.0-408.el8.x86_64",
        "Installed: cpp-8.5.0-7.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-5.el8.x86_64",
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: glibc-devel-2.28-184.el8.x86_64",
        "Installed: python3-pip-9.0.3-22.el8.noarch",
        "Installed: cyrus-sasl-gssapi-2.1.27-5.el8.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-7.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022  15:21:51 +0000 (0:01:05.074)       0:01:13.015 ****** 
skipping: [/cache/centos-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022  15:21:51 +0000 (0:00:00.029)       0:01:13.045 ****** 
ok: [/cache/centos-8.qcow2] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.006563",
    "end": "2022-08-03 15:21:52.343273",
    "rc": 0,
    "start": "2022-08-03 15:21:52.336710"
}

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

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

MSG:

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

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

MSG:

All assertions passed
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  15:21:54 +0000 (0:00:00.156)       0:01:15.381 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 65.07s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 2.23s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.80s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Gather system services facts ----------------- 1.70s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
Gathering Facts --------------------------------------------------------- 1.11s
/tmp/tmpek3rdkcs/tests/tests_accept_eula_2019.yml:3 ---------------------------
Enable HA repos --------------------------------------------------------- 1.03s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.56s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.54s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.40s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------
Assert that the role failed with variables undefined -------------------- 0.16s
/tmp/tmpek3rdkcs/tests/tests_accept_eula_2019.yml:21 --------------------------
Run the role with default parameters ------------------------------------ 0.09s
/tmp/tmpek3rdkcs/tests/tests_accept_eula_2019.yml:12 --------------------------
linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.08s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------
linux-system-roles.mssql : Set platform/version specific variables ------ 0.05s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 ---
linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------
linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.05s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 -------
linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.04s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 -------
linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 -------
linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.03s
/tmp/tmpek3rdkcs/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/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 -------
ansible-playbook [core 2.12.6]
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3.9/site-packages/ansible
  ansible collection location = /tmp/tmpn59lzvet
  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-8_setup.yml ***************************************************
1 plays in /cache/centos-8_setup.yml

PLAY [Enable HA repos] *********************************************************
META: ran handlers

TASK [Enable HA repos] *********************************************************
task path: /cache/centos-8_setup.yml:5
Wednesday 03 August 2022  15:59:05 +0000 (0:00:00.019)       0:00:00.019 ****** 
changed: [/cache/centos-8.qcow2] => {
    "ansible_facts": {
        "discovered_interpreter_python": "/usr/libexec/platform-python"
    },
    "changed": true,
    "cmd": [
        "dnf",
        "config-manager",
        "--set-enabled",
        "ha"
    ],
    "delta": "0:00:00.370154",
    "end": "2022-08-03 15:59:05.082765",
    "rc": 0,
    "start": "2022-08-03 15:59:04.712611"
}
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  15:59:06 +0000 (0:00:01.015)       0:00:01.034 ****** 
=============================================================================== 
Enable HA repos --------------------------------------------------------- 1.02s
/cache/centos-8_setup.yml:5 ---------------------------------------------------

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

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

TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:3
Wednesday 03 August 2022  15:59:06 +0000 (0:00:00.010)       0:00:01.045 ****** 
ok: [/cache/centos-8.qcow2]
META: ran handlers

TASK [Run the role with default parameters] ************************************
task path: /tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:12
Wednesday 03 August 2022  15:59:07 +0000 (0:00:01.070)       0:00:02.115 ****** 

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

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022  15:59:07 +0000 (0:00:00.032)       0:00:02.263 ****** 
ok: [/cache/centos-8.qcow2]

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

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

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

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

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

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

MSG:

All assertions passed

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

MSG:

All assertions passed

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

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

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

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

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

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

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

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

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

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

TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
Wednesday 03 August 2022  15:59:13 +0000 (0:00:00.513)       0:00:08.003 ****** 
changed: [/cache/centos-8.qcow2] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: libpkgconf-1.4.2-1.el8.x86_64",
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: pkgconf-1.4.2-1.el8.x86_64",
        "Installed: pkgconf-m4-1.4.2-1.el8.noarch",
        "Installed: pkgconf-pkg-config-1.4.2-1.el8.x86_64",
        "Installed: glibc-headers-2.28-184.el8.x86_64",
        "Installed: isl-0.16.1-6.el8.x86_64",
        "Installed: python36-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64",
        "Installed: binutils-2.30-117.el8.x86_64",
        "Installed: libmpc-1.1.0-9.1.el8.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: mssql-server-15.0.4236.7-1.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: python3-setuptools-39.2.0-6.el8.noarch",
        "Installed: gcc-8.5.0-7.el8.x86_64",
        "Installed: gdb-8.2-19.el8.x86_64",
        "Installed: kernel-headers-4.18.0-408.el8.x86_64",
        "Installed: cpp-8.5.0-7.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-5.el8.x86_64",
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: glibc-devel-2.28-184.el8.x86_64",
        "Installed: python3-pip-9.0.3-22.el8.noarch",
        "Installed: cyrus-sasl-gssapi-2.1.27-5.el8.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-7.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022  16:00:28 +0000 (0:01:15.017)       0:01:23.021 ****** 
skipping: [/cache/centos-8.qcow2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022  16:00:28 +0000 (0:00:00.036)       0:01:23.057 ****** 
ok: [/cache/centos-8.qcow2] => {
    "changed": false,
    "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n  echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n  echo /var/opt/mssql/log/errorlog\nelse\n  echo \"\"\nfi\n",
    "delta": "0:00:00.004871",
    "end": "2022-08-03 16:00:27.561277",
    "rc": 0,
    "start": "2022-08-03 16:00:27.556406"
}

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

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

MSG:

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

TASK [Assert that the role failed with variables undefined] ********************
task path: /tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:21
Wednesday 03 August 2022  16:00:30 +0000 (0:00:00.070)       0:01:25.277 ****** 
ok: [/cache/centos-8.qcow2] => {
    "changed": false
}

MSG:

All assertions passed
META: ran handlers
META: ran handlers

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

Wednesday 03 August 2022  16:00:30 +0000 (0:00:00.067)       0:01:25.345 ****** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 75.02s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 2.08s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 2.08s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 
fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.69s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 
Gathering Facts --------------------------------------------------------- 1.07s
/tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:3 ---------------------
Enable HA repos --------------------------------------------------------- 1.02s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.53s
/tmp/tmpn59lzvet/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.51s
/tmp/tmpn59lzvet/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.46s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 
Run the role with default parameters ------------------------------------ 0.12s
/tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:12 --------------------
fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.07s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 
fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 
Assert that the role failed with variables undefined -------------------- 0.07s
/tmp/tmpsacc72k6/tests/mssql/tests_accept_eula_2019.yml:21 --------------------
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.05s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 
fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 
fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.05s
/tmp/tmpn59lzvet/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/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 
fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 0.04s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 
fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.03s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63