На арендованном ВПС сервере из-за нехватки места стопнулся БД, я почистил логи и освободил 4 ГБ места из 100 ГБ, но сервис БД не запускается. Задача – починить БД!
из командной строки я набирал и получил следующую информацию:
root@seo-1:~# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@seo-1:~# systemctl status mariadb.service
● mariadb.service – MariaDB 10.3.34 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─nofile.conf
Active: failed (Result: exit-code) since Mon 2022-08-15 20:16:40 MSK; 35s ago
Docs: man:mysqld(8)
Process: 3429 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3430 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3432 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environme
Process: 3480 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 3480 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Aug 15 20:16:34 seo-1 systemd[1]: Starting MariaDB 10.3.34 database server...
Aug 15 20:16:34 seo-1 mysqld[3480]: 2022-08-15 20:16:34 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0+deb10u1) starting as process 3480 ...
Aug 15 20:16:34 seo-1 mysqld[3480]: 2022-08-15 20:16:34 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32189)
Aug 15 20:16:40 seo-1 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Aug 15 20:16:40 seo-1 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug 15 20:16:40 seo-1 systemd[1]: Failed to start MariaDB 10.3.34 database server.