LINUX.ORG.RU
ФорумAdmin

Циклическая перезагрузка MariaDB 10.3

 , ,


0

1

Стоит панель Ispmanager 6 lite, по какой-то причине mariadb сама завершает работу, а потом панель ее запускает. Система Centos 7 стоит Hiper-v 2019, 32 ГБ выделено из 128, такой же конфиг на железной машине и там таких проблем не только mariadb 10.4 и 128 ГБ, судя mysqltuner памяти хватает.

внутри my.cnf

[mysqld]
sql-mode =
collation-server = utf8_general_ci
character-set-server = utf8
local-infile = 0
log-error = /var/log/mariadb/mariadb.log
pid-file = /var/run/mysqld/mysqld.pid
datadir = /var/lib/mysql
port=3306
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
bind-address = 127.0.0.1
open_files_limit=32768
general_log = 1
general_log_file = /var/lib/mysql/mysql.log

tmpdir = /dev/shm
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 32M
table_open_cache = 8192
sort_buffer_size = 2M
read_buffer_size = 512K
read_rnd_buffer_size = 1M
net_buffer_length = 64K
thread_stack = 512K
query_cache_size = 64M
query_cache_limit = 4M
thread_cache_size = 256
join_buffer_size = 2M
max_connections = 128
tmp_table_size = 1024M
max_heap_table_size = 2048M
wait_timeout = 300

innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_per_table = 1
innodb_log_group_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 16G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 1024M
innodb_log_buffer_size = 32M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_flush_log_at_timeout = 5
innodb_thread_concurrency = 0
innodb_open_files = 8192
innodb_io_capacity = 50000
innodb_read_io_threads = 32
innodb_write_io_threads = 32
innodb_lock_wait_timeout = 50
innodb_adaptive_hash_index = 0

slow_query_log = 0
slow_query_log_file = /var/lib/mysql/mysql_slow.log
long_query_time = 0.1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open_files_limit = 32768
log-error = /var/log/mariadb/mariadb.log
pid-file = /var/run/mariadb/mariadb.pid

!includedir /etc/my.cnf.d

внутри mariadb.log

2022-06-01 22:41:51 141 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:41:53 143 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:41:54 145 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:41:58 148 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:00 150 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:02 152 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:04 154 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:25 157 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:28 159 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:42:43 169 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:44:10 179 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:44:15 181 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:44:45 186 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:44:52 189 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:45:01 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-06-01 22:45:01 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-06-01 22:45:01 0 [Note] InnoDB: FTS optimize thread exiting.
2022-06-01 22:45:01 0 [Note] InnoDB: Starting shutdown…
2022-06-01 22:45:01 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-06-01 22:45:01 0 [Note] InnoDB: Buffer pool(s) dump completed at 220601 22:45:01
2022-06-01 22:45:04 0 [Note] InnoDB: Removed temporary tablespace data file: «ibtmp1»
2022-06-01 22:45:04 0 [Note] InnoDB: Shutdown completed; log sequence number 755146112; transaction id 65655
2022-06-01 22:45:04 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-06-01 22:45:04 0 [Note] InnoDB: Using Linux native AIO
2022-06-01 22:45:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-01 22:45:04 0 [Note] InnoDB: Uses event mutexes
2022-06-01 22:45:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-01 22:45:04 0 [Note] InnoDB: Number of pools: 1 2022-06-01 22:45:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-01 22:45:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M
2022-06-01 22:45:05 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-01 22:45:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-01 22:45:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-01 22:45:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-01 22:45:05 0 [Note] InnoDB: Setting file ‘/var/lib/mysql/ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2022-06-01 22:45:05 0 [Note] InnoDB: File ‘/var/lib/mysql/ibtmp1’ size is now 12 MB.
2022-06-01 22:45:05 0 [Note] InnoDB: Waiting for purge to start
2022-06-01 22:45:05 0 [Note] InnoDB: 10.3.35 started; log sequence number 755146112; transaction id 65656
2022-06-01 22:45:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-06-01 22:45:05 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2022-06-01 22:45:05 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2022-06-01 22:45:05 0 [Note] Reading of all Master_info entries succeeded
2022-06-01 22:45:05 0 [Note] Added new Master_info '' to hash table
2022-06-01 22:45:05 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.3.35-MariaDB-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server 2022-06-01 22:45:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220601 22:45:08
2022-06-01 22:46:07 14 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:49:07 34 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:49:39 37 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
2022-06-01 22:50:07 39 [Warning] Access denied for user ''@‘localhost’ (using password: NO)


