mysql数据库报错：InnoDB: Operating system error number 13 in a file operation

最新推荐文章于 2024-07-08 18:42:36 发布

reblue520

最新推荐文章于 2024-07-08 18:42:36 发布

阅读量5.9k

点赞数

分类专栏：错误处理

本文链接：https://blog.csdn.net/reblue520/article/details/52289835

版权

在CentOS 6.5环境下，启动MySQL时遇到InnoDB错误13，导致数据库无法正常运行。通过检查日志发现修复房间消息表时存在问题。分析认为该问题是由于SELinux处于强制模式导致。通过运行`getenforce`确认为enforcing状态，然后使用`setenforce 0`临时关闭SELinux，并修改`/etc/sysconfig/selinux`配置文件将SELINUX设为disabled，成功解决问题。

摘要由CSDN通过智能技术生成

环境：centos6.5 x86_64

启动mysql发现日志报错(日志路径可以查看/etc/my.cnf的配置)

160722 10:34:08 [Note] Found 42570716 of 42570696 rows when repairing './yunva@002dlog/room_msg'

160810 0:54:00 [ERROR] /usr/libexec/mysqld: Sort aborted
160810 10:41:55 [ERROR] /usr/libexec/mysqld: Sort aborted
160810 16:41:43 [ERROR] /usr/libexec/mysqld: Sort aborted
160823 11:34:45 mysqld_safe Starting mysqld daemon with databases from /home/data
160823 11:34:46 [Warning] Can't create test file /home/data/plugin.lower-test
160823 11:34:46 [Warning] Can't create test file /home/data/plugin.lower-test
160823 11:34:46 [Warning] option 'innodb-additional-mem-pool-size': signed value 200 adjusted to 524288
160823 11:34:46 InnoDB: Initializing buffer pool, size = 128.0M
160823 11:34:46 InnoDB: Completed initialization of buffer pool
160823 11:34:46 InnoDB: Operating system error n