开发者社区> 问答> 正文

mysql启动不了了,求高数指点,日志已贴出

140829  0:55:14 [Warning] IP address '110.249.223.148' could not be resolved: Name or service not known
140829  2:48:33 [Warning] IP address '139.201.126.225' could not be resolved: Name or service not known
140829  4:38:16 [Warning] IP address '58.56.136.90' could not be resolved: Name or service not known
140829 10:02:39 [Warning] Disk is full writing './mysql-bin.000010' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140829 10:02:39 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140829 10:03:41 [Warning] Disk is full writing './mysql-bin.000010' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140829 10:03:41 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140829 10:07:24 mysqld_safe Number of processes running now: 0
140829 10:07:24 mysqld_safe mysqld restarted
140829 10:07:25 [Note] Plugin 'FEDERATED' is disabled.
140829 10:07:25 InnoDB: The InnoDB memory heap is disabled
140829 10:07:25 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140829 10:07:25 InnoDB: Compressed tables use zlib 1.2.3
140829 10:07:25 InnoDB: Using Linux native AIO
140829 10:07:25 InnoDB: Initializing buffer pool, size = 16.0M
140829 10:07:25 InnoDB: Completed initialization of buffer pool
140829 10:07:25 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140829 10:07:25  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Transaction 1907EF was in the XA prepared state.
InnoDB: Transaction 190B77 was in the XA prepared state.
InnoDB: 6 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 4 row operations to undo
InnoDB: Trx id counter is 190E00
InnoDB: Last MySQL binlog file position 0 64516096, file name ./mysql-bin.000010
InnoDB: Error: pthread_create returned 11
140829 10:07:28 mysqld_safe mysqld from pid file /alidata/server/mysql/data/AY1301080646117449669.pid ended
140829 10:39:00 mysqld_safe Starting mysqld daemon with databases from /alidata/server/mysql/data
140829 10:39:00 [Note] Plugin 'FEDERATED' is disabled.
140829 10:39:00 InnoDB: The InnoDB memory heap is disabled
140829 10:39:00140829 10:39:03 mysqld_safe mysqld from pid file /alidata/server/mysql/data/AY1301080646117449669.pid ended

展开
收起
hi34028332 2014-08-29 10:52:04 11539 0
2 条回答
写回答
取消 提交回答
  • Remysql启动不了了,求高数指点,日志已贴出
    df -h
    看下你磁盘空间是不是不够了
    2014-08-29 11:46:37
    赞同 展开评论 打赏
  • 路过
    2014-08-29 11:19:39
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
PostgresChina2018_赖思超_PostgreSQL10_hash索引的WAL日志修改版final 立即下载
Kubernetes下日志实时采集、存储与计算实践 立即下载
日志数据采集与分析对接 立即下载

相关镜像