mysql:5.6 faied to start - changing ownership of '/var/lib/mysql/': Operation not permitted

[libnux]

Details below, thanks.

Command

docker run -e MYSQL_ROOT_PASSWORD=passw0rd -v ~/temp/mysql:/var/lib/mysql mysql:5.6

Error

chown: changing ownership of '/var/lib/mysql/': Operation not permitted

OS

ubuntu 16.04 (4.4.0-25-generic #44-Ubuntu SMP Fri Jun 10 18:19:48 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux)

Docker

Server Version: 1.11.2
Storage Driver: aufs
Root Dir: /var/lib/docker/165536.165536/aufs
Backing Filesystem: extfs
Dirs: 91
Dirperm1 Supported: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: host bridge null
Kernel Version: 4.4.0-25-generic
Operating System: Ubuntu 16.04 LTS
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 15.58 GiB
Name: libnux-desktop
ID: HG7F:MORL:Y7GC:VAM7:NBXD:KJAH:3MOB:MVYP:QZRU:FOK4:5CAQ:432Y
Docker Root Dir: /var/lib/docker/165536.165536
Debug mode (client): false
Debug mode (server): false
Registry: https://index.docker.io/v1/

[ltangvald]

Can you try adding a --user= set to a user that has the necessary permissions for /temp/mysql?

[libnux]

1. added "--user=root" and still got the same error.
2. added "--user=mysql", and failed to start since mysql user has no enough rights.

It might be caused by some change in docker 1.11.x. I could run mysql docker successfully with older docker versions.

[yosifkit]

What is the uid of the owner of ~/temp/mysql, try using that.

# probably should work:
$ docker run -e MYSQL_ROOT_PASSWORD=passw0rd -v ~/temp/mysql:/var/lib/mysql --user 1000 mysql:5.6

[libnux]

I uninstalled docker-engine, and installed it again. Then the problem was resolved.

Thanks.

[lpshikhar]

Is there any other workaround for this issues, especially running the image inside a kubernetes based framework ?

[yosifkit]

@lpshikhar, I believe that the Kubernetes way is fsGroup in the securityContext: kubernetes/kubernetes#2630 (comment). But I think it depends on what persistent volume you are using.