Comments (7)
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.
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.
At the moment the only workaround for that is to use a data volume (as suggested).
from mssql-docker.
any updates on this?
it currently crashes on load when docker volume (-v) is used:
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.
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.
Exactly same issue,
what the point to use this image at all if the volume cannot be mapped ?
from mssql-docker.
@evgeny-pol You can still use volumes. Please see #52 (comment)
from mssql-docker.
Related Issues (20)
- Unable to lock /var/opt/mssql/ HOT 3
- custimize build error: "mkdir: cannot create directory '/usr/config': Permission denied" HOT 1
- install.tar is part of the final image, makes the image 1.3 GB bigger than necessary HOT 7
- Fail to run conatiner with Error "Too many open files"
- mssql Error: 17113, Severity: 16, State: 1. Error 5 (Access Denied)
- EXCEPTION_ACCESS_VIOLATION HOT 15
- Massive virtual memory usage while running linux container with only one DB
- Confusing Password Validation Error Message HOT 1
- Broken/held packages for libldap HOT 1
- Machine Learning Extension SQL Server 2022 not working HOT 1
- mssql for arm64 HOT 2
- Cannot connect SQLServer docker from ASP.NET Core 8 HOT 1
- Security vulnerabilites identified in sqlserver linux docker image
- Unable to start container on Linux 6.7 HOT 63
- Incompatible permissions tracking 2022-latest (from 2022-CU10-ubuntu-22.04 to 2022-CU11-ubuntu-22.04) HOT 1
- Issuse pulling any image from mcr.microsoft.com/mssql/ HOT 1
- Issue with AD on mssql-docker linux > CU9 (Ubuntu 22.04 vs 20.04) HOT 2
- Daylight savings time - wrong time with 2017-latest HOT 1
- LDF files are not moved to MSSQL_LOG_DIR
- Restore command is hanging after logged as success HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mssql-docker.