Issues

Bad magic header in tc log

Text Only

2024-10-31 13:13:43 0 [Note] Recovering after a crash using tc.log
2024-10-31 13:13:43 0 [ERROR] Bad magic header in tc log
2024-10-31 13:13:43 0 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start server with --tc-heuristic-recover={commit|rollback}
2024-10-31 13:13:43 0 [ERROR] Can't init tc log
2024-10-31 13:13:43 0 [ERROR] Aborting

Bash

mv -vi /var/lib/mysql/tc.log /var/lib/mysql/tc.log.moved

And run again.

Database locked

use locaked database and fire up

MySQL

UPDATE DATABASECHANGELOGLOCK SET LOCKED=0, LOCKGRANTED=null, LOCKEDBY=null where ID=1;