Mysql启动服务再现异类错误
121206 11:14:09 InnoDB: Could not open or create data files.
121206 11:14:09 InnoDB: If you tried to add new data files, and it failed here,
121206 11:14:09 InnoDB: you should now edit innodb_data_file_path in my.cnf back
121206 11:14:09 InnoDB: to what it was, and remove the new ibdata files InnoDB created
121206 11:14:09 InnoDB: in this failed attempt. InnoDB only wrote those files full of
121206 11:14:09 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
121206 11:14:09 InnoDB: remove old data files which contain your precious data!
121206 11:14:09 [ERROR] Plugin 'InnoDB' init function returned error.
121206 11:14:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121206 11:14:09 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
121206 11:14:09 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121206 11:14:09 [ERROR] Aborting


121206 11:14:09 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


121206 11:14:09 mysqld_safe mysqld from pid file /usr/local/mysql/data/slave01.pid ended
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.
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.
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.

[root@slave01 data]#

出现这类错误的原因，看iNNOB提醒，已经指出其他的线程启动已经在运行无法再次创建相关的读文件进程的权限，也就是说，现有的ibddata文件已经有人读取了，无法再次启动！我们通过以下命令来查找是否如提醒中所言；

如以下红色的所示：

[root@slave01 tmp]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL....................................................................................................The server quit without updating PID file (/usr/local/mysql/data/slave01.pid).