MySQL Bugs: #16073: mysqld does not start during the RPM installation process, nor later

Bug #16073	mysqld does not start during the RPM installation process, nor later
Submitted:	29 Dec 2005 16:07	Modified:	10 Feb 2006 16:45
Reporter:	Michael Steinbeck-Reeves	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	MySQL-server-5.0.17-1.glibc23.x86_64.rpm	OS:	Linux (Linux FC4)
Assigned to:		CPU Architecture:	Any

Description:
When I install MySQL-server-5.0.17-1.glibc23.x86_64.rpm the server does not start and will not start subsequently.  This is a fresh FC4 installation, fully updated using yum.

Kernel:  2.6.14-1.1653_FC4smp

System is a dual Opteron 280 with 2Gb RAM, running on a Tyan K8WE motherboard, with a 2T RAID on a 3Ware 9500S controller.

Thanks,

Michael.

How to repeat:
# rpm -ivh MySQL-server-5.0.17-1.glibc23.x86_64.rpm
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
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 yyy.zzz.com 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]

Thank you for a problem report. Do you use SELinux? Is it a fresh RPM installation or you upgraded from the previous version?

I do not use SELinux. This is a fresh installation. Thanks, Michael.

Not sure if it helps but the zzz.com.err file simply contains:

051228 11:47:05  mysqld started
051228 11:47:09  mysqld ended

I have tried to repeat on the closest platform I have, FC1, 32bit, with the appropriate, similar RPM:

[root@Fedora tmp]# rpm -ivh MySQL-server-5.0.17-1.glibc23.i386.rpm
...
   1:MySQL-server           ########################################### [100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
...

Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL. SUCCESS!
[root@Fedora tmp]# ps -ef | grep mysqld
root      1432     1  0 19:48 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --d
atadir=/var/lib/mysql --pid-file=/var/lib/mysql/Fedora.pid
mysql     1453  1432  2 19:48 pts/0    00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/Fedora.pid --skip-locking
root      1468  1364  0 19:48 pts/0    00:00:00 grep mysqld
[root@Fedora tmp]# uname -a
Linux Fedora 2.4.22-1.2115.nptl #1 Wed Oct 29 15:42:51 EST 2003 i686 i686 i386 GNU/Linux

So, it works. Your problem, thus, should be related to your hardware and software configuration, or our x86_64.rpm... Please, try to remove the RPM, restart the system and install once more. Inform about the results.

I have reinstalled (several times) and the results are consistent.

However, I can start mysqld up (having manually run mysql_install_db) with:
 /usr/bin/mysqld_safe &
I can access the server both locally and from a Windows machine.  There are no tables in the test database.

However, it will still not startup as a runlevel service.  I really am at a loss on this one.
I did notice that when I tried to link MySQL-Administrator (compiling from source), it said that I had a missing library (mysqlclient_r) was this supposed to be installed with the server?

Full output from the ln process:
Entering directory `/home/miker/install/mysql-administrator-1.1.5/mysql-administrator/source/linux'
g++ -g -O2 -o mysql-administrator-bin MGUserBrowserList.o MInstanceInfo.o MDataInterface.o MDynamicInterface.o MAdministrator.o MTranslation.o MAPanel.o MAPreferences.o MAPreferencesEditor.o util.o main.o MAServerInformationPanel.o MAServiceControlPanel.o MAUserAdministrationPanel.o MAStartupParametersPanel.o MAServerConnectionsPanel.o MAHealthPanel.o MAServerLogsPanel.o MABackupPanel.o MARestorePanel.o MAReplicationStatusPanel.o MACatalogsPanel.o MADummyPanel.o ../../library/source/libadmin.a ../../../mysql-gui-common/source/linux/libmacommongui.a ../../../mysql-gui-common/library/source/libmysqlx.a ../../../mysql-gui-common/library_util/source/libguiutil.a -L/usr/lib -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lpcre -lglade-2.0 -lxml2 -lpthread -lz -lgtkmm-2.4 -lgdkmm-2.4 -latkmm-1.6 -lgtk-x11-2.0 -lpangomm-1.4 -lglibmm-2.4 -lsigc-2.0 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lm -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0
/usr/bin/ld: cannot find -lmysqlclient_r

My reading of your documentation indicates that it should be in the c API.  If so, I presume that it did not complete all of its tasks.

Thanks, Michael

Please, try to repeat with 5.0.18 RPMs now available at http://dev.mysql.com/downloads/mysql/5.0.html, and inform about the results.

As for problems with MySQL-Administrator, please, open a separate bug report with the appropriate category. Client libraries are in a separate RPM, http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-5.0.18-0.glibc23.i386.rpm, for example.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".