[ERROR] Unix socket lock file is empty /var/run/mysqld/mysqld.sock.lock.

[weiqiLee]

I can't start mysql anymore
The log show
2018-09-07T11:25:29.698654Z 0 [ERROR] Unix socket lock file is empty /var/run/mysqld/mysqld.sock.lock.
2018-09-07T11:25:29.698666Z 0 [ERROR] Unable to setup unix socket lock file.
2018-09-07T11:25:29.698672Z 0 [ERROR] Aborting

[weiqiLee]

[user@glusterfs01 ~]$ sudo docker start -i dev_db
[sudo] password for user:
2018-09-07T11:25:29.494875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-07T11:25:29.498395Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 1 ...
2018-09-07T11:25:29.501319Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-09-07T11:25:29.501394Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-07T11:25:29.501402Z 0 [Note] InnoDB: Uses event mutexes
2018-09-07T11:25:29.501410Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-09-07T11:25:29.501429Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-07T11:25:29.501449Z 0 [Note] InnoDB: Using Linux native AIO
2018-09-07T11:25:29.501693Z 0 [Note] InnoDB: Number of pools: 1
2018-09-07T11:25:29.501786Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-09-07T11:25:29.503157Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-09-07T11:25:29.510188Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-09-07T11:25:29.511751Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-09-07T11:25:29.523340Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-07T11:25:29.540519Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-09-07T11:25:29.540646Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-09-07T11:25:29.635400Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-09-07T11:25:29.636979Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-09-07T11:25:29.637046Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-09-07T11:25:29.637873Z 0 [Note] InnoDB: Waiting for purge to start
2018-09-07T11:25:29.688035Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 140219066533
2018-09-07T11:25:29.688245Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-09-07T11:25:29.688504Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-09-07T11:25:29.690606Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180907 19:25:29
2018-09-07T11:25:29.694499Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-09-07T11:25:29.694913Z 0 [Warning] CA certificate ca.pem is self signed.
2018-09-07T11:25:29.698256Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-09-07T11:25:29.698344Z 0 [Note] IPv6 is available.
2018-09-07T11:25:29.698409Z 0 [Note] - '::' resolves to '::';
2018-09-07T11:25:29.698489Z 0 [Note] Server socket created on IP: '::'.
2018-09-07T11:25:29.698654Z 0 [ERROR] Unix socket lock file is empty /var/run/mysqld/mysqld.sock.lock.
2018-09-07T11:25:29.698666Z 0 [ERROR] Unable to setup unix socket lock file.
2018-09-07T11:25:29.698672Z 0 [ERROR] Aborting

2018-09-07T11:25:29.698688Z 0 [Note] Binlog end
2018-09-07T11:25:29.698767Z 0 [Note] Shutting down plugin 'ngram'
2018-09-07T11:25:29.698778Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-09-07T11:25:29.698784Z 0 [Note] Shutting down plugin 'partition'
2018-09-07T11:25:29.698789Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-09-07T11:25:29.698793Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-09-07T11:25:29.698798Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-09-07T11:25:29.698803Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-09-07T11:25:29.698807Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-09-07T11:25:29.698812Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-09-07T11:25:29.698816Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-09-07T11:25:29.698821Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-09-07T11:25:29.698825Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-09-07T11:25:29.698830Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-09-07T11:25:29.698834Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-09-07T11:25:29.698839Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-09-07T11:25:29.698843Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-09-07T11:25:29.698848Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-09-07T11:25:29.698852Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-09-07T11:25:29.698857Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-09-07T11:25:29.698861Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-09-07T11:25:29.698866Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-09-07T11:25:29.698871Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-09-07T11:25:29.698875Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-09-07T11:25:29.698880Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-09-07T11:25:29.698884Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-09-07T11:25:29.698889Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-09-07T11:25:29.698893Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-09-07T11:25:29.698898Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-09-07T11:25:29.698902Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-09-07T11:25:29.698907Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-09-07T11:25:29.698911Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-09-07T11:25:29.698915Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-09-07T11:25:29.698920Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-09-07T11:25:29.698924Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-09-07T11:25:29.698929Z 0 [Note] Shutting down plugin 'InnoDB'
2018-09-07T11:25:29.698998Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-09-07T11:25:29.699173Z 0 [Note] InnoDB: Starting shutdown...
2018-09-07T11:25:29.799325Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-09-07T11:25:29.799696Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180907 19:25:29
2018-09-07T11:25:31.309722Z 0 [Note] InnoDB: Shutdown completed; log sequence number 140219066552
2018-09-07T11:25:31.313746Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-09-07T11:25:31.313781Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-09-07T11:25:31.313796Z 0 [Note] Shutting down plugin 'MyISAM'
2018-09-07T11:25:31.313816Z 0 [Note] Shutting down plugin 'CSV'
2018-09-07T11:25:31.313831Z 0 [Note] Shutting down plugin 'MEMORY'
2018-09-07T11:25:31.313907Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-09-07T11:25:31.313993Z 0 [Note] Shutting down plugin 'sha256_password'
2018-09-07T11:25:31.314009Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-09-07T11:25:31.314234Z 0 [Note] Shutting down plugin 'binlog'
2018-09-07T11:25:31.314714Z 0 [Note] mysqld: Shutdown complete

