Page 1 of 2
Reboot and Mysql Problem
Posted: Mon Jan 19, 2015 10:09 am
by muhammed332
When I was reboot vps after mysql problem
VPS Spec.
512MB Ram
20GB SSD Disk
Amsterdam 3
Ubuntu 14.04 x64
Please watch this video
http://www.youtube.com/watch?v=mKJedp3z ... e=youtu.be
var/log/mysql/errorlog file
Code: Select all
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 6:33 am
by joem
muhammed332 wrote:When I was reboot vps after mysql problem
VPS Spec.
512MB Ram
20GB SSD Disk
Amsterdam 3
Ubuntu 14.04 x64
Please watch this video
http://www.youtube.com/watch?v=mKJedp3z ... e=youtu.be
var/log/mysql/errorlog file
Code: Select all
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
Check out the last two solutions they should help you.
http://serverfault.com/questions/477448 ... 1-error-11
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 6:44 am
by muhammed332
joem wrote:muhammed332 wrote:When I was reboot vps after mysql problem
VPS Spec.
512MB Ram
20GB SSD Disk
Amsterdam 3
Ubuntu 14.04 x64
Please watch this video
http://www.youtube.com/watch?v=mKJedp3z ... e=youtu.be
var/log/mysql/errorlog file
Code: Select all
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
Check out the last two solutions they should help you.
http://serverfault.com/questions/477448 ... 1-error-11
Unfortunately ,problem continues
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 3:14 pm
by melkerman
I have the exact same problem. After reboot, MySQL is trying to start when it is already running. I have to manual stop and start mysql from terminal. And then everything works again.
VPS DigitalOcean
2 GB Ram
40GB SSD Disk
Ubuntu 14.04 x64 + Vesta Install, nothing else.
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 3:55 pm
by skurudo
Guys, try this:
1. stop satan-oracle-sql machine
2. file manipulation
Code: Select all
mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
3. start database
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 5:46 pm
by muhammed332
skurudo wrote:Guys, try this:
1. stop satan-oracle-sql machine
2. file manipulation
Code: Select all
mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
3. start database
Problem Continues
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
Re: Reboot and Mysql Problem
Posted: Wed Jan 21, 2015 5:50 pm
by muhammed332
Im try it on ubuntu 12.04 x64.
No any problem on ubuntu 12.04 x64
But 14.04 x64 Mysql Problem
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
Any ideas for this issue?
Re: Reboot and Mysql Problem
Posted: Thu Jan 22, 2015 5:18 pm
by skurudo
Hmm... may be your MySQL server start twice?
Re: Reboot and Mysql Problem
Posted: Thu Jan 22, 2015 5:23 pm
by skurudo
Can you check, may be it was a duplicate copy of /etc/init/rc.conf so upstart was running /etc/init.d/rc twice?
Re: Reboot and Mysql Problem
Posted: Thu Jan 22, 2015 6:33 pm
by skurudo