# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.13.3] 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-meta-remove-f36-support-onrIfw/.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-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:4 Tuesday 04 October 2022 11:13:26 +0000 (0:00:00.818) 0:00:00.818 ******* 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-meta-remove-f36-support-onrIfw/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-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:9 Tuesday 04 October 2022 11:13:27 +0000 (0:00:01.173) 0:00:01.991 ******* ok: [sut] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:18 Tuesday 04 October 2022 11:13:39 +0000 (0:00:11.937) 0:00:13.929 ******* TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Tuesday 04 October 2022 11:13:43 +0000 (0:00:03.526) 0:00:17.456 ******* included: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Tuesday 04 October 2022 11:13:43 +0000 (0:00:00.665) 0:00:18.122 ******* ok: [sut] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Tuesday 04 October 2022 11:13:45 +0000 (0:00:02.075) 0:00:20.197 ******* 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-meta-remove-f36-support-onrIfw/.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_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=Fedora_36.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_36.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Tuesday 04 October 2022 11:13:47 +0000 (0:00:01.713) 0:00:21.911 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Tuesday 04 October 2022 11:13:48 +0000 (0:00:01.308) 0:00:23.220 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:19 Tuesday 04 October 2022 11:13:50 +0000 (0:00:01.426) 0:00:24.646 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Tuesday 04 October 2022 11:13:51 +0000 (0:00:01.389) 0:00:26.035 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:36 Tuesday 04 October 2022 11:13:52 +0000 (0:00:01.149) 0:00:27.185 ******* skipping: [sut] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Tuesday 04 October 2022 11:13:53 +0000 (0:00:00.734) 0:00:27.920 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:48 Tuesday 04 October 2022 11:13:54 +0000 (0:00:01.140) 0:00:29.061 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:60 Tuesday 04 October 2022 11:13:56 +0000 (0:00:01.404) 0:00:30.465 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Tuesday 04 October 2022 11:13:59 +0000 (0:00:03.209) 0:00:33.674 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Tuesday 04 October 2022 11:14:00 +0000 (0:00:01.467) 0:00:35.142 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Tuesday 04 October 2022 11:14:02 +0000 (0:00:01.821) 0:00:36.964 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:92 Tuesday 04 October 2022 11:14:03 +0000 (0:00:00.764) 0:00:37.729 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Tuesday 04 October 2022 11:14:04 +0000 (0:00:00.683) 0:00:38.412 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Tuesday 04 October 2022 11:14:17 +0000 (0:00:12.998) 0:00:51.410 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 Tuesday 04 October 2022 11:14:18 +0000 (0:00:01.209) 0:00:52.620 ******* changed: [sut] => { "changed": true } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 Tuesday 04 October 2022 11:14:23 +0000 (0:00:05.402) 0:00:58.023 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:134 Tuesday 04 October 2022 11:14:24 +0000 (0:00:00.997) 0:00:59.021 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:140 Tuesday 04 October 2022 11:14:26 +0000 (0:00:01.793) 0:01:00.814 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:150 Tuesday 04 October 2022 11:14:31 +0000 (0:00:05.486) 0:01:06.300 ******* changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: numactl-libs-2.0.14-5.fc36.x86_64", "Installed: libatomic-12.2.1-2.fc36.x86_64", "Installed: boost-regex-1.76.0-12.fc36.x86_64", "Installed: cyrus-sasl-2.1.27-18.fc36.x86_64", "Installed: gcc-gdb-plugin-12.2.1-2.fc36.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-18.fc36.x86_64", "Installed: source-highlight-3.1.9-12.fc36.1.x86_64", "Installed: bzip2-1.0.8-11.fc36.x86_64", "Installed: gdb-12.1-1.fc36.x86_64", "Installed: mssql-server-15.0.4261.1-2.x86_64", "Installed: ctags-5.9-3.20220206.0.fc36.x86_64", "Installed: gdb-headless-12.1-1.fc36.x86_64", "Installed: libipt-2.0.5-1.fc36.x86_64", "Installed: libbabeltrace-1.5.8-9.fc36.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:158 Tuesday 04 October 2022 11:15:30 +0000 (0:00:58.330) 0:02:04.631 ******* ok: [sut] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Tuesday 04 October 2022 11:15:33 +0000 (0:00:02.982) 0:02:07.614 ******* 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.007082", "end": "2022-10-04 11:15:33.822035", "rc": 0, "start": "2022-10-04 11:15:33.814953" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 Tuesday 04 October 2022 11:15:33 +0000 (0:00:00.618) 0:02:08.232 ******* 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-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:195 Tuesday 04 October 2022 11:15:36 +0000 (0:00:02.851) 0:02:11.084 ******* 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-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:27 Tuesday 04 October 2022 11:15:37 +0000 (0:00:00.366) 0:02:11.451 ******* ok: [sut] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* sut : ok=17 changed=3 unreachable=0 failed=0 skipped=11 rescued=1 ignored=0 Tuesday 04 October 2022 11:15:37 +0000 (0:00:00.197) 0:02:11.648 ******* =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 58.33s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:150 fedora.linux_system_roles.mssql : Gather package facts ----------------- 13.00s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Gathering Facts -------------------------------------------------------- 11.94s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:9 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 5.45s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:140 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 5.40s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 Run the role with default parameters ------------------------------------ 3.53s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:18 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 3.21s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:60 fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 2.98s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:158 fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.85s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 2.08s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 1.83s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:134 fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 1.82s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 1.71s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 1.47s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 1.43s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 1.40s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:48 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 1.39s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:19 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 1.31s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 1.21s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Include vault variables ------------------------------------------------- 1.17s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_accept_eula_2019.yml:4 ---^---^---^---^---^--- # 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. ---^---^---^---^---^---