Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

mysql ping is not working with service mysql start command in Ubuntu 18.04

Description

vagrant@pxcnode2:~$ sudo mysqladmin shutdown vagrant@pxcnode2:~$ sudo mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) vagrant@pxcnode2:~$ sudo service mysql start Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. vagrant@pxcnode2:~$ sudo service mysql status ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql; generated) Active: failed (Result: exit-code) since Wed 2020-03-11 17:09:38 UTC; 7s ago Docs: man:systemd-sysv-generator(8) Process: 15366 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS) Process: 23957 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) Tasks: 41 (limit: 3498) CGroup: /system.slice/mysql.service ├─24003 /bin/sh /usr/bin/mysqld_safe └─24357 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/u Mar 11 17:09:25 pxcnode2 systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon... Mar 11 17:09:25 pxcnode2 mysql[23957]: * Starting MySQL (Percona XtraDB Cluster) database server mysqld Mar 11 17:09:27 pxcnode2 mysql[23957]: * State transfer in progress, setting sleep higher mysqld Mar 11 17:09:38 pxcnode2 mysql[23957]: * Please take a look at the syslog. Mar 11 17:09:38 pxcnode2 mysql[23957]: ...fail! Mar 11 17:09:38 pxcnode2 systemd[1]: mysql.service: Control process exited, code=exited status=1 Mar 11 17:09:38 pxcnode2 systemd[1]: mysql.service: Failed with result 'exit-code'. Mar 11 17:09:38 pxcnode2 systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon. vagrant@pxcnode2:~$ vagrant@pxcnode2:~$ vagrant@pxcnode2:~$ sudo mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.7.28-31-57-log Percona XtraDB Cluster (GPL), Release rel31, Revision ef2fa88, WSREP version 31.41, wsrep_31.41 Copyright (c) 2009-2019 Percona LLC and/or its affiliates Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ]q -> \q Bye vagrant@pxcnode2:~$ vagrant@pxcnode2:~$ sudo tail -10 /var/log/syslog Mar 11 17:09:25 vagrant systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon... Mar 11 17:09:25 vagrant mysql[23957]: * Starting MySQL (Percona XtraDB Cluster) database server mysqld Mar 11 17:09:25 vagrant /etc/init.d/mysql[24002]: MySQL PID not found, pid_file detected/guessed: /var/lib/mysql/pxcnode2.pid Mar 11 17:09:27 vagrant mysql[23957]: * State transfer in progress, setting sleep higher mysqld Mar 11 17:09:38 vagrant /etc/init.d/mysql[24957]: mysql ping failed Mar 11 17:09:38 vagrant mysql[23957]: * Please take a look at the syslog. Mar 11 17:09:38 vagrant mysql[23957]: ...fail! Mar 11 17:09:38 vagrant systemd[1]: mysql.service: Control process exited, code=exited status=1 Mar 11 17:09:38 vagrant systemd[1]: mysql.service: Failed with result 'exit-code'. Mar 11 17:09:38 vagrant systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon. vagrant@pxcnode2:~$

PXC installation command

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb sudo percona-release enable original sudo apt update -y sudo apt install -y percona-xtradb-cluster-server-5.7

Environment

None

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:27 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

Sveta Smirnova March 3, 2023 at 3:37 PM

It needs to be properly re-verified before closing.

Won't Do

Details

Assignee

Reporter

Components

Affects versions

Priority

Smart Checklist

Created March 11, 2020 at 5:14 PM
Updated March 4, 2025 at 9:27 PM
Resolved March 4, 2025 at 9:27 PM
Configure

Flag notifications