Not the answer you need?
Register and ask your own question!

mysql stops on centos7 with no reason

appigatlaappigatla EntrantCurrent User Role Beginner
Hi,

Recently I have installed Percona-XtraDB-Cluster-56-5.6.26-25.12.1.el7.x86_64 on CentOS 7. It is a 3 node cluster and only one node takes writes. MySQL stops on nodes once in 2-3 days with not much info in the error log. Has anyone faced similar issue?

in /var/log/messages

Dec 13 03:53:40 ip-172-31-44-2 mysqld_safe: /usr/bin/mysqld_safe: line 185: 30682 Aborted nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --wsrep-provider=/usr/lib64/galera/libgalera_smm.so --log-error=/var/lib/mysql/mysqld.err --pid-file=/var/lib/mysql/mysqld.pid --wsrep_start_position=1172b3f6-9ca2-11e5-b5d1-0a6d2db9efe6:2336679 < /dev/null >> /var/lib/mysql/mysqld.err 2>&1
Dec 13 03:53:40 ip-172-31-44-2 mysqld_safe: 151213 03:53:40 mysqld_safe Number of processes running now: 0
Dec 13 03:53:40 ip-172-31-44-2 mysqld_safe: 151213 03:53:40 mysqld_safe WSREP: not restarting wsrep node automatically
Dec 13 03:53:40 ip-172-31-44-2 mysqld_safe: 151213 03:53:40 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
Dec 13 03:53:40 ip-172-31-44-2 mysql-systemd: /usr/bin/mysql-systemd: line 261: kill: (30682) - No such process
Dec 13 03:53:40 ip-172-31-44-2 mysql-systemd: ERROR! Failed to stop the server with PID: 30682 with 1 status
Dec 13 03:53:40 ip-172-31-44-2 systemd: mysql.service: control process exited, code=exited status=1
Dec 13 03:53:40 ip-172-31-44-2 mysql-systemd: /usr/bin/mysql-systemd: line 204: kill: (30682) - No such process
Dec 13 03:53:40 ip-172-31-44-2 mysql-systemd: WARNING: mysql already dead
Dec 13 03:53:40 ip-172-31-44-2 mysql-systemd: ERROR! Stale PID file: /var/lib/mysql/mysqld.pid
Dec 13 03:53:40 ip-172-31-44-2 systemd: mysql.service: control process exited, code=exited status=3
Dec 13 03:53:40 ip-172-31-44-2 systemd: Unit mysql.service entered failed state.


in mysqld.err
2015-12-13 03:53:40 30682 [Note] WSREP: view((empty))
2015-12-13 03:53:40 30682 [Note] WSREP: gcomm: closed
2015-12-13 03:53:40 30682 [Note] WSREP: /usr/sbin/mysqld: Terminated.
151213 03:53:40 mysqld_safe Number of processes running now: 0
151213 03:53:40 mysqld_safe WSREP: not restarting wsrep node automatically
151213 03:53:40 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
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.