Question
error: #2002 - No such file or directory<br />The server is not responding (or the local server's socket is not correctly configured).
- Posted on December 9, 2016
- ApacheMySQLUbuntu 16.04
Asked by alireza naman
This is my mysql log
2016-12-09T22:10:35.858091Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-12-09T22:10:35.862330Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-12-09T22:10:36.037707Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp 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 __atomic_thread_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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Based on this line:
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.