Git Product home page Git Product logo

Comments (7)

evil-shrike avatar evil-shrike commented on May 22, 2024 10

Any news on the issue?
Running a container from image microsoft/mssql-server-linux and a volume mapping ./local/folder:/var/opt/mssql/ still fails. My host is a Win10 machine.

Microsoft SQL Server 2017 (RTM-CU3-GDR) (KB4052987) - 14.0.3015.40 (X64)
Dec 22 2017 16:13:22
Developer Edition (64-bit) on Linux (Ubuntu 16.04.3 LTS)

From output:

2018-02-06 00:09:05.50 spid7s      The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes.  3072 bytes at offset 418816 in file /var/opt/mssql/data/mastlog.ldf will be written.
2018-02-06 00:09:06.03 spid7s      Converting database 'master' from version 862 to the current version 869.
2018-02-06 00:09:06.04 spid7s      Database 'master' running the upgrade step from version 862 to version 863.
2018-02-06 00:09:06.09 spid7s      Database 'master' running the upgrade step from version 863 to version 864.
2018-02-06 00:09:06.15 spid7s      Error: 17053, Severity: 16, State: 1.
2018-02-06 00:09:06.15 spid7s      /var/opt/mssql/data/mastlog.ldf: Operating system error 31(A device attached to the system is not functioning.) encountered.
2018-02-06 00:09:07.21 spid7s      Error: 928, Severity: 20, State: 1.
2018-02-06 00:09:07.21 spid7s      During upgrade, database raised exception 9002, severity 17, state 0, address 0000000404D013DE. Use the exception number to determine the cause.
2018-02-06 00:09:07.25 spid7s      Error: 9002, Severity: 17, State: 0.
2018-02-06 00:09:07.25 spid7s      The transaction log for database 'master' is full due to 'NOTHING'.

from mssql-docker.

sspark519831 avatar sspark519831 commented on May 22, 2024 1

I have same problem with microsoft/mssql-server-linu:latest on Windows.

PS C:\Users\spark> systeminfo | findstr /B /C:"OS Name" /C:"OS Version"
OS Name:                   Microsoft Windows 10 Enterprise
OS Version:                10.0.14393 N/A Build 14393

PS C:\Users\spark> docker -v
Docker version 17.12.0-ce, build c97c6d6

PS C:\Users\spark> docker-machine -v
docker-machine.exe version 0.13.0, build 9ba6da9

But, it works for only microsoft/mssql-server-linu:2017-CU3.

from mssql-docker.

goostleek avatar goostleek commented on May 22, 2024

At the moment the only workaround for that is to use a data volume (as suggested).

from mssql-docker.

whatevergeek avatar whatevergeek commented on May 22, 2024

any updates on this?
it currently crashes on load when docker volume (-v) is used:
image

i talked to Anna Shrestinian the other day in the #MSTechSummit
she said volumes should now work...
e.g.
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=SqlServer101' -v /c/path_to_local/mssql:/var/opt/mssql -p 1433:1433 -d microsoft/mssql-server-linux:2017-GA

but seems it is still not working...
any other additional setup i need to do?

from mssql-docker.

rdalfonso avatar rdalfonso commented on May 22, 2024

I'm on Docker Cloud and deploy the container to an AWS EC2 instance and the container fails with the same error. Everything worked fine on the my mac. Container is based off microsoft/mssql-server-linux:latest image

2018-03-06 19:35:10.33 spid6s Database 'master' running the upgrade step from version 863 to version 864.
2018-03-06 19:35:10.35 spid6s Error: 17053, Severity: 16, State: 1.
2018-03-06 19:35:10.35 spid6s /var/opt/mssql/data/mastlog.ldf: Operating system error 31(A device attached to the system is not functioning.) encountered.
2018-03-06 19:35:11.36 spid6s Error: 928, Severity: 20, State: 1.
2018-03-06 19:35:11.36 spid6s During upgrade, database raised exception 9002, severity 17, state 0, address 0000000404D013DE. Use the exception number to determi
ne the cause.
2018-03-06 19:35:11.37 spid6s Error: 9002, Severity: 17, State: 0.
2018-03-06 19:35:11.37 spid6s The transaction log for database 'master' is full due to 'NOTHING'.

from mssql-docker.

EvgenyKhaliper avatar EvgenyKhaliper commented on May 22, 2024

Exactly same issue,
what the point to use this image at all if the volume cannot be mapped ?

from mssql-docker.

goostleek avatar goostleek commented on May 22, 2024

@evgeny-pol You can still use volumes. Please see #52 (comment)

from mssql-docker.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.