# 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_upgrade_2017.yml *********************************************** 2 plays in /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:4 Tuesday 04 October 2022 13:08:53 +0000 (0:00:00.273) 0:00:00.273 ******* 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 installs version 2017 and upgrades to 2019] ********* TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:9 Tuesday 04 October 2022 13:08:54 +0000 (0:00:00.801) 0:00:01.075 ******* ok: [sut] META: ran handlers TASK [Run the role with incorrect mssql_version] ******************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:18 Tuesday 04 October 2022 13:09:00 +0000 (0:00:06.135) 0:00:07.211 ******* 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 13:09:02 +0000 (0:00:01.879) 0:00:09.090 ******* 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 13:09:03 +0000 (0:00:00.506) 0:00:09.596 ******* 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 13:09:05 +0000 (0:00:02.521) 0:00:12.118 ******* 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 13:09:06 +0000 (0:00:01.128) 0:00:13.247 ******* 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 13:09:07 +0000 (0:00:00.659) 0:00:13.906 ******* 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 13:09:08 +0000 (0:00:00.618) 0:00:14.524 ******* 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 13:09:08 +0000 (0:00:00.621) 0:00:15.146 ******* 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 13:09:09 +0000 (0:00:00.595) 0:00:15.741 ******* 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 13:09:10 +0000 (0:00:00.678) 0:00:16.419 ******* 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 13:09:10 +0000 (0:00:00.529) 0:00:16.949 ******* 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 13:09:11 +0000 (0:00:01.127) 0:00:18.117 ******* fatal: [sut]: FAILED! => { "assertion": "mssql_version | int == 2017 or mssql_version | int == 2019", "changed": false, "evaluated_to": false } MSG: The mssql_version variable must be set to either 2017 or 2019. TASK [Assert that the role failed with the correct message] ******************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:29 Tuesday 04 October 2022 13:09:13 +0000 (0:00:01.260) 0:00:19.377 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [Run the role with mssql_version 2017 and mssql_upgrade true] ************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:37 Tuesday 04 October 2022 13:09:14 +0000 (0:00:01.197) 0:00:20.574 ******* 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 13:09:15 +0000 (0:00:01.614) 0:00:22.189 ******* 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 13:09:16 +0000 (0:00:00.669) 0:00:22.858 ******* 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 13:09:19 +0000 (0:00:02.440) 0:00:25.299 ******* 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 13:09:20 +0000 (0:00:01.098) 0:00:26.397 ******* 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 13:09:20 +0000 (0:00:00.516) 0:00:26.914 ******* 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 13:09:21 +0000 (0:00:00.691) 0:00:27.606 ******* 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 13:09:21 +0000 (0:00:00.672) 0:00:28.278 ******* 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 13:09:22 +0000 (0:00:00.415) 0:00:28.694 ******* 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 13:09:22 +0000 (0:00:00.548) 0:00:29.242 ******* 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 13:09:23 +0000 (0:00:00.426) 0:00:29.669 ******* 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 13:09:24 +0000 (0:00:00.969) 0:00:30.638 ******* 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 13:09:25 +0000 (0:00:01.185) 0:00:31.823 ******* fatal: [sut]: FAILED! => { "changed": false } MSG: ['You set mssql_upgrade to true and mssql_version to 2017.', 'If you want to upgrade, set the variables as such:', 'mssql_version: 2019', 'mssql_upgrade: true'] TASK [Assert that the role failed with the correct message] ******************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:49 Tuesday 04 October 2022 13:09:26 +0000 (0:00:01.359) 0:00:33.183 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [Set up MSSQL 2017] ******************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:55 Tuesday 04 October 2022 13:09:27 +0000 (0:00:00.598) 0:00:33.781 ******* 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 13:09:28 +0000 (0:00:01.465) 0:00:35.246 ******* 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 13:09:29 +0000 (0:00:00.828) 0:00:36.075 ******* 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 13:09:31 +0000 (0:00:01.992) 0:00:38.067 ******* 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 13:09:32 +0000 (0:00:01.226) 0:00:39.294 ******* 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 13:09:33 +0000 (0:00:00.584) 0:00:39.878 ******* 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 13:09:34 +0000 (0:00:00.526) 0:00:40.405 ******* 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 13:09:34 +0000 (0:00:00.344) 0:00:40.749 ******* 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 13:09:35 +0000 (0:00:00.774) 0:00:41.523 ******* 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 13:09:35 +0000 (0:00:00.647) 0:00:42.170 ******* 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 13:09:36 +0000 (0:00:00.734) 0:00:42.904 ******* 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 13:09:37 +0000 (0:00:01.288) 0:00:44.193 ******* 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 13:09:38 +0000 (0:00:00.835) 0:00:45.029 ******* 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 13:09:39 +0000 (0:00:01.132) 0:00:46.162 ******* 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 13:09:40 +0000 (0:00:00.703) 0:00:46.865 ******* 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 13:09:41 +0000 (0:00:00.995) 0:00:47.861 ******* 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 13:09:42 +0000 (0:00:00.722) 0:00:48.584 ******* 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 13:09:48 +0000 (0:00:06.570) 0:00:55.155 ******* 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 13:09:49 +0000 (0:00:00.924) 0:00:56.079 ******* 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 13:09:54 +0000 (0:00:04.811) 0:01:00.891 ******* 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 13:09:55 +0000 (0:00:01.256) 0:01:02.147 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2017 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 13:09:56 +0000 (0:00:00.948) 0:01:03.096 ******* changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "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 13:10:00 +0000 (0:00:03.319) 0:01:06.415 ******* changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: graphite2-1.3.14-9.fc36.x86_64", "Installed: fontconfig-2.14.0-1.fc36.x86_64", "Installed: go-srpm-macros-3.2.0-1.fc36.noarch", "Installed: bzip2-1.0.8-11.fc36.x86_64", "Installed: libXrender-0.9.10-16.fc36.x86_64", "Installed: ctags-5.9-3.20220206.0.fc36.x86_64", "Installed: tcl-1:8.6.12-2.fc36.x86_64", "Installed: libbabeltrace-1.5.8-9.fc36.x86_64", "Installed: nim-srpm-macros-3-6.fc36.noarch", "Installed: fonts-srpm-macros-1:2.0.5-7.fc36.noarch", "Installed: kernel-srpm-macros-1.0-14.fc36.noarch", "Installed: package-notes-srpm-macros-0.4-14.fc36.noarch", "Installed: harfbuzz-4.0.0-2.fc36.x86_64", "Installed: numactl-libs-2.0.14-5.fc36.x86_64", "Installed: freetype-2.12.1-2.fc36.x86_64", "Installed: libatomic-12.2.1-2.fc36.x86_64", "Installed: libxcb-1.13.1-9.fc36.x86_64", "Installed: python-srpm-macros-3.10-19.fc36.noarch", "Installed: mssql-server-14.0.3456.2-3.x86_64", "Installed: cyrus-sasl-2.1.27-18.fc36.x86_64", "Installed: python2.7-2.7.18-22.fc36.x86_64", "Installed: lua-srpm-macros-1-6.fc36.noarch", "Installed: xml-common-0.6.3-58.fc36.noarch", "Installed: gcc-gdb-plugin-12.2.1-2.fc36.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-18.fc36.x86_64", "Installed: libX11-1.7.3.1-2.fc36.x86_64", "Installed: libX11-common-1.7.3.1-2.fc36.noarch", "Installed: qt5-srpm-macros-5.15.6-1.fc36.noarch", "Installed: libXau-1.0.9-8.fc36.x86_64", "Installed: gcc-plugin-annobin-12.2.1-2.fc36.x86_64", "Installed: ghc-srpm-macros-1.5.0-6.fc36.noarch", "Installed: boost-regex-1.76.0-12.fc36.x86_64", "Installed: rpmautospec-rpm-macros-0.3.0-1.fc36.noarch", "Installed: dwz-0.14-4.fc36.x86_64", "Installed: redhat-rpm-config-222-1.fc36.noarch", "Installed: source-highlight-3.1.9-12.fc36.1.x86_64", "Installed: annobin-docs-10.81-1.fc36.noarch", "Installed: annobin-plugin-gcc-10.81-1.fc36.x86_64", "Installed: fpc-srpm-macros-1.3-5.fc36.noarch", "Installed: efi-srpm-macros-5-5.fc36.noarch", "Installed: libpng-2:1.6.37-12.fc36.x86_64", "Installed: tix-1:8.4.3-33.fc36.x86_64", "Installed: tk-1:8.6.12-2.fc36.x86_64", "Installed: openblas-srpm-macros-2-11.fc36.noarch", "Installed: openssl1.1-1:1.1.1q-1.fc36.x86_64", "Installed: ansible-srpm-macros-1-7.fc36.noarch", "Installed: ocaml-srpm-macros-6-6.fc36.noarch", "Installed: libXft-2.3.4-2.fc36.x86_64", "Installed: gdb-12.1-1.fc36.x86_64", "Installed: rust-srpm-macros-22-1.fc36.noarch", "Installed: gdb-headless-12.1-1.fc36.x86_64", "Installed: gnat-srpm-macros-4-15.fc36.noarch", "Installed: libipt-2.0.5-1.fc36.x86_64", "Installed: perl-srpm-macros-1-43.fc36.noarch" ] } 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 13:11:06 +0000 (0:01:06.072) 0:02:12.487 ******* 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 13:11:14 +0000 (0:00:08.432) 0:02:20.920 ******* 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.007389", "end": "2022-10-04 13:11:16.623840", "rc": 0, "start": "2022-10-04 13:11:16.616451" } 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 13:11:17 +0000 (0:00:02.437) 0:02:23.358 ******* 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 13:11:23 +0000 (0:00:06.590) 0:02:29.949 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Set up MSSQL] ************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:205 Tuesday 04 October 2022 13:11:26 +0000 (0:00:02.367) 0:02:32.337 ******* fatal: [sut]: FAILED! => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "-n", "setup" ], "delta": "0:00:14.655658", "end": "2022-10-04 13:11:41.650046", "rc": 1, "start": "2022-10-04 13:11:26.994388" } STDOUT: The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition]. Capturing a dump of 5651 Successfully captured dump: /var/opt/mssql/log/core.sqlservr.10_4_2022_13_11_31.5651 Executing: /opt/mssql/bin/handle-crash.sh with parameters handle-crash.sh /opt/mssql/bin/sqlservr 5651 /opt/mssql/bin /var/opt/mssql/log/ 2c707e90-8eed-4bbc-b317-27e02016320d 70b7f83b-87fb-4f53-b478-85a9e5a1d6ce /var/opt/mssql/log/core.sqlservr.10_4_2022_13_11_31.5651 Fedora Linux 36 (Thirty Six) Capturing core dump and information to /var/opt/mssql/log... Tue Oct 4 13:11:34 UTC 2022 Capturing program information Dump already generated: /var/opt/mssql/log/core.sqlservr.10_4_2022_13_11_31.5651, moving to /var/opt/mssql/log/core.sqlservr.5651.temp/core.sqlservr.5651.gdmp Moving logs to /var/opt/mssql/log/core.sqlservr.5651.temp/log/paldumper-debug.log Tue Oct 4 13:11:34 UTC 2022 Capturing program binaries Tue Oct 4 13:11:41 UTC 2022 Compressing the dump files Core dump and information are being compressed in the background. When complete, they can be found in the following location: /var/opt/mssql/log/core.sqlservr.10_04_2022_13_11_33.5651.tbz2 The license terms for this product can be found in /usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409 The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409 Input encoding cannot be detected. SQL Server will attempt to decode input as UTF-8 Configuring SQL Server... Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG in /var/opt/mssql/log for more information. STDERR: This program has encountered a fatal error and cannot continue running at Tue Oct 4 13:11:31 2022 The following diagnostic information is available: Reason: 0x00000001 Signal: SIGSEGV - Segmentation fault (11) Stack: IP Function ---------------- -------------------------------------- 000056385a0c776c 000056385a0c71b2 000056385a0debf6 000056385a0619cb 00007fa46d23ea70 __restore_rt+0x0 0000000000000000 000056385a069f5e 000056385a05dc74 000056385a05da99 Process: 5651 - sqlservr Thread: 5762 (application thread 0x1d4) Instance Id: 2c707e90-8eed-4bbc-b317-27e02016320d Crash Id: 70b7f83b-87fb-4f53-b478-85a9e5a1d6ce Build stamp: ecb90f5aaacc5cddc8c256d6bcc124ced54f0cf1bb11cd841ea2eab39ff974bd Distribution: Fedora Linux 36 (Thirty Six) Processors: 2 Total Memory: 3910074368 bytes Timestamp: Tue Oct 4 13:11:31 2022 Hint: You are currently not seeing messages from other users and the system. Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages. Pass -q to turn off this notice. No journal files were opened due to insufficient permissions. Hint: You are currently not seeing messages from other users and the system. Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages. Pass -q to turn off this notice. No journal files were opened due to insufficient permissions. /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: Permission denied /usr/bin/find: ‘/usr/share/empty.sshd’: Permission denied /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: Permission denied MSG: non-zero return code to retry, use: --limit @/tmp/tests_upgrade_2017.retry PLAY RECAP ********************************************************************* sut : ok=32 changed=3 unreachable=0 failed=1 skipped=19 rescued=2 ignored=0 Tuesday 04 October 2022 13:11:41 +0000 (0:00:15.751) 0:02:48.089 ******* =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 66.07s /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 : Set up MSSQL ------------------------- 15.75s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:205 fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 8.43s /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 ---------- 6.59s /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 : Gather package facts ------------------ 6.57s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Gathering Facts --------------------------------------------------------- 6.14s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:9 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 4.79s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2017 repository --- 3.32s /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 : Ensure ansible_facts used by role ----- 2.52s /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 : Ensure ansible_facts used by role ----- 2.44s /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 : Check if the errorlog file exists and its location --- 2.44s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 2.39s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:195 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 1.99s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Run the role with incorrect mssql_version ------------------------------- 1.88s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:18 Run the role with mssql_version 2017 and mssql_upgrade true ------------- 1.61s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:37 Set up MSSQL 2017 ------------------------------------------------------- 1.47s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_upgrade_2017.yml:55 fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 1.36s /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 : Verify that the user accepts EULA variables --- 1.29s /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 : Verify if the mssql_version variable is provided correctly --- 1.26s /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 : Update all packages from SQL Server 2017 repo --- 1.26s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 ---^---^---^---^---^--- # 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. ---^---^---^---^---^---