Bug #76104 Mysql refuses to start

Submitted: 2 Mar 2015 17:11 Modified: 9 Mar 2015 22:31
Reporter: Fabrizio Bartolomucci Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version: OS:Other (Centos)
Assigned to: CPU Architecture:Any
Tags: Mysql server refuses to start and even the mysql command gives erros

[2 Mar 2015 17:11] Fabrizio Bartolomucci
Description:
I am unable to restart my mysql server on Centos. Nothing appears in the logs but even the mysql command gives an error:
mysql
mysql: relocation error: mysql: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
I even tried to reinstall mysql to no avail.

How to repeat:
No idea, if I knew what was the problem I would be halfway in finding a solution.
[2 Mar 2015 17:14] Fabrizio Bartolomucci
I also tried to renistall mysql by removing and replacing the DBs but the problem remained unresolved.
[2 Mar 2015 23:19] MySQL Verification Team
Thank you for the bug report. MySQL server version? CentOS version? Are you able to attach the err log file /var/log/mysqld.log?. Thanks.
[3 Mar 2015 10:31] Fabrizio Bartolomucci
Server is Centos 6. The mysql version is the one found by yum install: namely:
mysql               i686        5.1.73-3.el6_5          @base        2.3 M
mysql-server        i686        5.1.73-3.el6_5          @base         24 M
At present I moved the support to another mysql server and trying to reinstall it. Yet after the reinstall it fails on restart with:

sudo /etc/init.d/mysqld start
Initializing MySQL database:  Installing MySQL system tables...
150303 11:03:33 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
150303 11:03:33 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
150303 11:03:33 [ERROR] Aborting

150303 11:03:33 [Note]

Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/libexec/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

                                                           [FAILED]
[3 Mar 2015 21:19] MySQL Verification Team
Please check if your my.cnf has the correct paths of basedir and datadir. Thanks.
[3 Mar 2015 21:26] Fabrizio Bartolomucci
I checked all kinds of cnf files including those in the distribution. At any rate what should be the correct paths for those basedir and datadir things?
[9 Mar 2015 22:27] MySQL Verification Team
Thank you for the feedback. This issue looks like a wrong process of install/upgrade and not MySQL bug.
[9 Mar 2015 22:31] MySQL Verification Team
miguel@miguelbr ~]$ cat /etc/redhat-release
CentOS release 6.6 (Final)
[miguel@miguelbr ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.