Re: Can't start the MySQL service - Error with InnoDB
I'm having a similar problem.
I'm creating a new slave from a master that was backed up using Percona's Xtrabackup. On 2 of my other servers, I was able to do this just fine and start MySQL from the restored data files. On my third server, it gives me this error when I try to start MySQL 5.6.10:
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/sjvs3-ogre.pid).
The log file contains:
2013-04-17 11:49:12 17879 [ERROR] InnoDB: read can't be opened in ./ibdata1 mode
2013-04-17 11:49:12 17879 [ERROR] InnoDB: The system tablespace must be writable!
2013-04-17 11:49:12 17879 [ERROR] Plugin 'InnoDB' init function returned error.
2013-04-17 11:49:12 17879 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-04-17 11:49:12 17879 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-04-17 11:49:12 17879 [ERROR] Aborting
I have checked the permissions on the data file folder, mysql owns and has access to all the files in /var/lib/mysql:
-rw-r----- 1 mysql mysql 56 Apr 17 11:17 auto.cnf
-rw-r--r-- 1 mysql mysql 189 Apr 16 00:01 backup-my.cnf
drwx--x--x 2 mysql mysql 4096 Apr 16 18:04 company
drwx--x--x 2 mysql mysql 20480 Apr 16 18:04 epi
drwx--x--x 2 mysql mysql 4096 Apr 16 18:04 equipment
drwx--x--x 2 mysql mysql 4096 Apr 16 18:04 fofdb
-rw-rw---- 1 mysql mysql 114397544448 Apr 17 10:02 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Apr 17 10:02 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Apr 17 10:02 ib_logfile1
drwx--x--x 2 mysql mysql 4096 Apr 16 18:04 mysql
drwx------ 2 mysql mysql 4096 Apr 16 18:04 performance_schema
When I switch to using the data folder of a fresh install, everything works fine.
I've commented out pretty much everything in my /etc/my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
innodb_buffer_pool_size = 256M
slow_query_log_file=/var/log/mysqld-slow.log
skip_secure_auth
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Any suggestions?
thanks,
imran
Subject
Views
Written By
Posted
7062
April 16, 2013 03:15AM
Re: Can't start the MySQL service - Error with InnoDB
6485
April 17, 2013 12:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.