Getting an error message after refreshing data on Power BI Desktop

[rhashhab]

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 ).

[Anonymous · Accepted solution]

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) 

ERROR: "Error writing file '/tmp/MYnEWYnz' (OS errno 28 - No space left on device)" when querying fr...

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.

[amitchandak]

@rhashhab , Seems like there is not enough space on your hard disk having MySQL. Please free up some space

[rhashhab]

I have 159 G on my disk