error: #2002 - No such file or directory<br />The server is not responding (or the local server's socket is not correctly configured).

December 9, 2016 564 views
Apache MySQL Ubuntu 16.04

This is my mysql log

2016-12-09T22:10:35.858091Z 0 [Warning] Changed limits: maxopenfiles: 1024 (requested 5000)
2016-12-09T22:10:35.862330Z 0 [Warning] Changed limits: tableopencache: 431 (requested 2000)
2016-12-09T22:10:36.037707Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicitdefaultsfortimestamp server option (see documentation for more details).
2016-12-09T22:10:36.039697Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-0ubuntu0.16.04.1) starting as process 15446 ...
2016-12-09T22:10:36.045338Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-12-09T22:10:36.045383Z 0 [Note] InnoDB: Mutexes and rw
locks use GCC atomic builtins
2016-12-09T22:10:36.045391Z 0 [Note] InnoDB: Uses event mutexes
2016-12-09T22:10:36.045398Z 0 [Note] InnoDB: GCC builtin _atomicthread_fence() is used for memory barrier
2016-12-09T22:10:36.045408Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-12-09T22:10:36.045415Z 0 [Note] InnoDB: Using Linux native AIO
2016-12-09T22:10:36.045702Z 0 [Note] InnoDB: Number of pools: 1
2016-12-09T22:10:36.045843Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-12-09T22:10:36.048002Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-12-09T22:10:36.048123Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2016-12-09T22:10:36.048155Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-12-09T22:10:36.048174Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2016-12-09T22:10:36.048192Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2016-12-09T22:10:36.048205Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-12-09T22:10:36.048218Z 0 [ERROR] Failed to initialize plugins.
2016-12-09T22:10:36.048227Z 0 [ERROR] Aborting

2016-12-09T22:10:36.048240Z 0 [Note] Binlog end
2016-12-09T22:10:36.048331Z 0 [Note] Shutting down plugin 'CSV'
2016-12-09T22:10:36.048351Z 0 [Note] Shutting down plugin 'MyISAM'
2016-12-09T22:10:36.048838Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

1 Answer

Based on this line:

2016-12-09T22:10:36.048155Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool

It looks like your droplet is running out of memory causing the MySQL service to crash. You should look into a larger droplet or making other configuration tweaks to optimize.

Have another answer? Share your knowledge.