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

Outlook SSL Security Alert Certificate Name is Invalid

Our Exchange Certificate expired and we had to renew the SSL. after deploying the new SSL, some users started getting SSL security Alert on...