MySQL Forums
Forum List  »  Install & Repo

MySQL stops every "X" days
Posted by: steve brining
Date: June 15, 2021 08:26AM

I am not sure what is causing this every "X" days MySQL just stops and I have to manually restart. What is causing this and how does one fix it..error log below;

2021-06-14T04:30:10.248268Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-14T04:30:10.261059Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.04.1) starting as process 16860 ...
2021-06-14T04:30:10.293329Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-14T04:30:10.293360Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14T04:30:10.293365Z 0 [Note] InnoDB: Uses event mutexes
2021-06-14T04:30:10.293369Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-14T04:30:10.293373Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14T04:30:10.293381Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-14T04:30:10.294264Z 0 [Note] InnoDB: Number of pools: 1
2021-06-14T04:30:10.298128Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-06-14T04:30:10.301109Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14T04:30:10.304481Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2021-06-14T04:30:10.304516Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-14T04:30:10.304525Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14T04:30:10.304540Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14T04:30:10.304547Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14T04:30:10.304557Z 0 [ERROR] Failed to initialize builtin plugins.
2021-06-14T04:30:10.304564Z 0 [ERROR] Aborting

2021-06-14T04:30:10.304646Z 0 [Note] Binlog end
2021-06-14T04:30:10.307602Z 0 [Note] Shutting down plugin 'CSV'
2021-06-14T04:30:10.307987Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-06-14T04:30:10.885190Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-14T04:30:10.886584Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.04.1) starting as process 16896 ...
2021-06-14T04:30:10.899229Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-14T04:30:10.899298Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14T04:30:10.899304Z 0 [Note] InnoDB: Uses event mutexes
2021-06-14T04:30:10.899310Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-14T04:30:10.899315Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14T04:30:10.899325Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-14T04:30:10.906473Z 0 [Note] InnoDB: Number of pools: 1
2021-06-14T04:30:10.907538Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-06-14T04:30:10.911363Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14T04:30:10.911418Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2021-06-14T04:30:10.911428Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-14T04:30:10.911435Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14T04:30:10.911446Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14T04:30:10.911452Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14T04:30:10.911459Z 0 [ERROR] Failed to initialize builtin plugins.
2021-06-14T04:30:10.911463Z 0 [ERROR] Aborting

2021-06-14T04:30:10.933494Z 0 [Note] Binlog end
2021-06-14T04:30:10.933569Z 0 [Note] Shutting down plugin 'CSV'
2021-06-14T04:30:10.933722Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-06-14T04:30:11.678413Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-14T04:30:11.680287Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.04.1) starting as process 16934 ...
2021-06-14T04:30:11.698566Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-14T04:30:11.698613Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14T04:30:11.698630Z 0 [Note] InnoDB: Uses event mutexes
2021-06-14T04:30:11.698635Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-14T04:30:11.698639Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14T04:30:11.698647Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-14T04:30:11.699383Z 0 [Note] InnoDB: Number of pools: 1
2021-06-14T04:30:11.700251Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-06-14T04:30:11.706239Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14T04:30:11.706285Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2021-06-14T04:30:11.706293Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-14T04:30:11.706298Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14T04:30:11.706307Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14T04:30:11.706313Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14T04:30:11.706319Z 0 [ERROR] Failed to initialize builtin plugins.
2021-06-14T04:30:11.706323Z 0 [ERROR] Aborting

2021-06-14T04:30:11.716759Z 0 [Note] Binlog end
2021-06-14T04:30:11.716850Z 0 [Note] Shutting down plugin 'CSV'
2021-06-14T04:30:11.717009Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-06-14T04:30:12.377603Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-14T04:30:12.379722Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.04.1) starting as process 16977 ...
2021-06-14T04:30:12.411755Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-14T04:30:12.411814Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14T04:30:12.411821Z 0 [Note] InnoDB: Uses event mutexes
2021-06-14T04:30:12.411827Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-14T04:30:12.411834Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14T04:30:12.411845Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-14T04:30:12.413523Z 0 [Note] InnoDB: Number of pools: 1
2021-06-14T04:30:12.414415Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-06-14T04:30:12.416766Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14T04:30:12.416841Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2021-06-14T04:30:12.416855Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-14T04:30:12.416863Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14T04:30:12.416876Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14T04:30:12.416884Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14T04:30:12.416894Z 0 [ERROR] Failed to initialize builtin plugins.
2021-06-14T04:30:12.416900Z 0 [ERROR] Aborting

2021-06-14T04:30:12.425759Z 0 [Note] Binlog end
2021-06-14T04:30:12.428254Z 0 [Note] Shutting down plugin 'CSV'
2021-06-14T04:30:12.428527Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-06-14T04:30:13.089650Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-14T04:30:13.099543Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.34-0ubuntu0.18.04.1) starting as process 17028 ...
2021-06-14T04:30:13.107063Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-14T04:30:13.107098Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14T04:30:13.107103Z 0 [Note] InnoDB: Uses event mutexes
2021-06-14T04:30:13.107107Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-14T04:30:13.107112Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14T04:30:13.107118Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-14T04:30:13.108792Z 0 [Note] InnoDB: Number of pools: 1
2021-06-14T04:30:13.113355Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-06-14T04:30:13.114883Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14T04:30:13.116006Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2021-06-14T04:30:13.116037Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-06-14T04:30:13.116045Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14T04:30:13.116055Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14T04:30:13.116061Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14T04:30:13.116067Z 0 [ERROR] Failed to initialize builtin plugins.
2021-06-14T04:30:13.116071Z 0 [ERROR] Aborting

2021-06-14T04:30:13.129859Z 0 [Note] Binlog end
2021-06-14T04:30:13.129983Z 0 [Note] Shutting down plugin 'CSV'
2021-06-14T04:30:13.130209Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Options: ReplyQuote


Subject
Written By
Posted
MySQL stops every "X" days
June 15, 2021 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.