MySQL Forums
Forum List  »  General

Re: mysql stops working
Posted by: Yuriy Markiv
Date: December 28, 2019 11:26AM

Please see my /var/log/mysql/error.log below:

2019-12-28T05:31:21.922405Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T05:31:21.923680Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 1826 ...
2019-12-28T05:31:21.929650Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T05:31:21.929679Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T05:31:21.929685Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T05:31:21.929690Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T05:31:21.929694Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T05:31:21.929702Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T05:31:21.930486Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T05:31:21.932768Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T05:31:21.934301Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T05:31:21.934888Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T05:31:21.934918Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T05:31:21.934936Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T05:31:21.934956Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T05:31:21.934962Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T05:31:21.934968Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T05:31:21.934973Z 0 [ERROR] Aborting

2019-12-28T05:31:21.936751Z 0 [Note] Binlog end
2019-12-28T05:31:21.936801Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T05:31:21.937047Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T05:31:22.337428Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T05:31:22.338670Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 1839 ...
2019-12-28T05:31:22.342674Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T05:31:22.342699Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T05:31:22.342704Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T05:31:22.342709Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T05:31:22.342714Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T05:31:22.342722Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T05:31:22.342924Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T05:31:22.343021Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T05:31:22.344314Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T05:31:22.344342Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T05:31:22.344351Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T05:31:22.344357Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T05:31:22.344362Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T05:31:22.344366Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T05:31:22.344370Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T05:31:22.344374Z 0 [ERROR] Aborting

2019-12-28T05:31:22.344392Z 0 [Note] Binlog end
2019-12-28T05:31:22.344422Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T05:31:22.344640Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T05:31:22.834964Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T05:31:22.836185Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 1852 ...
2019-12-28T05:31:22.839785Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T05:31:22.839805Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T05:31:22.839820Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T05:31:22.839825Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T05:31:22.839830Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T05:31:22.839838Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T05:31:22.840030Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T05:31:22.840124Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T05:31:22.843245Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T05:31:22.843278Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T05:31:22.843290Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T05:31:22.843296Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T05:31:22.843302Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T05:31:22.843306Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T05:31:22.843311Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T05:31:22.843314Z 0 [ERROR] Aborting

2019-12-28T05:31:22.843334Z 0 [Note] Binlog end
2019-12-28T05:31:22.843374Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T05:31:22.843658Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T05:31:23.344138Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T05:31:23.345413Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 1865 ...
2019-12-28T05:31:23.349137Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T05:31:23.349158Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T05:31:23.349164Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T05:31:23.349169Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T05:31:23.349173Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T05:31:23.349182Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T05:31:23.349372Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T05:31:23.349465Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T05:31:23.350729Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T05:31:23.350756Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T05:31:23.350764Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T05:31:23.350770Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T05:31:23.350776Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T05:31:23.350780Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T05:31:23.350784Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T05:31:23.350787Z 0 [ERROR] Aborting

2019-12-28T05:31:23.350807Z 0 [Note] Binlog end
2019-12-28T05:31:23.350836Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T05:31:23.351271Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T05:31:23.835180Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T05:31:23.836392Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 1878 ...
2019-12-28T05:31:23.840004Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T05:31:23.840025Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T05:31:23.840030Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T05:31:23.840035Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T05:31:23.840039Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T05:31:23.840047Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T05:31:23.840242Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T05:31:23.840331Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T05:31:23.841791Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T05:31:23.841828Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T05:31:23.841837Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T05:31:23.841843Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T05:31:23.841848Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T05:31:23.841852Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T05:31:23.841856Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T05:31:23.841860Z 0 [ERROR] Aborting

2019-12-28T05:31:23.841878Z 0 [Note] Binlog end
2019-12-28T05:31:23.842102Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T05:31:23.842155Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:01:11.757098Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:01:11.758391Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2471 ...
2019-12-28T06:01:11.775194Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:01:11.775218Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:01:11.775225Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:01:11.775230Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:01:11.775235Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:01:11.775244Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:01:11.775434Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:01:11.775553Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:01:11.776824Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:01:11.776862Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:01:11.776877Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:01:11.776886Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:01:11.776895Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:01:11.776902Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:01:11.776926Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:01:11.776929Z 0 [ERROR] Aborting

