MySQL Forums
Forum List  »  InnoDB

Re: Can't start the MySQL service - Error with InnoDB
Posted by: Imran Akbar
Date: April 17, 2013 12:53PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
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.