MYSQL/ mariadb.service failed

Hello Team ,
I am getting an error messages please advise how to proceed with this.

[root@frsellaappesc12 data]# sudo mysqld_safe --skip-grant-tables --skip-networking
220331 05:10:25 mysqld_safe Logging to ‘//data/frsellaappesc12.err’.
220331 05:10:25 mysqld_safe Starting mysqld daemon with databases from //data

[root@frsellaappesc12 data]# ps -ef |grep mysql
root 3452 19948 0 05:11 pts/0 00:00:00 grep --color=auto mysql
tomcat 28912 1 13 mars14 ? 2-05:15:43 /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64/jre/bin/java -Dmariadb_connectionString_escmdata=jdbc:mysql://localhost/escmdata_hermes?useSSL=false -Dmariadb_connectionString_escmparameters=jdbc:mysql://localhost/escmparameters_hermes?useSSL=false -Dmariadb_connectionString_habilitation=jdbc:mysql://localhost/habilitation_hermes?useSSL=false -Dmariadb_connectionString_portail=jdbc:mysql://localhost/portail_hermes?useSSL=false -Dmariadb_password=K09a2@eR$fN3mqPXV$69KjTHe -Dmariadb_username=escm -Dws_po_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/purchaseordermanagement/corp/v1 -Dws_pkl_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/packinglistmanagement/corp/v1 -Dws_ts_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/controlsheetmanagement/v1 -Dws_login=esb_r_ws_esc -Dws_password=64a4b98f9b -Xms512m -Xmx4096m -XX:+UseParallelGC -server -classpath /opt/rh/jws5/root/usr/share/tomcat/bin/bootstrap.jar:/opt/rh/jws5/root/usr/share/tomcat/bin/tomcat-juli.jar -Dcatalina.base=/opt/rh/jws5/root/usr/share/tomcat -Dcatalina.home=/opt/rh/jws5/root/usr/share/tomcat -Djava.endorsed.dirs= -Djava.io.tmpdir=/var/opt/rh/jws5/cache/tomcat/temp -Djava.util.logging.config.file=/opt/rh/jws5/root/usr/share/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.library.path=/opt/rh/jws5/root/usr/lib64 org.apache.catalina.startup.Bootstrap start

[root@frsellaappesc12 data]# mysql -u root
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

[root@frsellaappesc12 data]# systemctl start mysql
Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.
[root@frsellaappesc12 data]#

I found the below process are running for TCP

[root@frsellaappesc12 data]# lsof -i:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 28912 tomcat 70u IPv6 401284919 0t0 TCP localhost:35802->localhost:mysql (CLOSE_WAIT)
java 28912 tomcat 71u IPv6 400571341 0t0 TCP localhost:58816->localhost:mysql (CLOSE_WAIT)
java 28912 tomcat 72u IPv6 400590128 0t0 TCP localhost:58844->localhost:mysql (CLOSE_WAIT)

Regards

Prashant

Hi @pkelaska

Can you look in your MySQL error log as that is where you will see the reason why your MySQL instance did not successfully start.

You may also want to start your daemon like this:

sudo mysqld --skip-grant-tables --skip-networking
1 Like

After execute this command its getting aborted

1 Like