Tuesday, January 4, 2022

[SOLVED] Mariadb doesn't starts. Control process Exited

Issue

I am trying to start mariadb with systemctl start mariadb also tried using sudo along.

This is what it says

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

I saw this at many places but nothing helped.

It fails, I removed, installed again, nothing happened.

This is a part of /var/log/messages

Jun 17 18:03:09 controller systemd: Starting MariaDB 10.1 database
server... 
Jun 17 18:03:09 controller mysqld: 2016-06-17 18:03:09 140477178509440
       [Note] /usr/libexec/mysqld (mysqld 10.1.12-MariaDB) starting as process 120408 ... 
Jun 17 18:03:12 controller systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE 
Jun 17 18:04:13 controller systemd: mariadb.service: control process exited, code=exited status=3 
Jun 17 18:04:13 controller systemd: Failed to start MariaDB 10.1 database server. 
Jun 17 18:04:13 controller systemd: Unit mariadb.service entered failed state. 
Jun 17 18:04:13 controller systemd: mariadb.service failed.

I am really new to CentOS and mariadb, so I don't know how to proceed.

EDIT

The mariadb.log says

2016-06-17 19:24:39 140652810123392 [Note] Server socket created on IP: '::'.
2016-06-17 19:24:39 140652810123392 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2016-06-17 19:24:39 140652810123392 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2016-06-17 19:24:39 140652810123392 [ERROR] Aborting

This is my my.cnf

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# This group is read by the server
#
[mysqld]
port=5555
bind-address = 10.23.77.68
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

I tried adding a line in my.cnf 

port=5555

Didn't help, mariadb.log says the same thing as I have mentioned earlier.


Solution

fuser -k 3306/tcp will solve the probem. -k is to Kill processes accessing the file.



Answered By - Bhavya Arora
at