Hello!
I’m trying to modify the microsoft/mssql-server-windows-developer container to add the Full Text Search (FTS) capability. I’ve tried making various modifications to the provided dockerfile (github dot com/Microsoft/mssql-docker/blob/master/windows/mssql-server-windows-developer/dockerfile) and even tried using their dockerfile directly. I’ve tried 4 very different PCs. I’ve ended up with a lot of very strange errors. Most concerning of all, I’ve tried several times in a row to run their dockerfile and I get several different results, one of them is below. I’m beginning to think there’s a bug with docker desktop for windows 10. Surely this dockerfile has worked for “Perry Skountrianos” and I’ve seen numerous references to this file online where it works for others. Could it be that this works with Server 2016 directly but not on the Windows 10 version? Could it be an issue with Hyper-V isolation versus process isolation?
One run errored out due to an “out of memory exception.” You can see I’ve already tried expanding the memory allocated to the build process with the -m 4GB parameter. I haven’t seen that particular error since. But somehow there’s always some issue or another. Numerous times I’ve gotten the image to build but then it refuses to run. The container gets stuck at ‘created’ and then never moves and can’t be ended with ‘stop’, ‘kill’, or ‘rm’; I have to restart the docker service and then ‘rm’.
Any ideas?
Windows 10 build 1809
Docker Desktop for Windows 18.09 and 18.09.1 (2.0.0.2 build 30215)
PS C:\Users<user>\Desktop\SQL-dev> docker build . -m 4GB -t mssql
Sending build context to Docker daemon 2.128GB
Step 1/12 : FROM microsoft/windowsservercore
—> ea9f7aa13d03
Step 2/12 : LABEL maintainer “Perry Skountrianos”
—> Using cache
—> b80c56dd6c9c
Step 3/12 : ENV exe “https://go.microsoft.com/fwlink/?linkid=840945”
—> Using cache
—> f401c26f0701
Step 4/12 : ENV box “https://go.microsoft.com/fwlink/?linkid=840944”
—> Using cache
—> 28ff1e2b5ad1
Step 5/12 : ENV sa_password=“" attach_dbs=“[]” ACCEPT_EULA="” sa_password_path=“C:\ProgramData\Docker\secrets\sa-password”
—> Using cache
—> 32f2843253ee
Step 6/12 : SHELL [“powershell”, “-Command”, “$ErrorActionPreference = ‘Stop’; $ProgressPreference = ‘SilentlyContinue’;”]
—> Using cache
—> 206504964efb
Step 7/12 : COPY start.ps1 /
—> Using cache
—> 2b91abed8275
Step 8/12 : WORKDIR /
—> Using cache
—> ceacf932c85c
Step 9/12 : RUN Invoke-WebRequest -Uri $env:box -OutFile SQL.box ; Invoke-WebRequest -Uri $env:exe -OutFile SQL.exe ; Start-Process -Wait -FilePath .\SQL.exe -ArgumentList /qs, /x:setup ; .\setup\setup.exe /q /ACTION=Install /INSTANCENAME=MSSQLSERVER /FEATURES=SQLEngine /UPDATEENABLED=0 /SQLSVCACCOUNT=‘NT AUTHORITY\System’ /SQLSYSADMINACCOUNTS=‘BUILTIN\ADMINISTRATORS’ /TCPENABLED=1 /NPENABLED=0 /IACCEPTSQLSERVERLICENSETERMS ; Remove-Item -Recurse -Force SQL.exe, SQL.box, setup
—> Running in 5cd46655260f
CreateComputeSystem 5cd46655260f2b36904b1915b060319607bac5940281b4c4a8d485b072d5558c: This operation returned because the timeout period expired.
(extra info: {“SystemType”:“Container”,“Name”:“5cd46655260f2b36904b1915b060319607bac5940281b4c4a8d485b072d5558c”,“Owner”:“docker”,“IgnoreFlushesDuringBoot”:true,“LayerFolderPath”:“C:\ProgramData\Docker\windowsfilter\5cd46655260f2b36904b1915b060319607bac5940281b4c4a8d485b072d5558c”,“Layers”:[{“ID”:“c1bb7c56-6f13-5397-8e5f-9b53697943eb”,“Path”:“C:\ProgramData\Docker\windowsfilter\90039842c057f8c2f1fb98e73953c52473152ec794e9fec1f281e71e96066eaa”},{“ID”:“05f155a2-b04e-5137-9b3b-f72fe2504ee1”,“Path”:“C:\ProgramData\Docker\windowsfilter\cd2c8498643a7c3f0518f450baa3e71e9935874e4e1b6e9bad884c3eadff7a66”},{“ID”:“aaaa04fc-d477-5f41-8b73-4da33041ded9”,“Path”:“C:\ProgramData\Docker\windowsfilter\239f9c02c89253add622a39766b0ba4ff22fd16c7351aed9c4f58264d5a1f822”},{“ID”:“1673e75b-7ad3-540e-b803-93bd4f7e4a83”,“Path”:“C:\ProgramData\Docker\windowsfilter\de7ca8f8739f026b87a474cb580d1cfbeb1a78841469ce5c972163a05d8688a6”},{“ID”:“6db0d891-4954-5d4f-88d7-75f65edc6446”,“Path”:“C:\ProgramData\Docker\windowsfilter\427530a20decf89ef2a60b4e89f62f692e5a50969ab99d2cdf5b8623e46ea6c1”},{“ID”:“12d84982-86d4-5b7c-96ad-c1a02433625c”,“Path”:“C:\ProgramData\Docker\windowsfilter\96baf2a55eab524444747aa0e3c7f7a1e4fbc0b5b0dcf81f80438ecd10a95d3a”},{“ID”:“5309db97-7fff-582a-8f04-c5652515bbbd”,“Path”:“C:\ProgramData\Docker\windowsfilter\d1fa28f79ab6e6c6a5c1884f1708ddd7c10a5092e742616b65c0f4f98dffc8a6”},{“ID”:“e1fb1b1b-e222-50a7-9cde-025db386f0fc”,“Path”:“C:\ProgramData\Docker\windowsfilter\a17681a7c340b1f04cf2bc82b4bc4ddd092668eefc9cbcb513cb1b6dc8a6e363”},{“ID”:“585ed0c9-f01c-57b1-bf25-82b106e3defe”,“Path”:“C:\ProgramData\Docker\windowsfilter\874efe95b283614d91d0706c73c56334e87344ab06287236eca308b348de19cb”}],“MemoryMaximumInMB”:4096,“HostName”:“5cd46655260f”,“HvPartition”:true,“EndpointList”:[“9DCC3382-EFD3-4CDC-98D3-8E72B2F7586C”],“HvRuntime”:{“ImagePath”:“C:\ProgramData\Docker\windowsfilter\a17681a7c340b1f04cf2bc82b4bc4ddd092668eefc9cbcb513cb1b6dc8a6e363\UtilityVM”},“AllowUnqualifiedDNSQuery”:true})