[weiqiLee]

[
{
"Id": "c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a",
"Created": "2017-02-13T07:03:46.903497284Z",
"Path": "docker-entrypoint.sh",
"Args": [
"mysqld"
],
"State": {
"Status": "exited",
"Running": false,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 0,
"ExitCode": 1,
"Error": "",
"StartedAt": "2018-09-07T11:25:29.210775264Z",
"FinishedAt": "2018-09-07T11:25:31.450755399Z"
},
"Image": "sha256:7666f75adb6b50676a366c6fd7a3916cb41f6e8eaf336c3d3ab7d35317fed0b9",
"ResolvConfPath": "/disk2/docker/containers/c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a/resolv.conf",
"HostnamePath": "/disk2/docker/containers/c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a/hostname",
"HostsPath": "/disk2/docker/containers/c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a/hosts",
"LogPath": "/disk2/docker/containers/c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a/c2489c3dee0a562ad2d99f9afd804d32a7f6eb29c6091b06fd13d198c144df1a-json.log",
"Name": "/dev_db",
"RestartCount": 0,
"Driver": "overlay",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [
"/data/mysql:/var/lib/mysql"
],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "default",
"PortBindings": {
"3306/tcp": [
{
"HostIp": "",
"HostPort": "3306"
}
]
},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"CapAdd": null,
"CapDrop": null,
"Dns": [],
"DnsOptions": [],
"DnsSearch": [],
"ExtraHosts": null,
"GroupAdd": null,
"IpcMode": "",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"ConsoleSize": [
0,
0
],
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": null,
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": [],
"DiskQuota": 0,
"KernelMemory": 0,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": -1,
"OomKillDisable": false,
"PidsLimit": 0,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0
},
"GraphDriver": {
"Name": "overlay",
"Data": {
"LowerDir": "/disk2/docker/overlay/6c1f33cf4ca5ba9adea25d1a81346eeb0f4588374067ea4469e526609df6d1f7/root",
"MergedDir": "/disk2/docker/overlay/e45ce84ec9dc22f119427008eec160cfeaeacb26d311eb0235433662d974b35b/merged",
"UpperDir": "/disk2/docker/overlay/e45ce84ec9dc22f119427008eec160cfeaeacb26d311eb0235433662d974b35b/upper",
"WorkDir": "/disk2/docker/overlay/e45ce84ec9dc22f119427008eec160cfeaeacb26d311eb0235433662d974b35b/work"
}
},
"Mounts": [
{
"Type": "bind",
"Source": "/data/mysql",
"Destination": "/var/lib/mysql",
"Mode": "",
"RW": true,
"Propagation": ""
}
],
"Config": {
"Hostname": "c2489c3dee0a",
"Domainname": "",
"User": "",
"AttachStdin": true,
"AttachStdout": true,
"AttachStderr": true,
"ExposedPorts": {
"3306/tcp": {}
},
"Tty": true,
"OpenStdin": true,
"StdinOnce": true,
"Env": [
"MYSQL_ROOT_PASSWORD=xxxxxx",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.7",
"MYSQL_MAJOR=5.7",
"MYSQL_VERSION=5.7.17-1debian8"
],
"Cmd": [
"mysqld"
],
"ArgsEscaped": true,
"Image": "daocloud.io/library/mysql",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": null,
"Labels": {}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "c0718e6d9e0612d82ecc5910dd5fbdfb9025017950f55ed85cf4461e7bf13f8b",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": null,
"SandboxKey": "/var/run/docker/netns/c0718e6d9e06",
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "",
"Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"MacAddress": "",
"Networks": {
"bridge": {
"IPAMConfig": null,
"Links": null,
"Aliases": null,
"NetworkID": "924fcd0c24b1a7ff68ef65c5201b9021233083225a6d8a48470fa34be0468efd",
"EndpointID": "",
"Gateway": "",
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"MacAddress": ""
}
}
}
}
]

[wglambert]

The issue could be that you're using a mac and overlay2, or possibly an improper shutdown

https://stackoverflow.com/questions/34954455/mysql-daemon-lock-issue
https://serverfault.com/a/883505

[tianon]

Yeah, this looks to me like an improper shutdown.

In the future, these sorts of questions/requests would be more appropriately posted to the Docker Community Forums, the Docker Community Slack, or Stack Overflow.