List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:December 3 2004 8:01pm
Subject:Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
View as plain text  
Alejandro,

----- Original Message ----- 
From: ""Alejandro D. Burne"" <alejandro.dburne@stripped>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 7:20 PM
Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)


> After installing MySQL 5.0.2  on MDK10.0 mysqld doesn't start with error:
>
> "Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)"

InnoDB, and mysqld in general, must be able to create temporary files.

http://dev.mysql.com/doc/mysql/en/Temporary_files.html
"
MySQL uses the value of the TMPDIR environment variable as the pathname of 
the directory in which to store temporary files. If you don't have TMPDIR 
set, MySQL uses the system default, which is normally `/tmp', `/var/tmp', or 
`/usr/tmp'. If the filesystem containing your temporary file directory is 
too small, you can use the --tmpdir option to mysqld to specify a directory 
in a filesystem where you have enough space.
"

> I think it's a problem with innodb, if I add skip-innodb on my.cnf
> mysqld starts up:
>
> 041203 14:04:01  mysqld started
> 041203 14:04:01 [Warning] Asked for 196608 thread stack, but got 126976
> /usr/sbin/mysqld: ready for connections.
> Version: '5.0.2-alpha-standard-log'  socket: '/var/lib/mysql/mysql.sock' 
> port:
>
> But when I enable innodb (#skip-innodb on my.cnf);
> 041203 14:04:56  mysqld started
> 041203 14:04:56 [Warning] Asked for 196608 thread stack, but got 126976
> ./usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibu6vdue' 
> (Errcode: 13)
> 041203 14:04:56  InnoDB: Error: unable to create temporary file; errno: 13
> 041203 14:04:56 [ERROR] Can't init databases
> 041203 14:04:56 [ERROR] Aborting
>
> 041203 14:04:56 [Note] /usr/sbin/mysqld: Shutdown complete
>
> 041203 14:04:56  mysqld ended
>
> The only way to do work innodb is chmod 777 /root and /root/tmp, =(
>
> Alejandro

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/

Thread
Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)Alejandro D. Burne3 Dec
Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)Heikki Tuuri3 Dec
  • Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)Alejandro D. Burne6 Dec
Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)Heikki Tuuri6 Dec