运行中出现:error!mysql is running but PID file could not be found

一人天 发表于 2013-10-19 14:00:27

130630 16:41:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130630 16:41:51 InnoDB: The InnoDB memory heap is disabled
130630 16:41:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130630 16:41:51 InnoDB: Compressed tables use zlib 1.2.3
130630 16:41:51 InnoDB: Initializing buffer pool, size = 16.0M
130630 16:41:51 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
InnoDB: a new database to be created!
130630 16:41:51 InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130630 16:41:51 InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130630 16:41:51 InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130630 16:41:52 InnoDB: Waiting for the background threads to start
130630 16:41:53 InnoDB: 1.1.8 started; log sequence number 0
130630 16:41:53 Server hostname (bind-address): '0.0.0.0'; port: 3306
130630 16:41:53 - '0.0.0.0' resolves to '0.0.0.0';
130630 16:41:53 Server socket created on IP: '0.0.0.0'.
130630 16:41:53 Event Scheduler: Loaded 0 events
130630 16:41:53 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130630 16:41:54 /usr/local/mysql/bin/mysqld: Normal shutdown

130630 16:41:54 Event Scheduler: Purging the queue. 0 events
130630 16:41:54 InnoDB: Starting shutdown...
130630 16:41:55 InnoDB: Shutdown completed; log sequence number 1595675
130630 16:41:55 /usr/local/mysql/bin/mysqld: Shutdown complete

130630 16:41:55 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1306300803061624a9Z.pid ended
130630 16:41:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130630 16:41:56 InnoDB: The InnoDB memory heap is disabled
130630 16:41:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130630 16:41:56 InnoDB: Compressed tables use zlib 1.2.3
130630 16:41:56 InnoDB: Initializing buffer pool, size = 16.0M
130630 16:41:56 InnoDB: Completed initialization of buffer pool
"AY1306300803061624a9Z.err" 160L, 10010C

puffbaby 发表于 2013-10-19 14:32:58

ps aux |grep mysql
看下mysql 进程呗
应该是卡死了

然后再
kill XXXX
XXX 是那个mysql的进程号有几个
就KILL 几个，全部KILL掉
然后再重启试试

licess 发表于 2013-10-19 14:34:06

InnoDB: Database physically writes the file full: wait...
看这个是当前分区或硬盘已满

一人天 发表于 2013-10-19 14:37:25

回复 2# 的帖子

KILL 掉之后,start不了.一直....

可恶的一小时两个贴子

删掉了mysql/var里面的0000日志文件也是无法启动

确实是磁盘满了.谢谢各位

[ 本帖最后由一人天于 2013-10-19 15:27 编辑 ]

licess 发表于 2013-10-19 16:25:16

你这是看的inode占用，不是看的硬盘容量占用，df -h 是看硬盘容量占用

页: [1]

VPS侦探论坛's Archiver

运行中出现:error!mysql is running but PID file could not be found

回复 2# 的帖子