The Ultimate Guide to High Availability with MariaDB

cannot start mariadb

You are viewing an old version of this question. View the current version here.

just stoping mariadb server for changing mysql password, when I want to start mariadb server again it was failed, when I check my mariadb status it shown like this:

mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: Active: failed (Result: timeout) since Thu 2017-11-16 11:25:08 WIB; 22min ago Process: 957 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START Process: 918 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCC Process: 2402 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS Process: 2315 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR Process: 2313 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START Process: 2312 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/ru Main PID: 2402 (code=exited, status=1/FAILURE) Status: "MariaDB server is down"

Nov 16 11:22:55 administrator-X202E systemd[1]: Starting MariaDB database server Nov 16 11:22:56 administrator-X202E mysqld[2402]: 2017-11-16 11:22:56 140698408298752 [Note] /usr/sbin/mysqld (mysqld 10.1.25-MariaDB-1) starting as process 2402 ... Nov 16 11:24:26 administrator-X202E systemd[1]: mariadb.service: Start operation timed out. Terminating. Nov 16 11:25:08 administrator-X202E systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Nov 16 11:25:08 administrator-X202E systemd[1]: Failed to start MariaDB database server. Nov 16 11:25:08 administrator-X202E systemd[1]: mariadb.service: Unit entered failed state. Nov 16 11:25:08 administrator-X202E systemd[1]: mariadb.service: Failed with result 'timeout'.

do I need to remove /usr/sbin/mysqld (mysqld 10.1.25-MariaDB-1) as indicate the status failure?

Answer Answered by Faustin Lammler in this comment.

Hi, I am not sure I understand, could you please explain us exactly the steps that leads to this?

Regards,

Faustin

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.