MySQL – InnoDB: Error: log file /var/db/mysql/ib_logfile0 is of different size 0 1073741824 bytes

MySQL을 재시작시 데몬이 뜨지 않고 아래 에러를 내뱉을 경우가 있습니다.

[root@yongbok ~]# cat /var/db/mysql/yongbok.net.err

110402 08:28:47 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110402  8:28:47 InnoDB: The InnoDB memory heap is disabled
110402  8:28:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110402  8:28:47 InnoDB: Compressed tables use zlib 1.2.3
110402  8:28:48 InnoDB: Initializing buffer pool, size = 1.0G
110402  8:28:48 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file /var/db/mysql/ib_logfile0 is of different size 0 1073741824 bytes
InnoDB: than specified in the .cnf file 0 1308622848 bytes!
110402  8:28:48 [ERROR] Plugin ‘InnoDB’ init function returned error.
110402  8:28:48 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
110402  8:28:48 [ERROR] Unknown/unsupported storage engine: InnoDB
110402  8:28:48 [ERROR] Aborting

위의 경우는 ib_logfile0 로그 파일과 두번째 생성되는 로그 파일의 크기가 서로 달라 생기는 문제입니다.
기존의 ib_logfile0 로그 파일을 지우거나 다른 이름으로 저장하여 로그를 재생성 해주면 됩니다.
(ib_logfile0 로그 파일은 데이터베이스 복구시 유용하게 사용될수 있으므로 임시 방편으로 다른이름으로 변경하고 로그를 재생성)

필자는 다른이름으로 변경 해주고 재시작 했습니다.

[root@yongbok ~]# mv /var/db/mysql/ib_logfile0 /var/db/mysql/ib_logfile0_old

[root@yongbok ~]# /usr/local/etc/rc.d/mysql-server start
Starting mysql.

에러 로그 확인 (로그 파일을 재생성하고 정상적으로 데몬 구동됨)

[root@yongbok ~]# cat /var/db/mysql/yongbok.net.err

110402 08:28:48 mysqld_safe mysqld from pid file /var/db/mysql/yongbok.net.pid ended
110402 08:30:11 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110402  8:30:11 InnoDB: The InnoDB memory heap is disabled
110402  8:30:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110402  8:30:11 InnoDB: Compressed tables use zlib 1.2.3
110402  8:30:12 InnoDB: Initializing buffer pool, size = 1.0G
110402  8:30:12 InnoDB: Completed initialization of buffer pool
110402  8:30:14  InnoDB: Log file /var/db/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/db/mysql/ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait…
110402  8:30:15  InnoDB: Log file /var/db/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/db/mysql/ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
110402  8:30:15 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110402  8:30:15  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
110402  8:30:17  InnoDB: Waiting for the background threads to start
110402  8:30:18 InnoDB: 1.1.5 started; log sequence number 49338892
110402  8:30:19 [Note] Event Scheduler: Loaded 0 events
110402  8:30:19 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: ’5.5.10′  socket: ‘/tmp/mysql.sock’  port: 3306  Source distribution

Loading Disqus Comments ...
Loading Facebook Comments ...

No Trackbacks.