ansible-playbook [core 2.12.6]
config file = /etc/ansible/ansible.cfg
configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
ansible python module location = /usr/lib/python3.9/site-packages/ansible
ansible collection location = /tmp/tmpn59lzvet
executable location = /usr/bin/ansible-playbook
python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
jinja version = 2.11.3
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: centos-8_setup.yml ***************************************************
1 plays in /cache/centos-8_setup.yml
PLAY [Enable HA repos] *********************************************************
META: ran handlers
TASK [Enable HA repos] *********************************************************
task path: /cache/centos-8_setup.yml:5
Wednesday 03 August 2022 15:34:27 +0000 (0:00:00.019) 0:00:00.019 ******
changed: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"discovered_interpreter_python": "/usr/libexec/platform-python"
},
"changed": true,
"cmd": [
"dnf",
"config-manager",
"--set-enabled",
"ha"
],
"delta": "0:00:00.362188",
"end": "2022-08-03 15:34:28.885545",
"rc": 0,
"start": "2022-08-03 15:34:28.523357"
}
META: ran handlers
META: ran handlers
PLAY RECAP *********************************************************************
/cache/centos-8.qcow2 : ok=1 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
Wednesday 03 August 2022 15:34:28 +0000 (0:00:01.024) 0:00:01.044 ******
===============================================================================
Enable HA repos --------------------------------------------------------- 1.02s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
PLAYBOOK: tests_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmpek3rdkcs/tests/tests_input_sql_file_2019.yml
PLAY [Ensure that the role can input sql files to MSSQL] ***********************
TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpek3rdkcs/tests/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022 15:34:28 +0000 (0:00:00.011) 0:00:01.055 ******
ok: [/cache/centos-8.qcow2]
META: ran handlers
TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmpek3rdkcs/tests/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022 15:34:29 +0000 (0:00:01.090) 0:00:02.145 ******
TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022 15:34:29 +0000 (0:00:00.093) 0:00:02.239 ******
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/centos-8.qcow2
TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.033) 0:00:02.273 ******
ok: [/cache/centos-8.qcow2]
TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.525) 0:00:02.798 ******
ok: [/cache/centos-8.qcow2] => (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": [
"/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
],
"ansible_loop_var": "item",
"changed": false,
"item": "RedHat.yml"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS_8.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS_8.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS_8.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS_8.yml",
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:8
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.046) 0:00:02.845 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": null
},
"changed": false
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:12
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.026) 0:00:02.871 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": null
},
"changed": false
}
TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:16
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.025) 0:00:02.896 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:22
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.024) 0:00:02.921 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:27
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.024) 0:00:02.945 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:39
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.045) 0:00:02.990 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:44
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.041) 0:00:03.032 ******
skipping: [/cache/centos-8.qcow2] => {
"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] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:55
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.032) 0:00:03.064 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:63
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.032) 0:00:03.097 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:72
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.033) 0:00:03.130 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Gather package facts] *************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:85
Wednesday 03 August 2022 15:34:30 +0000 (0:00:00.031) 0:00:03.162 ******
ok: [/cache/centos-8.qcow2] => {
"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] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:90
Wednesday 03 August 2022 15:34:32 +0000 (0:00:01.720) 0:00:04.882 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:101
Wednesday 03 August 2022 15:34:32 +0000 (0:00:00.043) 0:00:04.926 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true
}
TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:107
Wednesday 03 August 2022 15:34:35 +0000 (0:00:02.495) 0:00:07.421 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:118
Wednesday 03 August 2022 15:34:35 +0000 (0:00:00.045) 0:00:07.467 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:124
Wednesday 03 August 2022 15:34:35 +0000 (0:00:00.048) 0:00:07.515 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"repo": "packages-microsoft-com-mssql-server-2019",
"state": "present"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022 15:34:35 +0000 (0:00:00.539) 0:00:08.055 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: libpkgconf-1.4.2-1.el8.x86_64",
"Installed: libatomic-8.5.0-15.el8.x86_64",
"Installed: pkgconf-1.4.2-1.el8.x86_64",
"Installed: pkgconf-m4-1.4.2-1.el8.noarch",
"Installed: pkgconf-pkg-config-1.4.2-1.el8.x86_64",
"Installed: glibc-headers-2.28-184.el8.x86_64",
"Installed: isl-0.16.1-6.el8.x86_64",
"Installed: python36-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64",
"Installed: binutils-2.30-117.el8.x86_64",
"Installed: libmpc-1.1.0-9.1.el8.x86_64",
"Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
"Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
"Installed: gc-7.6.4-3.el8.x86_64",
"Installed: mssql-server-15.0.4236.7-1.x86_64",
"Installed: libipt-1.6.1-8.el8.x86_64",
"Installed: libbabeltrace-1.5.4-4.el8.x86_64",
"Installed: python3-setuptools-39.2.0-6.el8.noarch",
"Installed: gcc-8.5.0-7.el8.x86_64",
"Installed: gdb-8.2-19.el8.x86_64",
"Installed: kernel-headers-4.18.0-408.el8.x86_64",
"Installed: cpp-8.5.0-7.el8.x86_64",
"Installed: cyrus-sasl-2.1.27-5.el8.x86_64",
"Installed: gdb-headless-8.2-19.el8.x86_64",
"Installed: glibc-devel-2.28-184.el8.x86_64",
"Installed: python3-pip-9.0.3-22.el8.noarch",
"Installed: cyrus-sasl-gssapi-2.1.27-5.el8.x86_64",
"Installed: guile-5:2.0.14-7.el8.x86_64",
"Installed: gcc-gdb-plugin-8.5.0-7.el8.x86_64",
"Installed: libatomic_ops-7.6.2-3.el8.x86_64"
]
}
TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022 15:35:40 +0000 (0:01:04.674) 0:01:12.730 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022 15:35:40 +0000 (0:00:00.030) 0:01:12.760 ******
ok: [/cache/centos-8.qcow2] => {
"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.005612",
"end": "2022-08-03 15:35:41.032253",
"rc": 0,
"start": "2022-08-03 15:35:41.026641"
}
TASK [linux-system-roles.mssql : Gather system services facts] *****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:165
Wednesday 03 August 2022 15:35:40 +0000 (0:00:00.435) 0:01:13.196 ******
ok: [/cache/centos-8.qcow2] => {
"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] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022 15:35:42 +0000 (0:00:01.651) 0:01:14.848 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:189
Wednesday 03 August 2022 15:35:42 +0000 (0:00:00.073) 0:01:14.921 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"-n",
"setup"
],
"delta": "0:00:04.713585",
"end": "2022-08-03 15:35:47.882045",
"rc": 0,
"start": "2022-08-03 15:35:43.168460"
}
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] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:198
Wednesday 03 August 2022 15:35:47 +0000 (0:00:05.135) 0:01:20.057 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: tuned-2.18.0-3.el8.noarch",
"Installed: tuned-profiles-mssql-2.18.0-3.el8.noarch",
"Removed: tuned-2.16.0-1.el8.noarch"
]
}
TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:203
Wednesday 03 August 2022 15:35:51 +0000 (0:00:03.549) 0:01:23.606 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"enabled": true,
"name": "tuned",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"ActiveEnterTimestampMonotonic": "97557298",
"ActiveExitTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"ActiveExitTimestampMonotonic": "97251764",
"ActiveState": "active",
"After": "dbus.socket sysinit.target network.target basic.target dbus.service systemd-journald.socket system.slice systemd-sysctl.service",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"AssertTimestampMonotonic": "97383414",
"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-03 15:35:50 UTC",
"ConditionTimestampMonotonic": "97383413",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target cpupower.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": "15513",
"ExecMainStartTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"ExecMainStartTimestampMonotonic": "97384375",
"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",
"InactiveEnterTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"InactiveEnterTimestampMonotonic": "97382375",
"InactiveExitTimestamp": "Wed 2022-08-03 15:35:50 UTC",
"InactiveExitTimestampMonotonic": "97384497",
"InvocationID": "d084157c7323414a997b4239deffaff0",
"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": "14647",
"LimitNPROCSoft": "14647",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15513",
"MemoryAccounting": "yes",
"MemoryCurrent": "17383424",
"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": "system.slice dbus.socket dbus.service sysinit.target polkit.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-03 15:35:50 UTC",
"StateChangeTimestampMonotonic": "97557298",
"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": "23435",
"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-03 15:35:50 UTC",
"WatchdogTimestampMonotonic": "97557296",
"WatchdogUSec": "0"
}
}
TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:209
Wednesday 03 August 2022 15:35:52 +0000 (0:00:00.809) 0:01:24.416 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"tuned-adm",
"active"
],
"delta": "0:00:00.124704",
"end": "2022-08-03 15:35:52.763980",
"rc": 0,
"start": "2022-08-03 15:35:52.639276"
}
STDOUT:
Current active profile: virtual-guest
TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:219
Wednesday 03 August 2022 15:35:52 +0000 (0:00:00.513) 0:01:24.930 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"cmd": [
"tuned-adm",
"profile",
"virtual-guest",
"mssql"
],
"delta": "0:00:02.179267",
"end": "2022-08-03 15:35:55.351894",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 15:35:53.172627"
}
TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:232
Wednesday 03 August 2022 15:35:55 +0000 (0:00:02.594) 0:01:27.525 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:241
Wednesday 03 August 2022 15:35:55 +0000 (0:00:00.035) 0:01:27.560 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:251
Wednesday 03 August 2022 15:35:55 +0000 (0:00:00.035) 0:01:27.596 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"repo": "packages-microsoft-com-prod",
"state": "present"
}
TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:258
Wednesday 03 August 2022 15:35:55 +0000 (0:00:00.455) 0:01:28.051 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: mssql-tools-17.10.1.1-1.x86_64",
"Installed: unixODBC-2.3.7-1.rh.x86_64",
"Installed: unixODBC-devel-2.3.7-1.rh.x86_64",
"Installed: msodbcsql17-17.10.1.1-1.x86_64"
]
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:270
Wednesday 03 August 2022 15:36:00 +0000 (0:00:04.248) 0:01:32.299 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:275
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.036) 0:01:32.336 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:281
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.039) 0:01:32.376 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:288
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.036) 0:01:32.412 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:296
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.035) 0:01:32.448 ******
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/centos-8.qcow2
TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.061) 0:01:32.509 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.097) 0:01:32.607 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.e0p8v9jl",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 0,
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Copy the sql_script.sql file to the host] *****
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 15:36:00 +0000 (0:00:00.490) 0:01:33.097 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.e0p8v9jl",
"gid": 0,
"group": "root",
"md5sum": "8edbc22195757a4f043b10e9367f131b",
"mode": "0644",
"owner": "root",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 391,
"src": "/root/.ansible/tmp/ansible-tmp-1659540960.9207082-33762-254978067661800/source",
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 15:36:01 +0000 (0:00:00.977) 0:01:34.075 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 15:36:01 +0000 (0:00:00.039) 0:01:34.115 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ActiveEnterTimestampMonotonic": "94555752",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target sysinit.target auditd.service system.slice -.mount systemd-journald.socket basic.target",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"AssertTimestampMonotonic": "94546035",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 15:35:47 UTC",
"ConditionTimestampMonotonic": "94546035",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15228",
"ExecMainStartTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ExecMainStartTimestampMonotonic": "94555697",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"InactiveExitTimestampMonotonic": "94555752",
"InvocationID": "115a5e152b8d429bb4d91b7310ab4831",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15228",
"MemoryAccounting": "yes",
"MemoryCurrent": "652754944",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"StateChangeTimestampMonotonic": "94555752",
"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": "142",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"WatchdogTimestampMonotonic": "94555744",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 15:36:02 +0000 (0:00:00.529) 0:01:34.644 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"elapsed": 0,
"gid": 987,
"group": "mssql",
"match_groupdict": {},
"match_groups": [],
"mode": "0660",
"owner": "mssql",
"path": "/var/opt/mssql/log/errorlog",
"port": null,
"search_regex": "SQL Server is now ready for client connections",
"secontext": "system_u:object_r:var_t:s0",
"size": 7681,
"state": "file",
"uid": 989
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 15:36:02 +0000 (0:00:00.575) 0:01:35.220 ******
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml for /cache/centos-8.qcow2
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022 15:36:03 +0000 (0:00:00.065) 0:01:35.285 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ActiveEnterTimestampMonotonic": "94555752",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target sysinit.target auditd.service system.slice -.mount systemd-journald.socket basic.target",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"AssertTimestampMonotonic": "94546035",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 15:35:47 UTC",
"ConditionTimestampMonotonic": "94546035",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15228",
"ExecMainStartTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ExecMainStartTimestampMonotonic": "94555697",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"InactiveExitTimestampMonotonic": "94555752",
"InvocationID": "115a5e152b8d429bb4d91b7310ab4831",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15228",
"MemoryAccounting": "yes",
"MemoryCurrent": "652759040",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"StateChangeTimestampMonotonic": "94555752",
"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": "142",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"WatchdogTimestampMonotonic": "94555744",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Check if a custom tcpport setting exist] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022 15:36:03 +0000 (0:00:00.507) 0:01:35.792 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003266",
"end": "2022-08-03 15:36:04.042243",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 15:36:04.038977"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Check if a custom ipaddress setting exist] ****
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022 15:36:03 +0000 (0:00:00.413) 0:01:36.205 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^ipaddress = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003040",
"end": "2022-08-03 15:36:04.439057",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 15:36:04.436017"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Set a fact with a password query] *************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022 15:36:04 +0000 (0:00:00.406) 0:01:36.612 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": "/opt/mssql-tools/bin/sqlcmd -U sa -P p@55w0rD"
},
"changed": false
}
TASK [linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 15:36:04 +0000 (0:00:00.062) 0:01:36.674 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.e0p8v9jl",
"-b"
],
"delta": "0:00:00.261547",
"end": "2022-08-03 15:36:05.155398",
"rc": 0,
"start": "2022-08-03 15:36:04.893851"
}
STDOUT:
Changed database context to 'ExampleDB'.
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
TASK [linux-system-roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.653) 0:01:37.327 ******
ok: [/cache/centos-8.qcow2] => {
"__mssql_sqlcmd_input_file.stdout_lines": [
"Changed database context to 'ExampleDB'.",
"",
"(1 rows affected)",
"",
"(1 rows affected)",
"",
"(1 rows affected)",
"",
"(1 rows affected)"
]
}
TASK [linux-system-roles.mssql : Remove the tempfile] **************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.098) 0:01:37.426 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.075) 0:01:37.501 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the mssql_pre_input_sql_file fact] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:302
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.037) 0:01:37.539 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"mssql_pre_input_sql_file": null
},
"changed": false
}
TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:311
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.037) 0:01:37.576 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:324
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.034) 0:01:37.610 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:331
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.035) 0:01:37.646 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the IP address setting] *************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:340
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.039) 0:01:37.686 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:347
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.038) 0:01:37.724 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:354
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.045) 0:01:37.770 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:365
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.045) 0:01:37.815 ******
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for /cache/centos-8.qcow2
TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022 15:36:05 +0000 (0:00:00.053) 0:01:37.868 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.002891",
"end": "2022-08-03 15:36:06.120427",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 15:36:06.117536"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.420) 0:01:38.289 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"set",
"network.tcpport",
"1433"
],
"delta": "0:00:00.104729",
"end": "2022-08-03 15:36:06.628509",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 15:36:06.523780"
}
STDOUT:
Validation error on setting 'network.tcpport'
Port '1433' is already in use. Please use another port
TASK [linux-system-roles.mssql : Unset the network tcpport setting] ************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.516) 0:01:38.806 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:371
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.034) 0:01:38.840 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:389
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.090) 0:01:38.931 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-fts package] **********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:396
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.040) 0:01:38.972 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:403
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.038) 0:01:39.010 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:412
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.044) 0:01:39.055 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:418
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.040) 0:01:39.095 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Check if the 3979 trace flag is enabled] ******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:427
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.043) 0:01:39.139 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:433
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.041) 0:01:39.181 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the 3979 traceflag] *********************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:439
Wednesday 03 August 2022 15:36:06 +0000 (0:00:00.040) 0:01:39.222 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:446
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.041) 0:01:39.263 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:452
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.038) 0:01:39.302 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:463
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.036) 0:01:39.338 ******
skipping: [/cache/centos-8.qcow2] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the tlscert setting] ****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:479
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.044) 0:01:39.382 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:488
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.036) 0:01:39.419 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:497
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.039) 0:01:39.459 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:504
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.038) 0:01:39.497 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:514
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.040) 0:01:39.537 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Set host variables] ***************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:533
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.044) 0:01:39.582 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:544
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.047) 0:01:39.630 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:550
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.086) 0:01:39.716 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:557
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.043) 0:01:39.760 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:565
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.043) 0:01:39.803 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:570
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.042) 0:01:39.845 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate and private key files] *****
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:576
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.044) 0:01:39.890 ******
skipping: [/cache/centos-8.qcow2] => (item=/var/opt/mssql/data/.cer) => {
"ansible_loop_var": "item",
"changed": false,
"item": "/var/opt/mssql/data/.cer",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=/var/opt/mssql/data/.pvk) => {
"ansible_loop_var": "item",
"changed": false,
"item": "/var/opt/mssql/data/.pvk",
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create master key encryption] *****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:585
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.054) 0:01:39.944 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create and back up certificate] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:590
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.049) 0:01:39.994 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Fetch certificate and private key from the primary node to the control node] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:596
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.046) 0:01:40.040 ******
skipping: [/cache/centos-8.qcow2] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "cert",
"value": "/var/opt/mssql/data/.cer"
},
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "key",
"value": "/var/opt/mssql/data/.pvk"
},
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create database mirroring endpoints] **********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:608
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.053) 0:01:40.094 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create the] ***********************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:613
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.049) 0:01:40.143 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Get mssql-server version to see if WRITE_LEASE_VALIDITY is available] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:619
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.046) 0:01:40.190 ******
skipping: [/cache/centos-8.qcow2] => {
"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 : Create the availability group] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:624
Wednesday 03 August 2022 15:36:07 +0000 (0:00:00.050) 0:01:40.241 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Grant permissions to the login] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:629
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.048) 0:01:40.289 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Back up and replicate the database] **********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:634
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.046) 0:01:40.335 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Set a fact to indicate successful set up on the primary replica] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:641
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.052) 0:01:40.388 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Fail if the primary node failed] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:668
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.051) 0:01:40.439 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:675
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.050) 0:01:40.489 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:681
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.045) 0:01:40.535 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:688
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.046) 0:01:40.581 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:696
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.083) 0:01:40.665 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create master key encryption] *****************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:701
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.047) 0:01:40.712 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:706
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.048) 0:01:40.761 ******
skipping: [/cache/centos-8.qcow2] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "cert",
"value": "/var/opt/mssql/data/.cer"
},
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "key",
"value": "/var/opt/mssql/data/.pvk"
},
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:718
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.052) 0:01:40.813 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Restore certificate] **************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:724
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.060) 0:01:40.874 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create database mirroring endpoints] **********
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:729
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.049) 0:01:40.923 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create the login] ****************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:734
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.048) 0:01:40.972 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Join synchronous and witness servers to the availability group] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:739
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.047) 0:01:41.020 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Grant permissions to the login] **************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:744
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.048) 0:01:41.068 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify if the database exists on secondaries] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:749
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.047) 0:01:41.115 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate and private key from the control node] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:756
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.049) 0:01:41.164 ******
skipping: [/cache/centos-8.qcow2] => (item=cert) => {
"ansible_loop_var": "item",
"changed": false,
"item": "cert",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=key) => {
"ansible_loop_var": "item",
"changed": false,
"item": "key",
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Save credentials for the SQL Server login] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:769
Wednesday 03 August 2022 15:36:08 +0000 (0:00:00.052) 0:01:41.217 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:780
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.044) 0:01:41.261 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify if the database exists] ***************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:785
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.043) 0:01:41.304 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:793
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.043) 0:01:41.347 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true
}
MSG:
Block inserted
TASK [linux-system-roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:802
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.606) 0:01:41.954 ******
included: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/centos-8.qcow2
TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.102) 0:01:42.057 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 15:36:09 +0000 (0:00:00.050) 0:01:42.107 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.ua7_9y8r",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 0,
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Copy the sql_script.sql file to the host] *****
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 15:36:10 +0000 (0:00:00.393) 0:01:42.501 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.ua7_9y8r",
"gid": 0,
"group": "root",
"md5sum": "8edbc22195757a4f043b10e9367f131b",
"mode": "0644",
"owner": "root",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 391,
"src": "/root/.ansible/tmp/ansible-tmp-1659540970.3223271-34088-162742157063253/source",
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 15:36:10 +0000 (0:00:00.728) 0:01:43.230 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 15:36:11 +0000 (0:00:00.043) 0:01:43.273 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ActiveEnterTimestampMonotonic": "94555752",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target sysinit.target auditd.service system.slice -.mount systemd-journald.socket basic.target",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"AssertTimestampMonotonic": "94546035",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 15:35:47 UTC",
"ConditionTimestampMonotonic": "94546035",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15228",
"ExecMainStartTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"ExecMainStartTimestampMonotonic": "94555697",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"InactiveExitTimestampMonotonic": "94555752",
"InvocationID": "115a5e152b8d429bb4d91b7310ab4831",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15228",
"MemoryAccounting": "yes",
"MemoryCurrent": "670117888",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"StateChangeTimestampMonotonic": "94555752",
"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": "141",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 15:35:47 UTC",
"WatchdogTimestampMonotonic": "94555744",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 15:36:11 +0000 (0:00:00.525) 0:01:43.798 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"elapsed": 0,
"gid": 987,
"group": "mssql",
"match_groupdict": {},
"match_groups": [],
"mode": "0660",
"owner": "mssql",
"path": "/var/opt/mssql/log/errorlog",
"port": null,
"search_regex": "SQL Server is now ready for client connections",
"secontext": "system_u:object_r:var_t:s0",
"size": 8075,
"state": "file",
"uid": 989
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 15:36:11 +0000 (0:00:00.426) 0:01:44.224 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 15:36:12 +0000 (0:00:00.073) 0:01:44.297 ******
fatal: [/cache/centos-8.qcow2]: FAILED! => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.ua7_9y8r",
"-b"
],
"delta": "0:00:00.024974",
"end": "2022-08-03 15:36:12.539051",
"rc": 1,
"start": "2022-08-03 15:36:12.514077"
}
STDOUT:
Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1
The server principal 'MyLogin' already exists.
Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2
User, group, or role 'MyUser' already exists in the current database.
Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3
Database 'ExampleDB' already exists. Choose a different database name.
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 15:36:12 +0000 (0:00:00.413) 0:01:44.710 ******
ok: [/cache/centos-8.qcow2] => {
"__mssql_sqlcmd_input_file.stdout_lines": [
"Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1",
"The server principal 'MyLogin' already exists.",
"Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2",
"User, group, or role 'MyUser' already exists in the current database.",
"Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3",
"Database 'ExampleDB' already exists. Choose a different database name."
]
}
TASK [linux-system-roles.mssql : Remove the tempfile] **************************
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 15:36:12 +0000 (0:00:00.063) 0:01:44.774 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 15:36:12 +0000 (0:00:00.040) 0:01:44.814 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
PLAY RECAP *********************************************************************
/cache/centos-8.qcow2 : ok=48 changed=10 unreachable=0 failed=1 skipped=82 rescued=0 ignored=0
Wednesday 03 August 2022 15:36:12 +0000 (0:00:00.017) 0:01:44.832 ******
===============================================================================
linux-system-roles.mssql : Ensure the mssql-server package ------------- 64.67s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Set up MSSQL --------------------------------- 5.14s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:189 ------
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 4.25s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:258 ------
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.55s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:198 ------
linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 2.59s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:219 ------
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 2.50s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.72s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Gather system services facts ----------------- 1.65s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
Gathering Facts --------------------------------------------------------- 1.09s
/tmp/tmpek3rdkcs/tests/tests_input_sql_file_2019.yml:3 ------------------------
Enable HA repos --------------------------------------------------------- 1.02s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 0.98s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 0.81s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:203 ------
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 0.73s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.65s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
linux-system-roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.61s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:793 ------
linux-system-roles.mssql : Wait for mssql-server to prepare for client connections --- 0.58s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.54s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.53s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.53s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.53s
/tmp/tmpek3rdkcs/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
ansible-playbook [core 2.12.6]
config file = /etc/ansible/ansible.cfg
configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
ansible python module location = /usr/lib/python3.9/site-packages/ansible
ansible collection location = /tmp/tmpn59lzvet
executable location = /usr/bin/ansible-playbook
python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)]
jinja version = 2.11.3
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: centos-8_setup.yml ***************************************************
1 plays in /cache/centos-8_setup.yml
PLAY [Enable HA repos] *********************************************************
META: ran handlers
TASK [Enable HA repos] *********************************************************
task path: /cache/centos-8_setup.yml:5
Wednesday 03 August 2022 16:20:59 +0000 (0:00:00.019) 0:00:00.019 ******
changed: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"discovered_interpreter_python": "/usr/libexec/platform-python"
},
"changed": true,
"cmd": [
"dnf",
"config-manager",
"--set-enabled",
"ha"
],
"delta": "0:00:00.367869",
"end": "2022-08-03 16:20:59.971390",
"rc": 0,
"start": "2022-08-03 16:20:59.603521"
}
META: ran handlers
META: ran handlers
PLAY RECAP *********************************************************************
/cache/centos-8.qcow2 : ok=1 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
Wednesday 03 August 2022 16:21:00 +0000 (0:00:01.008) 0:00:01.028 ******
===============================================================================
Enable HA repos --------------------------------------------------------- 1.01s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
PLAYBOOK: tests_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmpsacc72k6/tests/mssql/tests_input_sql_file_2019.yml
PLAY [Ensure that the role can input sql files to MSSQL] ***********************
TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpsacc72k6/tests/mssql/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022 16:21:00 +0000 (0:00:00.011) 0:00:01.039 ******
ok: [/cache/centos-8.qcow2]
META: ran handlers
TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmpsacc72k6/tests/mssql/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022 16:21:01 +0000 (0:00:01.095) 0:00:02.135 ******
TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.114) 0:00:02.250 ******
included: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/centos-8.qcow2
TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.032) 0:00:02.282 ******
ok: [/cache/centos-8.qcow2]
TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.551) 0:00:02.834 ******
ok: [/cache/centos-8.qcow2] => (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": [
"/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
],
"ansible_loop_var": "item",
"changed": false,
"item": "RedHat.yml"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS_8.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS_8.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=CentOS_8.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "CentOS_8.yml",
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.051) 0:00:02.886 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": null
},
"changed": false
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.029) 0:00:02.915 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": null
},
"changed": false
}
TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.031) 0:00:02.947 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22
Wednesday 03 August 2022 16:21:01 +0000 (0:00:00.024) 0:00:02.971 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.023) 0:00:02.994 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.045) 0:00:03.040 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.042) 0:00:03.082 ******
skipping: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.035) 0:00:03.117 ******
skipping: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.036) 0:00:03.153 ******
skipping: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.036) 0:00:03.189 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
Wednesday 03 August 2022 16:21:02 +0000 (0:00:00.036) 0:00:03.225 ******
ok: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85
Wednesday 03 August 2022 16:21:04 +0000 (0:00:02.031) 0:00:05.257 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 03 August 2022 16:21:04 +0000 (0:00:00.045) 0:00:05.303 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true
}
TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102
Wednesday 03 August 2022 16:21:06 +0000 (0:00:01.992) 0:00:07.295 ******
skipping: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113
Wednesday 03 August 2022 16:21:06 +0000 (0:00:00.043) 0:00:07.339 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119
Wednesday 03 August 2022 16:21:06 +0000 (0:00:00.044) 0:00:07.384 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"repo": "packages-microsoft-com-mssql-server-2019",
"state": "present"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
Wednesday 03 August 2022 16:21:06 +0000 (0:00:00.563) 0:00:07.948 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: libpkgconf-1.4.2-1.el8.x86_64",
"Installed: libatomic-8.5.0-15.el8.x86_64",
"Installed: pkgconf-1.4.2-1.el8.x86_64",
"Installed: pkgconf-m4-1.4.2-1.el8.noarch",
"Installed: pkgconf-pkg-config-1.4.2-1.el8.x86_64",
"Installed: glibc-headers-2.28-184.el8.x86_64",
"Installed: isl-0.16.1-6.el8.x86_64",
"Installed: python36-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64",
"Installed: binutils-2.30-117.el8.x86_64",
"Installed: libmpc-1.1.0-9.1.el8.x86_64",
"Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
"Installed: libxcrypt-devel-4.1.1-6.el8.x86_64",
"Installed: gc-7.6.4-3.el8.x86_64",
"Installed: mssql-server-15.0.4236.7-1.x86_64",
"Installed: libipt-1.6.1-8.el8.x86_64",
"Installed: libbabeltrace-1.5.4-4.el8.x86_64",
"Installed: python3-setuptools-39.2.0-6.el8.noarch",
"Installed: gcc-8.5.0-7.el8.x86_64",
"Installed: gdb-8.2-19.el8.x86_64",
"Installed: kernel-headers-4.18.0-408.el8.x86_64",
"Installed: cpp-8.5.0-7.el8.x86_64",
"Installed: cyrus-sasl-2.1.27-5.el8.x86_64",
"Installed: gdb-headless-8.2-19.el8.x86_64",
"Installed: glibc-devel-2.28-184.el8.x86_64",
"Installed: python3-pip-9.0.3-22.el8.noarch",
"Installed: cyrus-sasl-gssapi-2.1.27-5.el8.x86_64",
"Installed: guile-5:2.0.14-7.el8.x86_64",
"Installed: gcc-gdb-plugin-8.5.0-7.el8.x86_64",
"Installed: libatomic_ops-7.6.2-3.el8.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022 16:22:18 +0000 (0:01:11.211) 0:01:19.159 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022 16:22:18 +0000 (0:00:00.032) 0:01:19.191 ******
ok: [/cache/centos-8.qcow2] => {
"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.015173",
"end": "2022-08-03 16:22:18.563176",
"rc": 0,
"start": "2022-08-03 16:22:18.548003"
}
TASK [fedora.linux_system_roles.mssql : Gather system services facts] **********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
Wednesday 03 August 2022 16:22:18 +0000 (0:00:00.438) 0:01:19.630 ******
ok: [/cache/centos-8.qcow2] => {
"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: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022 16:22:20 +0000 (0:00:01.802) 0:01:21.433 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
Wednesday 03 August 2022 16:22:20 +0000 (0:00:00.074) 0:01:21.508 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"-n",
"setup"
],
"delta": "0:00:04.795563",
"end": "2022-08-03 16:22:25.660350",
"rc": 0,
"start": "2022-08-03 16:22:20.864787"
}
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 [fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193
Wednesday 03 August 2022 16:22:25 +0000 (0:00:05.234) 0:01:26.742 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: tuned-2.18.0-3.el8.noarch",
"Installed: tuned-profiles-mssql-2.18.0-3.el8.noarch",
"Removed: tuned-2.16.0-1.el8.noarch"
]
}
TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
Wednesday 03 August 2022 16:22:29 +0000 (0:00:03.875) 0:01:30.617 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"enabled": true,
"name": "tuned",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"ActiveEnterTimestampMonotonic": "104704903",
"ActiveExitTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"ActiveExitTimestampMonotonic": "104270837",
"ActiveState": "active",
"After": "systemd-journald.socket dbus.service basic.target system.slice sysinit.target systemd-sysctl.service dbus.socket network.target",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"AssertTimestampMonotonic": "104504060",
"Before": "shutdown.target multi-user.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-03 16:22:28 UTC",
"ConditionTimestampMonotonic": "104504059",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "cpupower.service shutdown.target",
"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": "15503",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"ExecMainStartTimestampMonotonic": "104505357",
"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",
"InactiveEnterTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"InactiveEnterTimestampMonotonic": "104502740",
"InactiveExitTimestamp": "Wed 2022-08-03 16:22:28 UTC",
"InactiveExitTimestampMonotonic": "104505419",
"InvocationID": "3c0e4da9a5fd40d0834efd188ed7da8a",
"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": "14647",
"LimitNPROCSoft": "14647",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15503",
"MemoryAccounting": "yes",
"MemoryCurrent": "15290368",
"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": "dbus.socket dbus.service polkit.service sysinit.target system.slice",
"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-03 16:22:28 UTC",
"StateChangeTimestampMonotonic": "104704903",
"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": "23435",
"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-03 16:22:28 UTC",
"WatchdogTimestampMonotonic": "104704901",
"WatchdogUSec": "0"
}
}
TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] *********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:204
Wednesday 03 August 2022 16:22:30 +0000 (0:00:00.818) 0:01:31.436 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"tuned-adm",
"active"
],
"delta": "0:00:00.118736",
"end": "2022-08-03 16:22:30.877225",
"rc": 0,
"start": "2022-08-03 16:22:30.758489"
}
STDOUT:
Current active profile: virtual-guest
TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214
Wednesday 03 August 2022 16:22:30 +0000 (0:00:00.509) 0:01:31.945 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"cmd": [
"tuned-adm",
"profile",
"virtual-guest",
"mssql"
],
"delta": "0:00:02.168305",
"end": "2022-08-03 16:22:33.486682",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 16:22:31.318377"
}
TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:227
Wednesday 03 August 2022 16:22:33 +0000 (0:00:02.612) 0:01:34.558 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:236
Wednesday 03 August 2022 16:22:33 +0000 (0:00:00.068) 0:01:34.627 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:246
Wednesday 03 August 2022 16:22:33 +0000 (0:00:00.034) 0:01:34.661 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"repo": "packages-microsoft-com-prod",
"state": "present"
}
TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253
Wednesday 03 August 2022 16:22:34 +0000 (0:00:00.398) 0:01:35.059 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true,
"rc": 0,
"results": [
"Installed: mssql-tools-17.10.1.1-1.x86_64",
"Installed: unixODBC-2.3.7-1.rh.x86_64",
"Installed: unixODBC-devel-2.3.7-1.rh.x86_64",
"Installed: msodbcsql17-17.10.1.1-1.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:265
Wednesday 03 August 2022 16:22:38 +0000 (0:00:04.314) 0:01:39.374 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:270
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.038) 0:01:39.413 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:276
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.037) 0:01:39.450 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Change the password of the sa user] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:283
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.036) 0:01:39.487 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.089) 0:01:39.576 ******
included: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/centos-8.qcow2
TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.068) 0:01:39.644 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 16:22:38 +0000 (0:00:00.050) 0:01:39.695 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.5_tpe1lo",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 0,
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 16:22:39 +0000 (0:00:00.497) 0:01:40.192 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.5_tpe1lo",
"gid": 0,
"group": "root",
"md5sum": "8edbc22195757a4f043b10e9367f131b",
"mode": "0644",
"owner": "root",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 391,
"src": "/root/.ansible/tmp/ansible-tmp-1659543759.2634778-64048-228429773293803/source",
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 16:22:40 +0000 (0:00:00.971) 0:01:41.163 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 16:22:40 +0000 (0:00:00.039) 0:01:41.203 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ActiveEnterTimestampMonotonic": "101328993",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target basic.target system.slice sysinit.target systemd-journald.socket auditd.service -.mount",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"AssertTimestampMonotonic": "101318278",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 16:22:25 UTC",
"ConditionTimestampMonotonic": "101318278",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15217",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ExecMainStartTimestampMonotonic": "101328956",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"InactiveExitTimestampMonotonic": "101328993",
"InvocationID": "42925a68480c4f80a918d1484b2e1152",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15217",
"MemoryAccounting": "yes",
"MemoryCurrent": "650248192",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "system.slice sysinit.target -.mount",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"StateChangeTimestampMonotonic": "101328993",
"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": "141",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"WatchdogTimestampMonotonic": "101328991",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 16:22:40 +0000 (0:00:00.525) 0:01:41.729 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"elapsed": 0,
"gid": 987,
"group": "mssql",
"match_groupdict": {},
"match_groups": [],
"mode": "0660",
"owner": "mssql",
"path": "/var/opt/mssql/log/errorlog",
"port": null,
"search_regex": "SQL Server is now ready for client connections",
"secontext": "system_u:object_r:var_t:s0",
"size": 7681,
"state": "file",
"uid": 989
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 16:22:41 +0000 (0:00:00.537) 0:01:42.266 ******
included: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml for /cache/centos-8.qcow2
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022 16:22:41 +0000 (0:00:00.065) 0:01:42.332 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ActiveEnterTimestampMonotonic": "101328993",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target basic.target system.slice sysinit.target systemd-journald.socket auditd.service -.mount",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"AssertTimestampMonotonic": "101318278",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 16:22:25 UTC",
"ConditionTimestampMonotonic": "101318278",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15217",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ExecMainStartTimestampMonotonic": "101328956",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"InactiveExitTimestampMonotonic": "101328993",
"InvocationID": "42925a68480c4f80a918d1484b2e1152",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15217",
"MemoryAccounting": "yes",
"MemoryCurrent": "650252288",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "system.slice sysinit.target -.mount",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"StateChangeTimestampMonotonic": "101328993",
"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": "141",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"WatchdogTimestampMonotonic": "101328991",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Check if a custom tcpport setting exist] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022 16:22:41 +0000 (0:00:00.554) 0:01:42.887 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003527",
"end": "2022-08-03 16:22:42.230257",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:22:42.226730"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Check if a custom ipaddress setting exist] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022 16:22:42 +0000 (0:00:00.411) 0:01:43.298 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^ipaddress = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003746",
"end": "2022-08-03 16:22:42.616519",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:22:42.612773"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Set a fact with a password query] ******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022 16:22:42 +0000 (0:00:00.382) 0:01:43.680 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": "/opt/mssql-tools/bin/sqlcmd -U sa -P p@55w0rD"
},
"changed": false
}
TASK [fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 16:22:42 +0000 (0:00:00.066) 0:01:43.747 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.5_tpe1lo",
"-b"
],
"delta": "0:00:00.327758",
"end": "2022-08-03 16:22:43.403431",
"rc": 0,
"start": "2022-08-03 16:22:43.075673"
}
STDOUT:
Changed database context to 'ExampleDB'.
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
TASK [fedora.linux_system_roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.730) 0:01:44.477 ******
ok: [/cache/centos-8.qcow2] => {
"__mssql_sqlcmd_input_file.stdout_lines": [
"Changed database context to 'ExampleDB'.",
"",
"(1 rows affected)",
"",
"(1 rows affected)",
"",
"(1 rows affected)",
"",
"(1 rows affected)"
]
}
TASK [fedora.linux_system_roles.mssql : Remove the tempfile] *******************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.068) 0:01:44.546 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.042) 0:01:44.588 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the mssql_pre_input_sql_file fact] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:297
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.038) 0:01:44.627 ******
ok: [/cache/centos-8.qcow2] => {
"ansible_facts": {
"mssql_pre_input_sql_file": null
},
"changed": false
}
TASK [fedora.linux_system_roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:306
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.047) 0:01:44.674 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:319
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.037) 0:01:44.712 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Change the edition of MSSQL] ***********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:326
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.038) 0:01:44.750 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the IP address setting] ******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:335
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.038) 0:01:44.788 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:342
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.041) 0:01:44.830 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:349
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.049) 0:01:44.879 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:360
Wednesday 03 August 2022 16:22:43 +0000 (0:00:00.046) 0:01:44.925 ******
included: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for /cache/centos-8.qcow2
TASK [fedora.linux_system_roles.mssql : Get the network tcpport setting] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022 16:22:44 +0000 (0:00:00.070) 0:01:44.995 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.004051",
"end": "2022-08-03 16:22:44.357283",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:22:44.353232"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Configure the network tcpport setting] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022 16:22:44 +0000 (0:00:00.428) 0:01:45.424 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"set",
"network.tcpport",
"1433"
],
"delta": "0:00:00.110020",
"end": "2022-08-03 16:22:44.875255",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 16:22:44.765235"
}
STDOUT:
Validation error on setting 'network.tcpport'
Port '1433' is already in use. Please use another port
TASK [fedora.linux_system_roles.mssql : Unset the network tcpport setting] *****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022 16:22:44 +0000 (0:00:00.523) 0:01:45.948 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:366
Wednesday 03 August 2022 16:22:44 +0000 (0:00:00.033) 0:01:45.981 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:384
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.043) 0:01:46.025 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-fts package] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:391
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.036) 0:01:46.062 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the powershell package] *********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:398
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.040) 0:01:46.102 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:407
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.044) 0:01:46.146 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the hadrenabled setting] *****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:413
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.061) 0:01:46.208 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Check if the 3979 trace flag is enabled] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:422
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.048) 0:01:46.256 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Set the 3979 traceflag] ****************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:428
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.039) 0:01:46.296 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the 3979 traceflag] **************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:434
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.037) 0:01:46.334 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:441
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.036) 0:01:46.370 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the writethrough setting] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:447
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.034) 0:01:46.405 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:458
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.037) 0:01:46.442 ******
skipping: [/cache/centos-8.qcow2] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] *********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:474
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.044) 0:01:46.487 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] **********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:483
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.035) 0:01:46.523 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:492
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.040) 0:01:46.563 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:499
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.036) 0:01:46.599 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 5022/tcp port and enable the high-availability service in firewall] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:509
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.041) 0:01:46.641 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Set host variables] ********************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:528
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.124) 0:01:46.766 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:539
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.080) 0:01:46.846 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:545
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.047) 0:01:46.894 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:552
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.042) 0:01:46.937 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:559
Wednesday 03 August 2022 16:22:45 +0000 (0:00:00.045) 0:01:46.982 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:564
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.045) 0:01:47.028 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate and private key files] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:570
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.046) 0:01:47.074 ******
skipping: [/cache/centos-8.qcow2] => (item=/var/opt/mssql/data/.cer) => {
"ansible_loop_var": "item",
"changed": false,
"item": "/var/opt/mssql/data/.cer",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=/var/opt/mssql/data/.pvk) => {
"ansible_loop_var": "item",
"changed": false,
"item": "/var/opt/mssql/data/.pvk",
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create master key encryption] **********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:579
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.052) 0:01:47.126 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create and back up certificate] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:584
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.051) 0:01:47.178 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Fetch certificate and private key from the primary node to the control node] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:590
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.048) 0:01:47.227 ******
skipping: [/cache/centos-8.qcow2] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "cert",
"value": "/var/opt/mssql/data/.cer"
},
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "key",
"value": "/var/opt/mssql/data/.pvk"
},
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create database mirroring endpoints] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:602
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.055) 0:01:47.282 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create the] ****************************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:607
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.050) 0:01:47.333 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Get mssql-server version to see if WRITE_LEASE_VALIDITY is available] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:613
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.045) 0:01:47.378 ******
skipping: [/cache/centos-8.qcow2] => {
"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 : Create the availability group] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:618
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.047) 0:01:47.426 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Grant permissions to the login] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:623
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.049) 0:01:47.475 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Back up and replicate the database] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:628
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.047) 0:01:47.523 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Set a fact to indicate successful set up on the primary replica] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:635
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.054) 0:01:47.578 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Fail if the primary node failed] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:662
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.051) 0:01:47.630 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:669
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.047) 0:01:47.678 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:675
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.090) 0:01:47.769 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:682
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.045) 0:01:47.815 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:689
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.047) 0:01:47.862 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create master key encryption] **********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:694
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.045) 0:01:47.907 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:699
Wednesday 03 August 2022 16:22:46 +0000 (0:00:00.049) 0:01:47.957 ******
skipping: [/cache/centos-8.qcow2] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "cert",
"value": "/var/opt/mssql/data/.cer"
},
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'}) => {
"ansible_loop_var": "item",
"changed": false,
"item": {
"key": "key",
"value": "/var/opt/mssql/data/.pvk"
},
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:711
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.056) 0:01:48.013 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Restore certificate] *******************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:717
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.048) 0:01:48.062 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create database mirroring endpoints] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:722
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.047) 0:01:48.109 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create the login] *********************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:727
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.043) 0:01:48.152 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Join synchronous and witness servers to the availability group] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:732
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.044) 0:01:48.197 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Grant permissions to the login] *******
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:737
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.045) 0:01:48.243 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify if the database exists on secondaries] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:742
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.049) 0:01:48.292 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate and private key from the control node] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:749
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.050) 0:01:48.342 ******
skipping: [/cache/centos-8.qcow2] => (item=cert) => {
"ansible_loop_var": "item",
"changed": false,
"item": "cert",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/centos-8.qcow2] => (item=key) => {
"ansible_loop_var": "item",
"changed": false,
"item": "key",
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Save credentials for the SQL Server login] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:762
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.047) 0:01:48.390 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:773
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.046) 0:01:48.437 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify if the database exists] ********
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:778
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.050) 0:01:48.487 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786
Wednesday 03 August 2022 16:22:47 +0000 (0:00:00.050) 0:01:48.537 ******
changed: [/cache/centos-8.qcow2] => {
"changed": true
}
MSG:
Block inserted
TASK [fedora.linux_system_roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:795
Wednesday 03 August 2022 16:22:48 +0000 (0:00:00.621) 0:01:49.158 ******
included: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/centos-8.qcow2
TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 16:22:48 +0000 (0:00:00.070) 0:01:49.229 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 16:22:48 +0000 (0:00:00.049) 0:01:49.279 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.wkc5h89s",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 0,
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 16:22:48 +0000 (0:00:00.381) 0:01:49.661 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.wkc5h89s",
"gid": 0,
"group": "root",
"md5sum": "8edbc22195757a4f043b10e9367f131b",
"mode": "0644",
"owner": "root",
"secontext": "unconfined_u:object_r:user_tmp_t:s0",
"size": 391,
"src": "/root/.ansible/tmp/ansible-tmp-1659543768.731833-64374-90655216099961/source",
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 16:22:49 +0000 (0:00:00.726) 0:01:50.387 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 16:22:49 +0000 (0:00:00.039) 0:01:50.427 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ActiveEnterTimestampMonotonic": "101328993",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target basic.target system.slice sysinit.target systemd-journald.socket auditd.service -.mount",
"AllowIsolate": "no",
"AllowedCPUs": "",
"AllowedMemoryNodes": "",
"AmbientCapabilities": "",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"AssertTimestampMonotonic": "101318278",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"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-03 16:22:25 UTC",
"ConditionTimestampMonotonic": "101318278",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"DefaultDependencies": "yes",
"DefaultMemoryLow": "0",
"DefaultMemoryMin": "0",
"Delegate": "no",
"Description": "Microsoft SQL Server Database Engine",
"DevicePolicy": "auto",
"Documentation": "https://docs.microsoft.com/en-us/sql/linux",
"DynamicUser": "no",
"EffectiveCPUs": "",
"EffectiveMemoryNodes": "",
"ExecMainCode": "0",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "15217",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"ExecMainStartTimestampMonotonic": "101328956",
"ExecMainStatus": "0",
"ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; 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/mssql-server.service",
"FreezerState": "running",
"GID": "987",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOSchedulingClass": "0",
"IOSchedulingPriority": "0",
"IOWeight": "[not set]",
"IPAccounting": "no",
"IPEgressBytes": "18446744073709551615",
"IPEgressPackets": "18446744073709551615",
"IPIngressBytes": "18446744073709551615",
"IPIngressPackets": "18446744073709551615",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"InactiveExitTimestampMonotonic": "101328993",
"InvocationID": "42925a68480c4f80a918d1484b2e1152",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"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": "infinity",
"LimitNOFILESoft": "infinity",
"LimitNPROC": "infinity",
"LimitNPROCSoft": "infinity",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "14647",
"LimitSIGPENDINGSoft": "14647",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "15217",
"MemoryAccounting": "yes",
"MemoryCurrent": "670130176",
"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": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"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": "system.slice sysinit.target -.mount",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"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": "3",
"StartLimitIntervalUSec": "2min",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"StateChangeTimestampMonotonic": "101328993",
"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": "142",
"TasksMax": "infinity",
"TimeoutStartUSec": "30min",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "989",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogTimestamp": "Wed 2022-08-03 16:22:25 UTC",
"WatchdogTimestampMonotonic": "101328991",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 16:22:49 +0000 (0:00:00.529) 0:01:50.956 ******
ok: [/cache/centos-8.qcow2] => {
"changed": false,
"elapsed": 0,
"gid": 987,
"group": "mssql",
"match_groupdict": {},
"match_groups": [],
"mode": "0660",
"owner": "mssql",
"path": "/var/opt/mssql/log/errorlog",
"port": null,
"search_regex": "SQL Server is now ready for client connections",
"secontext": "system_u:object_r:var_t:s0",
"size": 8075,
"state": "file",
"uid": 989
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.426) 0:01:51.382 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.042) 0:01:51.425 ******
fatal: [/cache/centos-8.qcow2]: FAILED! => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.wkc5h89s",
"-b"
],
"delta": "0:00:00.026786",
"end": "2022-08-03 16:22:50.761667",
"rc": 1,
"start": "2022-08-03 16:22:50.734881"
}
STDOUT:
Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1
The server principal 'MyLogin' already exists.
Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2
User, group, or role 'MyUser' already exists in the current database.
Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3
Database 'ExampleDB' already exists. Choose a different database name.
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Print the output of the sqlcmd command for sql_script.sql if not empty] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.409) 0:01:51.835 ******
ok: [/cache/centos-8.qcow2] => {
"__mssql_sqlcmd_input_file.stdout_lines": [
"Msg 15025, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 1",
"The server principal 'MyLogin' already exists.",
"Msg 15023, Level 16, State 1, Server ibm-p8-kvm-03-guest-02, Line 2",
"User, group, or role 'MyUser' already exists in the current database.",
"Msg 1801, Level 16, State 3, Server ibm-p8-kvm-03-guest-02, Line 3",
"Database 'ExampleDB' already exists. Choose a different database name."
]
}
TASK [fedora.linux_system_roles.mssql : Remove the tempfile] *******************
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.067) 0:01:51.902 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.036) 0:01:51.939 ******
skipping: [/cache/centos-8.qcow2] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
PLAY RECAP *********************************************************************
/cache/centos-8.qcow2 : ok=48 changed=10 unreachable=0 failed=1 skipped=82 rescued=0 ignored=0
Wednesday 03 August 2022 16:22:50 +0000 (0:00:00.016) 0:01:51.956 ******
===============================================================================
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 71.21s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 5.23s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 4.31s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253
fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.88s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193
fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 2.61s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214
fedora.linux_system_roles.mssql : Gather package facts ------------------ 2.03s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.99s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.80s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
Gathering Facts --------------------------------------------------------- 1.10s
/tmp/tmpsacc72k6/tests/mssql/tests_input_sql_file_2019.yml:3 ------------------
Enable HA repos --------------------------------------------------------- 1.01s
/cache/centos-8_setup.yml:5 ---------------------------------------------------
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 0.97s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled --- 0.82s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.73s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 0.73s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.62s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.56s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.55s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.55s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections --- 0.54s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.53s
/tmp/tmpn59lzvet/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41