MYSQL随笔十二磁盘坏道 _随笔

【MYSQL随笔十二磁盘坏道】少年辛苦终身事，莫向光阴惰寸功。这篇文章主要讲述MYSQL随笔十二磁盘坏道相关的知识，希望能为你提供帮助。

大概报错内容：
2019-09-06 14:14:39 3448 [ERROR] InnoDB: Error in system call pread(). The operating system error number is 5.
2019-09-06 14:14:39 7f30fc28d700InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means Input/output error.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2019-09-06 14:14:39 3448 [ERROR] InnoDB: File (unknown): read returned OS error 105. Cannot continue operation
190906 14:14:40 mysqld_safe Number of processes running now: 0
190906 14:14:40 mysqld_safe mysqld restarted
2019-09-06 14:14:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-09-06 14:14:40 0 [Note] /home/mysql/mysql-5.6.32_3306/bin/mysqld (mysqld 5.6.32-log) starting as process 6945 ...
2019-09-06 14:14:40 6945 [Note] Plugin FEDERATED is disabled.

[root@$ ~]# badblocks -s -v /dev/sdb1
正在检查从 0 到 1953513471的块
Checking for bad blocks (read-only test): 968188800one, 3:22:11 elapsed
968188836one, 3:23:15 elapsed
968188837one, 3:23:36 elapsed
968188838one, 3:23:57 elapsed
968188839one, 3:24:19 elapsed
969017368one, 3:24:53 elapsed
969017424one, 3:25:36 elapsed
969017425one, 3:25:57 elapsed
969017426one, 3:26:19 elapsed
969017427one, 3:26:40 elapsed
完成
Pass completed, 10 bad blocks found.

[root@$ ~]# dmesg | tail
ata2.00: configured for UDMA/133
sd 1:0:0:0: [sdb]Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
sd 1:0:0:0: [sdb]Sense Key : Medium Error [current] [descriptor]
Descriptor sense data with sense descriptors (in hex):
72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
73 84 18 a0
sd 1:0:0:0: [sdb]Add. Sense: Unrecovered read error - auto reallocate failed
sd 1:0:0:0: [sdb] CDB: Read(10): 28 00 73 84 18 a0 00 00 08 00
end_request: I/O error, dev sdb, sector 1938036896
ata2: EH complete

[root@$ ~]# cat /var/log/messages |tail
Sep9 10:27:36 $ kernel: ata2.00: configured for UDMA/133
Sep9 10:27:36 $ kernel: sd 1:0:0:0: [sdb]Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
Sep9 10:27:36 $ kernel: sd 1:0:0:0: [sdb]Sense Key : Medium Error [current] [descriptor]
Sep9 10:27:36 $ kernel: Descriptor sense data with sense descriptors (in hex):
Sep9 10:27:36 $ kernel:72 03 11 04 00 00 00 0c 00 0a 80 00 00 00 00 00
Sep9 10:27:36 $ kernel:73 84 18 a0
Sep9 10:27:36 $ kernel: sd 1:0:0:0: [sdb]Add. Sense: Unrecovered read error - auto reallocate failed
Sep9 10:27:36 $ kernel: sd 1:0:0:0: [sdb] CDB: Read(10): 28 00 73 84 18 a0 00 00 08 00
Sep9 10:27:36 $ kernel: end_request: I/O error, dev sdb, sector 1938036896
Sep9 10:27:36 $ kernel: ata2: EH complete
##解决办法更换磁盘