SQL Server docker container with NFS mount as volume mapping -
i trying run sql server on ubuntu docker container using stranded microsoft/mssql-server-linux:latest docker image. data persistence mapping volume host (having ext4 file system) container using -v option in docker run command below
docker run -it -e 'accept_eula=y' -e 'sa_password=######' -p 1433:1433 -v /var/opt/database:/var/opt/mssql/data microsoft/mssql-server-linux
container running fine , able connect database. not want store data on host because of growing size of database , swarm reasons. thought run nfs server on other machine , mount nfs directory onto docker host , use nfs dir on volume mapping volume mapping
-v /var/nfs/database:/var/opt/mssql/data
where /var/nfs/database
nfs mount dir on docker host. when start container following error
2017-08-18 10:15:53.98 spid5s fcb::open failed: not open file /var/opt/mssql/data/master.mdf file number 1. os error: 87(the parameter incorrect.). 2017-08-18 10:15:53.98 spid5s error: 5120, severity: 16, state: 101. 2017-08-18 10:15:53.98 spid5s unable open physical file "/var/opt/mssql/data/master.mdf". operating system error 87: "87(the parameter incorrect.)". 2017-08-18 10:15:54.13 spid5s error: 17204, severity: 16, state: 1. 2017-08-18 10:15:54.13 spid5s fcb::open failed: not open file /var/opt/mssql/data/mastlog.ldf file number 2. os error: 87(the parameter incorrect.). 2017-08-18 10:15:54.13 spid5s error: 5120, severity: 16, state: 101. 2017-08-18 10:15:54.13 spid5s unable open physical file "/var/opt/mssql/data/mastlog.ldf". operating system error 87: "87(the parameter incorrect.)".
i have given permissions database files. below nfs mount snippet
sharedstorageip:/var/nfs nfs4 443g 47g 375g 11% /var/nfs
the release notes explain can't this:
hosting database files on nfs server not supported in release. includes using nfs shared disk failover clustering databases on non-clustered instances. working on enabling nfs server support in upcoming releases.
hosting database files on networked path not trivial, given demands database has reliability. hosting files on smb shares wasn't possible until version 2.2 of protocol.
Comments
Post a Comment