search

microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.73k stars 758 forks source link

SQL Server LCOW fails to start #606

Open scalise opened 4 years ago

scalise commented 4 years ago

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

sirajka commented 4 years ago

Related to https://github.com/microsoft/mssql-docker/issues/603?

deivid11 commented 8 months ago

I decided to install a vmware machine, looks like is a terrible idea to install Microsoft stuff on linux...

aaronhod commented 7 months ago

Had the same issue on MacOS with Orbstack. Downgrading my Orbstack version fixed the issue.