今天在測試環境啟動MySQL資料庫時發現一個例項始終無法正常啟動。

```shell
[root@mysql ~]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld55623321 is running
MySQL server from group: mysqld56483331 is running
MySQL server from group: mysqld57303341 is running
MySQL server from group: mysqld80193380 is not running
```

檢視error日誌發現有如下報錯：

```shell
2022-02-24T09:43:29.921737+08:00 0 [ERROR] [MY-010259] [Server] Another process with pid 1156 is using unix socket file.
2022-02-24T09:43:29.921880+08:00 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2022-02-24T09:43:29.922141+08:00 0 [ERROR] [MY-010119] [Server] Aborting
```

看到的提示是不能設定socket lock檔案導致終止了，到對應的目錄下面看了下，發現在mysql沒有啟動的時候有

```shell
-rw------- 1 mysql mysql        5 Feb 23 09:44 mysqls80193350.sock.lock

```

這個檔案存在，應該是因為存在了sock的鎖檔案，導致啟動的時候不能建立該檔案導致的失敗，將該檔案mv或刪除，再次啟動正常。

```shell
[root@mysql data]# mv mysqls80193350.sock.lock mysqls80193350.sock.lock.bak

[root@mysql data]# mysqld_multi start 80193380

[root@mysql data]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld55623321 is running
MySQL server from group: mysqld56483331 is running
MySQL server from group: mysqld57303341 is running
MySQL server from group: mysqld80193380 is running

```

sock鎖檔案導致的MySQL啟動失敗

相關文章