# Mysql is failed but synced **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [October 19, 2016, 6:32am UTC](https://forums.percona.com/t/mysql-is-failed-but-synced/5160 "2016-10-19T06:32:06Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![slence](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@slence](https://forums.percona.com/u/slence)\ **Post date:** [October 19, 2016, 6:32am UTC](https://forums.percona.com/t/mysql-is-failed-but-synced/5160/1 "2016-10-19T06:32:06Z")
HI, my problem (or not) is: /etc/init.d/mysql status ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: timeout) since Qua 2016-10-19 12:36:56 WEST; 23min ago Out 19 12:36:56 systemd[1]: mysql.service start operation timed out. Terminating. Out 19 12:36:56 systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon. Out 19 12:36:56 systemd[1]: Unit mysql.service entered failed state. Out 19 12:36:58 mysql[30262]: Starting MySQL (Percona XtraDB Cluster) database server: mysqld . .State transf… . . . Hint: Some lines were ellipsized, use -l to show in full. But the node is synced with other 2. 2016-10-19 12:39:11 30915 [Note] WSREP: 2.0 (node5): State transfer from 0.0 () complete. 2016-10-19 12:39:11 30915 [Note] WSREP: Shifting JOINER → JOINED (TO: 17959590) 2016-10-19 12:39:11 30915 [Note] WSREP: Member 2.0 (node5) synced with group. 2016-10-19 12:39:11 30915 [Note] WSREP: Shifting JOINED → SYNCED (TO: 17959590) 2016-10-19 12:39:11 30915 [Note] WSREP: Synchronized with group, ready for connections What’s happening here? Thanks. ---
**Author:** ![krunalbauskar](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@krunalbauskar](https://forums.percona.com/u/krunalbauskar)\ **Post date:** [November 9, 2016, 1:21am UTC](https://forums.percona.com/t/mysql-is-failed-but-synced/5160/2 "2016-11-09T01:21:53Z")
Can you share the complete log file for the said node. ---
**Author:** ![MasterCATZ](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@MasterCATZ](https://forums.percona.com/u/MasterCATZ)\ **Post date:** [November 19, 2016, 1:56pm UTC](https://forums.percona.com/t/mysql-is-failed-but-synced/5160/3 "2016-11-19T13:56:56Z")
I am having the same thing the Primary node says its failed … but its running … all other nodes come back as actively running I am assuming this is from syslogs first run ? on one note can some code be put in place to remove the pid ? - The server quit without updating PID file (/var/lib/mysql/ubuntuServer.pid). Nov 19 16:30:20 ubuntuServer mysql[620]: …fail! its a pain manually deleting the pid to restart … on main node /etc/init.d/mysql bootstrap-pxc root@ubuntuServer:/var/lib/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: failed (Result: exit-code) since Sat 2016-11-19 16:30:20 AEST; 12h ago Docs: man:systemd-sysv-generator(8) Process: 620 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) Nov 19 16:29:44 ubuntuServer systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon… Nov 19 16:29:45 ubuntuServer mysql[620]: \* Starting MySQL (Percona XtraDB Cluster) database server mysqld Nov 19 16:29:45 ubuntuServer /etc/init.d/mysql[662]: MySQL PID not found, pid\_file detected/guessed: /var/lib/mysql/ubuntuServer.pid Nov 19 16:30:20 ubuntuServer mysql[620]: \* The server quit without updating PID file (/var/lib/mysql/ubuntuServer.pid). Nov 19 16:30:20 ubuntuServer mysql[620]: …fail! Nov 19 16:30:20 ubuntuServer systemd[1]: mysql.service: Control process exited, code=exited status=1 Nov 19 16:30:20 ubuntuServer systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon. Nov 19 16:30:20 ubuntuServer systemd[1]: mysql.service: Unit entered failed state. Nov 19 16:30:20 ubuntuServer systemd[1]: mysql.service: Failed with result ‘exit-code’. yet the other nodes come back as running using systemctl status? how would I see the bootstrapped details ? the only process I can see running are 1280 mysql 20 0 1363M 423M 19864 S 0.0 42.7 0:01.13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir= 1031 root 20 0 4508 1464 1464 S 0.0 0.1 0:00.01 /bin/sh /usr/bin/mysqld\_safe --wsrep-new-cluster systemctl status mysqld\_safe.service ● mysqld\_safe.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) root@ubuntuServer:~# systemctl status mysqld.service ● mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) The other nodes /etc/init.d/mysql start [ok] Starting mysql (via systemctl): mysql.service. root@ubuntuServerN1:/var/lib/mysql# /etc/init.d/mysql start [ok] Starting mysql (via systemctl): mysql.service. root@ubuntuServerN1:/var/lib/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: active (running) since Sun 2016-11-20 05:13:23 AEST; 1min 0s ago Docs: man:systemd-sysv-generator(8) Process: 1347 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS) CGroup: /system.slice/mysql.service ├─1386 /bin/sh /usr/bin/mysqld\_safe └─1650 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-pr Nov 20 05:12:14 ubuntuServerN1 systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon… Nov 20 05:12:14 ubuntuServerN1 mysql[1347]: \* Starting MySQL (Percona XtraDB Cluster) database server mysqld Nov 20 05:12:14 ubuntuServerN1 /etc/init.d/mysql[1385]: MySQL PID not found, pid\_file detected/guessed: /var/lib/mysql/ubuntuServerN1 Nov 20 05:12:22 ubuntuServerN1 mysql[1347]: \* State transfer in progress, setting sleep higher mysqld Nov 20 05:13:23 ubuntuServerN1 mysql[1347]: …done. Nov 20 05:13:23 ubuntuServerN1 systemd[1]: Started LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon. everything appears to be working how ever mysql\> show status like ‘wsrep%’;