故障案例----tokudb启动失败

这篇博客记录了一个Tokudb在显示正常关闭后,启动时遇到的问题。故障表现为mysqld无法启动,提示发现有未完成的事务并需要使用--tc-heuristic-recover选项进行提交或回滚。故障原因可能是由于mysqld上次未正常关闭,解决方法是在启动时添加--tc-heuristic-recover=COMMIT或--tc-heuristic-recover=ROLLBACK参数,执行后移除该参数再次启动。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

现象

tokudb显示正常关闭

2016-10-18 14:22:19 144471 [Note] /opt/udb/program/mysql/percona-5.6.21/bin/mysqld: Normal shutdown

.....

.....

2016-10-18 14:22:23 144471 [Note] Shutting down plugin 'mysql_old_password'
2016-10-18 14:22:23 144471 [Note] Shutting down plugin 'mysql_native_password'
2016-10-18 14:22:23 144471 [Note] Shutting down plugin 'binlog'
2016-10-18 14:22:23 144471 [Note] /opt/udb/program/mysql/percona-5.6.21/bin/mysqld: Shutdown complete


但是启动失败

Tue Oct 18 14:22:25 2016 TokuFT recovery done
2016-10-18 14:22:25 201862 [Note] Found 1 prepared transaction(s) in TokuDB
2016-10-18 14:22:25 201862 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2016-10-18 14:22:25 201862 [ERROR] Aborting


故障原因

应该是bug


解决方法

按照错误提示来弄

mysqld启动时添加

--tc-heuristic-recover=COMMIT或者--tc-heuristic-recover=ROLLBACK

执行完成后,去掉该参数再启动一次即可。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值