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
Subscribe to:
Post Comments (Atom)
Thanks for sharing useful information for us.I really enjoyed reading your blog, you have lots of great content.
ReplyDeletePackers 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
We Provide Best Packers And Movers Ahmedabad List for Get Free Best Quotes, Compare Charges, Save Money And Time,Household Shifting Services @
ReplyDeleteclick here for ore details
http://packersmoversahmedabad.co.in/
http://packersmoversahmedabad.co.in/packers-and-movers-surat-gujarat
This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
ReplyDeletehttp://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
Thanks for all your info, Web page is excellent and useful. movers and packers kondapur hyderabad movers and packers madhapur hyderabad
ReplyDeleteThanks for sharing your experience with us and it is very helpful for the programmers best packers and movers
ReplyDeletepackers and movers in madhapur
find out info
best devops training in hyderabad
Fantastic post! Thanks for sharing this. packers and movers jubilee hills hyderabad
ReplyDeleteشركة تنظيف خزانات بجدة الجوهرة من افضل شركات تنظيف الخزانات بجدة حيث ان تنظيف خزانات بجدة يحتاج الى مهارة فى كيفية غسيل وتنظيف الخزانات الكبيرة والصغيرة بجدة على ايدى متخصصين فى تنظيف الخزانات بجدة
ReplyDeleteشركة تنظيف خزانات بجدة
شركة كشف تسربات المياه بالدمام
شركة نقل عفش واثاث
now present in your city cara menggugurkan kandungan
ReplyDelete1. manfaat kurma untuk persalinan
2. manfaat buah nanas
3. aktivitas penyebab keguguran
4. apakah usg berbahaya
5. penyebab telat haid
6. cara melancarkan haid
7. cara mengatasi keputihan
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
ReplyDeleteThis is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche
ReplyDeleteHey 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
This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche
ReplyDeleteHey 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
I really appreciate the way you write...Please check my work as well
ReplyDeleteJaipur Call Girl
Jaipur Call Girl
Jaipur Call Girl
Delhi Call Girl
Guwahati Call Girl
Guwahati Call Girl
Guwahati Call Girl
Guwahati Call Girl
Aerocity Call Girl
Lucknow Call Girl