最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
问答文章1 问答文章501 问答文章1001 问答文章1501 问答文章2001 问答文章2501 问答文章3001 问答文章3501 问答文章4001 问答文章4501 问答文章5001 问答文章5501 问答文章6001 问答文章6501 问答文章7001 问答文章7501 问答文章8001 问答文章8501 问答文章9001 问答文章9501
当前位置: 首页 - 科技 - 知识百科 - 正文

MySQL服务启动时,错误:1067,进程意外终止

来源:懂视网 责编:小采 时间:2020-11-09 07:42:12
文档

MySQL服务启动时,错误:1067,进程意外终止

MySQL服务启动时,错误:1067,进程意外终止:寻找错误日志,日志默认在: C:\ProgramData\MySQL\MySQL Server 5.6\data\LI-PC.err 错误日志如下: InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibdInnoDB
推荐度:
导读MySQL服务启动时,错误:1067,进程意外终止:寻找错误日志,日志默认在: C:\ProgramData\MySQL\MySQL Server 5.6\data\LI-PC.err 错误日志如下: InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibdInnoDB

寻找错误日志,日志默认在: C:\ProgramData\MySQL\MySQL Server 5.6\data\LI-PC.err 错误日志如下: InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibdInnoDB: We do not continue the crash recovery, because

寻找错误日志,日志默认在:
C:\ProgramData\MySQL\MySQL Server 5.6\data\LI-PC.err
错误日志如下:

InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
140424 9:34:06 [Note] Plugin 'FEDERATED' is disabled.
140424 9:34:06 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
140424 9:34:06 InnoDB: The InnoDB memory heap is disabled
140424 9:34:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140424 9:34:06 InnoDB: Compressed tables use zlib 1.2.3
140424 9:34:06 InnoDB: CPU does not support crc32 instructions
140424 9:34:06 InnoDB: Initializing buffer pool, size = 49.0M
140424 9:34:06 InnoDB: Completed initialization of buffer pool
140424 9:34:06 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140424 9:34:06 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
140424 9:34:06 [ERROR] InnoDB: InnoDB: Error: Attempt to open a tablespace previously opened.
Previous tablespace hibernate/teacher uses space ID: 2 at filepath: .\hibernate\teacher.ibd
Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd

InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.

解决方案:仅从上述信息看,是innodb 的数据文件损坏,在我安装Mysql的数据目录:C:\ProgramData\MySQL\MySQL Server 5.6\data下,一般来说,直接删除ibdata1, ib_logfile0, .. 等innodb的文件,让MYSQL自动重建即可。

声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

文档

MySQL服务启动时,错误:1067,进程意外终止

MySQL服务启动时,错误:1067,进程意外终止:寻找错误日志,日志默认在: C:\ProgramData\MySQL\MySQL Server 5.6\data\LI-PC.err 错误日志如下: InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibdInnoDB
推荐度:
标签: 错误 服务 意外
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top