MYSQL-ERROR(1030 - Got error 28 from storage engine)

原创

woxuewangluo 2013-11-07 14:50:58 博主文章分类：MYSQL文档 ©著作权

©著作权归作者所有：来自51CTO博客作者woxuewangluo的原创作品，请联系作者获取转载授权，否则将追究法律责任

1、app平台提示错误：

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select a.*,ac.type_id from qinba_article as a left join qinba_article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 and ac.type_id = 3 order by a.sort desc limit 8 ) [2] => Array ( [error] => Got error 28 from storage engine ) [3] => Array ( [errno] => 1030 ) )

2、解决方法：

在mysql中执行报错中的语句：

select a.*,ac.type_id from qinba_article as a left join qinba_article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 and ac.type_id = 3 order by a.sort desc limit 8

报错误：1030 - Got error 28 from storage engine

3、在系统中查看/tmp是否已经满了：

[root@localhost /]# df /tmp/

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/sda6 20315812 14877588 4389584 100% /

[root@localhost ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda6 20G 19G 0 100% /

4、统计/tmp大小：

[root@localhost /]# du -sh /tmp/

29M /tmp/

看到/tmp只有29M 那么是什么占用了/ 目录空间？