MYSQL 1067 에러 발생시 조치 방법

로그파일 위치

C:\Program Files\MariaDB 10.1\data

 

에러문구

2021-12-06  8:32:38 656 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-12-06  8:32:38 656 [Note] InnoDB: The InnoDB memory heap is disabled
2021-12-06  8:32:38 656 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-06  8:32:38 656 [Note] InnoDB: Memory barrier is not used
2021-12-06  8:32:38 656 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-12-06  8:32:38 656 [Note] InnoDB: Not using CPU crc32 instructions
2021-12-06  8:32:38 656 [Note] InnoDB: Initializing buffer pool, size = 979.0M
2021-12-06  8:32:38 656 [Note] InnoDB: Completed initialization of buffer pool
2021-12-06  8:32:38 656 [Note] InnoDB: Highest supported file format is Barracuda.
2021-12-06  8:32:38 656 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*3200 pages, LSN=3979003632
2021-12-06  8:32:38 656 [Warning] InnoDB: Starting to delete and rewrite log files.
2021-12-06  8:32:38 656 [Note] InnoDB: Setting log file .\ib_logfile101 size to 50 MB
2021-12-06  8:32:38 656 [Note] InnoDB: Setting log file .\ib_logfile1 size to 50 MB
2021-12-06  8:32:39 656 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2021-12-06  8:32:39 656 [Warning] InnoDB: New log files created, LSN=3979003916
2021-12-06  8:32:39 656 [Note] InnoDB: 128 rollback segment(s) are active.
2021-12-06  8:32:39 656 [Note] InnoDB: Waiting for purge to start
2021-12-06  8:32:39 656 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 3979003632
2021-12-06  8:32:39 5452 [Note] InnoDB: Dumping buffer pool(s) not yet started
2021-12-06  8:32:39 656 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-06  8:32:39 656 [Note] Recovering after a crash using tc.log
2021-12-06  8:32:39 656 [ERROR] Bad magic header in tc log
2021-12-06  8:32:39 656 [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 mysqld with --tc-heuristic-recover={commit|rollback}
2021-12-06  8:32:39 656 [ERROR] Can't init tc log
2021-12-06  8:32:39 656 [ERROR] Aborting

 

구글에서 검색하여 확인하니 IBDATA1, ib_logfile0, ib_logfile1 파일을 삭제하면 된다.