MySQL Bugs: #14663: [Warning] Asked for 196608 thread stack, but got 126976

Bug #14663	[Warning] Asked for 196608 thread stack, but got 126976
Submitted:	4 Nov 2005 23:03	Modified:	11 Nov 2005 0:46
Reporter:	Bertrand Campos	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	MySQL-server-5.0.15-0.	OS:	Linux (SuSe 9.2)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When try to install/start Mysqld the follow message warning are showed:

squid:~/INSTALL # rpm -ivh MySQL-server-5.0.15-0.i386.rpm 
warning: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
051104 19:04:23 [Warning] Asked for 196608 thread stack, but got 126976
051104 19:04:23 [Warning] Asked for 196608 thread stack, but got 126976
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h squid password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL...................................                     failed

squid:~ # mysqld
051104 19:02:59 [Warning] Asked for 196608 thread stack, but got 126976
051104 19:02:59 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

051104 19:02:59 [ERROR] Aborting

051104 19:02:59 [Note] mysqld: Shutdown complete

How to repeat:
You can remove and install it several times and other release such as 4.1.
The error message is the same.

Suggested fix:
I cannot find the file my.cnf in my system... perhaps this is a hint to solve the problem.

Duplicate of bugs:

http://bugs.mysql.com/bug.php?id=6226
http://bugs.mysql.com/bug.php?id=8357

All right, i read these 2 link, but i was not sure, what i have to do.
Its a RAM problem or a GLIB version?

If isnt a bug (because in all RPM edition i have the same problem), how can i resolve this?

Tks and regards

Please see the below error you got, that is the problem not the warning.

051104 19:02:59 [ERROR] Fatal error: Please read "Security" section of the
manual to find out how to run mysqld as root!

I recommend you to read the relevant chapter of the Manual.