MySQL Forums
Forum List  »  InnoDB

Can't create temporary table (errno:135)
Posted by: marco matchefts
Date: October 16, 2006 10:19AM

My application got the following error when trying to create a temporary table:

Can't create table '/tmp/#sql5ae_28_1.frm' (errno: 135)

The sql prepared statement to create the table is below:

create temporary table foo select id from bar limit ?, ?;

The database is InnoDB under mysql version 5.0.16. There was plenty of room in the database.

Does this error occur because there was not enough room in the /tmp directory? The /tmp directory should only need enough space to create the table? Would the data for the table go into the /tmp directory as well? I wasn't able to reproduce the problem so I am tring to figure out where I ran out of space. Thanks in advance for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't create temporary table (errno:135)
9927
October 16, 2006 10:19AM


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.