LINUX.ORG.RU

Периодически отваливается база на wordpress

 , ,


0

1

Добрый день

периодически пару раз в месяц отваливается база в WP. После перезапуска mysql все работает отлично. Насколько я понял данная ошибка возникает при выделении памяти(возможно она просто закончилась), что наталкивает на мысли о том что возможно стоит начать искать backdoor.

error.log:

2019-08-15T08:36:09.986630Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio                                     n (see documentation for more details).
2019-08-15T08:36:09.991850Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 8897 ...
2019-08-15T08:36:10.029787Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-08-15T08:36:10.029872Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-15T08:36:10.029878Z 0 [Note] InnoDB: Uses event mutexes
2019-08-15T08:36:10.029883Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-15T08:36:10.029888Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-15T08:36:10.029896Z 0 [Note] InnoDB: Using Linux native AIO
2019-08-15T08:36:10.031360Z 0 [Note] InnoDB: Number of pools: 1
2019-08-15T08:36:10.032852Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-08-15T08:36:10.041133Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-15T08:36:10.041530Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-08-15T08:36:10.041550Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-08-15T08:36:10.041560Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-15T08:36:10.041579Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-15T08:36:10.041588Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-15T08:36:10.041601Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-15T08:36:10.041611Z 0 [ERROR] Aborting

2019-08-15T08:36:10.041975Z 0 [Note] Binlog end
2019-08-15T08:36:10.048243Z 0 [Note] Shutting down plugin 'CSV'
2019-08-15T08:36:10.053326Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-08-15T08:36:10.561668Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio                                     n (see documentation for more details).
2019-08-15T08:36:10.565934Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 8910 ...
2019-08-15T08:36:10.598629Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-08-15T08:36:10.598693Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-15T08:36:10.598701Z 0 [Note] InnoDB: Uses event mutexes
2019-08-15T08:36:10.598707Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-15T08:36:10.598713Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-15T08:36:10.598719Z 0 [Note] InnoDB: Using Linux native AIO
2019-08-15T08:36:10.601565Z 0 [Note] InnoDB: Number of pools: 1
2019-08-15T08:36:10.611311Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-08-15T08:36:10.614672Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-15T08:36:10.617945Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-08-15T08:36:10.617989Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-08-15T08:36:10.617998Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-15T08:36:10.618024Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-15T08:36:10.618033Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-15T08:36:10.618043Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-15T08:36:10.618049Z 0 [ERROR] Aborting

2019-08-15T08:36:10.621249Z 0 [Note] Binlog end
2019-08-15T08:36:10.621315Z 0 [Note] Shutting down plugin 'CSV'
2019-08-15T08:36:10.621697Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-08-15T08:36:11.269169Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio                                     n (see documentation for more details).
2019-08-15T08:36:11.271401Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 8923 ...
2019-08-15T08:36:11.276712Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-08-15T08:36:11.276748Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-15T08:36:11.276771Z 0 [Note] InnoDB: Uses event mutexes
2019-08-15T08:36:11.276776Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-15T08:36:11.276780Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-15T08:36:11.276784Z 0 [Note] InnoDB: Using Linux native AIO
2019-08-15T08:36:11.277087Z 0 [Note] InnoDB: Number of pools: 1
2019-08-15T08:36:11.277220Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-08-15T08:36:11.279266Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-15T08:36:11.279307Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-08-15T08:36:11.279318Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-08-15T08:36:11.279323Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-15T08:36:11.279335Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-15T08:36:11.279340Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-15T08:36:11.279345Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-15T08:36:11.279348Z 0 [ERROR] Aborting

2019-08-15T08:36:11.282038Z 0 [Note] Binlog end
2019-08-15T08:36:11.282095Z 0 [Note] Shutting down plugin 'CSV'
2019-08-15T08:36:11.282475Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-08-15T08:36:11.713969Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio                                     n (see documentation for more details).
2019-08-15T08:36:11.716209Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 8936 ...
2019-08-15T08:36:11.721439Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-08-15T08:36:11.721464Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-15T08:36:11.721469Z 0 [Note] InnoDB: Uses event mutexes
2019-08-15T08:36:11.721474Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-15T08:36:11.721478Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-15T08:36:11.721483Z 0 [Note] InnoDB: Using Linux native AIO
2019-08-15T08:36:11.721790Z 0 [Note] InnoDB: Number of pools: 1
2019-08-15T08:36:11.721966Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-08-15T08:36:11.724198Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-15T08:36:11.724238Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-08-15T08:36:11.724246Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-08-15T08:36:11.724251Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-15T08:36:11.724264Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-15T08:36:11.724270Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-15T08:36:11.724275Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-15T08:36:11.724278Z 0 [ERROR] Aborting

2019-08-15T08:36:11.726022Z 0 [Note] Binlog end
2019-08-15T08:36:11.726087Z 0 [Note] Shutting down plugin 'CSV'
2019-08-15T08:36:11.726501Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-08-15T08:36:12.230931Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio                                     n (see documentation for more details).
2019-08-15T08:36:12.233082Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 8949 ...
2019-08-15T08:36:12.238642Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-08-15T08:36:12.238678Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-15T08:36:12.238683Z 0 [Note] InnoDB: Uses event mutexes
2019-08-15T08:36:12.238687Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-15T08:36:12.238691Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-15T08:36:12.238695Z 0 [Note] InnoDB: Using Linux native AIO
2019-08-15T08:36:12.239033Z 0 [Note] InnoDB: Number of pools: 1
2019-08-15T08:36:12.239179Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-08-15T08:36:12.241059Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-15T08:36:12.241110Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-08-15T08:36:12.241118Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-08-15T08:36:12.241123Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-15T08:36:12.241135Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-15T08:36:12.241140Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-15T08:36:12.241145Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-15T08:36:12.241149Z 0 [ERROR] Aborting

2019-08-15T08:36:12.243543Z 0 [Note] Binlog end
2019-08-15T08:36:12.243601Z 0 [Note] Shutting down plugin 'CSV'
2019-08-15T08:36:12.243915Z 0 [Note] /usr/sbin/mysqld: Shutdown complete



Последнее исправление: TesterTester (всего исправлений: 3)

Вам нужно настроить все сервисы на этом сервере, чтобы они не кушали слишком много памяти

goingUp ★★★★★
()
Ответ на: комментарий от goingUp

Еще вопрос, после блокировки ip я все ровно наблюдаю его пакеты в tcpdump, это нормально(кто работает ниже tcpdump или iptables)?

iptables -A INPUT -s IP -j DROP

TesterTester
() автор топика

Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

Cannot allocate memory for the buffer pool

На кофеварке запускаешь?

no-such-file ★★★★★
()
Ответ на: комментарий от TesterTester

Еще вопрос, после блокировки ip я все ровно наблюдаю его пакеты в tcpdump, это нормально(кто работает ниже tcpdump или iptables)?

так и должно быть

Rost ★★★★★
()
Ответ на: комментарий от Rost

Дешевый, но отваливается он даже без клиентов, система свободна полностью....

TesterTester
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.