hello, i didnt do any changes but my mariadbserver stop working, in systemctl status for it i get Code: root@vm28069:~# systemctl status mariadb.service ● mariadb.service - MariaDB 10.5.12 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2021-10-11 09:21:07 CEST; 30s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 3712 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 3713 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 3714 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_> Process: 3779 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7) Main PID: 3779 (code=exited, status=7) Status: "MariaDB server is down" CPU: 504ms Oct 11 09:21:07 vm28069 systemd[1]: Starting MariaDB 10.5.12 database server... Oct 11 09:21:07 vm28069 mariadbd[3779]: 2021-10-11 9:21:07 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.12-MariaDB-0+deb11u1-log) starting as process 3779 ... Oct 11 09:21:07 vm28069 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING Oct 11 09:21:07 vm28069 systemd[1]: mariadb.service: Failed with result 'exit-code'. Oct 11 09:21:07 vm28069 systemd[1]: Failed to start MariaDB 10.5.12 database server. root@vm28069:~# any idea why?
Solved, in my etc/mysql/my.cnf a remove lines log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes