# Percona-xtradb-cluster-57 fails start upg 5.7.18-29.20 \> 5.7.19-29.22. All nodes **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [September 27, 2017, 4:23pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-57-fails-start-upg-5-7-18-29-20-5-7-19-29-22-all-nodes/5890 "2017-09-27T16:23:26Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![mpavaonunes](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@mpavaonunes](https://forums.percona.com/u/mpavaonunes)\ **Post date:** [September 27, 2017, 4:23pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-57-fails-start-upg-5-7-18-29-20-5-7-19-29-22-all-nodes/5890/1 "2017-09-27T16:23:26Z")
## After upgrading everything stop and can’t roll back. /my.cnf # # The Percona XtraDB Cluster 5.7 configuration file. # # # \* IMPORTANT: Additional settings that can override those from this file! # The files must end with ‘.cnf’, otherwise they’ll be ignored. # Please make any edits and changes to the appropriate sectional files # included below. # ## !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/percona-xtradb-cluster.conf.d/ * * * ## /etc/mysql/percona-xtradb-cluster.conf.d/mysqld.cnf # Template my.cnf for PXC # Edit to your requirements. [mysqld] server-id=1 datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-bin log\_slave\_updates expire\_logs\_days=7 # Disabling symbolic-links is recommended to prevent assorted security risks ## symbolic-links=0 * * * ## /etc/mysql/percona-xtradb-cluster.conf.d/wsrep.cnf [mysqld] # Path to Galera library wsrep\_provider=/usr/lib/galera3/libgalera\_smm.so # Cluster connection URL contains IPs of nodes #If no IP is found, this implies that a new cluster needs to be created, #in order to do that you need to bootstrap this node wsrep\_cluster\_address=gcomm://192.168.1.45,192.168.1.46,192.168.1.47 # In order for Galera to work correctly binlog format should be ROW binlog\_format=ROW # MyISAM storage engine has only experimental support default\_storage\_engine=InnoDB # Slave thread to use wsrep\_slave\_threads=8 wsrep\_log\_conflicts # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb\_autoinc\_lock\_mode=2 # Node IP address wsrep\_node\_address=192.168.1.45 # Cluster name wsrep\_cluster\_name=imglx-db-cluster #If wsrep\_node\_name is not specified, then system hostname will be used wsrep\_node\_name=prod45 #pxc\_strict\_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER pxc\_strict\_mode=ENFORCING pxc\_strict\_mode=ENFORCING # SST method wsrep\_sst\_method=xtrabackup-v2 #Authentication for SST method #wsrep\_sst\_auth=“sstuser:password” ## #wsrep\_replicate\_myisam = ON ~# service mysql start Job for mysql.service failed. See ‘systemctl status mysql.service’ and ‘journalctl -xn’ for details. ~# systemctl status mysql.service - mysql.service - Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/lib/systemd/system/mysql.service; enabled) Active: activating (start) since Wed 2017-09-27 22:46:28 WEST; 40s ago Process: 4599 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Control: 4686 (mysql) CGroup: /system.slice/mysql.service |-4686 /bin/bash /etc/init.d/mysql start |-4722 /bin/sh /usr/bin/mysqld\_safe |-5106 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --wsrep-provider=/usr/lib/ga… `-5273 sleep 1 ## Sep 27 22:46:28 PROD45 systemd[1]: Stopping Start and stop the mysql (Percona XtraDB Cluster) daemon… Sep 27 22:46:28 PROD45 systemd[1]: Starting Start and stop the mysql (Percona XtraDB Cluster) daemon… Sep 27 22:46:31 PROD45 mysql[4681]: WSREP: Recovered position dcb3260d-5d9a-11e7-b715-cf577114ed32:13578 Help! ---
**Author:** ![mpavaonunes](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@mpavaonunes](https://forums.percona.com/u/mpavaonunes)\ **Post date:** [October 4, 2017, 8:08am UTC](https://forums.percona.com/t/percona-xtradb-cluster-57-fails-start-upg-5-7-18-29-20-5-7-19-29-22-all-nodes/5890/2 "2017-10-04T08:08:52Z")
grastate.dat Node: 0 # GALERA saved state version: 2.1 uuid: dcb3260d-5d9a-11e7-b715-cf577114ed32 seqno: 13578 safe\_to\_bootstrap: 0 Node: 1 # GALERA saved state version: 2.1 uuid: 00000000-0000-0000-0000-000000000000 seqno: -1 safe\_to\_bootstrap: 0 Node:2 # GALERA saved state version: 2.1 uuid: 00000000-0000-0000-0000-000000000000 seqno: -1 safe\_to\_bootstrap: 0 Tried everything but still won’t start. (Scenario 6) [https://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/](https://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/) It was running perfectly until upgrade.