Closed sonix07 closed 7 years ago
There arent any new required parameters. Can you take a look at the /var/opt/mssql/logs/errorlog file? Anything interesting in there?
@twright-msft thank you for your quick response. I tried again this morning but there were no entries in the errorlog after I changed the container to ctp2-1 again.
This is the most recent errorlog from ctp2-0 if it is of any help:
root@de8f674c0c2e:/var/opt/mssql/log# cat errorlog
2017-05-22 12:30:13.58 Server Microsoft SQL Server vNext (CTP2.0) - 14.0.500.272 (X64)
Apr 13 2017 11:44:40
Copyright (C) 2017 Microsoft Corporation. All rights reserved.
Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS)
2017-05-22 12:30:13.58 Server UTC adjustment: 0:00
2017-05-22 12:30:13.58 Server (c) Microsoft Corporation.
2017-05-22 12:30:13.58 Server All rights reserved.
2017-05-22 12:30:13.58 Server Server process ID is 4116.
2017-05-22 12:30:13.58 Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2017-05-22 12:30:13.58 Server Registry startup parameters:
-d /var/opt/mssql/data/master.mdf
-l /var/opt/mssql/data/mastlog.ldf
-e /var/opt/mssql/log/errorlog
2017-05-22 12:30:13.59 Server SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2017-05-22 12:30:13.59 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-05-22 12:30:13.59 Server Detected 12621 MB of RAM. This is an informational message; no user action is required.
2017-05-22 12:30:13.60 Server Using conventional memory in the memory manager.
2017-05-22 12:30:13.60 Server Large Page Allocated: 32MB
2017-05-22 12:30:15.31 Server Buffer pool extension is already disabled. No action is necessary.
2017-05-22 12:30:16.12 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
2017-05-22 12:30:16.12 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
2017-05-22 12:30:16.12 Server Successfully initialized the TLS configuration. Allowed TLS protocol versions are ['1.0 1.1 1.2']. Allowed TLS ciphers are ['ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384'].
2017-05-22 12:30:16.18 Server The maximum number of dedicated administrator connections for this instance is '1'
2017-05-22 12:30:16.18 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2017-05-22 12:30:16.19 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2017-05-22 12:30:16.19 Server In-Memory OLTP initialized on lowend machine.
2017-05-22 12:30:16.39 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2017-05-22 12:30:16.39 Server Query Store settings initialized with enabled = 1,
2017-05-22 12:30:16.40 spid7s Starting up database 'master'.
2017-05-22 12:30:16.40 Server Software Usage Metrics is disabled.
2017-05-22 12:30:16.64 spid7s 19 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-22 12:30:16.65 spid7s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-22 12:30:16.65 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2017-05-22 12:30:16.69 spid7s Buffer pool extension is already disabled. No action is necessary.
2017-05-22 12:30:16.69 spid7s Resource governor reconfiguration succeeded.
2017-05-22 12:30:16.69 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2017-05-22 12:30:16.69 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2017-05-22 12:30:16.80 spid7s SQL Trace ID 1 was started by login "sa".
2017-05-22 12:30:16.81 spid7s Server name is 'cd1403cbd1fb'. This is an informational message only. No user action is required.
2017-05-22 12:30:16.81 spid7s The NETBIOS name of the local node that is running the server is 'cd1403cbd1fb'. This is an informational message only. No user action is required.
2017-05-22 12:30:16.82 spid22s Starting up database 'msdb'.
2017-05-22 12:30:16.82 spid23s Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2017-05-22 12:30:16.82 spid9s Starting up database 'mssqlsystemresource'.
2017-05-22 12:30:16.82 spid23s Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.
2017-05-22 12:30:16.82 spid24s Starting up database 'sfSQL'.
2017-05-22 12:30:16.83 spid9s The resource database build version is 14.00.500. This is an informational message only. No user action is required.
2017-05-22 12:30:16.87 spid9s Starting up database 'model'.
2017-05-22 12:30:17.25 spid24s Parallel redo is started for database 'sfSQL' with worker pool size [2].
2017-05-22 12:30:17.28 spid24s 13 transactions rolled forward in database 'sfSQL' (5:0). This is an informational message only. No user action is required.
2017-05-22 12:30:17.32 spid22s 1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2017-05-22 12:30:17.32 spid9s Polybase feature disabled.
2017-05-22 12:30:17.32 spid9s Clearing tempdb database.
2017-05-22 12:30:17.42 spid7s 0 transactions rolled back in database 'sfSQL' (5:0). This is an informational message only. No user action is required.
2017-05-22 12:30:17.42 spid7s Recovery is writing a checkpoint in database 'sfSQL' (5). This is an informational message only. No user action is required.
2017-05-22 12:30:17.43 spid7s Parallel redo is shutdown for database 'sfSQL' with worker pool size [2].
2017-05-22 12:30:17.53 spid7s 0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2017-05-22 12:30:17.54 spid7s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2017-05-22 12:30:17.90 spid19s A self-generated certificate was successfully loaded for encryption.
2017-05-22 12:30:17.91 spid19s Server is listening on [ 0.0.0.0 <ipv4> 1433].
2017-05-22 12:30:17.91 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2017-05-22 12:30:17.92 Server Dedicated admin connection support was established for listening locally on port 1434.
2017-05-22 12:30:17.92 spid19s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2017-05-22 12:30:18.10 spid9s Starting up database 'tempdb'.
2017-05-22 12:30:18.47 spid9s The tempdb database has 1 data file(s).
2017-05-22 12:30:18.49 spid23s The Service Broker endpoint is in disabled or stopped state.
2017-05-22 12:30:18.49 spid23s The Database Mirroring endpoint is in disabled or stopped state.
2017-05-22 12:30:18.50 spid23s Service Broker manager has started.
2017-05-22 12:30:18.61 spid7s Recovery is complete. This is an informational message only. No user action is required.
2017-05-22 12:35:19.89 spid53 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2017-05-22 12:35:20.02 spid53 Using 'xplog70.dll' version '2017.140.500' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2017-05-22 12:35:21.14 spid53 Starting up database 'sfSQL'.
2017-05-22 12:35:21.37 spid53 Parallel redo is started for database 'sfSQL' with worker pool size [2].
2017-05-22 12:35:21.41 spid53 Parallel redo is shutdown for database 'sfSQL' with worker pool size [2].
2017-05-22 13:21:30.79 spid51 Starting up database 'sfSQL'.
2017-05-22 13:21:31.04 spid51 Parallel redo is started for database 'sfSQL' with worker pool size [2].
2017-05-22 13:21:31.08 spid51 Parallel redo is shutdown for database 'sfSQL' with worker pool size [2].
The ctp2-0 error log looks as expected. Is there anything showing up when you run docker logs against the ctp2-1 container? Maybe try without the --mount and see if that works to narrow down the problem?
I can confirm that it works without the --mount option. I also tried to --mount a new and empty folder and it got stuck again... unfortunately I don't want to loose the database content when the container gets moved around the cluster, therefore the --mount option is crucial. This time I manged to get a crash.json file:
{
"reason": "0x00000002",
"processName": "sqlservr",
"pid": "9",
"instanceId": "32095c83-88dc-4367-93a8-b45e42c9ef51",
"crashId": "c1d983dc-caca-46f8-8fa5-a6a1bb25ed34",
"threadId": "40",
"libosThreadId": "0x106c",
"buildStamp": "0a7fe2a13669acfb48c31a17e752ad495ef645f7e730a69404f903f749c677d0",
"status": "0xc000000d",
"libosStack": [
"0x000000006a4ed558",
"0x000000006a43f1cd",
"0x000000006a4fba90",
"0x000000006a43cc74",
"0x000000006a50e1d2",
"0x00007fcc83ff1d70"
]
}
and crash.txt:
This program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000002
Status: 0xc000000d
Stacktrace: 000000006a4ed558 000000006a43f1cd 000000006a4fba90
000000006a43cc74 000000006a50e1d2 00007fcc83ff1d70
Process: 9 - sqlservr
Thread: 40 (application thread 0x106c)
Instance Id: 32095c83-88dc-4367-93a8-b45e42c9ef51
Crash Id: c1d983dc-caca-46f8-8fa5-a6a1bb25ed34
Build stamp: 0a7fe2a13669acfb48c31a17e752ad495ef645f7e730a69404f903f749c677d0
Can you please provide more details about your Docker Swarm environment? Are you running Swarm in your own environment or something like Azure Container Service?
It is all self hosted on machines running centos 7. I also tried to disable selinux for debugging but it didn't have any effect. The storage is mounted via NFS, but to my understanding this should be transparent to the container and it is still working with ctp2-0. In addition the storage is used by other containers as well so it does not seem to be a permission issue. Furthermore some folders and files get created when I start the ctp2-1 image... Am I missing something?
Just an idea - we ran into a permissions issue lately with trying to create directories on start on a RHEL-based container host. We resolved this by passing --privileged=true to docker run. Given that you are using an NFS mounted storage you might need to do something with --privileged or --device. See: https://docs.docker.com/engine/reference/run/#runtime-privilege-and-linux-capabilities
some files and directories get created on container startup therefore read/write permissions appear to be fine to me. Unfortunately --privileged=true does not exist in docker swarm mode. In my opinion passing --privileged=true is a quick fix but not a solution for a production environment. Where your permission issues related to SELinux?
Yes, we first resolved the issue by disabling SELinux. Then we discovered the --privileged flag and used that instead. Good to know that the --privileged is not available in Docker Swarm. I'm going to ask one of our engineers to take a look at this. He might have some ideas on what else we could look at.
Are there dump files in /var/opt/mssql/log?
We think this might be an issue with using NFS storage that showed up in CTP 2.1. We are investigating...
Thanks again for all the help I feel like we are getting close to identifying the problem. I can confirm indeed that it seems to be an NFS issue. I just tried to mount a folder from the host and it was working without any problem.
If it is of any help this is my fstab file:
UUID=753f668b-eaed-46b9-a02a-f7a3cfca8663 / btrfs rw,noatime,compress=lzo,ssd,discard,subvol=root 0 0
UUID=753f668b-eaed-46b9-a02a-f7a3cfca8663 /home btrfs rw,noatime,compress=lzo,ssd,discard,subvol=home 0 0
UUID=cab79e0d-70f8-4e17-bdfc-e8f0b9f3d14d swap swap defaults 0 0
192.168.0.50:/zelos /data/nas nfs auto 0 0
the /var/opt/mssql/log contains 3 files: core.sqlservr.06_06_2017_07_07_19.9.json
{
"reason": "0x00000002",
"processName": "sqlservr",
"pid": "9",
"instanceId": "513a0aac-1244-48a5-9cc8-831efaa80224",
"crashId": "0d71ff0b-7ab9-450b-8558-4cb53c6b9a74",
"threadId": "40",
"libosThreadId": "0x106c",
"buildStamp": "0a7fe2a13669acfb48c31a17e752ad495ef645f7e730a69404f903f749c677d0",
"status": "0xc000000d",
"libosStack": [
"0x000000006a4ed558",
"0x000000006a43f1cd",
"0x000000006a4fba90",
"0x000000006a43cc74",
"0x000000006a50e1d2",
"0x00007f2d5e3f2d70"
]
}
the core.sqlservr.06_06_2017_07_07_19.9.txt
his program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000002
Status: 0xc000000d
Stacktrace: 000000006a4ed558 000000006a43f1cd 000000006a4fba90
000000006a43cc74 000000006a50e1d2 00007f2d5e3f2d70
Process: 9 - sqlservr
Thread: 40 (application thread 0x106c)
Instance Id: 513a0aac-1244-48a5-9cc8-831efaa80224
Crash Id: 0d71ff0b-7ab9-450b-8558-4cb53c6b9a74
Build stamp: 0a7fe2a13669acfb48c31a17e752ad495ef645f7e730a69404f903f749c677d0
and a folder called core.sqlservr.9.tmp do you need any output from this folder?
If you do an "ls -la" from inside the container to look at the NFS mount point I saw a difference between the two versions. ctp2-1 (the version that stopped working for me)
root@1a5609168222:/# ls -la /var/opt/
total 8
drwxr-xr-x. 1 root root 10 Jun 26 11:35 .
drwxr-xr-x. 1 root root 90 Apr 20 16:51 ..
drwxrwxr-x. 7 root root 4096 Apr 3 08:27 mssql
and the ctp2-0
root@04ebbd73ba2a:/# ls -la /var/opt/
total 8
drwxr-xr-x. 1 root root 10 Jun 26 12:26 .
drwxr-xr-x. 1 root root 90 May 15 20:25 ..
drwxr-xr-x. 4 1000 1000 4096 Jun 26 12:26 mssql
any new information regarding this issue?
This is a confirmed issue. We are working on a fix. It will be available in the next public release. Unfortunately, the only workaround is to use the CTP 2.0 image.
I just tried the RC1 version and I get a different error message this time. I thought I share my result, maybe this is of help to you.
crash.txt
This program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000006
Status: 0x40000015
Message: Kernel bug check
Address: 0x6a42b4a0
Parameters: 0x6a62a250
Stacktrace: 000000006a4e83c6 000000006a42b4fb 000000006a41ec9d
000000006a42ae9b 000000006a4e695d 000000006a4e599c
000000006a4e5810 000000006a4e5745
Process: 9 - sqlservr
Thread: 13 (application thread 0x1000)
Instance Id: b7de1515-cad2-4ab3-ae71-6499c8406f42
Crash Id: bea9ff10-8e11-40a5-9603-8cddfb34088a
Build stamp: e83d0295c4b8a8055fc3842cb84be4f864e57a4bf7c38359c4427ace56a27dbf
crash.json
{
"reason": "0x00000006",
"processName": "sqlservr",
"pid": "9",
"instanceId": "b7de1515-cad2-4ab3-ae71-6499c8406f42",
"crashId": "bea9ff10-8e11-40a5-9603-8cddfb34088a",
"threadId": "13",
"libosThreadId": "0x1000",
"buildStamp": "e83d0295c4b8a8055fc3842cb84be4f864e57a4bf7c38359c4427ace56a27dbf",
"status": "0x40000015",
"message": "Kernel bug check",
"address": "0x6a42b4a0",
"parameters": [
{
"value": "0x41"
},
{
"value": "0xffffffffc0000001"
},
{
"value": "0x5"
},
{
"value": "0x0"
},
{
"value": "0x0"
}
],
"libosStack": [
"0x000000006a4e83c6",
"0x000000006a42b4fb",
"0x000000006a41ec9d",
"0x000000006a42ae9b",
"0x000000006a4e695d",
"0x000000006a4e599c",
"0x000000006a4e5810",
"0x000000006a4e5745"
]
}
paldumper-debug.log
07/18/2017 08:51:39.444794948 Info [paldumper] <285/0x0> Executing PalDumper against PID: 9
07/18/2017 08:51:39.444871641 Info [paldumper] <285/0x0> Dump type: miniplus
07/18/2017 08:51:39.444879854 Info [paldumper] <285/0x0> Stopping target
07/18/2017 08:51:39.444895047 Info [paldumper] <285/0x0> Target stopped
07/18/2017 08:51:39.444901081 Info [paldumper] <285/0x0> Attaching to target threads
07/18/2017 08:51:39.445059854 Error [paldumper] <285/0x0> Attempt to trace target failed.
07/18/2017 08:51:39.445068020 Error [paldumper] <285/0x0> errno: 0x00000001
07/18/2017 08:51:39.451005610 Info [paldumper] <287/0x0> Executing PalDumper against PID: 9
07/18/2017 08:51:39.451067154 Info [paldumper] <287/0x0> Dump type: filtered
07/18/2017 08:51:39.451074754 Info [paldumper] <287/0x0> Stopping target
07/18/2017 08:51:39.451089167 Info [paldumper] <287/0x0> Target stopped
07/18/2017 08:51:39.451095402 Info [paldumper] <287/0x0> Attaching to target threads
07/18/2017 08:51:39.451245468 Error [paldumper] <287/0x0> Attempt to trace target failed.
07/18/2017 08:51:39.451253299 Error [paldumper] <287/0x0> errno: 0x00000001
gdb.log
Could not attach to process. If your uid matches the uid of the target
process, check the setting of /proc/sys/kernel/yama/ptrace_scope, or try
again as the root user. For more details, see /etc/sysctl.d/10-ptrace.conf
/var/opt/mssql/log/core.sqlservr.9.temp/gdbcommands:4: Error in sourced command file:
ptrace: Operation not permitted.
thread_information.log
1 rchar: 7585911
2 wchar: 2541
3 syscr: 326
4 syscw: 4
5 read_bytes: 43274240
6 write_bytes: 8192
7 cancelled_write_bytes: 0
1 sqlservr (30269, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985527.992315
4 se.vruntime : 766.775062
5 se.sum_exec_runtime : 91.933379
6 se.nr_migrations : 6
7 nr_switches : 37
8 nr_voluntary_switches : 14
9 nr_involuntary_switches : 23
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 20
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810b535b>] hrtimer_nanosleep+0xbb/0x180
2 [<ffffffff810b549e>] SyS_nanosleep+0x7e/0x90
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 9
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005207
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 14
45 nonvoluntary_ctxt_switches: 23
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 323584
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30270, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984653.666944
4 se.vruntime : 278.256345
5 se.sum_exec_runtime : 0.305360
6 se.nr_migrations : 1
7 nr_switches : 6
8 nr_voluntary_switches : 6
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 19
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810b535b>] hrtimer_nanosleep+0xbb/0x180
2 [<ffffffff810b549e>] SyS_nanosleep+0x7e/0x90
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 10
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 6
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30271, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985427.880078
4 se.vruntime : 258.031982
5 se.sum_exec_runtime : 0.199965
6 se.nr_migrations : 1
7 nr_switches : 5
8 nr_voluntary_switches : 5
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 20
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff81212b95>] poll_schedule_timeout+0x55/0xb0
2 [<ffffffff8121411d>] do_sys_poll+0x4cd/0x580
3 [<ffffffff81214523>] SyS_ppoll+0x1b3/0x1d0
4 [<ffffffff816967d2>] tracesys+0xdd/0xe2
5 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 11
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 5
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30272, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985408.109896
4 se.vruntime : 251.766939
5 se.sum_exec_runtime : 0.363103
6 se.nr_migrations : 1
7 nr_switches : 23
8 nr_voluntary_switches : 23
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 17
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124e438>] read_events+0x1f8/0x270
2 [<ffffffff8124fe89>] SyS_io_getevents+0x49/0x80
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 12
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 23
45 nonvoluntary_ctxt_switches: 0
1 rchar: 7529868
2 wchar: 2537
3 syscr: 191
4 syscw: 3
5 read_bytes: 40329216
6 write_bytes: 8192
7 cancelled_write_bytes: 0
1 sqlservr (30273, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985527.238803
4 se.vruntime : 384.708302
5 se.sum_exec_runtime : 618.752609
6 se.nr_migrations : 4
7 nr_switches : 297
8 nr_voluntary_switches : 290
9 nr_involuntary_switches : 7
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810b535b>] hrtimer_nanosleep+0xbb/0x180
2 [<ffffffff810b549e>] SyS_nanosleep+0x7e/0x90
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 13
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 290
45 nonvoluntary_ctxt_switches: 7
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30274, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984787.859808
4 se.vruntime : 117.362038
5 se.sum_exec_runtime : 0.439043
6 se.nr_migrations : 1
7 nr_switches : 5
8 nr_voluntary_switches : 5
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 18
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 14
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 5
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30275, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984787.904951
4 se.vruntime : 303.710870
5 se.sum_exec_runtime : 0.218614
6 se.nr_migrations : 1
7 nr_switches : 4
8 nr_voluntary_switches : 4
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 15
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 4
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30276, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984789.000911
4 se.vruntime : 170.074385
5 se.sum_exec_runtime : 0.218747
6 se.nr_migrations : 2
7 nr_switches : 5
8 nr_voluntary_switches : 5
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 16
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 5
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30277, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.454973
4 se.vruntime : 154.791079
5 se.sum_exec_runtime : 0.537718
6 se.nr_migrations : 1
7 nr_switches : 10
8 nr_voluntary_switches : 10
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 26
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 17
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 10
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30278, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984789.445387
4 se.vruntime : 322.096625
5 se.sum_exec_runtime : 0.384491
6 se.nr_migrations : 1
7 nr_switches : 3
8 nr_voluntary_switches : 3
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 22
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 18
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 3
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30279, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984789.493618
4 se.vruntime : 136.038306
5 se.sum_exec_runtime : 0.242951
6 se.nr_migrations : 1
7 nr_switches : 3
8 nr_voluntary_switches : 3
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 19
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 3
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30280, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984790.636645
4 se.vruntime : 179.263552
5 se.sum_exec_runtime : 0.270434
6 se.nr_migrations : 2
7 nr_switches : 5
8 nr_voluntary_switches : 5
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 19
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 20
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 5
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30281, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.008337
4 se.vruntime : 390.816927
5 se.sum_exec_runtime : 0.512280
6 se.nr_migrations : 2
7 nr_switches : 9
8 nr_voluntary_switches : 9
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 17
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 21
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 9
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30282, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984790.855288
4 se.vruntime : 188.344804
5 se.sum_exec_runtime : 0.266495
6 se.nr_migrations : 2
7 nr_switches : 11
8 nr_voluntary_switches : 11
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 23
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 22
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 11
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30283, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.016583
4 se.vruntime : 188.315776
5 se.sum_exec_runtime : 0.264621
6 se.nr_migrations : 1
7 nr_switches : 7
8 nr_voluntary_switches : 7
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 19
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 23
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 7
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30284, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.455068
4 se.vruntime : 188.378505
5 se.sum_exec_runtime : 0.273309
6 se.nr_migrations : 2
7 nr_switches : 9
8 nr_voluntary_switches : 9
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 22
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 24
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 9
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30285, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.076872
4 se.vruntime : 340.723884
5 se.sum_exec_runtime : 0.146643
6 se.nr_migrations : 1
7 nr_switches : 3
8 nr_voluntary_switches : 3
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 20
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 25
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 3
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30286, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985672.188440
4 se.vruntime : 444.133905
5 se.sum_exec_runtime : 5.655489
6 se.nr_migrations : 19
7 nr_switches : 225
8 nr_voluntary_switches : 223
9 nr_involuntary_switches : 2
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 26
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 223
45 nonvoluntary_ctxt_switches: 2
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30287, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.494312
4 se.vruntime : 409.089566
5 se.sum_exec_runtime : 0.126282
6 se.nr_migrations : 1
7 nr_switches : 6
8 nr_voluntary_switches : 3
9 nr_involuntary_switches : 3
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 28
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 27
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 3
45 nonvoluntary_ctxt_switches: 3
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30288, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.577424
4 se.vruntime : 169.654275
5 se.sum_exec_runtime : 0.111637
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 18
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 28
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30289, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.723900
4 se.vruntime : 359.024269
5 se.sum_exec_runtime : 0.095768
6 se.nr_migrations : 1
7 nr_switches : 2
8 nr_voluntary_switches : 2
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 16
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 29
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 2
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30290, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984791.843512
4 se.vruntime : 178.757069
5 se.sum_exec_runtime : 0.102801
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 23
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 30
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30291, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.035478
4 se.vruntime : 187.859593
5 se.sum_exec_runtime : 0.102531
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 17
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 31
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30292, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.218425
4 se.vruntime : 196.963869
5 se.sum_exec_runtime : 0.104283
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 24
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 32
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30293, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.373113
4 se.vruntime : 206.038125
5 se.sum_exec_runtime : 0.074263
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 25
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 33
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30294, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.545782
4 se.vruntime : 215.113410
5 se.sum_exec_runtime : 0.075292
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 34
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30295, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.700200
4 se.vruntime : 224.184936
5 se.sum_exec_runtime : 0.071533
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 15
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 35
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30296, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984792.871523
4 se.vruntime : 233.267496
5 se.sum_exec_runtime : 0.082567
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124807e>] ep_poll+0x23e/0x360
2 [<ffffffff812492ed>] SyS_epoll_wait+0xed/0x120
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 36
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30297, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984793.018363
4 se.vruntime : 242.321058
5 se.sum_exec_runtime : 0.053569
6 se.nr_migrations : 1
7 nr_switches : 2
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 1
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 17
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff8124e438>] read_events+0x1f8/0x270
2 [<ffffffff8124fe89>] SyS_io_getevents+0x49/0x80
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 37
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 1
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30298, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984793.171863
4 se.vruntime : 251.398336
5 se.sum_exec_runtime : 0.077285
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 19
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 38
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30299, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036984793.334744
4 se.vruntime : 260.483204
5 se.sum_exec_runtime : 0.084875
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 24
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 39
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 0
2 wchar: 0
3 syscr: 0
4 syscw: 0
5 read_bytes: 0
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30300, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985361.060811
4 se.vruntime : 368.138335
5 se.sum_exec_runtime : 0.114075
6 se.nr_migrations : 1
7 nr_switches : 1
8 nr_voluntary_switches : 1
9 nr_involuntary_switches : 0
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 21
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810f4dd4>] futex_wait_queue_me+0xc4/0x120
2 [<ffffffff810f5949>] futex_wait+0x179/0x280
3 [<ffffffff810f7a4e>] do_futex+0xfe/0x5b0
4 [<ffffffff810f7f80>] SyS_futex+0x80/0x180
5 [<ffffffff816967d2>] tracesys+0xdd/0xe2
6 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 40
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005007
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 1
45 nonvoluntary_ctxt_switches: 0
1 rchar: 56043
2 wchar: 4
3 syscr: 135
4 syscw: 1
5 read_bytes: 2621440
6 write_bytes: 0
7 cancelled_write_bytes: 0
1 sqlservr (30269, #threads: 32)
2 -------------------------------------------------------------------
3 se.exec_start : 1036985728.105349
4 se.vruntime : 822.939089
5 se.sum_exec_runtime : 91.946358
6 se.nr_migrations : 6
7 nr_switches : 39
8 nr_voluntary_switches : 16
9 nr_involuntary_switches : 23
10 se.load.weight : 1024
11 policy : 0
12 prio : 120
13 clock-delta : 19
14 mm->numa_scan_seq : 0
15 numa_migrations, 0
16 numa_faults_memory, 0, 0, 1, 0, -1
17 numa_faults_memory, 1, 0, 0, 0, -1
1 [<ffffffff810b535b>] hrtimer_nanosleep+0xbb/0x180
2 [<ffffffff810b549e>] SyS_nanosleep+0x7e/0x90
3 [<ffffffff816967d2>] tracesys+0xdd/0xe2
4 [<ffffffffffffffff>] 0xffffffffffffffff
1 Name: sqlservr
2 State: S (sleeping)
3 Tgid: 9
4 Ngid: 0
5 Pid: 9
6 PPid: 7
7 TracerPid: 0
8 Uid: 0 0 0 0
9 Gid: 0 0 0 0
10 FDSize: 64
11 Groups:
12 VmPeak: 504684 kB
13 VmSize: 502876 kB
14 VmLck: 0 kB
15 VmPin: 0 kB
16 VmHWM: 90600 kB
17 VmRSS: 90600 kB
18 RssAnon: 86556 kB
19 RssFile: 4044 kB
20 RssShmem: 0 kB
21 VmData: 423416 kB
22 VmStk: 144 kB
23 VmExe: 872 kB
24 VmLib: 9924 kB
25 VmPTE: 604 kB
26 VmSwap: 0 kB
27 Threads: 32
28 SigQ: 1/63028
29 SigPnd: 0000000000000000
30 ShdPnd: 0000000000000000
31 SigBlk: 0000000600005207
32 SigIgn: 0000000000000000
33 SigCgt: 0000000180000200
34 CapInh: 00000000a80425fb
35 CapPrm: 00000000a80425fb
36 CapEff: 00000000a80425fb
37 CapBnd: 00000000a80425fb
38 CapAmb: 0000000000000000
39 Seccomp: 2
40 Cpus_allowed: f
41 Cpus_allowed_list: 0-3
42 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
43 Mems_allowed_list: 0
44 voluntary_ctxt_switches: 16
45 nonvoluntary_ctxt_switches: 23
This issue is not resolved yet in the RC1. We have a fix in testing now. We are considering the following requirements for production use of NFS remote shares:
Are these reasonable requirements?
Your requirements seem reasonable to me. Are there other recommended NFS options besides 'nolock'?
Thanks. Not at this time. We are targeting releasing this fix in an RC2 release in the first week of Aug.
@sonix07 do you still have that issue on rc2?
@aerkefiende I've tried many times with different mounts but unfortunately it still does not work with the NFS mount. Mounting the local filesystem works, but mounting an NFS mounted folder from the host (with the nolock option) gives me the following error:
This is an evaluation version. There are [172] days left in the evaluation period.
This program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000006
Status: 0x40000015
Message: Kernel bug check
Address: 0x6a42b4b0
Parameters: 0x6a62a250
Stacktrace: 000000006a4e8446 000000006a42b50b 000000006a41ecad
000000006a42aeab 000000006a4e69dd 000000006a4e5a1c
000000006a4e5890 000000006a4e57c5
Process: 9 - sqlservr
Thread: 13 (application thread 0x1000)
Instance Id: c0b01b06-3336-4609-bf40-ceab6be93ae4
Crash Id: da3beb17-019e-42e9-912a-d70ac8c6b008
Build stamp: a37664e45e4156e76a53fa282fd694cb49f70c2037515f5684e3ce6dfa7549bc
If I only mount /var/opt/mssql/data and /var/opt/mssql/log then I get the following output:
This is an evaluation version. There are [172] days left in the evaluation period.
2017-08-04 11:08:56.20 Server Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'.
2017-08-04 11:08:56.25 Server Setup FAILED copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf': 87(The parameter is incorrect.)
ERROR: BootstrapSystemDataDirectories() failure (HRESULT 0x80070057)
This is particularly weird to me C:\templatedata\mastlog.ldf
since I'm running on centos. I've tripple checked the folder permissions and they are fine and owned by the right user. All folders where newly created and empty. The NFS is also used by other containers successfully (Including mssql ctp2-0). I also tried the new environment variables MSSQL_SA_PASSWORD=...
instead of SA_PASSWORD=...
without any success so far.
Using NFS or Samba shares is a known issue in RC2 and RC1, fixed in post RC2. Sorry for the inconvenience!
From: sonix07 notifications@github.com Sent: Friday, August 4, 2017 4:24:09 AM To: Microsoft/mssql-docker Cc: Travis Wright; Mention Subject: Re: [Microsoft/mssql-docker] mssql-server-linux:ctp2-1 hangs when used in docker swarm (#99)
@aerkefiendehttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Faerkefiende&data=02%7C01%7Ctwright%40microsoft.com%7Ca0a077c538974ef9125808d4db2b544c%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636374426520733212&sdata=Gjqt0BuepO64XUgLYc0Wcfk%2FlgH7G7D%2FfH3r%2Fu2t298%3D&reserved=0 I've tried many times with different mounts but unfortunately it still does not work with the NFS mount. Mounting the local filesystem works, but mounting an NFS mounted folder from the host (with the nolock option) gives me the following error:
This is an evaluation version. There are [172] days left in the evaluation period. This program has encountered a fatal error and cannot continue running. The following diagnostic information is available:
Reason: 0x00000006
Status: 0x40000015
Message: Kernel bug check
Address: 0x6a42b4b0
Parameters: 0x6a62a250 Stacktrace: 000000006a4e8446 000000006a42b50b 000000006a41ecad 000000006a42aeab 000000006a4e69dd 000000006a4e5a1c 000000006a4e5890 000000006a4e57c5 Process: 9 - sqlservr Thread: 13 (application thread 0x1000) Instance Id: c0b01b06-3336-4609-bf40-ceab6be93ae4 Crash Id: da3beb17-019e-42e9-912a-d70ac8c6b008 Build stamp: a37664e45e4156e76a53fa282fd694cb49f70c2037515f5684e3ce6dfa7549bc
If I only mount /var/opt/mssql/data and /var/opt/mssql/log then I get the following output:
This is an evaluation version. There are [172] days left in the evaluation period. 2017-08-04 11:08:56.20 Server Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'. 2017-08-04 11:08:56.25 Server Setup FAILED copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf': 87(The parameter is incorrect.) ERROR: BootstrapSystemDataDirectories() failure (HRESULT 0x80070057)
I've tripple checked the folder permissions and they are fine and owned by the right user. All folders where newly created and empty. The NFS is also used by other containers successfully (Including mssql ctp2-0). I also tried the new environment variables MSSQL_SA_PASSWORD=... instead of SA_PASSWORD=... without any success so far.
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-docker%2Fissues%2F99%23issuecomment-320225199&data=02%7C01%7Ctwright%40microsoft.com%7Ca0a077c538974ef9125808d4db2b544c%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636374426520733212&sdata=ROvYDqwjCAxZ8cZG2JabMaX5kwihe%2BEAyDrp02If7TY%3D&reserved=0, or mute the threadhttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAOSzJlbTbaYliTusOlPM8ZqwYQI9IMclks5sUv9ZgaJpZM4NiXq_&data=02%7C01%7Ctwright%40microsoft.com%7Ca0a077c538974ef9125808d4db2b544c%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636374426520733212&sdata=OsC6yeNzWLB%2FzZWpLr5BvMiK%2BJdr3OQ669zmv7x96B0%3D&reserved=0.
@twright-msft will this be fixed for sure in the next version? I'm asking because we have about 60 days left on our CTP2-0 version and we need a reliable solution + time to test it before the trial expires. What would you suggest? Should we get our hopes up for RC2+1 or should we start investigating a different solution?
There will be another release before :CTP2-0 expires.
I've been watching this issue for a while now. I'm feeling increasingly uncomfortable living with the uncertainty whether we'll have a working SQL server ready on time :(
Obviously, the part of my mind that is more inclined to distressed problem-solving is already poring over alternative scenarios. That's stress I'd rather not have to deal with atm ;)
What version are you on right now @urbanhusky?
CTP2-0, same scenario and issue (docker swarm, NFS mounted) @twright-msft
I am using rc2 version but still getting error when i do a volume mapping for NFS mounted directory. Below is the Error FCB::Open failed: Could not open file /var/opt/mssql/data/master.mdf for file number 1. OS error: 87(The parameter is incorrect.).
I have given full access rights to the nfs mounted directory. is this a known issue for NFS mounts?
I'd like to give a few folks that are having this issue access to a private test image to confirm that we have fixed this issue. @urbanhusky @upadhyayap and anybody else that currently has this problem - please reach out to me via email so I can get you set up. twright microsoft com
@twright-msft I cannot find your e-mail address, but I would gladly help test the image.
My email address is: twright microsoft com Sorry for the delay getting this out for testing. Should have everything in place to share this tomorrow.
@twright-msft I've already wrote you an e-mail a week ago (08/24/2017). Please share the image with me.
We'd love to test the fix image if you still have a need as well. We ran into this issue yesterday and had some other issues when pegged to the ctp2-0 tag. Will have one of our devops engineers reach out via email.
After testing the private image I can now confirm that this solves my issue. Will the change be included in the upcoming release?
Great. Yes, this fix will be included in the next public release.
@twright-msft works as expected with the 2017-GA
version and therefore this issue can be closed. Thanks for your collaboration.
Thanks for confirming. Closing...
Upgrade from ctp2-0 stuck with this output:
This is an evaluation version. There are [172] days left in the evaluation period.
I also tried to delete the database but the container is still stuck with the same output. The result is the same on all cluster nodes.Docker swarm command to start the service:
docker service create \ --name mssql \ --publish 1433:1433 \ -e 'ACCEPT_EULA=Y' \ -e 'SA_PASSWORD=NotGoingToPasteThePassword' \ --network sfswarm-nw \ --replicas 1 \ --mount type=bind,source=/data/nas/mssql,target=/var/opt/mssql \ microsoft/mssql-server-linux:ctp2-1
docker version: ` Version: 1.12.6 API version: 1.24 Package version: docker-common-1.12.6-16.el7.centos.x86_64 docker-common-1.12.6-11.el7.centos.x86_64 Go version: go1.7.4 Git commit: 3a094bd/1.12.6 Built: Fri Apr 14 13:46:13 2017 OS/Arch: linux/amd64
Server: Version: 1.12.6 API version: 1.24 Package version: docker-common-1.12.6-16.el7.centos.x86_64 docker-common-1.12.6-11.el7.centos.x86_64 Go version: go1.7.4 Git commit: 3a094bd/1.12.6 Built: Fri Apr 14 13:46:13 2017 OS/Arch: linux/amd64`
I've been using mssql with Docker Swarm since ctp1-2 and it was working flawlessly. Am I missing something? Do I need to pass a new parameter with ctp2-1 that I'm not currently aware?