这篇博客讲述了由于磁盘挂载错误导致MySQL主库无法启动的问题，具体表现为日志恢复过程中出现错误，系统找不到指定路径。解决方案包括检查分区UUID、确认挂载文件是否正确及重新挂载分区并更新fstab文件。在修复后，数据库成功启动，但出现了权限表不存在的错误。这提示可能还需要进一步修复MySQL的权限配置。
磁盘挂载不正确导致的主库启动不起来：
Recovery process statistics
Checked pages by doublewrite buffer: 128
Overwritten pages from doublewrite: 0
Recovered pages by io_thread: 143
Recovered pages by main thread: 0
Parsed log records to apply: 139463
Sum of the length: 964413
Applied log records: 135257
Sum of the length: 940059
Pages which are already new enough: 128 (It may not be accurate, if turns > 1)
Oldest page's LSN: 39274
Newest page's LSN: 1597908
============================================================
171205 10:04:01 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: cannot open ib_lru_dump
171205 10:04:01 InnoDB: Waiting for the background threads to start
171205 10:04:02 Percona XtraDB (https://www.percona.com) 1.1.8-rel24.1 started; log sequence number 1597915
171205 10:04:02 [Note] Recovering after a crash using /home/mysql/binlog
171205 10:04:02 [Note] Starting crash recovery...
171205 10:04:02 [Note] Crash recovery finished.
171205 10:04:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
171205 10:04:02 mysqld_safe mysqld from pid file /home/mysql/mysql.pid ended
解决： 1、查看分区UUID blkid 2、查看/etc/fstatb文件挂盘文件是否正确 3、重新挂载分区，写入fstab文件
289
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
