Ib logfile-foutmelding (MySQL)
Naar navigatie springen
Naar zoeken springen
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.