2019-12-28T06:01:11.777619Z 0 [Note] Binlog end
2019-12-28T06:01:11.777658Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:01:11.777888Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:01:12.423977Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:01:12.425266Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2489 ...
2019-12-28T06:01:12.428849Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:01:12.428872Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:01:12.428878Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:01:12.428883Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:01:12.428888Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:01:12.428896Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:01:12.429124Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:01:12.429219Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:01:12.430498Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:01:12.430526Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:01:12.430536Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:01:12.430542Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:01:12.430548Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:01:12.430558Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:01:12.430563Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:01:12.430567Z 0 [ERROR] Aborting

2019-12-28T06:01:12.430583Z 0 [Note] Binlog end
2019-12-28T06:01:12.430611Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:01:12.430833Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:01:12.837899Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:01:12.839139Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2502 ...
2019-12-28T06:01:12.842808Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:01:12.842832Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:01:12.842837Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:01:12.842842Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:01:12.842847Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:01:12.842855Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:01:12.843050Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:01:12.843142Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:01:12.844594Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:01:12.844627Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:01:12.844636Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:01:12.844641Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:01:12.844647Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:01:12.844651Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:01:12.844655Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:01:12.844659Z 0 [ERROR] Aborting

2019-12-28T06:01:12.844680Z 0 [Note] Binlog end
2019-12-28T06:01:12.844719Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:01:12.845004Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:01:13.336437Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:01:13.337744Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2515 ...
2019-12-28T06:01:13.341461Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:01:13.341484Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:01:13.341489Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:01:13.341494Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:01:13.341498Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:01:13.341506Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:01:13.341695Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:01:13.341785Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:01:13.343087Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:01:13.343116Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:01:13.343124Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:01:13.343130Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:01:13.343135Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:01:13.343139Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:01:13.343143Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:01:13.343147Z 0 [ERROR] Aborting

2019-12-28T06:01:13.343166Z 0 [Note] Binlog end
2019-12-28T06:01:13.343193Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:01:13.343382Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:01:13.835823Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:01:13.837065Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2528 ...
2019-12-28T06:01:13.840819Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:01:13.840843Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:01:13.840848Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:01:13.840853Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:01:13.840857Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:01:13.840866Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:01:13.841082Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:01:13.841178Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:01:13.842518Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:01:13.842547Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:01:13.842555Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:01:13.842561Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:01:13.842566Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:01:13.842570Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:01:13.842574Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:01:13.842578Z 0 [ERROR] Aborting

2019-12-28T06:01:13.842598Z 0 [Note] Binlog end
2019-12-28T06:01:13.842627Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:01:13.842816Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:05:11.378549Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:05:11.379850Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2600 ...
2019-12-28T06:05:11.384370Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:05:11.384399Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:05:11.384408Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:05:11.384413Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:05:11.384418Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:05:11.384427Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:05:11.384620Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:05:11.384713Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:05:11.394139Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:05:11.394185Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:05:11.394200Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:05:11.394211Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:05:11.394222Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:05:11.394229Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:05:11.394237Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:05:11.394244Z 0 [ERROR] Aborting

2019-12-28T06:05:11.394264Z 0 [Note] Binlog end
2019-12-28T06:05:11.394304Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:05:11.394523Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:05:11.815669Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:05:11.816917Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2618 ...
2019-12-28T06:05:11.820472Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:05:11.820495Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:05:11.820501Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:05:11.820516Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:05:11.820522Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:05:11.820530Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:05:11.820719Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:05:11.820808Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:05:11.822043Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:05:11.822071Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:05:11.822080Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:05:11.822086Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:05:11.822091Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:05:11.822095Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:05:11.822099Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:05:11.822103Z 0 [ERROR] Aborting

2019-12-28T06:05:11.822120Z 0 [Note] Binlog end
2019-12-28T06:05:11.822147Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:05:11.822330Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:05:12.335733Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:05:12.336997Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2631 ...
2019-12-28T06:05:12.340557Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:05:12.340581Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:05:12.340586Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:05:12.340591Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:05:12.340595Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:05:12.340603Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:05:12.340793Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:05:12.340885Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:05:12.342176Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:05:12.342207Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:05:12.342216Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:05:12.342222Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:05:12.342227Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:05:12.342231Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:05:12.342236Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:05:12.342239Z 0 [ERROR] Aborting

