Author Topic: Failed to start MariaDB 10.1.45 database server.  (Read 6272 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

Offline
*
Re: Failed to start MariaDB 10.1.45 database server.
« Reply #2 on: August 15, 2021, 12:27:00 PM »
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' &

Hi, I also have the same error, this command show me this log:
Quote
[root@serv1 ~]# su -s /bin/bash mysql -c '/usr/sbin/mysqld --defaults-file=/etc/                                                                                                             my.cnf' &
[1] 21590
[root@serv1 ~]# 2021-08-15 15:20:48 140705927891136 [Note] /usr/sbin/mysqld (mys                                                                                                             qld 10.2.40-MariaDB) starting as process 21591 ...
2021-08-15 15:20:48 140705927891136 [Warning] Could not increase number of max_o                                                                                                             pen_files to more than 1024 (request: 32183)
2021-08-15 15:20:48 140705927891136 [Warning] Changed limits: max_open_files: 10                                                                                                             24  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Mutexes and rw_locks use GCC                                                                                                              atomic builtins
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Uses event mutexes
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Compressed tables use zlib 1.                                                                                                             2.7
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Using Linux native AIO
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Number of pools: 1
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Initializing buffer pool, tot                                                                                                             al size = 128M, instances = 1, chunk size = 128M
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Completed initialization of b                                                                                                             uffer pool
2021-08-15 15:20:48 140705365317376 [Note] InnoDB: If the mysqld execution user                                                                                                              is authorized, page cleaner thread priority can be changed. See the man page of                                                                                                              setpriority().
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Highest supported file format                                                                                                              is Barracuda.
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Starting crash recovery from                                                                                                              checkpoint LSN=18841179001
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: 128 out of 128 rollback segme                                                                                                             nts are active.
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Creating shared tablespace fo                                                                                                             r temporary tables
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Setting file './ibtmp1' size                                                                                                              to 12 MB. Physically writing the file full; Please wait ...
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: File './ibtmp1' size is now 1                                                                                                             2 MB.
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: Waiting for purge to start
2021-08-15 15:20:48 140705927891136 [Note] InnoDB: 5.7.35 started; log sequence                                                                                                              number 18841179010
2021-08-15 15:20:48 140705356924672 [Note] InnoDB: Loading buffer pool(s) from /                                                                                                             var/lib/mysql/ib_buffer_pool
2021-08-15 15:20:48 140705927891136 [ERROR] mysqld: Can't lock aria control file                                                                                                              '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for                                                                                                              30 seconds
2021-08-15 15:20:48 140705356924672 [Note] InnoDB: Buffer pool(s) load completed                                                                                                              at 210815 15:20:48
[root@serv1 ~]# 2021-08-15 15:21:19 140705927891136 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2021-08-15 15:21:19 140705927891136 [ERROR] Plugin 'Aria' init function returned error.
2021-08-15 15:21:19 140705927891136 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-08-15 15:21:19 140705927891136 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-15 15:21:19 140705927891136 [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
2021-08-15 15:21:19 140705927891136 [ERROR] Aborting

Warning: Memory not freed: 520

Could you help me catch the problem?
« Last Edit: August 15, 2021, 12:39:40 PM by sergdev777 »