can you trying setting sort_buffer_size to big value at your session level and create the table
On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail < machiel.richa...@gmail.com> wrote: > Hi > > We tried that as well, however the databases are quite busy and either > other transactions overwrite the info, or there is nothing logged. > > We even tried running the create statement and immediately running > Show innodb status, but nothing for that statement. > > Regards > > > > > > On 09/10/2012 11:05 AM, Ananda Kumar wrote: > > try this command and see if you can get more info about the error > > show innodb status\G > > On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail < > machiel.richa...@gmail.com> wrote: > >> Hi All >> >> 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 >> >> > >