Today i got this errors while installing MySQL in my Debian :
1 | ERROR 126 (HY000) at line 1: Incorrect key file for table ‘/tmp/#sql_45cf_0.MYI’; try to repair it |
This errors usually refering for out of space in our server. I just replace server with new EBS which have more space. Then after doing “df -hT”, i found something wrong here :
1 2 3 4 5 6 | Filesystem Type Size Used Avail Use% Mounted on /dev/xvda1 ext3 5.0G 1.1G 3.7G 23% / tmpfs tmpfs 306M 12K 306M 1% /lib/init/rw udev tmpfs 285M 28K 285M 1% /dev tmpfs tmpfs 306M 4.0K 306M 1% /dev/shm overflow tmpfs 1.0M 0 1.0M 0% /tmp |
There is overflow on filesystem which supposed to be not happen. So, what the solution? Is easy! just reboot your server and overflow will gone and “/tmp” will come back to your /dev/sda1.