Showing posts with label mysql PID error. Show all posts
Showing posts with label mysql PID error. Show all posts

Tuesday, February 18, 2014

MySQL error mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

I recently upgraded MySQL 5.1 to 5.5.36 on CENTOS 6.5 64 bit

upgrade went well but MySQL won't start...

only one line logged under /var/log/mysqlerror.log

mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

hummm.... so PID error

tried many things... Google search for PID issues...but...

boy.... no matter what I tried...... I was not able to make mysql service start... then...


I ran command  mysql_safe ....

Voila... it gave me another log entry...

InnoDB: Error: log file ./ib_logfile0 is of different size 0 20356374 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!




the error was because the size of innoDB logfile mention didnt match the size of logfile on the server...


so the solution was...

moving the current ib_logfiles to another location

cd ..

mkdir innodblog

mv /var/lib/mysql/ib_logfile* /var/lib/innodblog

service mysqld start

and finally it started...


Thanks

Recent Posts

Upgrade Azure ADsync 1.6 to 2.3

 After a very long break, posting in new blog on upgrading ADsync to latest version. I was having version 1.6.4 running and doing its job we...