Posts Tagged ‘INNODB ERROR’

InnoDB: Unable to lock ./ib_logfile0, error: 11

February 23rd, 2011

I got the error after an hardware failure on MySQL server   while I tried to restart  MySQL server innodb was not showing as a plugin , on checking the error log I got “InnoDB: Unable to lock ./ib_logfile0, error: 11 “  as I use NFS to store the mysql directory  , from my previous expierence which is explained in http://onaxer.com/blog/blog/2010/06/01/innodb-unable-to-lock-ibdata1-error-37 ,

I tried doing these things

first -  /etc/init.d/portmap restart

Second – /etc/init.d/nfslock restart

restarted the mysql and it worked like a charm.

View Comments »

Posted in Mysql

Tags:

InnoDB: Fatal error: cannot allocate the memory for the buffer pool

July 29th, 2010 
I got this error while I was trying to setup a MySQLServer as    Copy
of another server I did not check the memory available in the system
and I got the error
“InnoDB: Fatal error: cannot allocate the memory for the buffer pool”
I realized that the memory of the system is less then the  allocated
innodb_buffer_pool_size of 1 GB , I set it less then the   available
memory <1GB , restarted the MySQL and it was done , error gone .
Thanks
Pankaj

View Comments »

Posted in Mysql

Tags: