wensy_wm 发表于 2017-8-2 21:30:02

mysql 重启出错

军哥:   今天把阿里云重启了一下，结果 数据启动不起来了

结果重新全部卸载了LNMP 然后重新装，结果提示
MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Active Internet connections (only servers)

启动的时候，MYSQL有这样的错误
下面的错误如何解决

170802 19:27:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var


2017-08-02 19:27:42 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


2017-08-02 19:27:42 3361 Plugin 'FEDERATED' is disabled.


2017-08-02 19:27:42 7f443ba74740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.


2017-08-02 19:27:42 3361 InnoDB: Using atomics to ref count buffer pool pages


2017-08-02 19:27:42 3361 InnoDB: The InnoDB memory heap is disabled


2017-08-02 19:27:42 3361 InnoDB: Mutexes and rw_locks use GCC atomic builtins


2017-08-02 19:27:42 3361 InnoDB: Memory barrier is not used


2017-08-02 19:27:42 3361 InnoDB: Compressed tables use zlib 1.2.3


2017-08-02 19:27:42 3361 InnoDB: Using CPU crc32 instructions



2017-08-02 19:27:42 3361 InnoDB: Initializing buffer pool, size = 16.0M


2017-08-02 19:27:42 3361 InnoDB: Completed initialization of buffer pool


2017-08-02 19:27:42 3361 InnoDB: Setting log file /usr/local/mysql/var/ib_logfile101 size to 5 MB


2017-08-02 19:27:42 7f443ba747402017-08-02 19:27:42 3361 InnoDB: Failure of system call pwrite(). Operating system error number is 28.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html


2017-08-02 19:27:42 3361 InnoDB: Cannot set log file /usr/local/mysql/var/ib_logfile101 to size 5 MB


2017-08-02 19:27:42 3361 Plugin 'InnoDB' init function returned error.


2017-08-02 19:27:42 3361 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


2017-08-02 19:27:42 3361 Unknown/unsupported storage engine: InnoDB


2017-08-02 19:27:42 3361 Aborting

licess 发表于 2017-8-3 12:10:52

上面日志有说明，当前磁盘或分区满了，没有可用空间了
页: [1]
查看完整版本: mysql 重启出错