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 ,
Maybe this can help you.
1) check inode:
df -iI saw:root@vm22433😕etc/mysql# df -i Filesystem Inodes IUsed IFree IUse% Mounted on udev 124696 304 124392 1% /dev tmpfs 127514 452 127062 1% /run /dev/vda1 1969920 1969920 0 100% / tmpfs 127514 1 127513 1% /dev/shm tmpfs 127514 3 127511 1% /run/lock tmpfs 127514 15 127499 1% /sys/fs/cgroup tmpfs 127514 12 127502 1% /run/user/10022) I began to look what folders use the maximum number of inods:
for i in /*; do echo $i; find $i |wc -l; donesoon I found in /home/tomnolane/tmp folder, which contained a huge number of files.
3) I removed /home/tomnolane/tmp folder PROFIT.
4) checked:
Filesystem Inodes IUsed IFree IUse% Mounted on udev 124696 304 124392 1% /dev tmpfs 127514 454 127060 1% /run /dev/vda1 1969920 450857 1519063 23% / tmpfs 127514 1 127513 1% /dev/shm tmpfs 127514 3 127511 1% /run/lock tmpfs 127514 15 127499 1% /sys/fs/cgroup tmpfs 127514 12 127502 1% /run/user/1002it's ok.
5)
restart mysql servicehttps://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28
2 Replies
- Fowmy
Super User
Anonymous
Check disk space and space allocation.
Check this thread as well: https://community.powerbi.com/t5/Desktop/Errors-28/td-p/103136#:~:text=Re%3A%20Errors%3A%2028&text=Based%20on%20my%20search%2C%20you,needed%20by%20big%20MySQL%20requests.________________________
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 🙂
v-xuding-msftCommunity Support
Hi Anonymous ,
Maybe this can help you.
1) check inode:
df -iI saw:root@vm22433😕etc/mysql# df -i Filesystem Inodes IUsed IFree IUse% Mounted on udev 124696 304 124392 1% /dev tmpfs 127514 452 127062 1% /run /dev/vda1 1969920 1969920 0 100% / tmpfs 127514 1 127513 1% /dev/shm tmpfs 127514 3 127511 1% /run/lock tmpfs 127514 15 127499 1% /sys/fs/cgroup tmpfs 127514 12 127502 1% /run/user/10022) I began to look what folders use the maximum number of inods:
for i in /*; do echo $i; find $i |wc -l; donesoon I found in /home/tomnolane/tmp folder, which contained a huge number of files.
3) I removed /home/tomnolane/tmp folder PROFIT.
4) checked:
Filesystem Inodes IUsed IFree IUse% Mounted on udev 124696 304 124392 1% /dev tmpfs 127514 454 127060 1% /run /dev/vda1 1969920 450857 1519063 23% / tmpfs 127514 1 127513 1% /dev/shm tmpfs 127514 3 127511 1% /run/lock tmpfs 127514 15 127499 1% /sys/fs/cgroup tmpfs 127514 12 127502 1% /run/user/1002it's ok.
5)
restart mysql servicehttps://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28
