记一次测试环境MySQL无法启动的案例。
欢迎转载，请注明作者、出处。
作者：张正
blog：http://space.itpub.net/26355921
QQ：176036317
如有疑问，欢迎联系。
| 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 |
| [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博客84223932的博客，原文链接：MySQL服务器异常关闭，重启后，无法启动----因为磁盘空间满，如需转载请自行联系原博主。
