mysql Got error 28 from storage engine(磁盘空间不足) 问题报错、问题分析 及 问题解决方法

项目场景：

提示：这里简述项目相关背景：

报错日志：
[ code: 500 ] ### Error querying database. Cause: java.sql.SQLException: Got error 28 from storage engine ### The error may exist in URL [jar:file:/www/wwwroot/huidaoyun/huidaoyun.jar!/mapper/device/device/DeviceDao.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT dd.*, ddc.name AS category_name, ddf.name AS country_category_name, ddb.name AS brand_name, ddl.name AS location_name, su.name AS manager_name, sd.name AS dept_name, csd.name AS company_name, cc.name AS supplier_name FROM device_device dd LEFT JOIN device_device_category ddc ON dd.category_id = ddc.id LEFT JOIN device_country_category ddf ON dd.country_category_id = ddf.id LEFT JOIN device_device_brand ddb ON dd.brand_id = ddb.id LEFT JOIN device_device_location ddl ON dd.location_id = ddl.id LEFT JOIN sys_user su ON dd.manager_id = su.user_id LEFT JOIN sys_dept sd ON dd.dept_id = sd.dept_id LEFT JOIN sys_dept csd ON dd.company_id = csd.dept_id LEFT JOIN com_commercia cc ON dd.supplier_id = cc.commercia_id WHERE dd.deleted_flag = ‘N’ ORDER BY repair_count DESC LIMIT ?,? ### Cause: java.sql.SQLException: Got error 28 from storage engine ; uncategorized SQLException; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine: http://api.huidaoyun.com/home/sum/repair_order

---

问题描述

提示：这里描述项目中遇到的问题：
前端页面输出的报错日志信息如下：

[ code: 500 ] 
 ### Error querying database. Cause: java.sql.SQLException: Got error 28 from storage engine ### The error may exist in URL [jar:file:/www/wwwroot/huidaoyun/huidaoyun.jar!/mapper/device/device/DeviceDao.xml] ### The error may involve defaultParameterMap
 ### The error occurred while setting parameters 
 ### SQL: SELECT dd.*, ddc.name AS category_name, ddf.name AS country_category_name, ddb.name AS brand_name, ddl.name AS location_name, su.name AS manager_name, sd.name AS dept_name, csd.name AS company_name, cc.name AS supplier_name FROM device_device dd LEFT JOIN device_device_category ddc ON dd.category_id = ddc.id LEFT JOIN device_country_category ddf ON dd.country_category_id = ddf.id LEFT JOIN device_device_brand ddb ON dd.brand_id = ddb.id LEFT JOIN device_device_location ddl ON dd.location_id = ddl.id LEFT JOIN sys_user su ON dd.manager_id = su.user_id LEFT JOIN sys_dept sd ON dd.dept_id = sd.dept_id LEFT JOIN sys_dept csd ON dd.company_id = csd.dept_id LEFT JOIN com_commercia cc ON dd.supplier_id = cc.commercia_id WHERE dd.deleted_flag = 'N' ORDER BY repair_count DESC LIMIT ?,?
 ### Cause: java.sql.SQLException: Got error 28 from storage engine ; uncategorized SQLException; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine: http://api.huidaoyun.com/home/sum/repair_order

截图如下所示：

---

原因分析：

提示：这里填写问题的分析：

前端页面 数据列表加载出现如上报错信息， 系统是在虚拟机服务器的环境下运行，故我们需要从虚拟机的方向进行考虑，
第一步： 查看服务器空间（在根目录下运行此命令）
df -h查看服务器磁盘空间

查询结果显示，数据库所在的盘没有问题，那么我们推测可能是 数据库 用的临时 目录空间 不足以使用了，导致系统无法执行此 SQL语句。

---

解决方案：

提示：这里填写该问题的具体解决方案：
解决方法：

1、清空 /tmp 目录
2、 或者修改my.cnf 中的 tmpdir 参数
3、将 tmpdir 指向 一个硬盘空间很大的目录，即具有足够空间 的目录即可。