MySQL Bugs: #5341: Small trouble (not a bug) on fedora core 2

Bug #5341	Small trouble (not a bug) on fedora core 2
Submitted:	1 Sep 2004 11:34	Modified:	2 Oct 2004 1:26
Reporter:	Vladislav Safronov (Basic Quality Contributor)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	4.1.4	OS:	Linux (Fedora Core 2)
Assigned to:	Matthew Lord	CPU Architecture:	Any

Description:
After upgrading from mysql-3.23 (which ships with Fedora Core 2) to latest 4.1.4 (RPM binaries) the server did not start out of box due to:

040901  9:58:46  [ERROR] Warning: Asked for 196608 thread stack, but got
 126976
 Fatal error: Can't change to run as user 'mysql' ;  Please check that the user
 exists!
040901  9:58:46  [ERROR] Aborting

the problem was in original Fedora packages that silently removed 'mysql' user after upgrade with rpm -Uvh ..

//

Also I can't say that init.d script is really friendly, even compares to standard scripts from Fedora or Debian:
> 
> $ sudo service mysql start
> $ sudo service mysql stop
> No mysqld pid file found. Looked for /var/lib/mysql/boxc.mysql.com.pid.
> $ sudo service mysql status
> Usage: /etc/init.d/mysql start|stop|restart
> $ sudo service mysql restart
> No mysqld pid file found. Looked for /var/lib/mysql/boxc.mysql.com.pid.
> $

Also naming packages as MySQL (not simply mysql) could cause some misunderstanding..

thanx,
/vlad

How to repeat:
just say 

#rpm -Uvh --nodeps MySQL-server-4.1.4-0.i386.rpm
#rpm -Uvh MySQL-shared-compat-4.1.4-0.i386.rpm
#rpm -Uvh MySQL-client-4.1.4-0.i386.rpm MySQL-devel-4.1.4-0.i386.rpm

Suggested fix:
Just upgrade it again..

#rpm -Uvh --force MySQL-server-4.1.4-0.i386.rpm

Hi,

Thank you for the bug report!

The thread stack warning you get is normal, this limitation comes from glibc and you see the 
warning because --show-warnings is now a default option.  It is noted incorrectly in the logs as an 
error in 4.1.4, this has been fixed in 4.1.5-gamma.

With regards to the removal of the mysql user, this must have been done by the Fedora RPM 
package.  When you do an upgrade the previous version is removed after the new one is 
installed.  We have no control over the Fedora packages, if you could file a bug report with them 
regarding the user removal that would be very helpful, otherwise I will try and do so.

I'm not sure what you mean when you ask for the packages to be named mysql* instead of 
MySQL*.  We are open to suggestions and would like to be aware of problems or confusion that
could be caused by the package names.

Best Regards