Project

General

Profile

Bug #500

InnoDB Error Log File ib_logfile0 Is Of Different Size

Added by Daniel Curtis about 10 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
12/17/2014
Due date:
% Done:

100%

Estimated time:
0.50 h
Spent time:

Description

I encountered an error while managing my MariaDB Galera cluster.

  • I checked the log file:
    tail -n 50 /var/log/syslog
    
    • And found the following error:
      InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
      InnoDB: than specified in the .cnf file 0 268435456 bytes!
      100118 20:52:52 [ERROR] Plugin 'InnoDB' init function returned error.
      100118 20:52:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      100118 20:52:52 [ERROR] Unknown/unsupported table type: InnoDB
      100118 20:52:52 [ERROR] Aborting
      
  • After looking around online I found the solution to be as simple as deleting the stale ib_logfiles:
    rm /var/lib/mysql/ib_logfile*
    

Resources

Also available in: Atom PDF