Forum Discussion
Errcode: 28 - No space left on device
I have a big quiery and I cannot get data or refresh data since:
MySQL: Error writing file '/rdsdbdata/tmp/MYZJySXi' (Errcode: 28 - No space left on device)
What should I do?
Thanks
Hi Anonymous ,
The error means that you dont have enough space to create temp files needed by MySQL.
You can use
df -hto check whether\tmpis in its own partition, and how much space is allocated to it.If it is in its own partition and short of space, you can either:
- modify /tmp so that its parition has more space (either by reallocating or moving it to the main partition - e.g. see here)
- changing MySql config so that it uses a different temp folder on a different partition, e.g.
/var/tmp
You can refer this simliar issue: MySQL/Writing file error (Errcode 28)
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Fowmy
Super User
Anonymous
I think this is a duplicated question, please keep one. I answered in the first question thread:
https://community.powerbi.com/t5/Power-Query/Errcode-28-No-space-left-on-device/m-p/1317038#M41674________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Yes I saw this.
But I did not understand here what should I do to make this:
"Step 1 - Login to your server using SSH, you can use Putty "
I downloaded Putty... I don't see here what should I do
and then where should I enter the commands?
HI Anonymous
What is your RAM size. your systems disc space is maxing out. Either you have to clean your temp folder or increase your memory size.
I don't like losing data but the last resort for me will be to import required columns and filter the rows based on the requirement(Dates, project, type etc...)
v-yingjlCommunity Support
Hi Anonymous ,
The error means that you dont have enough space to create temp files needed by MySQL.
You can use
df -hto check whether\tmpis in its own partition, and how much space is allocated to it.If it is in its own partition and short of space, you can either:
- modify /tmp so that its parition has more space (either by reallocating or moving it to the main partition - e.g. see here)
- changing MySql config so that it uses a different temp folder on a different partition, e.g.
/var/tmp
You can refer this simliar issue: MySQL/Writing file error (Errcode 28)
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
