MySQL服务器异常关闭，重启后，无法启动----因为磁盘空间满

记一次测试环境MySQL无法启动的案例。

---

欢迎转载，请注明作者、出处。

作者：张正

blog：http://space.itpub.net/26355921 

QQ：176036317

如有疑问，欢迎联系。

---

问题描述：MySQL服务器重启后，数据库实例无法启动，日志信息如下：

InnoDB: Transaction 91AE18A was in the XA prepar140805 13:51:18 mysqld_safe mysqld from pid file /data/mysql6015/mysqld.pid ended 140805 13:52:16 mysqld_safe Starting mysqld daemon with databases from /data/mysql6015/data/ 140805 13:52:16 InnoDB: The InnoDB memory heap is disabled 140805 13:52:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140805 13:52:16 InnoDB: Compressed tables use zlib 1.2.3 140805 13:52:17 InnoDB: Initializing buffer pool, size = 1.0G 140805 13:52:18 InnoDB: Completed initialization of buffer pool 140805 13:52:18 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! 140805 13:52:18  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 91ABFEE was in the XA prepared state. InnoDB: Transaction 91B0DD3 was in the XA prepared state. InnoDB: Transaction 91ABFF1 was in the XA prepared state. InnoDB: Transaction 91ACADF was in the XA prepared state. InnoDB: Transaction 91AC56B was in the XA prepared state. InnoDB: Transaction 91AC175 was in the XA prepared state. InnoDB: Transaction 91AE2B4 was in the XA prepared state. InnoDB: Transaction 91AD1D8 was in the XA prepared state. InnoDB: Transaction 91AC7ED was in the XA prepared state. InnoDB: Transaction 91B0D62 was in the XA prepared state. InnoDB: Transaction 91AC37B was in the XA prepared state. InnoDB: Transaction 91AF11F was in the XA prepared state. InnoDB: Transaction 91AC774 was in the XA prepared state. InnoDB: Transaction 91AE2BE was in the XA prepared state. InnoDB: Transaction 91AC006 was in the XA prepared state. InnoDB: Transaction 91ACAF1 was in the XA prepared state. ............................................................... InnoDB: Transaction 91AE275 was in the XA prepared state. InnoDB: Transaction 91AD70D was in the XA prepared state. InnoDB: Transaction 91ACB28 was in the XA prepared state. InnoDB: Transaction 91AE37D was in the XA prepared state. InnoDB: Transaction 91AE204 was in the XA prepared state. InnoDB: Transaction 91AF2E5 was in the XA prepared state. InnoDB: Transaction 91AD4A2 was in the XA prepared state. InnoDB: Transaction 91AE18A was in the XA prepar140805 13:53:09 mysqld_safe mysqld from pid file /data/mysql6015/mysqld.pid ended

排查了10分钟之后，看了一下磁盘，才发现磁盘已满：

[root@localhost log]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/sda2              40G  6.5G   31G  18% / tmpfs                 4.9G     0  4.9G   0% /dev/shm /dev/sda1             504M   58M  421M  13% /boot /dev/sdb1             197G  187G     0 100% /data

清理掉磁盘空间后，再次启动，OK。

各位看到这里，是不是觉得很无语。。。。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26355921/viewspace-1245593/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26355921/viewspace-1245593/