Ответ на: комментарий от Dimez
2022-06-01 22:41:51 141 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 

2022-06-01 22:41:53 143 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:41:54 145 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:41:58 148 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:00 150 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:02 152 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:04 154 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:25 157 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:28 159 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:42:43 169 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:44:10 179 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:44:15 181 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:44:45 186 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:44:52 189 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:45:01 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 
2022-06-01 22:45:01 0 [Note] Event Scheduler: Purging the queue. 0 events 
2022-06-01 22:45:01 0 [Note] InnoDB: FTS optimize thread exiting. 
2022-06-01 22:45:01 0 [Note] InnoDB: Starting shutdown… 
2022-06-01 22:45:01 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 
2022-06-01 22:45:01 0 [Note] InnoDB: Buffer pool(s) dump completed at 220601 22:45:01 
2022-06-01 22:45:04 0 [Note] InnoDB: Removed temporary tablespace data file: «ibtmp1» 
2022-06-01 22:45:04 0 [Note] InnoDB: Shutdown completed; log sequence number 755146112; transaction id 65655 
2022-06-01 22:45:04 0 [Note] /usr/sbin/mysqld: Shutdown complete 
2022-06-01 22:45:04 0 [Note] InnoDB: Using Linux native AIO 
2022-06-01 22:45:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
2022-06-01 22:45:04 0 [Note] InnoDB: Uses event mutexes 
2022-06-01 22:45:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 
2022-06-01 22:45:04 0 [Note] InnoDB: Number of pools: 1 
2022-06-01 22:45:04 0 [Note] InnoDB: Using SSE2 crc32 instructions 
2022-06-01 22:45:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M 
2022-06-01 22:45:05 0 [Note] InnoDB: Completed initialization of buffer pool 
2022-06-01 22:45:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 
2022-06-01 22:45:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 
2022-06-01 22:45:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables 
2022-06-01 22:45:05 0 [Note] InnoDB: Setting file ‘/var/lib/mysql/ibtmp1’ size to 12 MB. Physically writing the file full; Please wait … 
2022-06-01 22:45:05 0 [Note] InnoDB: File ‘/var/lib/mysql/ibtmp1’ size is now 12 MB. 
2022-06-01 22:45:05 0 [Note] InnoDB: Waiting for purge to start 
2022-06-01 22:45:05 0 [Note] InnoDB: 10.3.35 started; log sequence number 755146112; transaction id 65656 
2022-06-01 22:45:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 
2022-06-01 22:45:05 0 [Note] Plugin ‘FEEDBACK’ is disabled. 
2022-06-01 22:45:05 0 [Note] Server socket created on IP: ‘127.0.0.1’. 
2022-06-01 22:45:05 0 [Note] Reading of all Master_info entries succeeded 
2022-06-01 22:45:05 0 [Note] Added new Master_info '' to hash table 
2022-06-01 22:45:05 0 [Note] /usr/sbin/mysqld: ready for connections. Version: ‘10.3.35-MariaDB-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server 
2022-06-01 22:45:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220601 22:45:08 
2022-06-01 22:46:07 14 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:49:07 34 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:49:39 37 [Warning] Access denied for user ''@‘localhost’ (using password: NO) 
2022-06-01 22:50:07 39 [Warning] Access denied for user ''@‘localhost’ (using password: NO)
Busf
()
Ответ на: комментарий от antech

В общем сам разобрался видимо из-за того что обновлял mariadb c 5.5 до 10.3 слетела настройка в панели ispmanger 6

Мониторинг и журналы -> Службы -> Параметры службы для мониторинга - mariadb -> Имя процесса было пусто заменил на mysqld

так было на другом сервер где тоже mariadb

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