Can not start mariadb after reboot

Discussion in 'Installation/Configuration' started by pecka33, Sep 23, 2023.

  1. pecka33

    pecka33 Member

    Hello,
    i have a problem. I did import of database via phpmyadmin. Process still running - i import 1 gb database via command and after 2 hours process was not done. So i did reboot of my server, after i run it i can not start mariadb.
    When i check mariadb status i get error

    Code:
    root@samantos:~# systemctl status mariadb.service
    × mariadb.service - MariaDB 10.11.3 database server
         Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled)
        Drop-In: /etc/systemd/system/mysql.service.d
                 └─limits.conf
         Active: failed (Result: exit-code) since Sat 2023-09-23 12:26:02 CEST; 2min 42s ago
           Docs: man:mariadbd(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 2437 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
        Process: 2438 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
        Process: 2440 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl se>
        Process: 2514 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
       Main PID: 2514 (code=exited, status=1/FAILURE)
         Status: "MariaDB server is down"
            CPU: 129ms
    
    Sep 23 12:26:01 samantos mariadbd[2514]: *** duplicate variable name '' ?
    Sep 23 12:26:02 samantos mariadbd[2514]: failed to initialize System variables2023-09-23 12:26:02 0 [Note] Starting MariaDB 10.11.3-MariaDB source revision  as process>
    Sep 23 12:26:02 samantos mariadbd[2514]: *** duplicate variable name 'innodb_' ?
    Sep 23 12:26:02 samantos mariadbd[2514]: 2023-09-23 12:26:02 0 [ERROR] Plugin 'InnoDB' has conflicting system variables
    Sep 23 12:26:02 samantos mariadbd[2514]: 2023-09-23 12:26:02 0 [Note] Plugin 'FEEDBACK' is disabled.
    Sep 23 12:26:02 samantos mariadbd[2514]: 2023-09-23 12:26:02 0 [ERROR] Unknown/unsupported storage engine: InnoDB
    Sep 23 12:26:02 samantos mariadbd[2514]: 2023-09-23 12:26:02 0 [ERROR] Aborting
    Sep 23 12:26:02 samantos systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
    Sep 23 12:26:02 samantos systemd[1]: mariadb.service: Failed with result 'exit-code'.
    Sep 23 12:26:02 samantos systemd[1]: Failed to start mariadb.service - MariaDB 10.11.3 database server.
    
    Any idea please what could be wrong? Thank you.

    Maybe i should remove that database via command?
     
  2. pecka33

    pecka33 Member

    I solved it. I did reinstall of mariadb server and mysql
     
    Th0m likes this.

Share This Page