Question
Wordpress - mysql crash
Hello what’s wrong on Digital Ocean?
I have a droplet with 1 GB Memory / 30 GB Disk / AMS2 - Ubuntu 16.04.2 x64 and it work very well in the last 2 months.
Now i want know why in the last 4 days mysql stop working???
i really don’t understand why this occured, i have one more droplet with same specs and more Wordpress site on it, and work very well.
problem is related to ram consuption, but i try a2dissite all my sites and leave just one active, problem persist!!!!!!
tail -40 /var/log/mysql/error.log
2017-07-24T19:04:30.218958Z 0 [Note] InnoDB: Number of pools: 1
2017-07-24T19:04:30.219177Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-07-24T19:04:30.222532Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M
2017-07-24T19:04:30.222644Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errn o 12
2017-07-24T19:04:30.222824Z 0 [ERROR] InnoDB: Cannot allocate memory for the buf fer pool
2017-07-24T19:04:30.222864Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-07-24T19:04:30.222887Z 0 [ERROR] Plugin ‘InnoDB’ init function returned err or.
2017-07-24T19:04:30.222904Z 0 [ERROR] Plugin 'InnoDB’ registration as a STORAGE ENGINE failed.
2017-07-24T19:04:30.222921Z 0 [ERROR] Failed to initialize plugins.
2017-07-24T19:04:30.222935Z 0 [ERROR] Aborting
2017-07-24T19:04:30.222951Z 0 [Note] Binlog end
2017-07-24T19:04:30.223066Z 0 [Note] Shutting down plugin 'MyISAM’
2017-07-24T19:04:30.223766Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-07-24T19:05:00.448335Z 0 [Warning] Changed limits: maxopenfiles: 1024 (re quested 5000)
2017-07-24T19:05:00.448433Z 0 [Warning] Changed limits: tableopencache: 431 (r equested 2000)
2017-07-24T19:05:00.658943Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicitdefaultsfortimestamp server option (see doc umentation for more details).
2017-07-24T19:05:00.662549Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.16 .04.1) starting as process 5831 …
2017-07-24T19:05:00.672747Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-07-24T19:05:00.672879Z 0 [Note] InnoDB: Mutexes and rwlocks use GCC atomic builtins
2017-07-24T19:05:00.672910Z 0 [Note] InnoDB: Uses event mutexes
2017-07-24T19:05:00.673003Z 0 [Note] InnoDB: GCC builtin _atomicthread_fence() is used for memory barrier
2017-07-24T19:05:00.673107Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-07-24T19:05:00.673136Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-24T19:05:00.674193Z 0 [Note] InnoDB: Number of pools: 1
2017-07-24T19:05:00.674524Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-07-24T19:05:00.677755Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M
2017-07-24T19:05:00.677867Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errn o 12
2017-07-24T19:05:00.677951Z 0 [ERROR] InnoDB: Cannot allocate memory for the buf fer pool
2017-07-24T19:05:00.677980Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-07-24T19:05:00.677996Z 0 [ERROR] Plugin 'InnoDB’ init function returned err or.
2017-07-24T19:05:00.678006Z 0 [ERROR] Plugin 'InnoDB’ registration as a STORAGE ENGINE failed.
2017-07-24T19:05:00.678017Z 0 [ERROR] Failed to initialize plugins.
2017-07-24T19:05:00.678025Z 0 [ERROR] Aborting
2017-07-24T19:05:00.678051Z 0 [Note] Binlog end
2017-07-24T19:05:00.678201Z 0 [Note] Shutting down plugin 'MyISAM’
2017-07-24T19:05:00.679034Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
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.
×