Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Mysql pid not found during installation XtraDB Cluster

Sam AnikinSam Anikin Current User Role Novice
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 Current User Role Novice
    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 Current User Role Patron
    Hi Sam Anikin
    Please share the error log file.
  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    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.