2019-12-28T06:05:12.342258Z 0 [Note] Binlog end
2019-12-28T06:05:12.342287Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:05:12.342467Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:05:12.836909Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:05:12.838212Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2644 ...
2019-12-28T06:05:12.841983Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:05:12.842013Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:05:12.842021Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:05:12.842029Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:05:12.842036Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:05:12.842048Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:05:12.842267Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:05:12.842359Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:05:12.843581Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:05:12.843614Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:05:12.843623Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:05:12.843628Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:05:12.843634Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:05:12.843638Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:05:12.843642Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:05:12.843645Z 0 [ERROR] Aborting

2019-12-28T06:05:12.843665Z 0 [Note] Binlog end
2019-12-28T06:05:12.843696Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:05:12.843891Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:05:13.335979Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:05:13.337236Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 2657 ...
2019-12-28T06:05:13.340848Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:05:13.340873Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:05:13.340878Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:05:13.340883Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:05:13.340888Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:05:13.340896Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:05:13.341106Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:05:13.341197Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:05:13.342464Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:05:13.342492Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-12-28T06:05:13.342501Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-12-28T06:05:13.342506Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-28T06:05:13.342512Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-28T06:05:13.342516Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-28T06:05:13.342520Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-28T06:05:13.342524Z 0 [ERROR] Aborting

2019-12-28T06:05:13.342543Z 0 [Note] Binlog end
2019-12-28T06:05:13.342571Z 0 [Note] Shutting down plugin 'CSV'
2019-12-28T06:05:13.342800Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-12-28T06:10:56.855237Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-28T06:10:56.856529Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.18.04.1) starting as process 830 ...
2019-12-28T06:10:56.862926Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-12-28T06:10:56.862951Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-28T06:10:56.862957Z 0 [Note] InnoDB: Uses event mutexes
2019-12-28T06:10:56.862962Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-12-28T06:10:56.862967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-28T06:10:56.862975Z 0 [Note] InnoDB: Using Linux native AIO
2019-12-28T06:10:56.864244Z 0 [Note] InnoDB: Number of pools: 1
2019-12-28T06:10:56.874974Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-12-28T06:10:56.876237Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-28T06:10:56.945774Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-28T06:10:56.948220Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-12-28T06:10:57.035102Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-12-28T06:10:57.053354Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 147061592
2019-12-28T06:10:57.053400Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 147061601
2019-12-28T06:10:57.053410Z 0 [Note] InnoDB: Database was not shutdown normally!
2019-12-28T06:10:57.053418Z 0 [Note] InnoDB: Starting crash recovery.
2019-12-28T06:10:57.735182Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-12-28T06:10:57.735209Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-28T06:10:57.735254Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-28T06:10:57.767486Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-12-28T06:10:57.768224Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-12-28T06:10:57.768236Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-12-28T06:10:57.768466Z 0 [Note] InnoDB: Waiting for purge to start
2019-12-28T06:10:57.818698Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 147061601
2019-12-28T06:10:57.818931Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-12-28T06:10:57.821210Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-12-28T06:10:57.862615Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-12-28T06:10:57.862636Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2019-12-28T06:10:57.862646Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2019-12-28T06:10:57.862671Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2019-12-28T06:10:57.876886Z 0 [Note] InnoDB: Buffer pool(s) load completed at 191228 8:10:57
2019-12-28T06:10:57.956854Z 0 [Note] Event Scheduler: Loaded 0 events
2019-12-28T06:10:57.957221Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.27-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

Options: ReplyQuote


Subject
Written By
Posted
December 28, 2019 10:17AM
December 28, 2019 11:06AM
Re: mysql stops working
December 28, 2019 11:26AM
December 28, 2019 12:04PM
December 28, 2019 12:18PM
December 29, 2019 11:59AM
December 31, 2019 08:12AM
December 31, 2019 10:40AM
January 01, 2020 09:13AM
January 01, 2020 11:34AM
January 01, 2020 04:35PM
January 01, 2020 07:46PM


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.