ITPub博客

首页 > 数据库 > MySQL > Unknown/unsupported storage engine: InnoDB

Unknown/unsupported storage engine: InnoDB

原创 MySQL 作者:goolen 时间:2014-11-17 16:20:44 0 删除 编辑
启动mysql 从库的时候报错:
# /etc/init.d/mysqld start
Starting MySQL (Percona Server)............................................................
The server quit without updating PID file (/tol/mysql/d[FAILED]db.pid).

查看错误日志:
# tail -30f mysql.err 
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.
141117 16:10:28  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
141117 16:10:28  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
141117 16:10:28 InnoDB: Could not open or create data files.
141117 16:10:28 InnoDB: If you tried to add new data files, and it failed here,
141117 16:10:28 InnoDB: you should now edit innodb_data_file_path in my.cnf back
141117 16:10:28 InnoDB: to what it was, and remove the new ibdata files InnoDB created
141117 16:10:28 InnoDB: in this failed attempt. InnoDB only wrote those files full of
141117 16:10:28 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
141117 16:10:28 InnoDB: remove old data files which contain your precious data!
141117 16:10:28 [ERROR] Plugin 'InnoDB' init function returned error.
141117 16:10:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141117 16:10:29 [ERROR] Unknown/unsupported storage engine: InnoDB
141117 16:10:29 [ERROR] Aborting

141117 16:10:29 [Note] /tol/mysql/home/bin/mysqld: Shutdown complete

141117 16:10:29 mysqld_safe mysqld from pid file /tol/mysql/data/coredb.pid ended

查看mysql进程
# ps aux | grep mysql
root      7332  0.0  0.0 103240   868 pts/0    S+   16:13   0:00 grep mysql
root     23914  0.0  0.0 106220  1416 ?        S    Nov14   0:00 /bin/sh /tol/mysql/home/bin/mysqld_safe --datadir=/tol/mysql/data --pid-file=/tol/mysql/data/localhost.localdomain.pid
mysql    24514  0.2  0.3 2056984 172400 ?      Sl   Nov14  10:15 /tol/mysql/home/bin/mysqld --basedir=/tol/mysql/home --datadir=/tol/mysql/data --plugin-dir=/tol/mysql/home/lib/plugin --user=mysql --log-error=/tol/mysql/mylog/mysql.err --pid-file=/tol/mysql/data/localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306

停止mysql也报错
# /etc/init.d/mysqld stop
MySQL (Percona Server) PID file could not be found!        [FAILED]

再次启动也报错
# /etc/init.d/mysqld start
Starting MySQL (Percona Server).....................................................................................................
The server quit without updating PID file (/tol/mysql/da[FAILED]1g.pid).

kill 掉上面的两个进程
# kill -9 23914 24514

重启ok
# /etc/init.d/mysqld start
Starting MySQL (Percona Server)...                         [  OK  ]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23249684/viewspace-1336371/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-10-20

  • 博文量
    121
  • 访问量
    731657