Forum Discussion
Getting an error message after refreshing data on Power BI Desktop
Dears All,
I was refreshing data on Power BI Desktop App I got this error message :
MySQL: Error writing file '/tmp/MYfd=201' (OS errno 28 - No space left on device)
How can I solve this issue by detailed steps ? (My PC system is Windows ).
Hi rhashhab ,
Please have a try.
This is a memory issue on the server and not the client. When you query on the DB, the database creates temp files in system temp of the MySQL sever. If the system temp gets filled up, you would get this error.
clear the system temp folder on the MySQL server.
- The default location can be changed from /tmp to a different location by setting --tmpdir attribute in the mysqld command or setting tmpdir system variable- refer to the mysql doc here: https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html- you can avoid this error to some extent by restricting the number of records returned, avoiding ORDER clause (this stages all the records and then sorts)Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
rhashhab , Seems like there is not enough space on your hard disk having MySQL. Please free up some space
I have 159 G on my disk
Hi rhashhab ,
Please have a try.
This is a memory issue on the server and not the client. When you query on the DB, the database creates temp files in system temp of the MySQL sever. If the system temp gets filled up, you would get this error.
clear the system temp folder on the MySQL server.
- The default location can be changed from /tmp to a different location by setting --tmpdir attribute in the mysqld command or setting tmpdir system variable- refer to the mysql doc here: https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html- you can avoid this error to some extent by restricting the number of records returned, avoiding ORDER clause (this stages all the records and then sorts)Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
