Re: MySQL 4.1.4 RPM Distribution startup problem
Egor Egorov [EMAIL PROTECTED] wrote: 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. [] Does MySQL need rights to /root/tmp to work well? No. It's a weird behavior. I will investigate and get back to you. Igor, First, does the mysql user exists? Second, here is what Marko Makela told me about your situation: It's probably from innobase_mysql_tmpfile(), which is called two or three times at startup. That function relies on create_temp_file(). Has the MySQL configuration parameter tmpdir or the environment variable TMPDIR been set incorrectly, or is the default value somehow incorrect? Could it be that the directory /var/mysqltmp does not exist, and the fall-back value is incorrect? Maybe $HOME is pointing to /root, but mysqld is being run as a non-privileged user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.4 RPM Distribution startup problem
Igor Zinkovsky [EMAIL PROTECTED] wrote: 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. [] Does MySQL need rights to /root/tmp to work well? No. It's a weird behavior. I will investigate and get back to you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.4 RPM Distribution startup problem
Igor Zinkovsky [EMAIL PROTECTED] wrote: 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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.4 RPM Distribution startup problem
- 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.0 +0400 Modify: 2004-08-17 12:17:13.0 +0400 Change: 2004-09-06 17:55:21.0 +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]
Re: MySQL 4.1.4 RPM Distribution startup problem
- Original Message - From: gerald_clark [EMAIL PROTECTED] To: Igor Zinkovsky [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 03, 2004 10:50 PM Subject: Re: MySQL 4.1.4 RPM Distribution startup problem Igor Zinkovsky wrote: After upgrade from 4.1.2 to 4.1.4 I can't start mysqld 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 log-bin server-id=1 default-character-set=cp1251 datadir=/var/lib/mysql user=mysql character-sets-dir=/usr/share/mysql/charsets max_allowed_packet=32M With best regards, Igor Zinkovsky aka TLoD,Snake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.4 RPM Distribution startup problem
Igor Zinkovsky wrote: After upgrade from 4.1.2 to 4.1.4 I can't start mysqld 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? 040902 21:47:53 InnoDB: Error: unable to create temporary file; errno: 13 040902 21:47:53 [ERROR] Can't init databases 040902 21:47:53 [ERROR] Aborting 040902 21:47:53 [ERROR] /usr/sbin/mysqld: Shutdown complete 040902 21:47:53 mysqld ended my /etc/my.cnf: [mysqld] log-bin server-id=1 default-character-set=cp1251 tmpdir=/var/mysqltmp datadir=/var/lib/mysql user=mysql character-sets-dir=/usr/share/mysql/charsets max_allowed_packet=32M OS: Linux Mandrake 10.0 I've got this problem on two servers, both Linux Mandrake 10.0. With best regards, Igor Zinkovsky aka TLoD,Snake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]