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
34802
August 25, 2005 11:26AM
11967
September 29, 2005 05:10AM
10327
October 03, 2005 07:06AM
8220
October 03, 2005 10:18AM
7740
October 04, 2005 12:41AM
7650
May 17, 2006 02:23AM
7271
May 13, 2006 10:03PM
4860
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.