# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.16.0] 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.16/lib/python3.11/site-packages/ansible ansible collection location = /WORKDIR/git-storage-selinuxuz0hjvg7/.collection executable location = /opt/ansible-2.16/bin/ansible-playbook python version = 3.11.5 (main, Sep 7 2023, 00:00:00) [GCC 11.4.1 20230605 (Red Hat 11.4.1-2)] (/opt/ansible-2.16/bin/python) 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_2019_upgrade.yml *********************************************** 2 plays in /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tests_2019_upgrade.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tests_2019_upgrade.yml:4 Wednesday 06 December 2023 08:37:49 +0000 (0:00:00.012) 0:00:00.012 **** ok: [sut] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/WORKDIR/git-storage-selinuxuz0hjvg7/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that the role installs version 2017 and upgrades to 2019] ********* TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tests_2019_upgrade.yml:9 Wednesday 06 December 2023 08:37:49 +0000 (0:00:00.013) 0:00:00.026 **** ok: [sut] TASK [Assert fail on EL 7 with version=2022 and EL 9 with version!=2022] ******* task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tests_2019_upgrade.yml:16 Wednesday 06 December 2023 08:37:50 +0000 (0:00:00.789) 0:00:00.815 **** included: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml for sut TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Wednesday 06 December 2023 08:37:50 +0000 (0:00:00.011) 0:00:00.827 **** ok: [sut] TASK [Run the role] ************************************************************ task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:15 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.350) 0:00:01.178 **** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.096) 0:00:01.274 **** included: /WORKDIR/git-storage-selinuxuz0hjvg7/.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/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.024) 0:00:01.299 **** skipping: [sut] => { "changed": false, "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.026) 0:00:01.325 **** ok: [sut] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [sut] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2022 ] }, "ansible_included_var_files": [ "/WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=RedHat_9.4.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "RedHat_9.4.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.046) 0:00:01.372 **** ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.023) 0:00:01.395 **** skipping: [sut] => { "false_condition": "mssql_input_sql_file is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.021) 0:00:01.417 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_input_sql_file is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.020) 0:00:01.438 **** skipping: [sut] => { "false_condition": "mssql_ha_listener_port is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.020) 0:00:01.458 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_listener_port is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.019) 0:00:01.478 **** skipping: [sut] => { "false_condition": "mssql_ad_sql_user_name is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.019) 0:00:01.498 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ad_sql_user_name is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.020) 0:00:01.518 **** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:67 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.023) 0:00:01.542 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "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/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.019) 0:00:01.561 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "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/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.019) 0:00:01.581 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:93 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.020) 0:00:01.601 **** skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:103 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.021) 0:00:01.623 **** skipping: [sut] => { "changed": false, "false_condition": "not __mssql_confined_supported", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:112 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.021) 0:00:01.645 **** fatal: [sut]: FAILED! => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result" } TASK [Assert that the role failed with EL < 8 not supported] ******************* task path: /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:26 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.020) 0:00:01.665 **** fatal: [sut]: FAILED! => {} MSG: The conditional check ''You must set the mssql_version variable to one of' in ansible_failed_result.msg' failed. The error was: error while evaluating conditional ('You must set the mssql_version variable to one of' in ansible_failed_result.msg): {'failed': True, 'msg': "the field 'no_log' has an invalid value ({{ __mssql_gather_facts_log }}), and could not be converted to an bool.The error was: The value 'flush_handlers' is not a valid boolean. Valid booleans include: 'n', 1, 'on', 0, 'no', 'true', 'f', 'y', 't', '1', 'off', '0', 'yes', 'false'. The value 'flush_handlers' is not a valid boolean. Valid booleans include: 'n', 1, 'on', 0, 'no', 'true', 'f', 'y', 't', '1', 'off', '0', 'yes', 'false'", '_ansible_no_log': '{{ __mssql_gather_facts_log }}'}: '__mssql_gather_facts_log' is undefined. '__mssql_gather_facts_log' is undefined. {'failed': True, 'msg': "the field 'no_log' has an invalid value ({{ __mssql_gather_facts_log }}), and could not be converted to an bool.The error was: The value 'flush_handlers' is not a valid boolean. Valid booleans include: 'n', 1, 'on', 0, 'no', 'true', 'f', 'y', 't', '1', 'off', '0', 'yes', 'false'. The value 'flush_handlers' is not a valid boolean. Valid booleans include: 'n', 1, 'on', 0, 'no', 'true', 'f', 'y', 't', '1', 'off', '0', 'yes', 'false'", '_ansible_no_log': '{{ __mssql_gather_facts_log }}'}: '__mssql_gather_facts_log' is undefined. '__mssql_gather_facts_log' is undefined to retry, use: --limit @/tmp/tests_2019_upgrade.retry PLAY RECAP ********************************************************************* sut : ok=8 changed=0 unreachable=0 failed=1 skipped=12 rescued=1 ignored=0 Wednesday 06 December 2023 08:37:51 +0000 (0:00:00.019) 0:00:01.685 **** =============================================================================== Gathering Facts --------------------------------------------------------- 0.79s /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tests_2019_upgrade.yml:9 ----------- Ensure ansible_facts to get ansible_distribution ------------------------ 0.35s /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Run the role ------------------------------------------------------------ 0.10s /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:15 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.05s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.03s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:93 fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:103 fedora.linux_system_roles.mssql : Gather package facts ------------------ 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:112 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Assert that the role failed with EL < 8 not supported ------------------- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/tests/tasks/assert_fail_on_unsupported_ver.yml:26 fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.02s /WORKDIR/git-storage-selinuxuz0hjvg7/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- [DEPRECATION WARNING]: ANSIBLE_COLLECTIONS_PATHS option, does not fit var naming standard, use the singular form ANSIBLE_COLLECTIONS_PATH instead. This feature will be removed from ansible-core in version 2.19. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. ---^---^---^---^---^---