I am hoping someone can point me in the right direction.
We have a mysql 5.0 database which is giving us hassles when trying to create a temporary table.
The creation works perfectly on the slave machine as well as all our other db's, however on the one specific main server we are getting the message "ERROR 1005 (HY000): Can't create table '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
We have been trying to figure this out for more than a week now with no luck.
When looking in the mysql error.log file, the innodb states that there is either another mysqld running (confirmed and not the case) or it is a filesystem permissions problem.
We have checked several times and the permissions on the /tmp filesystem is the same as on all servers.
Any suggestions would be greatly appreciated as google didnt help much either.
Regards
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Manuel Arostegui Re: Temporary table creation fails
Sep 10, 2012; 15:42
Manuel Arostegui
Re: Temporary table creation fails
Sep 10
Garot Conklin Re: Temporary table creation fails
Sep 10, 2012; 06:55
Garot Conklin
Re: Temporary table creation fails
Sep 10
Shawn Green Re: Temporary table creation fails
Sep 10, 2012; 10:10
Shawn Green
Re: Temporary table creation fails
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!