Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL/Writing file error (Errcode 28)

Tags:

logging

mysql

I have the following error with one of our web applications -

Query3 failed: Error writing file '/tmp/MY1fnqpm' (Errcode: 28) ... INSERT MailList... (removed the rest of the query for security reasons) 

Any ideas - is this some hard disk space issue on my server?

like image 307
Zabs Avatar asked Sep 14 '11 11:09

Zabs


People also ask

Can t create write to file errcode 28?

As pointed above Error code 28 means that there's insufficient disk space. Please note that it's a server error message, not client. So make sure you're checking on the right server. It could be caused, as others pointed out, by a lack of free space on the device.

Can t create table Errno 28?

This error means that your mysql server does not have enough free space. You need to check the file system size and please remove unwanted software(s) or installers or files. What we suggest is please try to remove the files in /tmp first before you proceed to remove other files of software's.


1 Answers

Use the perror command:

$ perror 28 OS error code  28:  No space left on device 

Unless error codes are different on your system, your file system is full.

like image 192
Arnaud Le Blanc Avatar answered Oct 02 '22 12:10

Arnaud Le Blanc