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/tmpxn3yv_ek
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: tests_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml
PLAY [Ensure that the role can input sql files to MSSQL] ***********************
TASK [Gathering Facts] *********************************************************
task path: /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022 16:46:19 +0000 (0:00:00.013) 0:00:00.013 ******
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers
TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022 16:46:20 +0000 (0:00:01.365) 0:00:01.378 ******
TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:3
Wednesday 03 August 2022 16:46:20 +0000 (0:00:00.091) 0:00:01.470 ******
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/fedora-35.qcow2.snap
TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022 16:46:20 +0000 (0:00:00.033) 0:00:01.503 ******
ok: [/cache/fedora-35.qcow2.snap]
TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.598) 0:00:02.102 ******
ok: [/cache/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/vars/RedHat.yml"
],
"ansible_loop_var": "item",
"changed": false,
"item": "RedHat.yml"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora_35.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora_35.yml",
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:8
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.050) 0:00:02.152 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"ansible_facts": {
"__mssql_sqlcmd_login_cmd": null
},
"changed": false
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:12
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.030) 0:00:02.182 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:16
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.028) 0:00:02.211 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:22
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.023) 0:00:02.235 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:27
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.024) 0:00:02.260 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:39
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.044) 0:00:02.304 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:44
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.048) 0:00:02.352 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:55
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.036) 0:00:02.388 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:63
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.037) 0:00:02.426 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:72
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.034) 0:00:02.460 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Gather package facts] *************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:85
Wednesday 03 August 2022 16:46:21 +0000 (0:00:00.036) 0:00:02.497 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:90
Wednesday 03 August 2022 16:46:22 +0000 (0:00:01.092) 0:00:03.590 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:101
Wednesday 03 August 2022 16:46:22 +0000 (0:00:00.045) 0:00:03.635 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:107
Wednesday 03 August 2022 16:46:23 +0000 (0:00:00.769) 0:00:04.405 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:118
Wednesday 03 August 2022 16:46:23 +0000 (0:00:00.049) 0:00:04.455 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:124
Wednesday 03 August 2022 16:46:23 +0000 (0:00:00.051) 0:00:04.506 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"repo": "packages-microsoft-com-mssql-server-2019",
"state": "present"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:134
Wednesday 03 August 2022 16:46:24 +0000 (0:00:00.578) 0:00:05.084 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: mssql-server-15.0.4236.7-1.x86_64"
]
}
TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:142
Wednesday 03 August 2022 16:47:01 +0000 (0:00:37.417) 0:00:42.501 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: openldap-compat-2.4.59-3.fc35.x86_64"
]
}
TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:150
Wednesday 03 August 2022 16:47:04 +0000 (0:00:02.331) 0:00:44.832 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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.005559",
"end": "2022-08-03 16:47:03.300526",
"rc": 0,
"start": "2022-08-03 16:47:03.294967"
}
TASK [linux-system-roles.mssql : Gather system services facts] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:165
Wednesday 03 August 2022 16:47:04 +0000 (0:00:00.536) 0:00:45.369 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:179
Wednesday 03 August 2022 16:47:06 +0000 (0:00:02.025) 0:00:47.394 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Set up MSSQL] *********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:189
Wednesday 03 August 2022 16:47:06 +0000 (0:00:00.103) 0:00:47.497 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"-n",
"setup"
],
"delta": "0:00:04.885476",
"end": "2022-08-03 16:47:10.752232",
"rc": 0,
"start": "2022-08-03 16:47:05.866756"
}
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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:198
Wednesday 03 August 2022 16:47:12 +0000 (0:00:05.348) 0:00:52.846 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: ethtool-2:5.18-1.fc35.x86_64",
"Installed: python3-gobject-base-3.42.0-1.fc35.x86_64",
"Installed: hdparm-9.63-1.fc35.x86_64",
"Installed: kernel-tools-5.18.13-100.fc35.x86_64",
"Installed: kernel-tools-libs-5.18.13-100.fc35.x86_64",
"Installed: tuned-2.18.0-2.fc35.noarch",
"Installed: python3-perf-5.18.13-100.fc35.x86_64",
"Installed: gobject-introspection-1.70.0-1.fc35.x86_64",
"Installed: tuned-profiles-mssql-2.18.0-2.fc35.noarch",
"Installed: python3-linux-procfs-0.6.3-3.fc35.noarch",
"Installed: python3-pyudev-0.22.0-6.fc35.noarch",
"Installed: virt-what-1.24-1.fc35.x86_64"
]
}
TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:203
Wednesday 03 August 2022 16:47:15 +0000 (0:00:03.641) 0:00:56.488 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"enabled": true,
"name": "tuned",
"state": "started",
"status": {
"ActiveEnterTimestamp": "n/a",
"ActiveEnterTimestampMonotonic": "0",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "inactive",
"After": "sysinit.target systemd-journald.socket dbus.socket dbus-broker.service system.slice basic.target systemd-sysctl.service network.target",
"AllowIsolate": "no",
"AssertResult": "no",
"AssertTimestamp": "n/a",
"AssertTimestampMonotonic": "0",
"Before": "shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"BusName": "com.redhat.tuned",
"CPUAccounting": "yes",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "no",
"ConditionTimestamp": "n/a",
"ConditionTimestampMonotonic": "0",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target auto-cpufreq.service tlp.service cpupower.service power-profiles-daemon.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "0",
"ExecMainStartTimestamp": "n/a",
"ExecMainStartTimestampMonotonic": "0",
"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 }",
"ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/tuned.service",
"FreezerState": "running",
"GID": "[not set]",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "tuned.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "n/a",
"InactiveExitTimestampMonotonic": "0",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "control-group",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"LimitMSGQUEUE": "819200",
"LimitMSGQUEUESoft": "819200",
"LimitNICE": "0",
"LimitNICESoft": "0",
"LimitNOFILE": "524288",
"LimitNOFILESoft": "1024",
"LimitNPROC": "15523",
"LimitNPROCSoft": "15523",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "0",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "[not set]",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "tuned.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"PIDFile": "/run/tuned/tuned.pid",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "dbus-broker.service polkit.service sysinit.target system.slice dbus.socket",
"Restart": "no",
"RestartKillSignal": "15",
"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",
"StandardOutput": "journal",
"StartLimitAction": "none",
"StartLimitBurst": "5",
"StartLimitIntervalUSec": "10s",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "n/a",
"StateChangeTimestampMonotonic": "0",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "dead",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "[not set]",
"TasksMax": "4656",
"TimeoutAbortUSec": "1min 30s",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "1min 30s",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "1min 30s",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "dbus",
"UID": "[not set]",
"UMask": "0022",
"UnitFilePreset": "disabled",
"UnitFileState": "disabled",
"UtmpMode": "init",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "infinity"
}
}
TASK [linux-system-roles.mssql : Get the active Tuned profiles] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:209
Wednesday 03 August 2022 16:47:17 +0000 (0:00:01.342) 0:00:57.830 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"tuned-adm",
"active"
],
"delta": "0:00:00.106106",
"end": "2022-08-03 16:47:16.306425",
"rc": 0,
"start": "2022-08-03 16:47:16.200319"
}
STDOUT:
Current active profile: virtual-guest
TASK [linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:219
Wednesday 03 August 2022 16:47:17 +0000 (0:00:00.549) 0:00:58.380 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"cmd": [
"tuned-adm",
"profile",
"virtual-guest",
"mssql"
],
"delta": "0:00:01.107010",
"end": "2022-08-03 16:47:17.829539",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 16:47:16.722529"
}
TASK [linux-system-roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:232
Wednesday 03 August 2022 16:47:19 +0000 (0:00:01.529) 0:00:59.909 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:241
Wednesday 03 August 2022 16:47:19 +0000 (0:00:00.039) 0:00:59.948 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:251
Wednesday 03 August 2022 16:47:19 +0000 (0:00:00.038) 0:00:59.987 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:258
Wednesday 03 August 2022 16:47:19 +0000 (0:00:00.430) 0:01:00.417 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: msodbcsql17-17.10.1.1-1.x86_64",
"Installed: mssql-tools-17.10.1.1-1.x86_64",
"Installed: unixODBC-2.3.9-4.fc35.x86_64",
"Installed: unixODBC-devel-2.3.9-4.fc35.x86_64"
]
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:270
Wednesday 03 August 2022 16:47:22 +0000 (0:00:02.781) 0:01:03.198 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:275
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.041) 0:01:03.240 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:281
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.044) 0:01:03.284 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Change the password of the sa user] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:288
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.041) 0:01:03.326 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:296
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.041) 0:01:03.367 ******
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap
TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.073) 0:01:03.440 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 16:47:22 +0000 (0:00:00.124) 0:01:03.565 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.f44o7xyl",
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 16:47:23 +0000 (0:00:00.518) 0:01:04.083 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.f44o7xyl",
"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-1659545243.4188056-84291-69763973753938/source",
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 16:47:24 +0000 (0:00:01.028) 0:01:05.112 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 16:47:24 +0000 (0:00:00.040) 0:01:05.153 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ActiveEnterTimestampMonotonic": "61981258",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"AssertTimestampMonotonic": "61977350",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "5107692000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ConditionTimestampMonotonic": "61977346",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2767",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ExecMainStartTimestampMonotonic": "61980637",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"InactiveExitTimestampMonotonic": "61981258",
"InvocationID": "f833cbe64ce74be387f09529551b4a81",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2767",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "645103616",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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:47:10 UTC",
"StateChangeTimestampMonotonic": "61981258",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "143",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 16:47:24 +0000 (0:00:00.565) 0:01:05.719 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"elapsed": 0,
"gid": 992,
"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": 7697,
"state": "file",
"uid": 992
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 16:47:25 +0000 (0:00:00.545) 0:01:06.264 ******
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml for /cache/fedora-35.qcow2.snap
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022 16:47:25 +0000 (0:00:00.100) 0:01:06.365 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ActiveEnterTimestampMonotonic": "61981258",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"AssertTimestampMonotonic": "61977350",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "5119409000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ConditionTimestampMonotonic": "61977346",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2767",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ExecMainStartTimestampMonotonic": "61980637",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"InactiveExitTimestampMonotonic": "61981258",
"InvocationID": "f833cbe64ce74be387f09529551b4a81",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2767",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "645103616",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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:47:10 UTC",
"StateChangeTimestampMonotonic": "61981258",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "143",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Check if a custom tcpport setting exist] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022 16:47:26 +0000 (0:00:00.569) 0:01:06.935 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003699",
"end": "2022-08-03 16:47:25.285595",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:47:25.281896"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Check if a custom ipaddress setting exist] ****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022 16:47:26 +0000 (0:00:00.428) 0:01:07.363 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^ipaddress = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.004344",
"end": "2022-08-03 16:47:25.699479",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:47:25.695135"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Set a fact with a password query] *************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022 16:47:27 +0000 (0:00:00.418) 0:01:07.782 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 16:47:27 +0000 (0:00:00.066) 0:01:07.849 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.f44o7xyl",
"-b"
],
"delta": "0:00:00.276306",
"end": "2022-08-03 16:47:26.458123",
"rc": 0,
"start": "2022-08-03 16:47:26.181817"
}
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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 16:47:27 +0000 (0:00:00.697) 0:01:08.546 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"__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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 16:47:27 +0000 (0:00:00.105) 0:01:08.651 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 16:47:27 +0000 (0:00:00.042) 0:01:08.694 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the mssql_pre_input_sql_file fact] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:302
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.042) 0:01:08.736 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:311
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.044) 0:01:08.781 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:324
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.042) 0:01:08.823 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Change the edition of MSSQL] ******************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:331
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.039) 0:01:08.863 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the IP address setting] *************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:340
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.038) 0:01:08.902 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Register the previous tcpport setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:347
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.040) 0:01:08.943 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:354
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.050) 0:01:08.993 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the TCP port setting to 1433] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:365
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.049) 0:01:09.043 ******
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml for /cache/fedora-35.qcow2.snap
TASK [linux-system-roles.mssql : Get the network tcpport setting] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.063) 0:01:09.106 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003852",
"end": "2022-08-03 16:47:27.467938",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 16:47:27.464086"
}
MSG:
non-zero return code
TASK [linux-system-roles.mssql : Configure the network tcpport setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022 16:47:28 +0000 (0:00:00.440) 0:01:09.547 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"set",
"network.tcpport",
"1433"
],
"delta": "0:00:00.102656",
"end": "2022-08-03 16:47:28.008387",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 16:47:27.905731"
}
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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.550) 0:01:10.097 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:371
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.037) 0:01:10.135 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the sqlagent setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:389
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.051) 0:01:10.187 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-fts package] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:396
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.042) 0:01:10.230 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the powershell package] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:403
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.040) 0:01:10.271 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:412
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.041) 0:01:10.313 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the hadrenabled setting] ************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:418
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.040) 0:01:10.354 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Check if the 3979 trace flag is enabled] ******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:427
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.039) 0:01:10.393 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Set the 3979 traceflag] ***********************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:433
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.038) 0:01:10.432 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the 3979 traceflag] *********************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:439
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.040) 0:01:10.472 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:446
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.039) 0:01:10.511 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the writethrough setting] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:452
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.040) 0:01:10.552 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:463
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.039) 0:01:10.592 ******
skipping: [/cache/fedora-35.qcow2.snap] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:479
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.042) 0:01:10.634 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the tlskey setting] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:488
Wednesday 03 August 2022 16:47:29 +0000 (0:00:00.040) 0:01:10.675 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the tlsprotocols setting] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:497
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.087) 0:01:10.762 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Configure the forceencryption setting] ********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:504
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.040) 0:01:10.803 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:514
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.045) 0:01:10.848 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Set host variables] ***************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:533
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.056) 0:01:10.905 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:544
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.050) 0:01:10.956 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:550
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.054) 0:01:11.010 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:557
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.049) 0:01:11.060 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:565
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.047) 0:01:11.107 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate from SQL Server] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:570
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.049) 0:01:11.157 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Remove certificate and private key files] *****
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:576
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.047) 0:01:11.204 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:585
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.050) 0:01:11.255 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create and back up certificate] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:590
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.049) 0:01:11.304 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:596
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.050) 0:01:11.354 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:608
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.059) 0:01:11.414 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create the] ***********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:613
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.051) 0:01:11.465 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:619
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.051) 0:01:11.517 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:624
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.097) 0:01:11.615 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Grant permissions to the login] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:629
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.052) 0:01:11.667 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Back up and replicate the database] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:634
Wednesday 03 August 2022 16:47:30 +0000 (0:00:00.051) 0:01:11.718 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:641
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.056) 0:01:11.775 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Fail if the primary node failed] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:668
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.055) 0:01:11.830 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure the mssql-server-ha package] ***********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:675
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.053) 0:01:11.884 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable the hadrenabled setting] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:681
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.049) 0:01:11.933 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:688
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.048) 0:01:11.982 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Enable AlwaysOn Health events] ****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:696
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.051) 0:01:12.034 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create master key encryption] *****************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:701
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.048) 0:01:12.082 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:706
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.047) 0:01:12.130 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:718
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.058) 0:01:12.188 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Restore certificate] **************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:724
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.048) 0:01:12.236 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create database mirroring endpoints] **********
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:729
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.050) 0:01:12.287 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Create the login] ****************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:734
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.054) 0:01:12.342 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:739
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.055) 0:01:12.397 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Grant permissions to the login] **************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:744
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.051) 0:01:12.449 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify if the database exists on secondaries] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:749
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.115) 0:01:12.565 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:756
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.081) 0:01:12.646 ******
skipping: [/cache/fedora-35.qcow2.snap] => (item=cert) => {
"ansible_loop_var": "item",
"changed": false,
"item": "cert",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:769
Wednesday 03 August 2022 16:47:31 +0000 (0:00:00.064) 0:01:12.710 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:780
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.055) 0:01:12.765 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Verify if the database exists] ***************
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:785
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.054) 0:01:12.819 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:793
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.053) 0:01:12.873 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true
}
MSG:
Block inserted
TASK [linux-system-roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:802
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.660) 0:01:13.534 ******
included: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap
TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.071) 0:01:13.606 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [linux-system-roles.mssql : Create a tempfile for the SQL file on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 16:47:32 +0000 (0:00:00.050) 0:01:13.656 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.0fiu_43f",
"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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 16:47:33 +0000 (0:00:00.407) 0:01:14.063 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.0fiu_43f",
"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-1659545253.4433212-84617-214991567097609/source",
"state": "file",
"uid": 0
}
TASK [linux-system-roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 16:47:34 +0000 (0:00:00.809) 0:01:14.872 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 16:47:34 +0000 (0:00:00.043) 0:01:14.916 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ActiveEnterTimestampMonotonic": "61981258",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "auditd.service network.target sysinit.target system.slice -.mount basic.target systemd-journald.socket",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"AssertTimestampMonotonic": "61977350",
"Before": "shutdown.target multi-user.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "5339878000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ConditionTimestampMonotonic": "61977346",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2767",
"ExecMainStartTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"ExecMainStartTimestampMonotonic": "61980637",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 16:47:10 UTC",
"InactiveExitTimestampMonotonic": "61981258",
"InvocationID": "f833cbe64ce74be387f09529551b4a81",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2767",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "661016576",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "-.mount system.slice sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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:47:10 UTC",
"StateChangeTimestampMonotonic": "61981258",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "141",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [linux-system-roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 16:47:34 +0000 (0:00:00.567) 0:01:15.484 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"elapsed": 0,
"gid": 992,
"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": 8091,
"state": "file",
"uid": 992
}
TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] *******
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.414) 0:01:15.898 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.043) 0:01:15.941 ******
fatal: [/cache/fedora-35.qcow2.snap]: FAILED! => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.0fiu_43f",
"-b"
],
"delta": "0:00:00.025160",
"end": "2022-08-03 16:47:34.294311",
"rc": 1,
"start": "2022-08-03 16:47:34.269151"
}
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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.435) 0:01:16.376 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"__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/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.158) 0:01:16.535 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.042) 0:01:16.578 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=48 changed=10 unreachable=0 failed=1 skipped=81 rescued=0 ignored=0
Wednesday 03 August 2022 16:47:35 +0000 (0:00:00.018) 0:01:16.596 ******
===============================================================================
linux-system-roles.mssql : Ensure the mssql-server package ------------- 37.42s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------
linux-system-roles.mssql : Set up MSSQL --------------------------------- 5.35s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:189 ------
linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.64s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:198 ------
linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 2.78s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:258 ------
linux-system-roles.mssql : Ensure that the openldap-compat package is installed --- 2.33s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 ------
linux-system-roles.mssql : Gather system services facts ----------------- 2.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------
linux-system-roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.53s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:219 ------
Gathering Facts --------------------------------------------------------- 1.37s
/tmp/tmpc9fejdi1/tests/tests_input_sql_file_2019.yml:3 ------------------------
linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 1.34s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:203 ------
linux-system-roles.mssql : Gather package facts ------------------------- 1.09s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 -------
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 1.03s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
linux-system-roles.mssql : Copy the sql_script.sql file to the host ----- 0.81s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:24
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.77s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------
linux-system-roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.70s
/tmp/tmpc9fejdi1/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.66s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:793 ------
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.60s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ----
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.58s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/verify_password.yml:3
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/tests/roles/linux-system-roles.mssql/tasks/input_sql_file.yml:41
linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpc9fejdi1/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/tmpxn3yv_ek
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: tests_input_sql_file_2019.yml ****************************************
1 plays in /tmp/tmphentkgqr/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/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:3
Wednesday 03 August 2022 17:19:38 +0000 (0:00:00.013) 0:00:00.013 ******
ok: [/cache/fedora-35.qcow2.snap]
META: ran handlers
TASK [Set up MSSQL and input sql files] ****************************************
task path: /tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:10
Wednesday 03 August 2022 17:19:39 +0000 (0:00:01.355) 0:00:01.369 ******
TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 03 August 2022 17:19:39 +0000 (0:00:00.116) 0:00:01.485 ******
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/fedora-35.qcow2.snap
TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 03 August 2022 17:19:39 +0000 (0:00:00.032) 0:00:01.518 ******
ok: [/cache/fedora-35.qcow2.snap]
TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.589) 0:00:02.107 ******
ok: [/cache/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
],
"ansible_loop_var": "item",
"changed": false,
"item": "RedHat.yml"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora_35.yml",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (item=Fedora_35.yml) => {
"ansible_loop_var": "item",
"changed": false,
"item": "Fedora_35.yml",
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.053) 0:00:02.161 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.033) 0:00:02.194 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.031) 0:00:02.226 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.023) 0:00:02.249 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.025) 0:00:02.275 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.047) 0:00:02.322 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.046) 0:00:02.368 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.034) 0:00:02.403 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.033) 0:00:02.437 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.034) 0:00:02.472 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
Wednesday 03 August 2022 17:19:40 +0000 (0:00:00.034) 0:00:02.506 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85
Wednesday 03 August 2022 17:19:42 +0000 (0:00:01.101) 0:00:03.607 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 03 August 2022 17:19:42 +0000 (0:00:00.057) 0:00:03.665 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102
Wednesday 03 August 2022 17:19:42 +0000 (0:00:00.792) 0:00:04.457 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113
Wednesday 03 August 2022 17:19:42 +0000 (0:00:00.047) 0:00:04.505 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119
Wednesday 03 August 2022 17:19:43 +0000 (0:00:00.051) 0:00:04.556 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
Wednesday 03 August 2022 17:19:43 +0000 (0:00:00.571) 0:00:05.127 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: mssql-server-15.0.4236.7-1.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
Wednesday 03 August 2022 17:20:20 +0000 (0:00:36.929) 0:00:42.057 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: openldap-compat-2.4.59-3.fc35.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145
Wednesday 03 August 2022 17:20:23 +0000 (0:00:02.661) 0:00:44.719 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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.005779",
"end": "2022-08-03 17:20:22.290019",
"rc": 0,
"start": "2022-08-03 17:20:22.284240"
}
TASK [fedora.linux_system_roles.mssql : Gather system services facts] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
Wednesday 03 August 2022 17:20:23 +0000 (0:00:00.539) 0:00:45.258 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 03 August 2022 17:20:25 +0000 (0:00:02.078) 0:00:47.336 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false
}
MSG:
All assertions passed
TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
Wednesday 03 August 2022 17:20:25 +0000 (0:00:00.148) 0:00:47.485 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"-n",
"setup"
],
"delta": "0:00:04.435949",
"end": "2022-08-03 17:20:29.392638",
"rc": 0,
"start": "2022-08-03 17:20:24.956689"
}
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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193
Wednesday 03 August 2022 17:20:30 +0000 (0:00:04.888) 0:00:52.373 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: ethtool-2:5.18-1.fc35.x86_64",
"Installed: python3-gobject-base-3.42.0-1.fc35.x86_64",
"Installed: hdparm-9.63-1.fc35.x86_64",
"Installed: kernel-tools-5.18.13-100.fc35.x86_64",
"Installed: kernel-tools-libs-5.18.13-100.fc35.x86_64",
"Installed: tuned-2.18.0-2.fc35.noarch",
"Installed: python3-perf-5.18.13-100.fc35.x86_64",
"Installed: gobject-introspection-1.70.0-1.fc35.x86_64",
"Installed: tuned-profiles-mssql-2.18.0-2.fc35.noarch",
"Installed: python3-linux-procfs-0.6.3-3.fc35.noarch",
"Installed: python3-pyudev-0.22.0-6.fc35.noarch",
"Installed: virt-what-1.24-1.fc35.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
Wednesday 03 August 2022 17:20:34 +0000 (0:00:03.377) 0:00:55.751 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"enabled": true,
"name": "tuned",
"state": "started",
"status": {
"ActiveEnterTimestamp": "n/a",
"ActiveEnterTimestampMonotonic": "0",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "inactive",
"After": "systemd-sysctl.service network.target system.slice dbus.socket dbus-broker.service basic.target systemd-journald.socket sysinit.target",
"AllowIsolate": "no",
"AssertResult": "no",
"AssertTimestamp": "n/a",
"AssertTimestampMonotonic": "0",
"Before": "shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"BusName": "com.redhat.tuned",
"CPUAccounting": "yes",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "no",
"ConditionTimestamp": "n/a",
"ConditionTimestampMonotonic": "0",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "auto-cpufreq.service cpupower.service tlp.service power-profiles-daemon.service shutdown.target",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "0",
"ExecMainStartTimestamp": "n/a",
"ExecMainStartTimestampMonotonic": "0",
"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 }",
"ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/tuned.service",
"FreezerState": "running",
"GID": "[not set]",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "tuned.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "n/a",
"InactiveExitTimestampMonotonic": "0",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "control-group",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"LimitMSGQUEUE": "819200",
"LimitMSGQUEUESoft": "819200",
"LimitNICE": "0",
"LimitNICESoft": "0",
"LimitNOFILE": "524288",
"LimitNOFILESoft": "1024",
"LimitNPROC": "15523",
"LimitNPROCSoft": "15523",
"LimitRSS": "infinity",
"LimitRSSSoft": "infinity",
"LimitRTPRIO": "0",
"LimitRTPRIOSoft": "0",
"LimitRTTIME": "infinity",
"LimitRTTIMESoft": "infinity",
"LimitSIGPENDING": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "0",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "[not set]",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "tuned.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"PIDFile": "/run/tuned/tuned.pid",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "polkit.service sysinit.target dbus-broker.service dbus.socket system.slice",
"Restart": "no",
"RestartKillSignal": "15",
"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",
"StandardOutput": "journal",
"StartLimitAction": "none",
"StartLimitBurst": "5",
"StartLimitIntervalUSec": "10s",
"StartupBlockIOWeight": "[not set]",
"StartupCPUShares": "[not set]",
"StartupCPUWeight": "[not set]",
"StartupIOWeight": "[not set]",
"StateChangeTimestamp": "n/a",
"StateChangeTimestampMonotonic": "0",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "dead",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "[not set]",
"TasksMax": "4656",
"TimeoutAbortUSec": "1min 30s",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "1min 30s",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "1min 30s",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "dbus",
"UID": "[not set]",
"UMask": "0022",
"UnitFilePreset": "disabled",
"UnitFileState": "disabled",
"UtmpMode": "init",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "infinity"
}
}
TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:204
Wednesday 03 August 2022 17:20:35 +0000 (0:00:01.391) 0:00:57.142 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"tuned-adm",
"active"
],
"delta": "0:00:00.108923",
"end": "2022-08-03 17:20:34.747340",
"rc": 0,
"start": "2022-08-03 17:20:34.638417"
}
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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214
Wednesday 03 August 2022 17:20:36 +0000 (0:00:00.581) 0:00:57.724 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"cmd": [
"tuned-adm",
"profile",
"virtual-guest",
"mssql"
],
"delta": "0:00:01.109160",
"end": "2022-08-03 17:20:36.316165",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 17:20:35.207005"
}
TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:227
Wednesday 03 August 2022 17:20:37 +0000 (0:00:01.571) 0:00:59.295 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:236
Wednesday 03 August 2022 17:20:37 +0000 (0:00:00.039) 0:00:59.335 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:246
Wednesday 03 August 2022 17:20:37 +0000 (0:00:00.035) 0:00:59.370 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253
Wednesday 03 August 2022 17:20:38 +0000 (0:00:00.429) 0:00:59.800 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true,
"rc": 0,
"results": [
"Installed: msodbcsql17-17.10.1.1-1.x86_64",
"Installed: mssql-tools-17.10.1.1-1.x86_64",
"Installed: unixODBC-2.3.9-4.fc35.x86_64",
"Installed: unixODBC-devel-2.3.9-4.fc35.x86_64"
]
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:265
Wednesday 03 August 2022 17:20:41 +0000 (0:00:02.764) 0:01:02.564 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:270
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.040) 0:01:02.605 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:276
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.075) 0:01:02.680 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Change the password of the sa user] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:283
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.041) 0:01:02.721 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.040) 0:01:02.762 ******
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap
TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.076) 0:01:02.839 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.049) 0:01:02.888 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.wvicbmlb",
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 17:20:41 +0000 (0:00:00.554) 0:01:03.443 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.wvicbmlb",
"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-1659547241.9869304-111183-14924172117700/source",
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 17:20:42 +0000 (0:00:01.018) 0:01:04.461 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 17:20:42 +0000 (0:00:00.042) 0:01:04.504 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ActiveEnterTimestampMonotonic": "61676748",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"AssertTimestampMonotonic": "61674996",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "4978862000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ConditionTimestampMonotonic": "61674994",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2769",
"ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ExecMainStartTimestampMonotonic": "61676336",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"InactiveExitTimestampMonotonic": "61676748",
"InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2769",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "643018752",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "system.slice -.mount sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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 17:20:29 UTC",
"StateChangeTimestampMonotonic": "61676748",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "142",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 17:20:43 +0000 (0:00:00.594) 0:01:05.098 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"elapsed": 0,
"gid": 992,
"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": 7697,
"state": "file",
"uid": 992
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 17:20:44 +0000 (0:00:00.521) 0:01:05.620 ******
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml for /cache/fedora-35.qcow2.snap
TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
Wednesday 03 August 2022 17:20:44 +0000 (0:00:00.068) 0:01:05.689 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ActiveEnterTimestampMonotonic": "61676748",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"AssertTimestampMonotonic": "61674996",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "4985254000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ConditionTimestampMonotonic": "61674994",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2769",
"ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ExecMainStartTimestampMonotonic": "61676336",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"InactiveExitTimestampMonotonic": "61676748",
"InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2769",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "643018752",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "system.slice -.mount sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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 17:20:29 UTC",
"StateChangeTimestampMonotonic": "61676748",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "142",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Check if a custom tcpport setting exist] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:8
Wednesday 03 August 2022 17:20:44 +0000 (0:00:00.571) 0:01:06.260 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003797",
"end": "2022-08-03 17:20:43.710076",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 17:20:43.706279"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Check if a custom ipaddress setting exist] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:14
Wednesday 03 August 2022 17:20:45 +0000 (0:00:00.421) 0:01:06.682 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^ipaddress = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003368",
"end": "2022-08-03 17:20:44.114195",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 17:20:44.110827"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Set a fact with a password query] ******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:20
Wednesday 03 August 2022 17:20:45 +0000 (0:00:00.400) 0:01:07.083 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 17:20:45 +0000 (0:00:00.066) 0:01:07.150 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.wvicbmlb",
"-b"
],
"delta": "0:00:00.285789",
"end": "2022-08-03 17:20:44.903712",
"rc": 0,
"start": "2022-08-03 17:20:44.617923"
}
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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.734) 0:01:07.884 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"__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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.070) 0:01:07.954 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.044) 0:01:07.999 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:297
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.042) 0:01:08.042 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:306
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.050) 0:01:08.092 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:319
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.041) 0:01:08.134 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Change the edition of MSSQL] ***********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:326
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.041) 0:01:08.176 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the IP address setting] ******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:335
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.051) 0:01:08.227 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:342
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.044) 0:01:08.272 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Open the 1433 TCP port] **************************************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:349
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.048) 0:01:08.321 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:360
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.090) 0:01:08.411 ******
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for /cache/fedora-35.qcow2.snap
TASK [fedora.linux_system_roles.mssql : Get the network tcpport setting] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 03 August 2022 17:20:46 +0000 (0:00:00.063) 0:01:08.474 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"grep",
"^tcpport = ",
"/var/opt/mssql/mssql.conf"
],
"delta": "0:00:00.003325",
"end": "2022-08-03 17:20:45.936770",
"failed_when_result": false,
"rc": 1,
"start": "2022-08-03 17:20:45.933445"
}
MSG:
non-zero return code
TASK [fedora.linux_system_roles.mssql : Configure the network tcpport setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:11
Wednesday 03 August 2022 17:20:47 +0000 (0:00:00.433) 0:01:08.907 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"cmd": [
"/opt/mssql/bin/mssql-conf",
"set",
"network.tcpport",
"1433"
],
"delta": "0:00:00.095544",
"end": "2022-08-03 17:20:46.454896",
"failed_when_result": false,
"rc": 0,
"start": "2022-08-03 17:20:46.359352"
}
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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:40
Wednesday 03 August 2022 17:20:47 +0000 (0:00:00.526) 0:01:09.434 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:366
Wednesday 03 August 2022 17:20:47 +0000 (0:00:00.037) 0:01:09.472 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:384
Wednesday 03 August 2022 17:20:47 +0000 (0:00:00.053) 0:01:09.525 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-fts package] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:391
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.048) 0:01:09.574 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the powershell package] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:398
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.043) 0:01:09.618 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:407
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.041) 0:01:09.659 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the hadrenabled setting] *****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:413
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.038) 0:01:09.698 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:422
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.038) 0:01:09.737 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Set the 3979 traceflag] ****************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:428
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.088) 0:01:09.826 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the 3979 traceflag] **************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:434
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.041) 0:01:09.867 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:441
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.043) 0:01:09.911 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the writethrough setting] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:447
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.042) 0:01:09.954 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:458
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.043) 0:01:09.998 ******
skipping: [/cache/fedora-35.qcow2.snap] => (item=None) => {
"ansible_loop_var": "item",
"changed": false,
"item": null,
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:474
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.045) 0:01:10.043 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:483
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.040) 0:01:10.083 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:492
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.038) 0:01:10.122 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:499
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.038) 0:01:10.160 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:509
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.038) 0:01:10.199 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Set host variables] ********************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:528
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.044) 0:01:10.243 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:539
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.049) 0:01:10.292 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:545
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.061) 0:01:10.353 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:552
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.049) 0:01:10.403 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:559
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.051) 0:01:10.455 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:564
Wednesday 03 August 2022 17:20:48 +0000 (0:00:00.052) 0:01:10.508 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Remove certificate and private key files] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:570
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.049) 0:01:10.557 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:579
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.127) 0:01:10.685 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create and back up certificate] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:584
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.051) 0:01:10.737 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:590
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.052) 0:01:10.789 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:602
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.053) 0:01:10.843 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create the] ****************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:607
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.046) 0:01:10.889 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:613
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.045) 0:01:10.935 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:618
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.046) 0:01:10.982 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Grant permissions to the login] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:623
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.051) 0:01:11.033 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Back up and replicate the database] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:628
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.060) 0:01:11.094 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:635
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.057) 0:01:11.151 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Fail if the primary node failed] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:662
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.058) 0:01:11.209 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server-ha package] ****
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:669
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.052) 0:01:11.262 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:675
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.052) 0:01:11.314 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:682
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.047) 0:01:11.362 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Enable AlwaysOn Health events] *********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:689
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.047) 0:01:11.409 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create master key encryption] **********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:694
Wednesday 03 August 2022 17:20:49 +0000 (0:00:00.091) 0:01:11.501 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:699
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.048) 0:01:11.549 ******
skipping: [/cache/fedora-35.qcow2.snap] => (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/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:711
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.058) 0:01:11.608 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Restore certificate] *******************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:717
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.052) 0:01:11.661 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create database mirroring endpoints] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:722
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.052) 0:01:11.713 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Create the login] *********************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:727
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.054) 0:01:11.768 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:732
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.050) 0:01:11.818 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Grant permissions to the login] *******
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:737
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.050) 0:01:11.869 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify if the database exists on secondaries] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:742
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.049) 0:01:11.919 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:749
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.054) 0:01:11.973 ******
skipping: [/cache/fedora-35.qcow2.snap] => (item=cert) => {
"ansible_loop_var": "item",
"changed": false,
"item": "cert",
"skip_reason": "Conditional result was False"
}
skipping: [/cache/fedora-35.qcow2.snap] => (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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:762
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.055) 0:01:12.028 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:773
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.049) 0:01:12.077 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Verify if the database exists] ********
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:778
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.052) 0:01:12.130 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786
Wednesday 03 August 2022 17:20:50 +0000 (0:00:00.051) 0:01:12.182 ******
changed: [/cache/fedora-35.qcow2.snap] => {
"changed": true
}
MSG:
Block inserted
TASK [fedora.linux_system_roles.mssql : Input the sql_script.sql sql file to SQL Server] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:795
Wednesday 03 August 2022 17:20:51 +0000 (0:00:00.676) 0:01:12.858 ******
included: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml for /cache/fedora-35.qcow2.snap
TASK [fedora.linux_system_roles.mssql : Verify that the mssql_password variable is defined] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:6
Wednesday 03 August 2022 17:20:51 +0000 (0:00:00.077) 0:01:12.936 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:17
Wednesday 03 August 2022 17:20:51 +0000 (0:00:00.052) 0:01:12.988 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"gid": 0,
"group": "root",
"mode": "0600",
"owner": "root",
"path": "/tmp/ansible.w8cpvbce",
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
Wednesday 03 August 2022 17:20:51 +0000 (0:00:00.414) 0:01:13.402 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"checksum": "385f265d232105f634c8f05f20b73a19670dc0bc",
"dest": "/tmp/ansible.w8cpvbce",
"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-1659547251.9384842-111509-196464898166544/source",
"state": "file",
"uid": 0
}
TASK [fedora.linux_system_roles.mssql : Generate the sql_script.sql template on the host] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:33
Wednesday 03 August 2022 17:20:52 +0000 (0:00:00.774) 0:01:14.177 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
Wednesday 03 August 2022 17:20:52 +0000 (0:00:00.048) 0:01:14.226 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"name": "mssql-server",
"state": "started",
"status": {
"ActiveEnterTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ActiveEnterTimestampMonotonic": "61676748",
"ActiveExitTimestamp": "n/a",
"ActiveExitTimestampMonotonic": "0",
"ActiveState": "active",
"After": "network.target system.slice auditd.service basic.target sysinit.target systemd-journald.socket -.mount",
"AllowIsolate": "no",
"AssertResult": "yes",
"AssertTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"AssertTimestampMonotonic": "61674996",
"Before": "multi-user.target shutdown.target",
"BlockIOAccounting": "no",
"BlockIOWeight": "[not set]",
"CPUAccounting": "yes",
"CPUAffinityFromNUMA": "no",
"CPUQuotaPerSecUSec": "infinity",
"CPUQuotaPeriodUSec": "infinity",
"CPUSchedulingPolicy": "0",
"CPUSchedulingPriority": "0",
"CPUSchedulingResetOnFork": "no",
"CPUShares": "[not set]",
"CPUUsageNSec": "5187712000",
"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 cap_checkpoint_restore",
"CleanResult": "success",
"CollectMode": "inactive",
"ConditionResult": "yes",
"ConditionTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ConditionTimestampMonotonic": "61674994",
"ConfigurationDirectoryMode": "0755",
"Conflicts": "shutdown.target",
"ControlGroup": "/system.slice/mssql-server.service",
"ControlPID": "0",
"CoredumpFilter": "0x33",
"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",
"ExecMainCode": "0",
"ExecMainExitTimestamp": "n/a",
"ExecMainExitTimestampMonotonic": "0",
"ExecMainPID": "2769",
"ExecMainStartTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"ExecMainStartTimestampMonotonic": "61676336",
"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 }",
"ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }",
"FailureAction": "none",
"FileDescriptorStoreMax": "0",
"FinalKillSignal": "9",
"FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
"FreezerState": "running",
"GID": "992",
"GuessMainPID": "yes",
"IOAccounting": "no",
"IOReadBytes": "18446744073709551615",
"IOReadOperations": "18446744073709551615",
"IOSchedulingClass": "2",
"IOSchedulingPriority": "4",
"IOWeight": "[not set]",
"IOWriteBytes": "18446744073709551615",
"IOWriteOperations": "18446744073709551615",
"IPAccounting": "no",
"IPEgressBytes": "[no data]",
"IPEgressPackets": "[no data]",
"IPIngressBytes": "[no data]",
"IPIngressPackets": "[no data]",
"Id": "mssql-server.service",
"IgnoreOnIsolate": "no",
"IgnoreSIGPIPE": "yes",
"InactiveEnterTimestamp": "n/a",
"InactiveEnterTimestampMonotonic": "0",
"InactiveExitTimestamp": "Wed 2022-08-03 17:20:29 UTC",
"InactiveExitTimestampMonotonic": "61676748",
"InvocationID": "056533a1e9ca4c31a6760eb3317195ee",
"JobRunningTimeoutUSec": "infinity",
"JobTimeoutAction": "none",
"JobTimeoutUSec": "infinity",
"KeyringMode": "private",
"KillMode": "process",
"KillSignal": "15",
"LimitAS": "infinity",
"LimitASSoft": "infinity",
"LimitCORE": "infinity",
"LimitCORESoft": "infinity",
"LimitCPU": "infinity",
"LimitCPUSoft": "infinity",
"LimitDATA": "infinity",
"LimitDATASoft": "infinity",
"LimitFSIZE": "infinity",
"LimitFSIZESoft": "infinity",
"LimitLOCKS": "infinity",
"LimitLOCKSSoft": "infinity",
"LimitMEMLOCK": "8388608",
"LimitMEMLOCKSoft": "8388608",
"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": "15523",
"LimitSIGPENDINGSoft": "15523",
"LimitSTACK": "infinity",
"LimitSTACKSoft": "8388608",
"LoadState": "loaded",
"LockPersonality": "no",
"LogLevelMax": "-1",
"LogRateLimitBurst": "0",
"LogRateLimitIntervalUSec": "0",
"LogsDirectoryMode": "0755",
"MainPID": "2769",
"ManagedOOMMemoryPressure": "auto",
"ManagedOOMMemoryPressureLimit": "0",
"ManagedOOMPreference": "none",
"ManagedOOMSwap": "auto",
"MemoryAccounting": "yes",
"MemoryAvailable": "infinity",
"MemoryCurrent": "659394560",
"MemoryDenyWriteExecute": "no",
"MemoryHigh": "infinity",
"MemoryLimit": "infinity",
"MemoryLow": "0",
"MemoryMax": "infinity",
"MemoryMin": "0",
"MemorySwapMax": "infinity",
"MountAPIVFS": "no",
"NFileDescriptorStore": "0",
"NRestarts": "0",
"NUMAPolicy": "n/a",
"Names": "mssql-server.service",
"NeedDaemonReload": "no",
"Nice": "0",
"NoNewPrivileges": "no",
"NonBlocking": "no",
"NotifyAccess": "none",
"OOMPolicy": "stop",
"OOMScoreAdjust": "0",
"OnFailureJobMode": "replace",
"OnSuccessJobMode": "fail",
"Perpetual": "no",
"PrivateDevices": "no",
"PrivateIPC": "no",
"PrivateMounts": "no",
"PrivateNetwork": "no",
"PrivateTmp": "no",
"PrivateUsers": "no",
"ProcSubset": "all",
"ProtectClock": "no",
"ProtectControlGroups": "no",
"ProtectHome": "no",
"ProtectHostname": "no",
"ProtectKernelLogs": "no",
"ProtectKernelModules": "no",
"ProtectKernelTunables": "no",
"ProtectProc": "default",
"ProtectSystem": "no",
"RefuseManualStart": "no",
"RefuseManualStop": "no",
"ReloadResult": "success",
"RemainAfterExit": "no",
"RemoveIPC": "no",
"Requires": "system.slice -.mount sysinit.target",
"RequiresMountsFor": "/var/opt/mssql",
"Restart": "on-failure",
"RestartKillSignal": "15",
"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",
"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 17:20:29 UTC",
"StateChangeTimestampMonotonic": "61676748",
"StateDirectoryMode": "0755",
"StatusErrno": "0",
"StopWhenUnneeded": "no",
"SubState": "running",
"SuccessAction": "none",
"SyslogFacility": "3",
"SyslogLevel": "6",
"SyslogLevelPrefix": "yes",
"SyslogPriority": "30",
"SystemCallErrorNumber": "2147483646",
"TTYReset": "no",
"TTYVHangup": "no",
"TTYVTDisallocate": "no",
"TasksAccounting": "yes",
"TasksCurrent": "141",
"TasksMax": "infinity",
"TimeoutAbortUSec": "30min",
"TimeoutCleanUSec": "infinity",
"TimeoutStartFailureMode": "terminate",
"TimeoutStartUSec": "30min",
"TimeoutStopFailureMode": "terminate",
"TimeoutStopUSec": "30min",
"TimerSlackNSec": "50000",
"Transient": "no",
"Type": "simple",
"UID": "992",
"UMask": "0007",
"UnitFilePreset": "disabled",
"UnitFileState": "enabled",
"User": "mssql",
"UtmpMode": "init",
"WantedBy": "multi-user.target",
"WatchdogSignal": "6",
"WatchdogTimestamp": "n/a",
"WatchdogTimestampMonotonic": "0",
"WatchdogUSec": "0",
"WorkingDirectory": "/var/opt/mssql"
}
}
TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:46
Wednesday 03 August 2022 17:20:53 +0000 (0:00:00.553) 0:01:14.779 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"elapsed": 0,
"gid": 992,
"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": 8091,
"state": "file",
"uid": 992
}
TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:52
Wednesday 03 August 2022 17:20:53 +0000 (0:00:00.442) 0:01:15.221 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
Wednesday 03 August 2022 17:20:53 +0000 (0:00:00.041) 0:01:15.263 ******
fatal: [/cache/fedora-35.qcow2.snap]: FAILED! => {
"changed": false,
"cmd": [
"/opt/mssql-tools/bin/sqlcmd",
"-U",
"sa",
"-P",
"p@55w0rD",
"-i",
"/tmp/ansible.w8cpvbce",
"-b"
],
"delta": "0:00:00.023602",
"end": "2022-08-03 17:20:52.720741",
"rc": 1,
"start": "2022-08-03 17:20:52.697139"
}
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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:66
Wednesday 03 August 2022 17:20:54 +0000 (0:00:00.432) 0:01:15.696 ******
ok: [/cache/fedora-35.qcow2.snap] => {
"__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/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:78
Wednesday 03 August 2022 17:20:54 +0000 (0:00:00.068) 0:01:15.765 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_input_file variable] ***
task path: /tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:89
Wednesday 03 August 2022 17:20:54 +0000 (0:00:00.042) 0:01:15.807 ******
skipping: [/cache/fedora-35.qcow2.snap] => {
"changed": false,
"skip_reason": "Conditional result was False"
}
PLAY RECAP *********************************************************************
/cache/fedora-35.qcow2.snap : ok=48 changed=10 unreachable=0 failed=1 skipped=81 rescued=0 ignored=0
Wednesday 03 August 2022 17:20:54 +0000 (0:00:00.018) 0:01:15.826 ******
===============================================================================
fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 36.93s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129
fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 4.89s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.38s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:193
fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 2.76s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:253
fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed --- 2.66s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137
fedora.linux_system_roles.mssql : Gather system services facts ---------- 2.08s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160
fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles --- 1.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:214
fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled --- 1.39s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
Gathering Facts --------------------------------------------------------- 1.36s
/tmp/tmphentkgqr/tests/mssql/tests_input_sql_file_2019.yml:3 ------------------
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.10s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 1.02s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.79s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
fedora.linux_system_roles.mssql : Copy the sql_script.sql file to the host --- 0.77s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:24
fedora.linux_system_roles.mssql : Input sql_script.sql with the sqlcmd command --- 0.73s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:60
fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf --- 0.68s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:786
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.59s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/input_sql_file.yml:41
fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.59s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
fedora.linux_system_roles.mssql : Get the active Tuned profiles --------- 0.58s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:204
fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started --- 0.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.57s
/tmp/tmpxn3yv_ek/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119