[root@jj03 bin]# mysql -uroot 2016-11-10 17:23:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-11-10 17:23:52 0 [Note] mysql (mysqld 5.6.30) starting as process 17822 ... 2016-11-10 17:23:52 17822 [Warning] Using pre 5.5 semantics to load error messages from /usr/local/mysql/share/. 2016-11-10 17:23:52 17822 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters. 2016-11-10 17:23:52 17822 [ERROR] Error message file '/usr/local/mysql/share/errmsg.sys' had only 873 error messages, but it should contain at least 886 error messages. Check that the above file is the right version for this program! 2016-11-10 17:23:52 17822 [Note] Plugin 'FEDERATED' is disabled. 2016-11-10 17:23:52 17822 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-11-10 17:23:52 17822 [Note] InnoDB: The InnoDB memory heap is disabled 2016-11-10 17:23:52 17822 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-11-10 17:23:52 17822 [Note] InnoDB: Memory barrier is not used 2016-11-10 17:23:52 17822 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-11-10 17:23:52 17822 [Note] InnoDB: Using Linux native AIO 2016-11-10 17:23:52 17822 [Note] InnoDB: Using CPU crc32 instructions 2016-11-10 17:23:52 17822 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-11-10 17:23:52 17822 [Note] InnoDB: Completed initialization of buffer pool 2016-11-10 17:23:52 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2016-11-10 17:23:52 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2016-11-10 17:23:52 17822 [Note] InnoDB: Retrying to lock the first data file 2016-11-10 17:23:53 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2016-11-10 17:23:53 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2016-11-10 17:23:54 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2016-11-10 17:23:54 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2016-11-10 17:23:55 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2016-11-10 17:23:55 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2016-11-10 17:23:56 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Unable to lock ./ibdata1, error: 11 系统空间不足
2016-11-10 17:23:52 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11不能锁定ibdata1 文件。10 17:23:52 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.就是检查一下是否有另一个msyqld进程使用了相同的 innodb数据或者日志文件。你可以:ps -ef | grep mysql 看看,或者在linux的监控里看看,mysql有几个进程在运行。
2016-11-10 17:23:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-11-10 17:23:52 0 [Note] mysql (mysqld 5.6.30) starting as process 17822 ...
2016-11-10 17:23:52 17822 [Warning] Using pre 5.5 semantics to load error messages from /usr/local/mysql/share/.
2016-11-10 17:23:52 17822 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
2016-11-10 17:23:52 17822 [ERROR] Error message file '/usr/local/mysql/share/errmsg.sys' had only 873 error messages,
but it should contain at least 886 error messages.
Check that the above file is the right version for this program!
2016-11-10 17:23:52 17822 [Note] Plugin 'FEDERATED' is disabled.
2016-11-10 17:23:52 17822 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-11-10 17:23:52 17822 [Note] InnoDB: The InnoDB memory heap is disabled
2016-11-10 17:23:52 17822 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-11-10 17:23:52 17822 [Note] InnoDB: Memory barrier is not used
2016-11-10 17:23:52 17822 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-11-10 17:23:52 17822 [Note] InnoDB: Using Linux native AIO
2016-11-10 17:23:52 17822 [Note] InnoDB: Using CPU crc32 instructions
2016-11-10 17:23:52 17822 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-11-10 17:23:52 17822 [Note] InnoDB: Completed initialization of buffer pool
2016-11-10 17:23:52 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-11-10 17:23:52 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-11-10 17:23:52 17822 [Note] InnoDB: Retrying to lock the first data file
2016-11-10 17:23:53 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-11-10 17:23:53 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-11-10 17:23:54 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-11-10 17:23:54 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-11-10 17:23:55 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-11-10 17:23:55 17822 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-11-10 17:23:56 17822 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11