Portal Home > Knowledgebase > Articles Database > Help with: General error: 1 Can't create/write to file '/tmp/#sql_71... (Errcode: 17)
Posted by Falesh, 01-27-2012, 10:48 AM I have recently been getting regular downtime with my sites getting the following error: The filename "#sql_71be_0.MYD" is the same across all my sites on that host, they are all trying to create/use the same single file. In my latest discussion with the host they said: However the sites went down again after this. Does anyone have anything they can add to try to help me resolve this, maybe suggestions for my host to try? Also would this issue be resolved if I tried to use the Zend Framework in such a way that is stops creating temporary tables? Many thanks!
Posted by relichost, 01-28-2012, 05:59 PM Hi This probably relates to the /tmp space being full, with a Mysql temp disk search... how big are your tables ? If you can increase the /tmp size, if you cant then change the /etc/my.cnf setting to use a different tmp location wih more space. Good luck
Add to Favourites 
Print this Article
