Not the answer you need?
Register and ask your own question!

MySQL Won't Start: "Found 1 prepared transaction" --tc-heuristic-recover alternative?

michaelpwardmichaelpward EntrantLegacy User Role Beginner
The logs (pertinent section pasted below) say that "critical information was manually deleted" – but we did not manually delete anything.

Trying "does not work. Any solutions for this?

Found 1 prepared transaction(s) in TokuDB
2018-05-06T14:56:02.063832Z 0 [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.
2018-05-06T14:56:02.063843Z 0 [ERROR] Aborting

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.