# 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_configure_ha_cluster.yml *************************************** 1 plays in /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml PLAY [Verify the role on the primary node] ************************************* TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:3 Tuesday 04 October 2022 11:10:33 +0000 (0:00:00.024) 0:00:00.024 ******* ok: [sut] META: ran handlers TASK [Run the role] ************************************************************ task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:93 Tuesday 04 October 2022 11:10:35 +0000 (0:00:01.160) 0:00:01.185 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:99 Tuesday 04 October 2022 11:10:35 +0000 (0:00:00.037) 0:00:01.222 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [End EL < 8 host] ********************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:110 Tuesday 04 October 2022 11:10:35 +0000 (0:00:00.031) 0:00:01.253 ******* META: end_host conditional evaluated to false, continuing execution for sut skipping: [sut] => { "skip_reason": "end_host conditional evaluated to False, continuing execution for sut" } MSG: end_host conditional evaluated to false, continuing execution for sut TASK [Run role with mssql_replica_type=primary not defined for nodes] ********** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:116 Tuesday 04 October 2022 11:10:35 +0000 (0:00:00.034) 0:00:01.288 ******* 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:10:35 +0000 (0:00:00.272) 0:00:01.560 ******* 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:10:35 +0000 (0:00:00.081) 0:00:01.642 ******* 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:10:36 +0000 (0:00:00.535) 0:00:02.177 ******* 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:10:36 +0000 (0:00:00.136) 0:00:02.314 ******* 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:10:36 +0000 (0:00:00.103) 0:00:02.418 ******* 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:10:36 +0000 (0:00:00.090) 0:00:02.508 ******* 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:10:36 +0000 (0:00:00.069) 0:00:02.578 ******* 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:10:36 +0000 (0:00:00.058) 0:00:02.637 ******* 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:10:36 +0000 (0:00:00.074) 0:00:02.711 ******* 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:10:36 +0000 (0:00:00.076) 0:00:02.787 ******* 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:10:36 +0000 (0:00:00.100) 0:00:02.888 ******* 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:10:36 +0000 (0:00:00.086) 0:00:02.974 ******* 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:10:36 +0000 (0:00:00.060) 0:00:03.035 ******* 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:10:36 +0000 (0:00:00.075) 0:00:03.111 ******* fatal: [sut]: FAILED! => { "assertion": "mssql_ha_replica_type in __mssql_ha_replica_types_all", "changed": false, "evaluated_to": false } MSG: You must set the mssql_ha_replica_type variable to one of primary, synchronous, asynchronous, witness, absent TASK [Assert that the role failed with EL < 8 not supported] ******************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:124 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.118) 0:00:03.229 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [Set the mssql_ha_replica_type fact to appear in hostvars] **************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:131 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.087) 0:00:03.316 ******* ok: [sut] => { "ansible_facts": { "mssql_ha_replica_type": "primary" }, "changed": false } TASK [Set up test environment for the ha_cluster role] ************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:138 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.096) 0:00:03.413 ******* TASK [fedora.linux_system_roles.ha_cluster : Set node name to 'localhost' for single-node clusters] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/ha_cluster/tasks/test_setup.yml:9 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.065) 0:00:03.479 ******* ok: [sut] => { "ansible_facts": { "inventory_hostname": "localhost" }, "changed": false } TASK [fedora.linux_system_roles.ha_cluster : Ensure facts used by tests] ******* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/ha_cluster/tasks/test_setup.yml:14 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.081) 0:00:03.560 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.ha_cluster : Do not try to enable RHEL repositories] *** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/ha_cluster/tasks/test_setup.yml:20 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.032) 0:00:03.592 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } META: role_complete for sut TASK [Set facts to create test DBs on primary as a pre task] ******************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:143 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.046) 0:00:03.639 ******* ok: [sut] => { "ansible_facts": { "mssql_pre_input_sql_file": [ "create_ExampleDB1.sql", "create_ExampleDB2.sql" ] }, "changed": false } TASK [Run on all hosts to configure HA cluster] ******************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:150 Tuesday 04 October 2022 11:10:37 +0000 (0:00:00.057) 0:00:03.697 ******* 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:10:37 +0000 (0:00:00.090) 0:00:03.787 ******* 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:10:37 +0000 (0:00:00.041) 0:00:03.829 ******* 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:10:38 +0000 (0:00:00.492) 0:00:04.321 ******* 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:10:38 +0000 (0:00:00.083) 0:00:04.405 ******* 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:10:38 +0000 (0:00:00.048) 0:00:04.454 ******* 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:10:38 +0000 (0:00:00.052) 0:00:04.506 ******* 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:10:38 +0000 (0:00:00.039) 0:00:04.545 ******* 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:10:38 +0000 (0:00:00.037) 0:00:04.582 ******* 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:10:38 +0000 (0:00:00.036) 0:00:04.619 ******* 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:10:38 +0000 (0:00:00.035) 0:00:04.655 ******* 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:10:38 +0000 (0:00:00.079) 0:00:04.734 ******* 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:10:38 +0000 (0:00:00.077) 0:00:04.812 ******* 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:10:38 +0000 (0:00:00.068) 0:00:04.880 ******* 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:10:38 +0000 (0:00:00.062) 0:00:04.943 ******* ok: [sut] => { "changed": false } MSG: All assertions passed 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:10:38 +0000 (0:00:00.089) 0:00:05.033 ******* ok: [sut] => { "changed": false } MSG: All assertions passed 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:10:38 +0000 (0:00:00.103) 0:00:05.136 ******* 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:10:40 +0000 (0:00:01.759) 0:00:06.896 ******* 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:10:40 +0000 (0:00:00.184) 0:00:07.080 ******* 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:10:43 +0000 (0:00:02.132) 0:00:09.213 ******* 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:10:43 +0000 (0:00:00.149) 0:00:09.362 ******* 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:10:43 +0000 (0:00:00.206) 0:00:09.569 ******* 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:10:44 +0000 (0:00:01.124) 0:00:10.694 ******* 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:11:45 +0000 (0:01:00.628) 0:01:11.322 ******* 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:11:50 +0000 (0:00:05.301) 0:01:16.623 ******* 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.007007", "end": "2022-10-04 11:11:54.215065", "rc": 0, "start": "2022-10-04 11:11:54.208058" } 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:11:55 +0000 (0:00:04.855) 0:01:21.479 ******* 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:12:04 +0000 (0:00:09.338) 0:01:30.818 ******* 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 11:12:07 +0000 (0:00:02.899) 0:01:33.717 ******* fatal: [sut]: FAILED! => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "-n", "setup" ], "delta": "0:00:20.219873", "end": "2022-10-04 11:12:30.193991", "rc": 1, "start": "2022-10-04 11:12:09.974118" } STDOUT: The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition]. Capturing a dump of 5122 Successfully captured dump: /var/opt/mssql/log/core.sqlservr.10_4_2022_11_12_14.5122 Executing: /opt/mssql/bin/handle-crash.sh with parameters handle-crash.sh /opt/mssql/bin/sqlservr 5122 /opt/mssql/bin /var/opt/mssql/log/ d764e5a3-8aec-4a86-ae21-485e5e7fa0e8 bda8596a-4bf5-42a2-96f5-054d1fb3ee19 /var/opt/mssql/log/core.sqlservr.10_4_2022_11_12_14.5122 Fedora Linux 36 (Thirty Six) Capturing core dump and information to /var/opt/mssql/log... Tue Oct 4 11:12:17 UTC 2022 Capturing program information Dump already generated: /var/opt/mssql/log/core.sqlservr.10_4_2022_11_12_14.5122, moving to /var/opt/mssql/log/core.sqlservr.5122.temp/core.sqlservr.5122.gdmp Moving logs to /var/opt/mssql/log/core.sqlservr.5122.temp/log/paldumper-debug.log Tue Oct 4 11:12:18 UTC 2022 Capturing program binaries Tue Oct 4 11:12:30 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_11_12_16.5122.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=2104294&clcid=0x409 The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409 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 11:12:14 2022 The following diagnostic information is available: Reason: 0x00000001 Signal: SIGSEGV - Segmentation fault (11) Stack: IP Function ---------------- -------------------------------------- 0000558f697d362c 0000558f697d3072 0000558f697ed616 0000558f6977175b 00007fcc2ba3ea70 __restore_rt+0x0 0000000000000000 0000558f6978633e 0000558f6976da04 0000558f6976d829 Process: 5122 - sqlservr Thread: 5236 (application thread 0x1e0) Instance Id: d764e5a3-8aec-4a86-ae21-485e5e7fa0e8 Crash Id: bda8596a-4bf5-42a2-96f5-054d1fb3ee19 Build stamp: 552d94c177a9792ae44a9aaac32d760a081b9559704eef11a8058918a632fad6 Distribution: Fedora Linux 36 (Thirty Six) Processors: 2 Total Memory: 3910066176 bytes Timestamp: Tue Oct 4 11:12:14 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_configure_ha_cluster.retry PLAY RECAP ********************************************************************* sut : ok=29 changed=3 unreachable=0 failed=1 skipped=19 rescued=1 ignored=0 Tuesday 04 October 2022 11:12:30 +0000 (0:00:22.737) 0:01:56.454 ******* =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 60.63s /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 ------------------------- 22.74s /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 : Gather system services facts ---------- 9.34s /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 that the openldap-compat package is installed --- 5.30s /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 : Check if the errorlog file exists and its location --- 4.86s /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.90s /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 : Deploy the GPG key for Microsoft repositories --- 2.13s /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 : Gather package facts ------------------ 1.76s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 Gathering Facts --------------------------------------------------------- 1.16s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:3 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 1.12s /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 ----- 0.54s /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 ----- 0.49s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Run role with mssql_replica_type=primary not defined for nodes ---------- 0.27s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_configure_ha_cluster.yml:116 fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.21s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.21s /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 if mssql_version is not smaller then the existing SQL Server version --- 0.18s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.18s /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 --- 0.16s /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 : Unset the __mssql_sqlcmd_login_cmd fact --- 0.15s /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 : Update all packages from SQL Server 2017 repo --- 0.15s /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. ---^---^---^---^---^---