MySQL报错：Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device)

深藏阁楼爱情的钟 2023-06-19 11:07 22阅读 0赞

## MySQL报错：Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device) ##

**一、问题描述**

1、MySQL好好的，突然就不行了，信息如下：

系统内部错误.

错误信息：

org.springframework.jdbc.UncategorizedSQLException:

\#\#\# Error querying database. Cause: java.sql.SQLException: **Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device)**

\#\#\# The error may exist in file \[/home/webapps/xxxxl/XXXDao.xml\]

\#\#\# The error may involve com.thxxx.getListArea-Inline

\#\#\# The error occurred while setting parameters

\#\#\# **SQL**: SELECT a.id, ROUND(a.wt\* 99 / (SELECT max(wt) from xxxx ),2) AS wt, ROUND(a.qt, 2) AS qt, DESC LIMIT ?  ....

\#\#\# Cause: java.sql.SQLException: Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device)

; uncategorized SQLException for SQL \[\]; SQL state \[HY000\]; error code \[3\]; Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device); nested exception is java.sql.SQLException: Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExcepti

...

Caused by: java.sql.SQLException: **Error writing file '/tmp/MY4WYVlC' (Errcode: 28 - No space left on device)**

...

**二、问题解决**

1、原因：Errcode: 28 - No space left on device ：**磁盘空间不足。 安装MySQL的服务器，磁盘空间不足。**

2、解决：**扩大磁盘空间；删掉垃圾文件等。**

3、Linux步骤参考：

*  df -lh ： 查看磁盘空间分布情况
 *  cd xx ： 进入占满空间的目录
 *  du -sh \* ：查看各个目录文件大小
 *  找到占用空间的垃圾文件
 *  rm xx ： 删掉垃圾文件。 （**删之前请再三确认，无法恢复的！！ 数据无价！**）