Thursday, September 8, 2016

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

One of our MySQL servers got restarted and after restart MySQL instance was not coming online.

I see below error message in mysqld.log

InnoDB: Unable to lock ./ib_logfile0, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Error in opening ./ib_logfile0
160712 19:16:34 [ERROR] Plugin 'InnoDB' init function returned error.
160712 19:16:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160712 19:16:34 [ERROR] Unknown/unsupported storage engine: InnoDB
160712 19:16:34 [ERROR] Aborting
160712 19:16:34 [Note] /u01/mysql/5.5.22/bin/mysqld: Shutdown complete

I receive below error message when trying to access the database from command line

# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/u01/mysql/5.5.22/mysqld.sock' (2) 

It looks like the sudden server crash didn’t update the logfile or datafile header properly and not able to lock to bring the instance up.

After research I was able to fix this error by following below steps

1. Go to the data directory and backup the ./ib_logfile0 and copy a new one
$ mv ib_logfile0 ib_logfile0.bak
$ cp -a ib_logfile0.bak ib_logfile0

2. Restart the mySQL database

Thanks,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

12 comments:

  1. Thanks for sharing useful information for us.I really enjoyed reading your blog, you have lots of great content.
    Packers And Movers Hyderabad
    In loading and unloading is done carefully by experienced workers. In addition, hyderabad packers and movers unpacks the delivery at the target, very efficiently & with maximum care.

    Packers And Movers gachibowli
    Packers And Movers kondapur
    Packers And Movers Hitech City

    ReplyDelete
  2. We Provide Best Packers And Movers Ahmedabad List for Get Free Best Quotes, Compare Charges, Save Money And Time,Household Shifting Services @
    click here for ore details

    http://packersmoversahmedabad.co.in/
    http://packersmoversahmedabad.co.in/packers-and-movers-surat-gujarat

    ReplyDelete
  3. This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
    http://www.jualobataborsiherbal.com/ obat aborsi
    http://caramenggugurkankandungan.info/ cara menggugurkan kandungan
    http://www.jualobataborsiherbal.com/cara-menggugurkan-kandungan/ cara menggugurkan kandungan
    http://obataborsi59.com/ obat aborsi
    http://obataborsi59.com/cara-menggugurkan-kandungan-dengan-cepat-dan-aman/ cara menggugurkan kandungan
    http://obattelatdatangbulan.info/ obat telat datang bulan
    http://klinikobataborsi.com/ jual obat aborsi
    http://jualobatpenggugurkandungan.net/ obat penggugur kandungan
    http://tandatandakehamilan.net/ tanda tanda kehamilan
    http://tandatandakehamilan.net/cara-cepat-dan-selamat-menggugurkan-kandungan/ cara menggugurkan kandungan

    ReplyDelete
  4. شركة تنظيف خزانات بجدة الجوهرة من افضل شركات تنظيف الخزانات بجدة حيث ان تنظيف خزانات بجدة يحتاج الى مهارة فى كيفية غسيل وتنظيف الخزانات الكبيرة والصغيرة بجدة على ايدى متخصصين فى تنظيف الخزانات بجدة
    شركة تنظيف خزانات بجدة
    شركة كشف تسربات المياه بالدمام
    شركة نقل عفش واثاث

    ReplyDelete
  5. Your property is important to you and keeping it safe should be a major priority. You can use these simple tips to make sure your residence is as protected as possible from burglary. Locksmith Colorado Springs

    ReplyDelete
  6. This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche

    Hey there, You’ve done a fantastic job. I’ll certainly digg it and personally
    recommend to my friends. I’m sure they’ll be benefited from this site.

    1. Klinik Raden Saleh
    2. Biaya Aborsi
    3. Dokter Aborsi

    ReplyDelete
  7. This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche

    Hey there, You’ve done a fantastic job. I’ll certainly digg it and personally
    recommend to my friends. I’m sure they’ll be benefited from this site.

    Klinik raden saleh
    Cara menggugurkan kandungan
    Baiaya aborsi kuret

    ReplyDelete