MysqL start ERROR 2002 (HY000): Can't connect to local MysqL server through socket '/var/run/MysqLd/MysqLd.sock' (2)
使用 journalctl -xe
journalctl -xe 12月 10 11:49:38 user-70DGA014CN kernel: ata3.00: configured for UDMA/133 12月 10 11:49:38 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#16 Failed Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE 12月 10 11:49:38 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#16 Sense Key : Medium Error [current] 12月 10 11:49:38 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#16 Add. Sense: Unrecovered read error 12月 10 11:49:38 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#16 CDB: Read(16) 88 00 00 00 00 00 5c 56 24 c0 00 00 00 08 00 00 12月 10 11:49:38 user-70DGA014CN kernel: print_req_error: I/O error, dev sda, sector 1549149383 12月 10 11:49:38 user-70DGA014CN kernel: ata3: EH complete 12月 10 11:49:38 user-70DGA014CN systemd[1]: MysqL.service: Main process exited, code=exited, status=2/INVALIDARGUMENT 12月 10 11:50:05 user-70DGA014CN systemd[1]: Failed to start MysqL Community Server. -- Subject: MysqL.service 单元已失败 -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- MysqL.service 单元已失败。 -- -- 结果为“Failed”。 12月 10 11:50:05 user-70DGA014CN systemd[1]: MysqL.service: Unit entered Failed state. 12月 10 11:50:05 user-70DGA014CN systemd[1]: MysqL.service: Failed with result 'exit-code'. 12月 10 11:50:05 user-70DGA014CN systemd[1]: MysqL.service: Service hold-off time over, scheduling restart. 12月 10 11:50:05 user-70DGA014CN systemd[1]: Stopped MysqL Community Server. -- Subject: MysqL.service 单元已结束停止操作 -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- MysqL.service 单元已结束停止操作。 12月 10 11:50:05 user-70DGA014CN systemd[1]: Starting MysqL Community Server... -- Subject: MysqL.service 单元已开始启动 -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- MysqL.service 单元已开始启动。 12月 10 11:50:05 user-70DGA014CN audit[8266]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/proc/8266/status" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=123 12月 10 11:50:05 user-70DGA014CN kernel: audit: type=1400 audit(1544413805.884:13993): apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/proc/8266/status" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=123 12月 10 11:50:05 user-70DGA014CN kernel: audit: type=1400 audit(1544413805.884:13994): apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/sys/devices/system/node/" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=0 12月 10 11:50:05 user-70DGA014CN kernel: audit: type=1400 audit(1544413805.884:13995): apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/proc/8266/status" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=123 12月 10 11:50:05 user-70DGA014CN audit[8266]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/sys/devices/system/node/" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=0 12月 10 11:50:05 user-70DGA014CN audit[8266]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/MysqLd" name="/proc/8266/status" pid=8266 comm="MysqLd" requested_mask="r" denied_mask="r" fsuid=123 ouid=123 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: exception Emask 0x0 SAct 0x400000 SErr 0x0 action 0x0 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: irq_stat 0x40000008 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: Failed command: READ FPDMA QUEUED 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: cmd 60/08:b0:c0:24:56/00:00:5c:00:00/40 tag 22 ncq dma 4096 in res 43/40:08:c7:24:56/00:00:5c:00:00/00 Emask 0x408 (media error) <F> 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: status: { DRDY SENSE ERR } 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: error: { UNC } 12月 10 11:50:09 user-70DGA014CN kernel: ata3.00: configured for UDMA/133 12月 10 11:50:09 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#22 Failed Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE 12月 10 11:50:09 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#22 Sense Key : Medium Error [current] 12月 10 11:50:09 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#22 Add. Sense: Unrecovered read error 12月 10 11:50:09 user-70DGA014CN kernel: sd 2:0:0:0: [sda] tag#22 CDB: Read(16) 88 00 00 00 00 00 5c 56 24 c0 00 00 00 08 00 00 12月 10 11:50:09 user-70DGA014CN kernel: print_req_error: I/O error, sector 1549149383 12月 10 11:50:09 user-70DGA014CN kernel: ata3: EH complete 12月 10 11:50:09 user-70DGA014CN systemd[1]: MysqL.service: Main process exited, status=2/INVALIDARGUMENT
使用systemctl status MysqL.service
>>> systemctl status MysqL.service ● MysqL.service - MysqL Community Server Loaded: loaded (/lib/systemd/system/MysqL.service; enabled; vendor preset: enabled) Active: activating (start-post) (Result: exit-code) since 一 2018-12-10 11:53:08 CST; 8s ago Process: 8815 ExecStart=/usr/sbin/MysqLd (code=exited, status=2) Process: 8807 ExecStartPre=/usr/share/MysqL/MysqL-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 8815 (code=exited, status=2); : 8816 (MysqL-systemd-s) CGroup: /system.slice/MysqL.service └─control ├─8816 /bin/bash /usr/share/MysqL/MysqL-systemd-start post └─8852 sleep 1 12月 10 11:53:08 user-70DGA014CN systemd[1]: Starting MysqL Community Server... 12月 10 11:53:12 user-70DGA014CN systemd[1]: MysqL.service: Main process exited, status=2/INVALIDARGUMENT