Привет, ребят. Кто может подсказать как увеличить этот чертов лимит на открытые файлы? Значение 6400135 в настройках mariadb, вызывает падение сервиса без явных ошибок. Можно как-то сбросить request? Спасибо)
/usr/lib/systemd/system/mariadb.service
LimitNOFILE=100000
/etc/security/limits.conf
mysql soft nofile 700000
mysql hard nofile 200000
mysql soft memlock 100000
mysql hard memlock 200000
systemctl status mariadb
● mariadb.service - MariaDB 10.5.5 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2020-08-24 12:42:37 EEST; 4s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 5810 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 5811 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 5970 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 5970 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
авг 24 12:42:36 kibersalon-web systemd[1]: Starting MariaDB 10.5.5 database server...
авг 24 12:42:37 kibersalon-web mariadbd[5970]: 2020-08-24 12:42:37 0 [Note] /usr/bin/mariadbd (mysqld 10.5.5-MariaDB) starting as process 5970 ...
авг 24 12:42:37 kibersalon-web mariadbd[5970]: 2020-08-24 12:42:37 0 [Warning] Could not increase number of max_open_files to more than 100000 (request: 6400135)
авг 24 12:42:37 kibersalon-web mariadbd[5970]: 2020-08-24 12:42:37 0 [Warning] Changed limits: max_open_files: 100000 max_connections: 100 (was 100) table_cache: 49935 (was 400000)
авг 24 12:42:37 kibersalon-web systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
авг 24 12:42:37 kibersalon-web systemd[1]: mariadb.service: Failed with result 'exit-code'.
авг 24 12:42:37 kibersalon-web systemd[1]: Failed to start MariaDB 10.5.5 database server.
