# STDOUT: ---v---v---v---v---v--- ansible-playbook 2.9.27 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.9/lib/python3.9/site-packages/ansible executable location = /opt/ansible-2.9/bin/ansible-playbook python version = 3.9.18 (main, Sep 7 2023, 00:00:00) [GCC 11.4.1 20230605 (Red Hat 11.4.1-2)] Using /etc/ansible/ansible.cfg as config file Skipping callback 'actionable', as we already have a stdout callback. Skipping callback 'counter_enabled', as we already have a stdout callback. Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'full_skip', as we already have a stdout callback. Skipping callback 'json', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'null', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. Skipping callback 'selective', as we already have a stdout callback. Skipping callback 'skippy', as we already have a stdout callback. Skipping callback 'stderr', as we already have a stdout callback. Skipping callback 'unixy', as we already have a stdout callback. Skipping callback 'yaml', as we already have a stdout callback. PLAYBOOK: tests_configure_ha_cluster_read_scale.yml **************************** 2 plays in /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:4 Wednesday 06 December 2023 08:58:29 +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-selinuxmlubhfv8/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Verify HA functionality with read-scale clusters] ************************ TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:9 Wednesday 06 December 2023 08:58:29 +0000 (0:00:00.010) 0:00:00.022 **** ok: [sut] META: ran handlers TASK [Run the role] ************************************************************ task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:45 Wednesday 06 December 2023 08:58:35 +0000 (0:00:05.520) 0:00:05.543 **** TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.158) 0:00:05.702 **** included: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.023) 0:00:05.725 **** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.022) 0:00:05.748 **** 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-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [sut] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019 ] }, "ansible_included_var_files": [ "/WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [sut] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.047) 0:00:05.795 **** ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.020) 0:00:05.815 **** skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.018) 0:00:05.834 **** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.020) 0:00:05.855 **** skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.020) 0:00:05.875 **** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.026) 0:00:05.902 **** skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:51 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.019) 0:00:05.922 **** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:55 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.018) 0:00:05.940 **** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:67 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.022) 0:00:05.962 **** fatal: [sut]: FAILED! => { "changed": false } MSG: mssql_ha_configure=true does not support running against EL 7 hosts TASK [Assert that the role failed with EL 7 not supported] ********************* task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:55 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.021) 0:00:05.984 **** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [Clean up after the role invocation] ************************************** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:61 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.020) 0:00:06.004 **** fatal: [sut]: FAILED! => { "reason": "conflicting action statements: shell, warn\n\nThe error appears to be in '/WORKDIR/git-storage-selinuxmlubhfv8/tests/tasks/cleanup.yml': line 58, column 3, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n- name: Remove related files\n ^ here\n" } TASK [Clean up after the role invocation] ************************************** task path: /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:114 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.024) 0:00:06.029 **** fatal: [sut]: FAILED! => { "reason": "conflicting action statements: shell, warn\n\nThe error appears to be in '/WORKDIR/git-storage-selinuxmlubhfv8/tests/tasks/cleanup.yml': line 58, column 3, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n- name: Remove related files\n ^ here\n" } to retry, use: --limit @/tmp/tests_configure_ha_cluster_read_scale.retry PLAY RECAP ********************************************************************* sut : ok=7 changed=0 unreachable=0 failed=2 skipped=7 rescued=1 ignored=0 Wednesday 06 December 2023 08:58:35 +0000 (0:00:00.008) 0:00:06.037 **** =============================================================================== Gathering Facts --------------------------------------------------------- 5.52s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:9 Run the role ------------------------------------------------------------ 0.16s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:45 linux-system-roles.mssql : Set platform/version specific variables ------ 0.05s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.03s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Clean up after the role invocation -------------------------------------- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:61 linux-system-roles.mssql : Ensure ansible_facts and variables used by role --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:55 linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:67 linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact ------ 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 linux-system-roles.mssql : Print that the variable is deprecated -------- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Assert that the role failed with EL 7 not supported --------------------- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:55 linux-system-roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 linux-system-roles.mssql : Link the deprecated mssql_ad_sql_user_name fact --- 0.02s /WORKDIR/git-storage-selinuxmlubhfv8/tests/roles/linux-system-roles.mssql/tasks/main.yml:51 Include vault variables ------------------------------------------------- 0.01s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:4 Clean up after the role invocation -------------------------------------- 0.01s /WORKDIR/git-storage-selinuxmlubhfv8/tests/tests_configure_ha_cluster_read_scale.yml:114 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- ---^---^---^---^---^---