Unable to create temporary file; errno: 2
Posted by:
Leif Neve
Date: August 25, 2005 11:26AM
I get the following error in my error log frequently. It may pop up when I access or set foreign key constraints, I'm not sure.
InnoDB: Error: unable to create temporary file; errno: 2
After I get this error, I can no longer view any of the tables' foreign key constraints until I restart the server.
There are no errors in standard system logs and no other evidence of any problem. My tmpdir variable uses the system
default. I tried setting it alternately to /tmp and /var/tmp. But this made no difference. I'm running MySQL 4.1.11/Solaris 9.
Subject
Views
Written By
Posted
Unable to create temporary file; errno: 2
34845
August 25, 2005 11:26AM
11968
September 29, 2005 05:10AM
10332
October 03, 2005 07:06AM
8221
October 03, 2005 10:18AM
7747
October 04, 2005 12:41AM
7650
May 17, 2006 02:23AM
7274
May 13, 2006 10:03PM
4862
May 23, 2009 12:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.