Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Reboot and Mysql Problem

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Locked
  • Print view
Advanced search
12 posts
  • 1
  • 2
  • Next
muhammed332
Posts: 4
Joined: Mon Jan 19, 2015 10:06 am

Reboot and Mysql Problem

Post by muhammed332 » Mon Jan 19, 2015 10:09 am

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
Top
joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: Reboot and Mysql Problem

Post by joem » Wed Jan 21, 2015 6:33 am

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
Top
muhammed332
Posts: 4
Joined: Mon Jan 19, 2015 10:06 am

Re: Reboot and Mysql Problem

Post by muhammed332 » Wed Jan 21, 2015 6:44 am

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
Top
melkerman
Posts: 8
Joined: Wed Apr 02, 2014 10:52 am

Re: Reboot and Mysql Problem

Post by melkerman » Wed Jan 21, 2015 3:14 pm

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.
Top
skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Reboot and Mysql Problem

Post by skurudo » Wed Jan 21, 2015 3:55 pm

Guys, try this:

1. stop satan-oracle-sql machine

Code: Select all

 /etc/init.d/mysql stop
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

Code: Select all

/etc/init.d/mysql start
Top
muhammed332
Posts: 4
Joined: Mon Jan 19, 2015 10:06 am

Re: Reboot and Mysql Problem

Post by muhammed332 » Wed Jan 21, 2015 5:46 pm

skurudo wrote:Guys, try this:

1. stop satan-oracle-sql machine

Code: Select all

 /etc/init.d/mysql stop
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

Code: Select all

/etc/init.d/mysql start
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.
Top
muhammed332
Posts: 4
Joined: Mon Jan 19, 2015 10:06 am

Re: Reboot and Mysql Problem

Post by muhammed332 » Wed Jan 21, 2015 5:50 pm

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?
Top
skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Reboot and Mysql Problem

Post by skurudo » Thu Jan 22, 2015 5:18 pm

Hmm... may be your MySQL server start twice?
Top
skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Reboot and Mysql Problem

Post by skurudo » Thu Jan 22, 2015 5:23 pm

Can you check, may be it was a duplicate copy of /etc/init/rc.conf so upstart was running /etc/init.d/rc twice?
Top
skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Reboot and Mysql Problem

Post by skurudo » Thu Jan 22, 2015 6:33 pm

https://github.com/serghey-rodin/vesta/ ... t-63156504 – fixed it: `update-rc.d mysql disable`

Proof - viewtopic.php?f=11&t=6887&p=20759#p20759
Top
Locked
  • Print view
12 posts
  • 1
  • 2
  • Next

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password