MariaDB stop working

Discussion in 'Installation/Configuration' started by pecka33, Oct 11, 2021.

  1. pecka33

    pecka33 Member

    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?
     
  2. pecka33

    pecka33 Member

    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
     

Share This Page