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
Start mysqld with --tc-heuristic-recover=COMMIT or – tc -heuristic-recover=ROLLBACK option, whichever works to solve this problem.
This related to Percona Rocksdb limitation for XA transactions.
TheXA protocol <[URL]https://dev.mysql.com/doc/refman/8.0/en/xa.html[/URL]>_ support, which allows distributed transactions combining multiple separate transactional resources, is an experimental feature in MyRocks: the implementation is less tested, it may lack some functionality and be not as stable as in case of InnoDB.
[url]https://www.percona.com/doc/percona-server/LATEST/myrocks/limitations.html[/url]
[URL]MySQL :: MySQL 5.7 Reference Manual :: 5.1.6 Server Command Options
As per the documentation for –_tc-heuristic-recover_ option " The type of decision to use in the heuristic recovery process. To use this option, two or more storage engines that support XA transactions must be installed."
So this is expected when 2 transactional engines enabled