记一次测试环境MySQL无法启动的案例。
问题描述：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。
各位看到这里，是不是觉得很无语。。。。 (责任编辑：IT) |