Can”t init tc log Aborting | mysql事务日志导致【zhì dǎo zhì】启动失【qǐ dòng shī】败问题🥛，killall  mysql进程后，mysql无法启🛢动问题🥔总汇【zǒng huì】；

问题1：

将mysql所有进【suǒ yǒu jìn】👑程【chéng】🧤kill掉后，重启✨，无法启动，报错【bào cuò】：

110303 14:01:45 InnoDB: Started; log sequence number 0 138710263

/usr/local/mysql/bin/mysqld: File ‘./mysql-bin.000041′ not found (Errcode: 13)

110303 14:01:45 [ERROR] Failed to open log (file ‘./mysql-bin.000041′, errno 13)

110303 14:01:45 [ERROR] Could not open log file

110303 14:01:45 [ERROR] Can’t init tc log

110303 14:01:45 [ERROR] Aborting

在【zài】🌺mysql/data/目录下【mù lù xià】找到🍌mysql-bin.000041文件🍨，删掉，重启【chóng qǐ】，仍不行，报错：

110303 14:04:07 InnoDB: Started; log sequence number 0 138710263

/usr/local/mysql/bin/mysqld: File ‘./mysql-bin.000041′ not found (Errcode: 2)

110303 14:04:07 [ERROR] Failed to open log (file ‘./mysql-bin.000041′, errno 2)

110303 14:04:07 [ERROR] Could not open log file

110303 14:04:07 [ERROR] Can’t init tc log

110303 14:04:07 [ERROR] Aborting

touch之🥟，修改权【xiū gǎi quán】限👛，重启，也不行，报错【bào cuò】：

110303 14:05:41 InnoDB: Started; log sequence number 0 138710263

110303 14:05:41 [ERROR] I/O error reading the header from the binary log, errno=-1, io cache code=0

110303 14:05:41 [ERROR] I/O error reading the header from the binary log

110303 14:05:41 [ERROR] Can’t init tc log

110303 14:05:41 [ERROR] Aborting

最后解决办法：

将mysql/data/mysql-bin.index文件删除【chú】，重启【chóng qǐ】😕mysql，会自动生成新【shēng chéng xīn】✒的🎐mysql-bin.index文件，启动成功

问题2：

启动后，报错：

InnoDB: Started; log sequence number 0 1004308157

110303 14:15:01 [Note] Recovering after a crash using mysql-bin

110303 14:15:01 [ERROR] Error in Log_event::read_log_event(): ‘read error’, data_len: 169, event_type: 2

110303 14:15:01 [Note] Starting crash recovery…

110303 14:15:01 [Note] Crash recovery finished.

/opt/31306/mysql/bin/mysqld: Disk is full writing ‘./mysql-bin.~rec~’ (Errcode: 28). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)

这是由【zhè shì yóu】🤷于mysql-bin日志过多，进入【jìn rù】mysql/data/目录【mù lù】，果断删🖼除所有mysql-bin.*文件，重启✈，启动成功【gōng】♈

问题3：

启动后，报错：

110303 14:21:37 InnoDB: Started; log sequence number 0 487312871

110303 14:21:37 [ERROR] Can’t start server: Bind on TCP/IP port: Address already in use

110303 14:21:37 [ERROR] Do you already have another mysqld server running on port: 43306 ?

110303 14:21:37 [ERROR] Aborting

按提示🏝，应该是43306端口占👆用【yòng】🦌，但是查【dàn shì chá】看后并未发现【wèi fā xiàn】✅该端口被占用【bèi zhàn yòng】🦌，不深究【bú shēn jiū】，果断将其☝my.cnf文件中的【zhōng de】⛱port修改成🐴一个新的端口【de duān kǒu】🚲，重启【chóng qǐ】，启动成功【chéng gōng】🛺。关闭后，重新将my.cnf中的【zhōng de】⛱port改回为43306，重启【chóng qǐ】，又可以成功【chéng gōng】🛺启动了。