MariaDB mysql not start

Max · May 23, 2019

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='morpheuss@zoho.com'
#####################################################
#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.

Max · May 23, 2019

close

Hello

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

and works

eva2000 · May 23, 2019

https://mariadb.com/kb/en/library/aria-faq/
When is it safe to remove old log files?
If you want to remove the Aria log files (aria_log.%) with rm or delete, then you must first shut down MariaDB cleanly (for example, with mysqladmin shutdown) before deleting the old files.

The same rules apply when upgrading MariaDB; When upgrading, first take down MariaDB in a clean way and then upgrade. This will allow you to remove the old log files if there are incompatible problems between releases.

Don't remove the aria_log_control file! This is not a log file, but a file that contains information about the Aria setup (current transaction id, unique id, next log file number etc.).

If you do, Aria will generate a new aria_log_control file at startup and will regard all old Aria files as files moved from another system. This means that they have to be 'zerofilled' before they can be used. This will happen automatically at next access of the Aria files, which can take some time if the files are big.

If this happens, you will see things like this in your mysqld.err file:
Code (Text):
[Note] Zerofilling moved table: '.\database\xxxx'
As part of zerofilling no vital data is removed.
Click to expand...

Log in / Register

Forums

Join the community today

MariaDB mysql not start

Max Member

Max Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Join the community today

MariaDB mysql not start

Max Member

Max Member

eva2000 Administrator Staff Member

.