----- Original Message ----- 
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 06, 2004 1:21 PM
Subject: Re: MySQL 4.1.4 RPM Distribution startup problem


> >> >error log:
> >> >
> >> >040902 21:47:53 mysqld started
> >> >040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but
got
> >> >126976
> >> >/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi'
> > (Errcode:
> >> >13)
> >> >
> >> mysql does not have permission to write to /root/tmp
> >> Why do you have the temp directory set here?
> >
> > I've wrote that I have following lines in my.cnf:
> >
> > [mysqld]
> > tmpdir=/var/mysqltmp

> Then temporary give a+rw on /root/tmp (don't forget to +x /root)
> and see what's mysqld_safe gonna write there. Maybe it's a bug in the
> script.
> Also please check the environment for TMPDIR.

After this mysql started successfully but it didn't write anything in
/root/tmp.

#mysqladmin -u root variables | grep tmp
| tmpdir                          | /var/mysqltmp                       |

# stat /var/mysqltmp/
  File: `/var/mysqltmp/'
  Size: 48              Blocks: 1          IO Block: 131072 directory
Device: 306h/774d       Inode: 29292       Links: 2
Access: (0755/drwxr-xr-x)  Uid: (   72/   mysql)   Gid: (   72/   mysql)
Access: 2004-09-06 17:54:33.000000000 +0400
Modify: 2004-08-17 12:17:13.000000000 +0400
Change: 2004-09-06 17:55:21.000000000 +0400

Does MySQL need rights to /root/tmp to work well?



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to