Author Topic: Failed to start MariaDB 10.1.45 database server.  (Read 557 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Failed to start MariaDB 10.1.45 database server.
« on: February 18, 2021, 10:43:25 AM »
Hello, I have problem. I get this error when I write "systemctl restart mariadb" on putty ssh. "Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. After "systemctl status mariadb.service"
● mariadb.service - MariaDB 10.1.45 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
   Active: failed (Result: exit-code) since Thu 2021-02-18 05:18:57 EST; 6s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 23359 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 23348 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 23346 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 23359 (code=exited, status=1/FAILURE)

Feb 18 05:18:57 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
Feb 18 05:18:57 localhost.localdomain sh[23348]: [102B blob data]
Feb 18 05:18:57 localhost.localdomain sh[23348]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: [92B blob data]
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:18:57 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
Feb 18 05:18:57 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service failed.

and after "journalctl -xe"

Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300c5e30 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300e2d70 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300d45d0 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:28 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:28 localhost.localdomain sh[23624]: [102B blob data]
Feb 18 05:20:28 localhost.localdomain sh[23624]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: [92B blob data]
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:28 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:28 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:39 localhost.localdomain sh[23650]: [102B blob data]
Feb 18 05:20:39 localhost.localdomain sh[23650]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: [92B blob data]
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:39 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:40 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00.... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:41 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:42 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:43 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31... SRC=175.24.44.131 DST=213.238.178.89 LEN=60 TOS=0x00 PREC=0x00
Feb 18 05:20:44 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31:... SRC=92.63.197.61 DST=213.238.178.89 LEN=40 TOS=0x00 PREC=0x00 T
lines 1997-2047/2047 (END)

please help me

Offline
*****
Re: Failed to start MariaDB 10.1.45 database server.
« Reply #1 on: February 27, 2021, 09:55:04 AM »
Hi, try to check the mariadb log. You can also try to check the problem with the command below, but if you have no idea what that means and does better asking a system administrator to check and fix MariaDB.

Code: [Select]
su -s /bin/bash mysql -c '/usr/sbin/mysqld --defaults-file=/etc/my.cnf' &
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services