Have you ever encounter failing to start your MySQL server that throws this kind of error:
1 |
[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. |
This occurs when your server suddenly shutsdown or…