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 : 删掉垃圾文件。
————————————————
版权声明:本文为CSDN博主「HaHa_Sir」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/HaHa_Sir/article/details/103416731