# Mysqld 5.6 crashes after joining galera cluster with successful SST

**URL:** https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575
**Category:** Percona XtraDB Cluster 5.x
**Tags:** percona
**Created:** [May 5, 2022, 9:05pm UTC](https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575 "2022-05-05T21:05:32Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Adam\_Lasut](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/adam_lasut/32/6512_2.png) [@Adam\_Lasut](https://forums.percona.com/u/Adam_Lasut)
#### Post date: [May 5, 2022, 9:05pm UTC](https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575/1 "2022-05-05T21:05:32Z")

</div>

Hello,

after os update my mysqld crashes after it successfuly receives state from another node of percona xtradb cluster and joins the cluster.

Versions (they are identical on all nodes of the cluster)

# mysql -V

mysql Ver 14.14 Distrib 5.6.51-91.0, for Linux (x86\_64) using 6.2

# cat /etc/centos-release

CentOS Linux release 7.9.2009 (Core)

after systemctl mysql start command finishes I can see in log:  
2022-05-05 22:47:22 3180 [Note] WSREP: SST received: 49799465-2157-11e8-9d5f-fa6bdff6d1ef:5629429893  
2022-05-05 22:47:22 3180 [Note] /usr/sbin/mysqld: ready for connections.  
Version: ‘5.6.51-91.0-56’ socket: ‘/mysql/mysql/mysql.sock’ port: 3307 Percona XtraDB Cluster (GPL), Release rel91.0, Revision c714694, WSREP version 28.46, wsrep\_28.46  
2022-05-05 22:47:22 3180 [Note] WSREP: 0.0 (hostname): State transfer from 1.0 (hostname) complete.  
2022-05-05 22:47:22 3180 [Note] WSREP: Shifting JOINER → JOINED (TO: 5629449386)

in status table:  
| wsrep\_cluster\_size | 3 |  
±-----------------------------±------------------------------------------------------------+  
74 rows in set (0.00 sec)

but suddenly:  
mysql\> show status like ‘%ws%’;  
ERROR 2006 (HY000): MySQL server has gone away  
No connection. Trying to reconnect…  
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)  
ERROR:  
Can’t connect to the server

mysql\> Bye

Mysqld log:  
2022-05-05 22:48:12 3180 [Note] WSREP: Deleted page /mysql/mysql/gcache.page.000023  
2022-05-05 22:48:15 3180 [Note] WSREP: Deleted page /mysql/mysql/gcache.page.000024  
20:48:19 UTC - mysqld got signal 11 ;  
This could be because you hit a bug. It is also possible that this binary  
or one of the libraries it was linked against is corrupt, improperly built,  
or misconfigured. This error can also be caused by malfunctioning hardware.  
We will try our best to scrape up some info that will hopefully help  
diagnose the problem, but since we have already crashed,  
something is definitely wrong and this may fail.  
Please help us make Percona XtraDB Cluster better by reporting any  
bugs at [Jira - Percona JIRA](https://jira.percona.com/projects/PXC/issues)

key\_buffer\_size=8388608  
read\_buffer\_size=131072  
max\_used\_connections=10  
max\_threads=153  
thread\_count=14  
connection\_count=9  
It is possible that mysqld could use up to  
key\_buffer\_size + (read\_buffer\_size + sort\_buffer\_size)\*max\_threads = 69151 K bytes of memory  
Hope that’s ok; if not, decrease some variables in the equation.

Thread pointer: 0x0  
Attempting backtrace. You can use the following information to find out  
where mysqld died. If you see no messages after this, something went  
terribly wrong…  
stack\_bottom = 0 thread\_stack 0x40000  
/usr/sbin/mysqld(my\_print\_stacktrace+0x3b)[0x92142b]  
/usr/sbin/mysqld(handle\_fatal\_signal+0x471)[0x686dc1]  
/usr/lib64/libpthread.so.0(+0xf630)[0x7fbe5eb7e630]  
/usr/lib64/libgalera\_smm.so(+0x22006)[0x7fbe3d1b4006]  
/usr/lib64/libgalera\_smm.so(+0x4c875)[0x7fbe3d1de875]  
/usr/lib64/libgalera\_smm.so(+0x160240)[0x7fbe3d2f2240]  
/usr/lib64/libgalera\_smm.so(+0x160e49)[0x7fbe3d2f2e49]  
/usr/lib64/libpthread.so.0(+0x7ea5)[0x7fbe5eb76ea5]  
/usr/lib64/libc.so.6(clone+0x6d)[0x7fbe5cd43b0d]  
You may download the Percona XtraDB Cluster operations manual by visiting  
[http://www.percona.com/software/percona-xtradb-cluster/](http://www.percona.com/software/percona-xtradb-cluster/). You may find information  
in the manual which will help you identify the cause of the crash.

Any recomendations? I was thinking about just cloning another node, clean it up, reconfigure and try to join cluster…or maybe restore from backup (the broken node) and try to update & join cluster again…

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [May 6, 2022, 2:39pm UTC](https://forums.percona.com/t/mysqld-5-6-crashes-after-joining-galera-cluster-with-successful-sst/15575/2 "2022-05-06T14:39:31Z")

</div>

Hello,  
PXC 5.6 is dead and has been dead for a while. There are no support for running 5.6 on CentOS 7.9. We recommend upgrading to either the latest 5.7 or latest 8.0 due to the many bugs fixed in these versions since 5.6 and for including support for the latest major operating systems.
