Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB mysql not start

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Max, May 23, 2019.

Tags:
  1. Max

    Max Member

    79
    4
    8
    Feb 17, 2018
    Ratings:
    +7
    Local Time:
    3:11 PM
    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit ?
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: i.e. 1.17.0
    • PHP Version Installed: 7.3.5
    • MariaDB MySQL Version Installed: 10.1.4
    • When was last time updated Centmin Mod code base ? :
    • Persistent Config:
      Code (Text):
      [*]LETSENCRYPT_DETECT='y'
      LIBRESSL_SWITCH='y'
      LIBRESSL_VERSION='2.7.4'
      NGINX_GEOIPTWOLITE='y'
      NGXDYNAMIC_GEOIPTWOLITE='y'
      NGXDYNAMIC_NGXPAGESPEED='y'
      NGINX_PAGESPEED='y'
      NGXDYNAMIC_BROTLI='y'
      NGINX_LIBBROTLI='y'
      WP_AUTOPTIMIZE_GZIP='y'
      ALERTEMAIL='[email protected]'
      #####################################################
      #NGINX_HPACK='y'
      #STRIPNGINX='y'                  # set 'y' to strip nginx binary to reduce size
      #####################################################
      
      
      

    • Hello
    mariadb not start
    Aria engine is not enabled or did not start.

    Code:
    systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.1.40 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, openfileslimit.conf, protecthome.conf
       Active: failed (Result: exit-code) since Do 2019-05-23 10:08:22 CEST; 7min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
      Process: 14929 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
      Process: 14658 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
      Process: 14657 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Main PID: 14929 (code=exited, status=1/FAILURE)
       Status: "MariaDB server is down"
    
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Waiting for purge to start
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 37764448225
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140094547687168 [Note] InnoDB: Dumping buffer pool(s) not yet started
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] Plugin 'FEEDBACK' is disabled.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Aborting
    Mai 23 10:08:22 happy.icoore.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Mai 23 10:08:22 happy.icoore.com systemd[1]: Failed to start MariaDB 10.1.40 database server.
    Mai 23 10:08:22 happy.icoore.com systemd[1]: Unit mariadb.service entered failed state.
    Mai 23 10:08:22 happy.icoore.com systemd[1]: mariadb.service failed.
    Sie haben neue Post in /var/spool/mail/root.
    
    Code:
    Mai 23 10:08:18 happy.icoore.com systemd[1]: Starting MariaDB 10.1.40 database server...
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] /usr/sbin/mysqld (mysqld 10.1.40-MariaDB) starting as process 14929 ...
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: Cannot find checkpoint record at LSN (196306,0x39775b)
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Plugin 'Aria' init function returned error.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: The InnoDB memory heap is disabled
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Compressed tables use zlib 1.2.7
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Using Linux native AIO
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Using SSE crc32 instructions
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Initializing buffer pool, size = 48.0M
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Completed initialization of buffer pool
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Highest supported file format is Barracuda.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: 128 rollback segment(s) are active.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB: Waiting for purge to start
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 37764448225
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140094547687168 [Note] InnoDB: Dumping buffer pool(s) not yet started
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [Note] Plugin 'FEEDBACK' is disabled.
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    Mai 23 10:08:19 happy.icoore.com mysqld[14929]: 2019-05-23 10:08:19 140095054756096 [ERROR] Aborting
    Mai 23 10:08:22 happy.icoore.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Mai 23 10:08:22 happy.icoore.com systemd[1]: Failed to start MariaDB 10.1.40 database server.
    Mai 23 10:08:22 happy.icoore.com systemd[1]: Unit mariadb.service entered failed state.
    Mai 23 10:08:22 happy.icoore.com systemd[1]: mariadb.service failed.
    

     
  2. Max

    Max Member

    79
    4
    8
    Feb 17, 2018
    Ratings:
    +7
    Local Time:
    3:11 PM
    close

    Hello

    i have
    rm -rf /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig

    and works
     
  3. eva2000

    eva2000 Administrator Staff Member

    42,743
    9,667
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,920
    Local Time:
    1:11 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    https://mariadb.com/kb/en/library/aria-faq/