Ib logfile-foutmelding (MySQL)

In verband met een row size-error heb ik de grootte van het InnoDB-logbestand op een onhandige manier verwijderd ofzo, en nu start MySQL niet meer.

Bestanden & locaties

• Error-log: /var/log/mysql/ → Sorteren op datum → Juiste bestand openen
• InnoDB-log: /var/lib/mysql → Bestanden ib_logfile0 en ib_logfile1
• my.cnf-configuratiebestand: /etc/mysql/my.cnf

Melding error-log

51213  1:05:25 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151213  1:05:25 [Note] Plugin 'FEDERATED' is disabled.
151213  1:05:25 InnoDB: The InnoDB memory heap is disabled
151213  1:05:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151213  1:05:25 InnoDB: Compressed tables use zlib 1.2.3.4
151213  1:05:25 InnoDB: Initializing buffer pool, size = 4.0G
151213  1:05:26 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
151213  1:05:26 [ERROR] Plugin 'InnoDB' init function returned error.
151213  1:05:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151213  1:05:26 [ERROR] Unknown/unsupported storage engine: InnoDB
151213  1:05:26 [ERROR] Aborting
151213  1:05:26 [Note] /usr/sbin/mysqld: Shutdown complete

Casus dec. 2015

Na verwijderen van beide logbestanden, was het probleem pas opgelost na herstarten van de computer.

Zie ook

• Row size error (MySQL)

Bronnen

• http://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/
• http://serverfault.com/questions/104014/innodb-error-log-file-ib-logfile0-is-of-different-size