Not the answer you need? Try our search, browse our categories, or register and ask your own question!

Mysql pid not found during installation XtraDB Cluster

Sam AnikinSam Anikin Active Member Participant
Hi, everyone. I am trying to install Percona XtraDB Cluster on fresh Debian 10 as root. 
apt remove -y apparmorapt install -y wget gnupg2 lsb-release
But last command failed with error:

 
Apr 04 05:16:22 kan460 systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon...
Apr 04 05:16:22 kan460 /etc/init.d/mysql[8283]: MySQL PID not found, pid_file detected/guessed: /var/lib/mysql/kan460.pid
Apr 04 05:16:25 kan460 /etc/init.d/mysql[8396]: mysql ping failed
Apr 04 05:16:25 kan460 mysql[8240]: Starting MySQL (Percona XtraDB Cluster) database server: mysqld .Please take a look at the syslog. ... failed!
Apr 04 05:16:25 kan460 mysql[8240]:  failed!
Apr 04 05:16:25 kan460 systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Apr 04 05:16:25 kan460 systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 04 05:16:25 kan460 systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.

https://paste.pics/8JC6Q 
I tried to create symlinks /var/lib/mysql/mysql.pid -> /var/lib/mysql/kan460.pid but it didn't resolve my installation problem. I checked free memory and free space disk but there are no problems there

              total        used        free      shared  buff/cache   available
Mem:         899408      326596      155420        2744      417392      422872
Swap:       1046524        5132     1041392
Filesystem      Size  Used Avail Use% Mounted on
udev            425M     0  425M   0% /dev
tmpfs            88M  3.7M   85M   5% /run
/dev/sda2       6.4G  3.1G  3.0G  52% /
tmpfs           440M     0  440M   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           440M     0  440M   0% /sys/fs/cgroup
/dev/sda1       511M  5.1M  506M   1% /boot/efi
tmpfs            88M     0   88M   0% /run/user/0
[email protected]:~# uname -a
Linux kan460 4.19.0-8-amd64 #1 SMP Debian 4.19.98-1 (2020-01-26) x86_64 GNU/Linux
              total        used        free      shared  buff/cache   available
Mem:          878Mi       318Mi       151Mi       2.0Mi       407Mi       412Mi
Swap:         1.0Gi       5.0Mi       1.0Gi

Comments

  • Sam AnikinSam Anikin Active Member Participant
    edited April 5
    Something go wrong with formating, here correct command listing:
    apt remove -y apparmor
    apt update
    apt install -y wget gnupg2 lsb-release
    dpkg -i percona-release_latest.generic_all.deb
    percona-release enable original release
    apt update
    apt install -y percona-xtradb-cluster-full-57
  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Active Member Mentor
    Hi Sam Anikin
    Please share the error log file.
  • Evgeniy PatlanEvgeniy Patlan Percona Percona
    Hi.
    I tried to reproduce this issue.
    I assume you are talking about system message
    `debian-10 /etc/init.d/mysql[2465]: MySQL PID not found, pid_file detected/guessed: /var/run/mysqld/mysqld.pid`
    But pid file is in place and everything works well:
    "ls -la /var/run/mysqld/mysqld.pid  
    -rw-r----- 1 mysql mysql 5 Jun 24 10:41 /var/run/mysqld/mysqld.pid
    "
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.