# 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_tls_2019.yml *************************************************** 2 plays in /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:4 Tuesday 04 October 2022 12:43:45 +0000 (0:00:00.755) 0:00:00.755 ******* 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 tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:9 Tuesday 04 October 2022 12:43:47 +0000 (0:00:02.241) 0:00:02.997 ******* ok: [sut] META: ran handlers TASK [Ensure the openssl package] ********************************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:19 Tuesday 04 October 2022 12:44:08 +0000 (0:00:20.474) 0:00:23.472 ******* ok: [sut] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [Create a tempfile for a certificate on hosts] **************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:25 Tuesday 04 October 2022 12:44:20 +0000 (0:00:12.113) 0:00:35.585 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible._97xdk9k", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 0, "state": "file", "uid": 0 } TASK [Create a tempfile for a private key on hosts] **************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:31 Tuesday 04 October 2022 12:44:31 +0000 (0:00:11.298) 0:00:46.883 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.at7ebfw5", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 0, "state": "file", "uid": 0 } TASK [Generate a self-signed certificate and public key] *********************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:37 Tuesday 04 October 2022 12:44:35 +0000 (0:00:03.983) 0:00:50.867 ******* changed: [sut] => { "changed": true, "cmd": [ "openssl", "req", "-x509", "-nodes", "-newkey", "rsa:2048", "-subj", "/CN=10.31.9.147", "-out", "/tmp/ansible._97xdk9k", "-keyout", "/tmp/ansible.at7ebfw5", "-days", "365" ], "delta": "0:00:00.312898", "end": "2022-10-04 12:44:40.607700", "rc": 0, "start": "2022-10-04 12:44:40.294802" } STDERR: .+...+.........+..............+.+........+.+..+...+....+...+.....+...+....+..+.+.................+............+..........+........+..........+.....+............+....+.....+.+...+...+..+..........+....................+...+.......+..+....+......+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..........+..+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.+...+.+.........+.........+...+.........+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ .............................+.+......+......+.........+......+..+.......+........+.......+...........+............+............+...+......+.+...+.....+.+.........+..+.+..+.+............+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.+.........+.....+...+......+....+..+.+...+.........+............+.....+...+...+.......+...+...+..+.......+...........+.+......+..+.............+.....+....+......+...+.....+.........+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*........+...+....+........+...+...+.+...+...+............+..+...+......+.+.........+.....+....+.....+............+....+..+.............+..+..................+.+.........+...........+.+....................+.........+.............+...............+..+......+..................+.......+..+.+..+...+.+...+......+.....+......+.+...............+..+.............+...+............+...+......+...+........+.......+.....+.+..+....+...+..+.+..+.+....................+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ----- TASK [Copy certificate files to local tmp] ************************************* task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:46 Tuesday 04 October 2022 12:44:41 +0000 (0:00:05.806) 0:00:56.673 ******* changed: [sut] => (item=/tmp/ansible._97xdk9k) => { "ansible_loop_var": "item", "changed": true, "checksum": "e8579c2433a6423cb727e4bb27913e25b6a9f75a", "dest": "/tmp/ansible._97xdk9k", "item": "/tmp/ansible._97xdk9k", "md5sum": "a20f808e01f961f407a984ca5ac43805", "remote_checksum": "e8579c2433a6423cb727e4bb27913e25b6a9f75a", "remote_md5sum": null } changed: [sut] => (item=/tmp/ansible.at7ebfw5) => { "ansible_loop_var": "item", "changed": true, "checksum": "7f1b3cde39108f68bebf6bb4811bc897cb0eb0ad", "dest": "/tmp/ansible.at7ebfw5", "item": "/tmp/ansible.at7ebfw5", "md5sum": "44ae60f5db0ef17c3513f6b046078b85", "remote_checksum": "7f1b3cde39108f68bebf6bb4811bc897cb0eb0ad", "remote_md5sum": null } TASK [Copy a private key to the playbook directory to test a relative path] **** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:58 Tuesday 04 October 2022 12:44:54 +0000 (0:00:12.848) 0:01:09.521 ******* changed: [sut -> localhost] => { "changed": true, "checksum": "7f1b3cde39108f68bebf6bb4811bc897cb0eb0ad", "dest": "./ansible.at7ebfw5", "gid": 1001, "group": "jenkins", "md5sum": "44ae60f5db0ef17c3513f6b046078b85", "mode": "0600", "owner": "jenkins", "size": 1704, "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1664887496.4386547-9393-235242417528797/source", "state": "file", "uid": 1000090000 } TASK [Run role] **************************************************************** task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:68 Tuesday 04 October 2022 12:45:10 +0000 (0:00:16.732) 0:01:26.253 ******* 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 12:45:11 +0000 (0:00:00.647) 0:01:26.901 ******* 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 12:45:11 +0000 (0:00:00.158) 0:01:27.060 ******* 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 12:45:12 +0000 (0:00:00.920) 0:01:27.981 ******* 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 12:45:12 +0000 (0:00:00.256) 0:01:28.237 ******* 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 12:45:13 +0000 (0:00:00.143) 0:01:28.380 ******* 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 12:45:13 +0000 (0:00:00.083) 0:01:28.463 ******* 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 12:45:13 +0000 (0:00:00.165) 0:01:28.628 ******* 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 12:45:13 +0000 (0:00:00.193) 0:01:28.822 ******* 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 12:45:13 +0000 (0:00:00.244) 0:01:29.067 ******* 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 12:45:13 +0000 (0:00:00.159) 0:01:29.226 ******* 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 12:45:14 +0000 (0:00:00.313) 0:01:29.540 ******* 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 12:45:14 +0000 (0:00:00.521) 0:01:30.062 ******* 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 12:45:15 +0000 (0:00:00.228) 0:01:30.291 ******* 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 12:45:15 +0000 (0:00:00.180) 0:01:30.471 ******* 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 12:45:15 +0000 (0:00:00.145) 0:01:30.617 ******* 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 12:45:15 +0000 (0:00:00.235) 0:01:30.852 ******* 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 12:45:19 +0000 (0:00:03.429) 0:01:34.281 ******* 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 12:45:19 +0000 (0:00:00.409) 0:01:34.691 ******* 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 12:45:21 +0000 (0:00:01.673) 0:01:36.364 ******* 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 12:45:21 +0000 (0:00:00.270) 0:01:36.666 ******* 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 12:45:21 +0000 (0:00:00.304) 0:01:36.971 ******* 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 12:45:22 +0000 (0:00:00.732) 0:01:37.703 ******* 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 12:46:32 +0000 (0:01:10.286) 0:02:47.990 ******* 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 12:46:39 +0000 (0:00:06.889) 0:02:54.879 ******* 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.007065", "end": "2022-10-04 12:46:41.723861", "rc": 0, "start": "2022-10-04 12:46:41.716796" } 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 12:46:42 +0000 (0:00:03.205) 0:02:58.085 ******* 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 12:46:53 +0000 (0:00:10.854) 0:03:08.940 ******* 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 12:46:57 +0000 (0:00:03.963) 0:03:12.904 ******* fatal: [sut]: FAILED! => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "-n", "setup" ], "delta": "0:00:18.163113", "end": "2022-10-04 12:47:19.268625", "rc": 1, "start": "2022-10-04 12:47:01.105512" } STDOUT: The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition]. Capturing a dump of 5686 Successfully captured dump: /var/opt/mssql/log/core.sqlservr.10_4_2022_12_47_5.5686 Executing: /opt/mssql/bin/handle-crash.sh with parameters handle-crash.sh /opt/mssql/bin/sqlservr 5686 /opt/mssql/bin /var/opt/mssql/log/ 79b52c64-afd5-402a-810d-bcc189797dbb 96f802f0-b294-4f0e-afe6-6ee754ee9302 /var/opt/mssql/log/core.sqlservr.10_4_2022_12_47_5.5686 Fedora Linux 36 (Thirty Six) Capturing core dump and information to /var/opt/mssql/log... Tue Oct 4 12:47:08 UTC 2022 Capturing program information Dump already generated: /var/opt/mssql/log/core.sqlservr.10_4_2022_12_47_5.5686, moving to /var/opt/mssql/log/core.sqlservr.5686.temp/core.sqlservr.5686.gdmp Moving logs to /var/opt/mssql/log/core.sqlservr.5686.temp/log/paldumper-debug.log Tue Oct 4 12:47:09 UTC 2022 Capturing program binaries Tue Oct 4 12:47:19 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_12_47_07.5686.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 12:47:05 2022 The following diagnostic information is available: Reason: 0x00000001 Signal: SIGSEGV - Segmentation fault (11) Stack: IP Function ---------------- -------------------------------------- 000055c3c830662c 000055c3c8306072 000055c3c8320616 000055c3c82a475b 00007f912083ea70 __restore_rt+0x0 0000000000000000 000055c3c82b933e 000055c3c82a0a04 000055c3c82a0829 Process: 5686 - sqlservr Thread: 5801 (application thread 0x1e4) Instance Id: 79b52c64-afd5-402a-810d-bcc189797dbb Crash Id: 96f802f0-b294-4f0e-afe6-6ee754ee9302 Build stamp: 552d94c177a9792ae44a9aaac32d760a081b9559704eef11a8058918a632fad6 Distribution: Fedora Linux 36 (Thirty Six) Processors: 2 Total Memory: 3910066176 bytes Timestamp: Tue Oct 4 12:47:05 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 TASK [Remove a private key from the playbook directory] ************************ task path: /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:77 Tuesday 04 October 2022 12:47:20 +0000 (0:00:22.492) 0:03:35.397 ******* changed: [sut -> localhost] => { "changed": true, "path": "ansible.at7ebfw5", "state": "absent" } to retry, use: --limit @/tmp/tests_tls_2019.retry PLAY RECAP ********************************************************************* sut : ok=24 changed=9 unreachable=0 failed=1 skipped=11 rescued=0 ignored=0 Tuesday 04 October 2022 12:47:26 +0000 (0:00:06.294) 0:03:41.691 ******* =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 70.29s /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.49s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:205 Gathering Facts -------------------------------------------------------- 20.47s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:9 Copy a private key to the playbook directory to test a relative path --- 16.73s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:58 Copy certificate files to local tmp ------------------------------------ 12.85s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:46 Ensure the openssl package --------------------------------------------- 12.11s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:19 Create a tempfile for a certificate on hosts --------------------------- 11.30s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:25 fedora.linux_system_roles.mssql : Gather system services facts --------- 10.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 that the openldap-compat package is installed --- 6.89s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:158 Remove a private key from the playbook directory ------------------------ 6.29s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:77 Generate a self-signed certificate and public key ----------------------- 5.81s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:37 Create a tempfile for a private key on hosts ---------------------------- 3.98s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:31 fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 3.96s /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 : Gather package facts ------------------ 3.43s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:101 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 3.21s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Include vault variables ------------------------------------------------- 2.24s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:4 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.67s /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 : Ensure ansible_facts used by role ----- 0.92s /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 : Configure the Microsoft SQL Server 2019 repository --- 0.73s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:140 Run role ---------------------------------------------------------------- 0.65s /WORKDIR/dist-git-mssql-meta-remove-f36-support-onrIfw/tests/tests_tls_2019.yml:68 ---^---^---^---^---^--- # 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. ---^---^---^---^---^---