MySQL won't start.

nathacof · 10-30-2008, 01:05 AM

Hey Guys,

I'm having a problem with MySQL startup on my CentOS server. Basically I'm using DRBD to replicate the /var/lib/mysql directory between two nodes.

The problem is, when trying to run the systems startup script for MySQL, I'm getting a time out error:

Code:

[root@mysql-primary ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@mysql-primary ~]#

Code:

[root@mysql-primary ~]# tail /var/log/mysqld.log

081030 02:02:30  mysqld ended

081030 03:00:39  mysqld started
081030  3:00:40  InnoDB: Started; log sequence number 0 43655
081030  3:00:40 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081030  3:00:40 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
081030  3:00:40 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
081030 03:00:40  mysqld ended

[root@mysql-primary ~]#

Permissions look good on the MySQL directory:

Code:

[root@mysql-primary ~]# ls -la /var/lib/mysql/
total 20564
drwxr-xr-x  4 mysql mysql     4096 Oct 30 03:00 .
drwxr-xr-x 24 root  root      4096 Oct 30 03:00 ..
-rw-rw----  1 mysql mysql 10485760 Oct 30 01:44 ibdata1
-rw-rw----  1 mysql mysql  5242880 Oct 30 03:00 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Oct 23 04:20 ib_logfile1
drwxrwx---  2 mysql mysql     4096 Oct 23 04:15 mysql
drwxrwx---  2 mysql mysql     4096 Oct 23 15:16 test
[root@mysql-primary ~]#

However if I run mysqld_safe from the command line the service starts up fine.

o_0 anyone know what's up here?

billymayday · 10-30-2008, 01:25 AM

Does host.frm exist?

How did you install mysql-server?

nathacof · 10-30-2008, 08:20 AM

Indeed it does. I created all the mysql system tables by running `mysql_install_db` after mounting the DRBD partition to /var/lib/mysql. MySQL was installed from the standard CentOS repoes (yum install mysqld).

The init script basically just calls mysqld_safe with the options ascertained from the my.cnf file, this does not work. However if I run:

$ mysqld_safe&

Then MySQL starts without issue...

chickenjoy · 10-30-2008, 09:09 AM

Quote:

Then MySQL starts without issue...

There must be something wrong in the my.cnf file that prevents it from running. Thats why if you can mysqld_safe& without the integrating the my.cnf (with a problematic entry) it runs smoothly. Try to remove some lines one at a time in my.cnf and try to start the mysql service.

I'm not an expert in this, it may or may not be the reason.

nathacof · 10-30-2008, 09:58 AM

Aye, that's what I would assume as well, but it's fairly limited my.cnf file:

Code:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I don't see any problems there...

billymayday · 10-30-2008, 10:07 AM

How did you mount thew DRBD partition?

nathacof · 10-30-2008, 10:46 AM

Well, heartbeat was configured to start the resource:

Code:

mysql-primary drbddisk Filesystem::/dev/drdb0::/var/lib/mysql::ext3 mysqld

But since the mysql startup script was failing, it was causing huge amounts of load on my server. So I disabled heartbeat to see if I could get things started manually.

Basically to get things working I can run:

Code:

$ drdbadmin primary r0
$ mount /dev/drbd0 /var/lib/mysql
$ mysqld_safe&

At which point I can login to MySQL and perform queries as expected.

Any assistance you can provide is greatly appreciated!

nathacof · 10-30-2008, 11:09 PM

Would it help if I posted the mysqld init script?

http://pastebin.com/m3145dbaa

sachin_shetty · 11-03-2008, 05:20 AM

Hi All;

I have Downloaded and Instlled Mysql 5.1-server on my Centos -el5 Machine.Installation was went pair
there was no error.
But while starting mysql I am getting this kind of error
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

and this is the mysql logs
tail /var/log/mysqld.log

081030 02:02:30 mysqld ended

081030 03:00:39 mysqld started
081030 3:00:40 InnoDB: Started; log sequence number 0 43655
081030 3:00:40 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/NTT.err' (errno: 13)
081030 3:00:40 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/mysql.sock' (errno: 13)
081030 3:00:40 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
081030 03:00:40 mysqld ended

and while i am logging into the mysql (mysql -root -p )

its prompting for the password and after its giving an error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Please can anybody help me out.

sachin_shetty

robertjinx · 11-03-2008, 05:45 AM

I have the impression that mysql doesnt know from where to take the files I mean like /var/lib/mysql. If its clasic mysql instalation from rpm, you should try to see configuration file /etc/sysconfig/mysql or mysqld and see there if is some options, or try the init script and set the "datadir" from whatever it is to "/var/lib/mysql".

Also check the rights of the folder /var/lib/mysql, it should be owned by mysql so... that might also be an issue.

robertjinx · 11-03-2008, 05:51 AM

Sorry I was wrong about the owner ship of the mysql folder, seems to be mysql. Anyway seems that error 13 means permission denied. Check more on google.com, also check that mount point...

nathacof · 11-03-2008, 06:13 PM

Yeah... still got nothing on this. The ownership of the /var/lib/mysql directory is correct. I've got everything working here except for the darned script that's supposed to make sure that the service is working. It would sure be nice to get this sorted out.

/etc/sysconfig/mysql(d) does not exist on my servers.

If there's anyone out there who has experienced similar problems please let me know how you corrected the issue!

Code:

[root@mysql-primary ~]# mysqld_safe&
[1] 4810
[root@mysql-primary ~]# Starting mysqld daemon with databases from /var/lib/mysql

[root@mysql-primary ~]# /etc/init.d/mysqld restart
STOPPING server from pid file /var/run/mysqld/mysqld.pid
081103 20:15:26  mysqld ended

Stopping MySQL:                                            [  OK  ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[1]+  Done                    mysqld_safe
[root@mysql-primary ~]#

/bangHead

Am I missing something in regards to DRBD?

makundib · 08-23-2011, 04:52 AM

This might be of help for you as well

http://www.linuxquestions.org/questi...b-mysq-689872/

jsaravana87 · 08-23-2011, 05:03 AM

HI,

start mysql by using

/etc/init.d/mysqld restart

it will start