RE: InnoDB error unable to create temporary file

2005-10-05 Thread Martijn van den Burg
Hi Joerg et all, [snip] You said this is Solaris. AFAIK, Solaris uses the same disk area for /tmp and paging, so the available space for files in /tmp may vary even without files being manipulated. I propose you set TMPDIR to point to some other disk area. We're on Solaris, yes. I

Re: InnoDB error unable to create temporary file

2005-09-29 Thread Joerg Bruehe
Hi Martijn, all! Martijn van den Burg wrote (reordered) On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote: Martijn van den Burg wrote: Hi list, After the most recent reboot (which we used to increase the ulimit/open_files_limit on our Solaris 8 machine running 4.1.10-log), the

Re: InnoDB error unable to create temporary file

2005-09-29 Thread Martijn van den Burg
Hi Jörg, On Thursday 29 September 2005 12:09, you wrote: Hi Martijn, all! Martijn van den Burg wrote (reordered) On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote: Martijn van den Burg wrote: Hi list, After the most recent reboot (which we used to increase the

Re: InnoDB error unable to create temporary file

2005-09-28 Thread Gleb Paharenko
Hello. Maybe some directory doesn't exist in the path where MySQL stores temporary files. See: http://dev.mysql.com/doc/mysql/en/temporary-files.html Martijn van den Burg wrote: Hi list, After the most recent reboot (which we used to increase the ulimit/open_files_limit on

Re: InnoDB error unable to create temporary file

2005-09-28 Thread Martijn van den Burg
Hi, Thanks for your reply. TMPDIR is not set explicitly, and the first 'fallback' directory in that case is '/tmp', which is accessible and has enough diskspace. At least, when I checked this morning. The error occurred in the night, maybe there were other processes that filled the