Question
Mysql shut down problem In Ubuntu
Hi
While my external app is working on server. It always shut down and failed to connect again.
What is the problem.
thanks
Error log
2020-03-11T15:35:38.507160Z 0 [Warning] Changed limits: maxopenfiles: 1024 (requested 5000)
2020-03-11T15:35:38.511341Z 0 [Warning] Changed limits: tableopencache: 431 (requested 2000)
2020-03-11T15:35:39.657307Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicitdefaultsfortimestamp server option (see documentation for more details).
2020-03-11T15:35:39.683864Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 3244 …
2020-03-11T15:35:39.776947Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-11T15:35:39.779305Z 0 [Note] InnoDB: Mutexes and rwlocks use GCC atomic builtins
2020-03-11T15:35:39.779410Z 0 [Note] InnoDB: Uses event mutexes
2020-03-11T15:35:39.779497Z 0 [Note] InnoDB: GCC builtin _atomicthread_fence() is used for memory barrier
2020-03-11T15:35:39.779580Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-11T15:35:39.779662Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-11T15:35:39.780503Z 0 [Note] InnoDB: Number of pools: 1
2020-03-11T15:35:39.781534Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-03-11T15:35:39.805432Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-11T15:35:39.811489Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2020-03-11T15:35:39.811599Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-03-11T15:35:39.811690Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-03-11T15:35:39.811895Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2020-03-11T15:35:39.812001Z 0 [ERROR] Plugin 'InnoDB’ registration as a STORAGE ENGINE failed.
2020-03-11T15:35:39.812066Z 0 [ERROR] Failed to initialize builtin plugins.
2020-03-11T15:35:39.812127Z 0 [ERROR] Aborting
2020-03-11T15:35:39.812199Z 0 [Note] Binlog end
2020-03-11T15:35:39.812673Z 0 [Note] Shutting down plugin 'MyISAM’
2020-03-11T15:35:39.819977Z 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.
×