# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.13.6] config file = /etc/ansible/ansible.cfg configured module search path = ['/home/jenkins/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /opt/ansible-2.13/lib/python3.8/site-packages/ansible ansible collection location = /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection executable location = /opt/ansible-2.13/bin/ansible-playbook python version = 3.8.13 (default, Jun 24 2022, 15:27:57) [GCC 8.5.0 20210514 (Red Hat 8.5.0-13)] jinja version = 3.1.2 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 ******************************************* 2 plays in /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:4 Monday 05 December 2022 14:58:25 +0000 (0:00:00.056) 0:00:00.057 ******* ok: [sut] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:9 Monday 05 December 2022 14:58:25 +0000 (0:00:00.138) 0:00:00.195 ******* ok: [sut] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:18 Monday 05 December 2022 14:58:29 +0000 (0:00:03.729) 0:00:03.925 ******* TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Monday 05 December 2022 14:58:30 +0000 (0:00:00.593) 0:00:04.518 ******* included: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for sut TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Monday 05 December 2022 14:58:30 +0000 (0:00:00.188) 0:00:04.707 ******* ok: [sut] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Monday 05 December 2022 14:58:31 +0000 (0:00:00.880) 0:00:05.587 ******* ok: [sut] => (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": [ "/WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=Fedora.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=Fedora_35.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_35.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=Fedora_35.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_35.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Monday 05 December 2022 14:58:31 +0000 (0:00:00.081) 0:00:05.668 ******* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Monday 05 December 2022 14:58:31 +0000 (0:00:00.051) 0:00:05.720 ******* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:19 Monday 05 December 2022 14:58:31 +0000 (0:00:00.059) 0:00:05.780 ******* skipping: [sut] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Monday 05 December 2022 14:58:31 +0000 (0:00:00.095) 0:00:05.875 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:36 Monday 05 December 2022 14:58:31 +0000 (0:00:00.105) 0:00:05.980 ******* skipping: [sut] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Monday 05 December 2022 14:58:31 +0000 (0:00:00.082) 0:00:06.062 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:48 Monday 05 December 2022 14:58:31 +0000 (0:00:00.070) 0:00:06.133 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:60 Monday 05 December 2022 14:58:31 +0000 (0:00:00.112) 0:00:06.245 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Monday 05 December 2022 14:58:32 +0000 (0:00:00.206) 0:00:06.452 ******* skipping: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Monday 05 December 2022 14:58:32 +0000 (0:00:00.117) 0:00:06.569 ******* skipping: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Monday 05 December 2022 14:58:32 +0000 (0:00:00.095) 0:00:06.665 ******* skipping: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:92 Monday 05 December 2022 14:58:32 +0000 (0:00:00.395) 0:00:07.060 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Monday 05 December 2022 14:58:32 +0000 (0:00:00.155) 0:00:07.216 ******* ok: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Monday 05 December 2022 14:58:36 +0000 (0:00:03.994) 0:00:11.211 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 Monday 05 December 2022 14:58:37 +0000 (0:00:00.289) 0:00:11.500 ******* changed: [sut] => { "changed": true } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 Monday 05 December 2022 14:58:38 +0000 (0:00:01.607) 0:00:13.108 ******* skipping: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:134 Monday 05 December 2022 14:58:38 +0000 (0:00:00.217) 0:00:13.325 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:140 Monday 05 December 2022 14:58:39 +0000 (0:00:00.141) 0:00:13.466 ******* changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] ******* task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:150 Monday 05 December 2022 14:58:39 +0000 (0:00:00.831) 0:00:14.298 ******* changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: bzip2-1.0.8-9.fc35.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-14.fc35.x86_64", "Installed: gcc-gdb-plugin-11.3.1-3.fc35.x86_64", "Installed: openssl-1:1.1.1q-1.fc35.x86_64", "Installed: source-highlight-3.1.9-15.fc35.x86_64", "Installed: xxhash-libs-0.8.1-1.fc35.x86_64", "Installed: mssql-server-15.0.4261.1-2.x86_64", "Installed: libatomic-11.3.1-3.fc35.x86_64", "Installed: numactl-libs-2.0.14-4.fc35.x86_64", "Installed: libipt-2.0.4-3.fc35.x86_64", "Installed: libbabeltrace-1.5.8-8.fc35.x86_64", "Installed: gdb-12.1-1.fc35.x86_64", "Installed: ctags-5.9-1.20210725.0.fc35.x86_64", "Installed: boost-regex-1.76.0-5.fc35.x86_64", "Installed: gdb-headless-12.1-1.fc35.x86_64", "Installed: libicu-69.1-6.fc35.x86_64", "Installed: cyrus-sasl-2.1.27-14.fc35.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:158 Monday 05 December 2022 14:59:35 +0000 (0:00:55.200) 0:01:09.498 ******* changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: openldap-compat-2.4.59-3.fc35.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Monday 05 December 2022 14:59:38 +0000 (0:00:03.613) 0:01:13.111 ******* ok: [sut] => { "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.007406", "end": "2022-12-05 14:59:39.090755", "rc": 0, "start": "2022-12-05 14:59:39.083349" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 Monday 05 December 2022 14:59:39 +0000 (0:00:00.459) 0:01:13.571 ******* ok: [sut] => { "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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:195 Monday 05 December 2022 14:59:41 +0000 (0:00:02.615) 0:01:16.187 ******* fatal: [sut]: FAILED! => { "assertion": "mssql_edition 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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:27 Monday 05 December 2022 14:59:41 +0000 (0:00:00.186) 0:01:16.373 ******* ok: [sut] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* sut : ok=17 changed=4 unreachable=0 failed=0 skipped=11 rescued=1 ignored=0 Monday 05 December 2022 14:59:42 +0000 (0:00:00.121) 0:01:16.494 ******* =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 55.20s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:150 fedora.linux_system_roles.mssql : Gather package facts ------------------ 3.99s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Gathering Facts --------------------------------------------------------- 3.73s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:9 fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 3.61s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:158 fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.62s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.61s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.88s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/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.83s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:140 Run the role with default parameters ------------------------------------ 0.59s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:18 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.46s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.40s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.29s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.22s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.21s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:60 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.19s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.19s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:195 fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.16s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:92 fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.14s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:134 Include vault variables ------------------------------------------------- 0.14s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:4 Assert that the role failed with variables undefined -------------------- 0.12s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_accept_eula_2019.yml:27 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- [DEPRECATION WARNING]: [defaults]callback_whitelist option, normalizing names to new standard, use callbacks_enabled instead. This feature will be removed from ansible-core in version 2.15. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. ---^---^---^---^---^---