Failed to start (MySQL): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
(Nieuwe pagina aangemaakt met 'Het probleem: $ sudo service mysql restart mysql stop/waiting start: Job failed to start') |
|||
| Regel 1: | Regel 1: | ||
| − | Het probleem | + | == Het probleem == |
$ sudo service mysql restart | $ sudo service mysql restart | ||
mysql stop/waiting | mysql stop/waiting | ||
start: Job failed to start | start: Job failed to start | ||
| + | |||
| + | == Log files == | ||
| + | |||
| + | Begin hier: | ||
| + | |||
| + | less /var/log/mysql/error.log | ||
| + | |||
| + | Tijdens een storing in januari 2016, stond dit in het logboek: | ||
| + | |||
| + | <pre> | ||
| + | 160101 1:24:31 [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. | ||
| + | 160101 1:24:31 [Note] Plugin 'FEDERATED' is disabled. | ||
| + | 160101 1:24:31 InnoDB: The InnoDB memory heap is disabled | ||
| + | 160101 1:24:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins | ||
| + | 160101 1:24:31 InnoDB: Compressed tables use zlib 1.2.3.4 | ||
| + | 160101 1:24:31 InnoDB: Initializing buffer pool, size = 4.0G | ||
| + | InnoDB: mmap(4395630592 bytes) failed; errno 12 | ||
| + | 160101 1:24:31 InnoDB: Completed initialization of buffer pool | ||
| + | 160101 1:24:31 InnoDB: Fatal error: cannot allocate memory for the buffer pool | ||
| + | 160101 1:24:31 [ERROR] Plugin 'InnoDB' init function returned error. | ||
| + | 160101 1:24:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. | ||
| + | 160101 1:24:31 [ERROR] Unknown/unsupported storage engine: InnoDB | ||
| + | 160101 1:24:31 [ERROR] Aborting | ||
| + | </pre> | ||
| + | |||
| + | Oftewel: InnoDB had een geheugen-allocatieprobleem en weigerde te starten. | ||
Versie van 1 jan 2016 02:32
Het probleem
$ sudo service mysql restart mysql stop/waiting start: Job failed to start
Log files
Begin hier:
less /var/log/mysql/error.log
Tijdens een storing in januari 2016, stond dit in het logboek:
160101 1:24:31 [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. 160101 1:24:31 [Note] Plugin 'FEDERATED' is disabled. 160101 1:24:31 InnoDB: The InnoDB memory heap is disabled 160101 1:24:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160101 1:24:31 InnoDB: Compressed tables use zlib 1.2.3.4 160101 1:24:31 InnoDB: Initializing buffer pool, size = 4.0G InnoDB: mmap(4395630592 bytes) failed; errno 12 160101 1:24:31 InnoDB: Completed initialization of buffer pool 160101 1:24:31 InnoDB: Fatal error: cannot allocate memory for the buffer pool 160101 1:24:31 [ERROR] Plugin 'InnoDB' init function returned error. 160101 1:24:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 160101 1:24:31 [ERROR] Unknown/unsupported storage engine: InnoDB 160101 1:24:31 [ERROR] Aborting
Oftewel: InnoDB had een geheugen-allocatieprobleem en weigerde te starten.