mssql-docker
mssql-docker copied to clipboard
microsoft
SQL Server LCOW fails to start
I've been running SQL Server LCOW via Docker Desktop for many months now and recently it started to fail. The failure seems to be around the bind mount usage (-v), as when not using a bind mount the container starts.
My docker environment is below and the command being run and failure output is included below. I am running Windows 1809.
Client: Docker Engine - Community Version: 19.03.8 API version: 1.40 Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:23:10 2020 OS/Arch: windows/amd64 Experimental: true
Server: Docker Engine - Community Engine: Version: 19.03.8 API version: 1.40 (minimum version 1.12) Go version: go1.12.17 Git commit: afacb8b Built: Wed Mar 11 01:29:16 2020 OS/Arch: linux/amd64 Experimental: true containerd: Version: v1.2.13 GitCommit: 7ad184331fa3e55e52b890ea95e65ba581ae3429 runc: Version: 1.0.0-rc10 GitCommit: dc9208a3303feef5b3839f4323d9beb36df0a9dd docker-init: Version: 0.18.0 GitCommit: fec3683
It doesnt seem to matter whether the directory on Windows being shared via Docker Desktop already exists or not.
docker run --rm -e 'ACCEPT_EULA=Y' --name sql2019 --hostname TMSQL -e 'MSSQL_SA_PASSWORD=TeamMate!1' --cpus=3 --memory=16g -p 1433:1433 -v E:/SQlData:/var/opt/mssql mcr.microsoft.com/mssql/server:2019-latest
SQL Server 2019 will run as non-root by default. This container is running as user mssql. To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216. This program has encountered a fatal error and cannot continue running at Mon May 18 17:17:28 2020 The following diagnostic information is available:
Reason: 0x00000007
Status: 0xc0000001
Message: Failed to load persistent registry. status code: c0000001
Stack Trace:
file://package4/windows/system32/sqlpal.dll+0x000000000033D3A7
file://package4/windows/system32/sqlpal.dll+0x000000000033C9F0
file://package4/windows/system32/sqlpal.dll+0x000000000033A647
file://package4/windows/system32/sqlpal.dll+0x000000000033A7C4
file://package4/windows/system32/sqlpal.dll+0x0000000000339623
file://package4/windows/system32/sqlpal.dll+0x0000000000338510
file://package4/windows/system32/sqlpal.dll+0x000000000037E531
Process: 8 - sqlservr
Thread: 12 (application thread 0x4)
Instance Id: 62519d0c-ee4e-4265-9705-374bc66aa0f1
Crash Id: 62ce2d88-451c-4133-8995-5ebabe8320ca
Build stamp: 9d61bcf28d2533f40f3df073a5c55d3c36750b6b1e650db137f069439b440661
Distribution: Ubuntu 18.04.4 LTS Processors: 4 Total Memory: 25203187712 bytes Timestamp: Mon May 18 17:17:28 2020 Last errno: 17 Last errno text: File exists
Ubuntu 18.04.4 LTS Capturing core dump and information to /var/opt/mssql/log... /bin/cat: /proc/8/maps: Permission denied /bin/cat: /proc/8/environ: Permission denied /usr/bin/find: '/proc/8/task/8/fd': Permission denied /usr/bin/find: '/proc/8/task/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/8/ns': Permission denied /usr/bin/find: '/proc/8/task/9/fd': Permission denied /usr/bin/find: '/proc/8/task/9/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/9/ns': Permission denied /usr/bin/find: '/proc/8/task/10/fd': Permission denied /usr/bin/find: '/proc/8/task/10/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/10/ns': Permission denied /usr/bin/find: '/proc/8/task/11/fd': Permission denied /usr/bin/find: '/proc/8/task/11/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/11/ns': Permission denied /usr/bin/find: '/proc/8/task/12/fd': Permission denied /usr/bin/find: '/proc/8/task/12/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/12/ns': Permission denied /usr/bin/find: '/proc/8/task/13/fd': Permission denied /usr/bin/find: '/proc/8/task/13/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/13/ns': Permission denied /usr/bin/find: '/proc/8/task/14/fd': Permission denied /usr/bin/find: '/proc/8/task/14/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/14/ns': Permission denied /usr/bin/find: '/proc/8/task/15/fd': Permission denied /usr/bin/find: '/proc/8/task/15/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/15/ns': Permission denied /usr/bin/find: '/proc/8/task/16/fd': Permission denied /usr/bin/find: '/proc/8/task/16/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/16/ns': Permission denied /usr/bin/find: '/proc/8/task/17/fd': Permission denied /usr/bin/find: '/proc/8/task/17/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/17/ns': Permission denied /usr/bin/find: '/proc/8/task/18/fd': Permission denied /usr/bin/find: '/proc/8/task/18/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/18/ns': Permission denied /usr/bin/find: '/proc/8/task/19/fd': Permission denied /usr/bin/find: '/proc/8/task/19/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/19/ns': Permission denied /usr/bin/find: '/proc/8/task/20/fd': Permission denied /usr/bin/find: '/proc/8/task/20/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/20/ns': Permission denied /usr/bin/find: '/proc/8/task/21/fd': Permission denied /usr/bin/find: '/proc/8/task/21/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/21/ns': Permission denied /usr/bin/find: '/proc/8/task/22/fd': Permission denied /usr/bin/find: '/proc/8/task/22/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/22/ns': Permission denied /usr/bin/find: '/proc/8/task/23/fd': Permission denied /usr/bin/find: '/proc/8/task/23/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/23/ns': Permission denied /usr/bin/find: '/proc/8/task/24/fd': Permission denied /usr/bin/find: '/proc/8/task/24/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/24/ns': Permission denied /usr/bin/find: '/proc/8/task/25/fd': Permission denied /usr/bin/find: '/proc/8/task/25/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/25/ns': Permission denied /usr/bin/find: '/proc/8/task/26/fd': Permission denied /usr/bin/find: '/proc/8/task/26/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/26/ns': Permission denied /usr/bin/find: '/proc/8/fd': Permission denied /usr/bin/find: '/proc/8/map_files': Permission denied /usr/bin/find: '/proc/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/ns': Permission denied /usr/bin/find: '/proc/8/task/8/fd': Permission denied /usr/bin/find: '/proc/8/task/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/8/ns': Permission denied /usr/bin/find: '/proc/8/task/9/fd': Permission denied /usr/bin/find: '/proc/8/task/9/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/9/ns': Permission denied /usr/bin/find: '/proc/8/task/10/fd': Permission denied /usr/bin/find: '/proc/8/task/10/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/10/ns': Permission denied /usr/bin/find: '/proc/8/task/11/fd': Permission denied /usr/bin/find: '/proc/8/task/11/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/11/ns': Permission denied /usr/bin/find: '/proc/8/task/12/fd': Permission denied /usr/bin/find: '/proc/8/task/12/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/12/ns': Permission denied /usr/bin/find: '/proc/8/task/13/fd': Permission denied /usr/bin/find: '/proc/8/task/13/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/13/ns': Permission denied /usr/bin/find: '/proc/8/task/14/fd': Permission denied /usr/bin/find: '/proc/8/task/14/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/14/ns': Permission denied /usr/bin/find: '/proc/8/task/15/fd': Permission denied /usr/bin/find: '/proc/8/task/15/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/15/ns': Permission denied /usr/bin/find: '/proc/8/task/16/fd': Permission denied /usr/bin/find: '/proc/8/task/16/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/16/ns': Permission denied /usr/bin/find: '/proc/8/task/17/fd': Permission denied /usr/bin/find: '/proc/8/task/17/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/17/ns': Permission denied /usr/bin/find: '/proc/8/task/18/fd': Permission denied /usr/bin/find: '/proc/8/task/18/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/18/ns': Permission denied /usr/bin/find: '/proc/8/task/19/fd': Permission denied /usr/bin/find: '/proc/8/task/19/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/19/ns': Permission denied /usr/bin/find: '/proc/8/task/20/fd': Permission denied /usr/bin/find: '/proc/8/task/20/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/20/ns': Permission denied /usr/bin/find: '/proc/8/task/21/fd': Permission denied /usr/bin/find: '/proc/8/task/21/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/21/ns': Permission denied /usr/bin/find: '/proc/8/task/22/fd': Permission denied /usr/bin/find: '/proc/8/task/22/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/22/ns': Permission denied /usr/bin/find: '/proc/8/task/23/fd': Permission denied /usr/bin/find: '/proc/8/task/23/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/23/ns': Permission denied /usr/bin/find: '/proc/8/task/24/fd': Permission denied /usr/bin/find: '/proc/8/task/24/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/24/ns': Permission denied /usr/bin/find: '/proc/8/task/25/fd': Permission denied /usr/bin/find: '/proc/8/task/25/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/25/ns': Permission denied /usr/bin/find: '/proc/8/task/26/fd': Permission denied /usr/bin/find: '/proc/8/task/26/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/26/ns': Permission denied /usr/bin/find: '/proc/8/fd': Permission denied /usr/bin/find: '/proc/8/map_files': Permission denied /usr/bin/find: '/proc/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/ns': Permission denied /usr/bin/find: '/proc/8/task/8/fd': Permission denied /usr/bin/find: '/proc/8/task/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/8/ns': Permission denied /usr/bin/find: '/proc/8/task/9/fd': Permission denied /usr/bin/find: '/proc/8/task/9/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/9/ns': Permission denied /usr/bin/find: '/proc/8/task/10/fd': Permission denied /usr/bin/find: '/proc/8/task/10/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/10/ns': Permission denied /usr/bin/find: '/proc/8/task/11/fd': Permission denied /usr/bin/find: '/proc/8/task/11/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/11/ns': Permission denied /usr/bin/find: '/proc/8/task/12/fd': Permission denied /usr/bin/find: '/proc/8/task/12/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/12/ns': Permission denied /usr/bin/find: '/proc/8/task/13/fd': Permission denied /usr/bin/find: '/proc/8/task/13/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/13/ns': Permission denied /usr/bin/find: '/proc/8/task/14/fd': Permission denied /usr/bin/find: '/proc/8/task/14/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/14/ns': Permission denied /usr/bin/find: '/proc/8/task/15/fd': Permission denied /usr/bin/find: '/proc/8/task/15/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/15/ns': Permission denied /usr/bin/find: '/proc/8/task/16/fd': Permission denied /usr/bin/find: '/proc/8/task/16/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/16/ns': Permission denied /usr/bin/find: '/proc/8/task/17/fd': Permission denied /usr/bin/find: '/proc/8/task/17/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/17/ns': Permission denied /usr/bin/find: '/proc/8/task/18/fd': Permission denied /usr/bin/find: '/proc/8/task/18/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/18/ns': Permission denied /usr/bin/find: '/proc/8/task/19/fd': Permission denied /usr/bin/find: '/proc/8/task/19/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/19/ns': Permission denied /usr/bin/find: '/proc/8/task/20/fd': Permission denied /usr/bin/find: '/proc/8/task/20/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/20/ns': Permission denied /usr/bin/find: '/proc/8/task/21/fd': Permission denied /usr/bin/find: '/proc/8/task/21/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/21/ns': Permission denied /usr/bin/find: '/proc/8/task/22/fd': Permission denied /usr/bin/find: '/proc/8/task/22/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/22/ns': Permission denied /usr/bin/find: '/proc/8/task/23/fd': Permission denied /usr/bin/find: '/proc/8/task/23/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/23/ns': Permission denied /usr/bin/find: '/proc/8/task/24/fd': Permission denied /usr/bin/find: '/proc/8/task/24/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/24/ns': Permission denied /usr/bin/find: '/proc/8/task/25/fd': Permission denied /usr/bin/find: '/proc/8/task/25/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/25/ns': Permission denied /usr/bin/find: '/proc/8/task/26/fd': Permission denied /usr/bin/find: '/proc/8/task/26/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/26/ns': Permission denied /usr/bin/find: '/proc/8/fd': Permission denied /usr/bin/find: '/proc/8/map_files': Permission denied /usr/bin/find: '/proc/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/ns': Permission denied /usr/bin/find: '/proc/8/task/8/fd': Permission denied /usr/bin/find: '/proc/8/task/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/8/ns': Permission denied /usr/bin/find: '/proc/8/task/9/fd': Permission denied /usr/bin/find: '/proc/8/task/9/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/9/ns': Permission denied /usr/bin/find: '/proc/8/task/10/fd': Permission denied /usr/bin/find: '/proc/8/task/10/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/10/ns': Permission denied /usr/bin/find: '/proc/8/task/11/fd': Permission denied /usr/bin/find: '/proc/8/task/11/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/11/ns': Permission denied /usr/bin/find: '/proc/8/task/12/fd': Permission denied /usr/bin/find: '/proc/8/task/12/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/12/ns': Permission denied /usr/bin/find: '/proc/8/task/13/fd': Permission denied /usr/bin/find: '/proc/8/task/13/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/13/ns': Permission denied /usr/bin/find: '/proc/8/task/14/fd': Permission denied /usr/bin/find: '/proc/8/task/14/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/14/ns': Permission denied /usr/bin/find: '/proc/8/task/15/fd': Permission denied /usr/bin/find: '/proc/8/task/15/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/15/ns': Permission denied /usr/bin/find: '/proc/8/task/16/fd': Permission denied /usr/bin/find: '/proc/8/task/16/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/16/ns': Permission denied /usr/bin/find: '/proc/8/task/17/fd': Permission denied /usr/bin/find: '/proc/8/task/17/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/17/ns': Permission denied /usr/bin/find: '/proc/8/task/18/fd': Permission denied /usr/bin/find: '/proc/8/task/18/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/18/ns': Permission denied /usr/bin/find: '/proc/8/task/19/fd': Permission denied /usr/bin/find: '/proc/8/task/19/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/19/ns': Permission denied /usr/bin/find: '/proc/8/task/20/fd': Permission denied /usr/bin/find: '/proc/8/task/20/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/20/ns': Permission denied /usr/bin/find: '/proc/8/task/21/fd': Permission denied /usr/bin/find: '/proc/8/task/21/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/21/ns': Permission denied /usr/bin/find: '/proc/8/task/22/fd': Permission denied /usr/bin/find: '/proc/8/task/22/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/22/ns': Permission denied /usr/bin/find: '/proc/8/task/23/fd': Permission denied /usr/bin/find: '/proc/8/task/23/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/23/ns': Permission denied /usr/bin/find: '/proc/8/task/24/fd': Permission denied /usr/bin/find: '/proc/8/task/24/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/24/ns': Permission denied /usr/bin/find: '/proc/8/task/25/fd': Permission denied /usr/bin/find: '/proc/8/task/25/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/25/ns': Permission denied /usr/bin/find: '/proc/8/task/26/fd': Permission denied /usr/bin/find: '/proc/8/task/26/fdinfo': Permission denied /usr/bin/find: '/proc/8/task/26/ns': Permission denied /usr/bin/find: '/proc/8/fd': Permission denied /usr/bin/find: '/proc/8/map_files': Permission denied /usr/bin/find: '/proc/8/fdinfo': Permission denied /usr/bin/find: '/proc/8/ns': Permission denied dmesg: read kernel buffer failed: Operation not permitted /usr/bin/timeout: failed to run command '/bin/journalctl': No such file or directory /usr/bin/timeout: failed to run command '/bin/journalctl': No such file or directory Mon May 18 17:17:29 UTC 2020 Capturing program information Mon May 18 17:17:29 UTC 2020 Attempting to capture a dump with paldumper for pid 8 WARNING: Capture attempt failure detected Attempting to capture a filtered dump with paldumper for pid 8 WARNING: Attempt to capture dump failed. Reference /var/opt/mssql/log/core.sqlservr.8.temp/log/paldumper-debug.log for details Mon May 18 17:17:29 UTC 2020 Attempting to capture a dump with gdb Mon May 18 17:17:29 UTC 2020 Captured a dump with gdb Mon May 18 17:17:29 UTC 2020 Capturing program binaries Mon May 18 17:17:29 UTC 2020 Compressing the dump files
I decided to install a vmware machine, looks like is a terrible idea to install Microsoft stuff on linux...
Had the same issue on MacOS with Orbstack. Downgrading my Orbstack version fixed the issue.
