# STDOUT: ---v---v---v---v---v--- Using /etc/ansible/ansible.cfg as config file PLAY [Verify the use of the firewall role to configure SQL Server TCP ports] *** TASK [Gathering Facts] ********************************************************* Wednesday 31 August 2022 11:26:24 +0000 (0:00:00.057) 0:00:00.057 ****** ok: [sut] TASK [Set up SQL Server] ******************************************************* Wednesday 31 August 2022 11:26:25 +0000 (0:00:01.117) 0:00:01.174 ****** TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** Wednesday 31 August 2022 11:26:25 +0000 (0:00:00.139) 0:00:01.314 ****** included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ Wednesday 31 August 2022 11:26:25 +0000 (0:00:00.039) 0:00:01.354 ****** ok: [sut] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.472) 0:00:01.827 ****** 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-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-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/8/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=RedHat_8.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_8.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=RedHat_8.7.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_8.7.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.088) 0:00:01.915 ****** ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.042) 0:00:01.957 ****** ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.042) 0:00:02.000 ****** skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.037) 0:00:02.037 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.035) 0:00:02.073 ****** skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.035) 0:00:02.108 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.036) 0:00:02.145 ****** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.070) 0:00:02.216 ****** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.064) 0:00:02.280 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.049) 0:00:02.330 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.049) 0:00:02.380 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.048) 0:00:02.428 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Gather package facts] ************************* Wednesday 31 August 2022 11:26:26 +0000 (0:00:00.050) 0:00:02.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 [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] *** Wednesday 31 August 2022 11:26:28 +0000 (0:00:01.861) 0:00:04.340 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** Wednesday 31 August 2022 11:26:28 +0000 (0:00:00.067) 0:00:04.408 ****** changed: [sut] => { "changed": true } TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] *** Wednesday 31 August 2022 11:26:29 +0000 (0:00:00.882) 0:00:05.290 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] *** Wednesday 31 August 2022 11:26:29 +0000 (0:00:00.068) 0:00:05.359 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** Wednesday 31 August 2022 11:26:29 +0000 (0:00:00.105) 0:00:05.465 ****** changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [linux-system-roles.mssql : Ensure the mssql-server package] ************** Wednesday 31 August 2022 11:26:30 +0000 (0:00:00.431) 0:00:05.896 ****** changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: gdb-8.2-19.el8.x86_64", "Installed: gdb-headless-8.2-19.el8.x86_64", "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64", "Installed: gc-7.6.4-3.el8.x86_64", "Installed: libatomic-8.5.0-15.el8.x86_64", "Installed: libatomic_ops-7.6.2-3.el8.x86_64", "Installed: gcc-gdb-plugin-8.5.0-15.el8.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64", "Installed: guile-5:2.0.14-7.el8.x86_64", "Installed: libtool-ltdl-2.4.6-25.el8.x86_64", "Installed: libipt-1.6.1-8.el8.x86_64", "Installed: libbabeltrace-1.5.4-4.el8.x86_64", "Installed: bzip2-1.0.6-26.el8.x86_64", "Installed: mssql-server-15.0.4249.2-1.x86_64" ] } TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] *** Wednesday 31 August 2022 11:27:21 +0000 (0:00:51.209) 0:00:57.106 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** Wednesday 31 August 2022 11:27:21 +0000 (0:00:00.048) 0:00:57.154 ****** 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.007329", "end": "2022-08-31 11:27:21.761265", "rc": 0, "start": "2022-08-31 11:27:21.753936" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** Wednesday 31 August 2022 11:27:21 +0000 (0:00:00.441) 0:00:57.596 ****** ok: [sut] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** Wednesday 31 August 2022 11:27:23 +0000 (0:00:02.079) 0:00:59.675 ****** ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* Wednesday 31 August 2022 11:27:23 +0000 (0:00:00.104) 0:00:59.779 ****** changed: [sut] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "-n", "setup" ], "delta": "0:00:07.305088", "end": "2022-08-31 11:27:31.545763", "rc": 0, "start": "2022-08-31 11:27:24.240675" } STDOUT: The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition]. ForceFlush is enabled for this instance. ForceFlush feature is enabled for log durability. 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... Setup has completed successfully. SQL Server is now starting. STDERR: Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service. TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** Wednesday 31 August 2022 11:27:31 +0000 (0:00:07.614) 0:01:07.394 ****** changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: tuned-profiles-mssql-2.19.0-1.el8.noarch" ] } TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** Wednesday 31 August 2022 11:27:35 +0000 (0:00:03.915) 0:01:11.309 ****** ok: [sut] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Wed 2022-08-31 11:18:55 UTC", "ActiveEnterTimestampMonotonic": "12121306", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "systemd-journald.socket network.target dbus.service systemd-sysctl.service basic.target system.slice sysinit.target dbus.socket", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2022-08-31 11:18:53 UTC", "AssertTimestampMonotonic": "10892253", "Before": "multi-user.target shutdown.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "no", "CPUAffinity": "", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "[not set]", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Wed 2022-08-31 11:18:53 UTC", "ConditionTimestampMonotonic": "10892252", "ConfigurationDirectoryMode": "0755", "Conflicts": "auto-cpufreq.service tlp.service shutdown.target cpupower.service power-profiles-daemon.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "man:tuned(8) man:tuned.conf(5) man:tuned-adm(8)", "DynamicUser": "no", "EffectiveCPUs": "", "EffectiveMemoryNodes": "", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "744", "ExecMainStartTimestamp": "Wed 2022-08-31 11:18:53 UTC", "ExecMainStartTimestampMonotonic": "10893809", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IPAccounting": "no", "IPEgressBytes": "18446744073709551615", "IPEgressPackets": "18446744073709551615", "IPIngressBytes": "18446744073709551615", "IPIngressPackets": "18446744073709551615", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Wed 2022-08-31 11:18:53 UTC", "InactiveExitTimestampMonotonic": "10893880", "InvocationID": "82b619b274d849fc83c70c077e3a48e2", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "262144", "LimitNOFILESoft": "1024", "LimitNPROC": "14143", "LimitNPROCSoft": "14143", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14143", "LimitSIGPENDINGSoft": "14143", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "744", "MemoryAccounting": "yes", "MemoryCurrent": "19296256", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "MountFlags": "", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAMask": "", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "PIDFile": "/run/tuned/tuned.pid", "PermissionsStartOnly": "no", "Perpetual": "no", "PrivateDevices": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "polkit.service sysinit.target dbus.socket system.slice dbus.service", "Restart": "no", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardInputData": "", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Wed 2022-08-31 11:18:55 UTC", "StateChangeTimestampMonotonic": "12121306", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "0", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "5", "TasksMax": "22628", "TimeoutStartUSec": "1min 30s", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogTimestamp": "Wed 2022-08-31 11:18:55 UTC", "WatchdogTimestampMonotonic": "12121300", "WatchdogUSec": "0" } } TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** Wednesday 31 August 2022 11:27:36 +0000 (0:00:01.123) 0:01:12.433 ****** ok: [sut] => { "changed": false, "cmd": [ "tuned-adm", "active" ], "delta": "0:00:00.356894", "end": "2022-08-31 11:27:37.380434", "rc": 0, "start": "2022-08-31 11:27:37.023540" } STDOUT: Current active profile: virtual-guest TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] *** Wednesday 31 August 2022 11:27:37 +0000 (0:00:00.795) 0:01:13.228 ****** changed: [sut] => { "changed": true, "cmd": [ "tuned-adm", "profile", "virtual-guest", "mssql" ], "delta": "0:00:01.475329", "end": "2022-08-31 11:27:39.332088", "failed_when_result": false, "rc": 0, "start": "2022-08-31 11:27:37.856759" } TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] *** Wednesday 31 August 2022 11:27:39 +0000 (0:00:01.946) 0:01:15.174 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] *** Wednesday 31 August 2022 11:27:39 +0000 (0:00:00.055) 0:01:15.229 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** Wednesday 31 August 2022 11:27:39 +0000 (0:00:00.054) 0:01:15.284 ****** changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] *** Wednesday 31 August 2022 11:27:39 +0000 (0:00:00.283) 0:01:15.568 ****** changed: [sut] => { "changed": true, "rc": 0, "results": [ "Installed: unixODBC-devel-2.3.7-1.rh.x86_64", "Installed: mssql-tools-17.10.1.1-1.x86_64", "Installed: msodbcsql17-17.10.1.1-1.x86_64", "Installed: unixODBC-2.3.7-1.rh.x86_64" ] } TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* Wednesday 31 August 2022 11:27:44 +0000 (0:00:05.070) 0:01:20.639 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the set password matches the existing password] *** Wednesday 31 August 2022 11:27:44 +0000 (0:00:00.060) 0:01:20.699 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] *** Wednesday 31 August 2022 11:27:44 +0000 (0:00:00.057) 0:01:20.757 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Change the password of the sa user] *********** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.058) 0:01:20.815 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Pre-input SQL scripts to SQL Server] ********** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.059) 0:01:20.874 ****** TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] *** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.060) 0:01:20.935 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] *** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.059) 0:01:20.995 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Change the edition of MSSQL] ****************** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.061) 0:01:21.056 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the IP address setting] ************* Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.058) 0:01:21.114 ****** skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Register the previous tcpport setting] ******** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.059) 0:01:21.174 ****** ok: [sut] => { "changed": false, "cmd": [ "grep", "^tcpport = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.003797", "end": "2022-08-31 11:27:45.629071", "failed_when_result": false, "rc": 1, "start": "2022-08-31 11:27:45.625274" } MSG: non-zero return code TASK [Open the 1433 TCP port] ************************************************** Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.294) 0:01:21.469 ****** to retry, use: --limit @/tmp/tests_tcp_firewall.retry PLAY RECAP ********************************************************************* sut : ok=23 changed=8 unreachable=0 failed=0 skipped=23 rescued=0 ignored=0 Wednesday 31 August 2022 11:27:45 +0000 (0:00:00.077) 0:01:21.547 ****** =============================================================================== linux-system-roles.mssql : Ensure the mssql-server package ------------- 51.21s linux-system-roles.mssql : Set up MSSQL --------------------------------- 7.61s linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 5.07s linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.92s linux-system-roles.mssql : Gather system services facts ----------------- 2.08s linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.95s linux-system-roles.mssql : Gather package facts ------------------------- 1.86s linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.12s Gathering Facts --------------------------------------------------------- 1.12s linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.88s linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.80s linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.47s linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.44s linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.43s linux-system-roles.mssql : Register the previous tcpport setting -------- 0.29s linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.28s Set up SQL Server ------------------------------------------------------- 0.14s linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.11s linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.10s linux-system-roles.mssql : Set platform/version specific variables ------ 0.09s ---^---^---^---^---^--- # 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. ERROR! the role 'fedora.linux_system_roles.firewall' was not found in /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles:/home/jenkins/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests The error appears to be in '/WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/main.yml': line 375, column 11, but may be elsewhere in the file depending on the exact syntax problem. The offending line appears to be: include_role: name: fedora.linux_system_roles.firewall ^ here ---^---^---^---^---^---