MySql Thread error on startup

[Biggen]

I am running Mandrake 10.0. I wanted to install the latest version of Mysql so I grab both the client and server RPM's from mysql.com and installed them like the docs say "rpm -i server.rpm" and "rpm -i client".

Here is the problem. As soon as it installed the server the RPM tried to run mysql_install_db to initialize the grant tables and it errored out with

"Warning: Asked for 196608 thread stack, but got 126976 040922 22:54:29 /usr/sbin/mysqld: Shutdown Complete

I have no idea what this means other than I can't start the server up. I get this everytime I try and run mysqld or mysqld_safe --user=mysql & or mysql_install_db Doing some internet searches it seems that it might have something to do with the kernal restricting the amount of threads the daemon is requesting. But I have no idea how to alter or fix that.

This is really a bummer as I wanted to get Atomic photo album up and running on my website...

Any thoughts??

[CroMagnon]

I think the thread message is just a warning, and shouldn't cause a shutdown - was there anything else above that that mentioned an error?

[Biggen]

Hey!

Actually, no, this is the only error on screen that is reported. It simply shuts the server down after this is reported.

I am extremely new to Mysql so I don't know if there are any logs available to look at. I am sure there are, I just don't know how to turn them on or access them...

[Biggen]

Well I found the error log file that was created! Not sure if this helps but here it is.

040922 22:03:29 mysqld started 040922 22:03:29 Warning: Asked for 196608 thread stack, but got 126976 ^G/usr/sbin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13) ^G/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibtuYQJn' (Errcode: 13) 040922 22:03:29 InnoDB: Error: unable to create temporary file; errno: 13 040922 22:03:29 Can't init databases 040922 22:03:29 Aborting 040922 22:03:29 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 040922 22:03:29 /usr/sbin/mysqld: Shutdown Complete 040922 22:03:29 mysqld ended 040922 22:17:00 mysqld started 040922 22:17:00 Warning: Asked for 196608 thread stack, but got 126976 ^G/usr/sbin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13) ^G/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibOfKyCt' (Errcode: 13) 040922 22:17:00 InnoDB: Error: unable to create temporary file; errno: 13 040922 22:17:00 Can't init databases 040922 22:17:00 Aborting 040922 22:17:00 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 040922 22:17:00 /usr/sbin/mysqld: Shutdown Complete 040922 22:17:00 mysqld ended 040922 22:26:57 mysqld started 040922 22:26:57 Warning: Asked for 196608 thread stack, but got 126976 ^G/usr/sbin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13) ^G/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ib7WSnHV' (Errcode: 13) 040922 22:26:57 InnoDB: Error: unable to create temporary file; errno: 13 040922 22:26:57 Can't init databases 040922 22:26:57 Aborting 040922 22:26:57 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 040922 22:26:57 /usr/sbin/mysqld: Shutdown Complete 040922 22:26:57 mysqld ended

[CroMagnon]

Why is mysql trying to use the /root directory? Did you provide /root as an option when it was being configured? This is almost certainly where your problem is - mysql shouldn't be running with root permissions, and so it won't have permission to use the /root folder. You should set up (well, the installation should have set up, but never mind that now) a directory under /var for mysql to use for it's data, and make sure the mysql daemon user has full access to it.

[Biggen]

Hmm.. Well, all I did was run the "rpm -i xxx.client" and "rpm -i xxx.server" files. I did not add anything to the command lines when they were run. I did run them as root, however if that makes a differences.

Like I said, I followed the instructions exactly as outlined on www.mysql.com.

So what do I do. Do I need to uninstall the rpms and start over??

[CroMagnon]

I wouldn't go that far. Have a look in the configuration files for anything that mentions /root.

[phaze2]

Biggen,

export TMPDIR=/tmp
Then try and launch mysql again. You may want to make sure that TMPDIR is set to /tmp for the user that launches mysql in future. Or manually set it in the mysql startup script.

I've reported this as a bug. They're probably going to claim it's a feature, but I thought I'd give it a shot anyway cos it wasted an hour of my time.
http://bugs.mysql.com/bug.php?id=5822

Mark.

[Biggen]

Excellent! Works like a charm, Phaze.

Make sure you fix the link (in the MySql bug area) you posted that points back to this thread. It seems that the end of the link got cutoff and the numbers "4077" aren't included...

[phaze2]

Hmmm, link works for me, but I'm using firefox. Wonder if it's an IE thing. Too lazy to check the HTML source of the board.

Remember that you're using a Gamma release of mysql and not a production release. If there are features you specifically need that the production release doesn't have, then stick with it. I am. Otherwise be aware that you may run into more issues like the above - and when you do be sure to search bugs.mysql.com for help.

Also, that log message of:
Warning: Asked for 196608 thread stack, but got 126976
Has been reported in the bugs database. It's nothing to worry about, but check the bugs if you want to know more.