# Percona xtradb cluster crash problem and loss of Mysql services

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-crash-problem-and-loss-of-mysql-services/29718>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [April 16, 2024, 8:07am UTC](https://forums.percona.com/t/percona-xtradb-cluster-crash-problem-and-loss-of-mysql-services/29718 "2024-04-16T08:07:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bthnklc](https://avatars.discourse-cdn.com/v4/letter/b/e0b2c6/32.png) [@bthnklc](https://forums.percona.com/u/bthnklc)\
**Post date:** [April 16, 2024, 8:07am UTC](https://forums.percona.com/t/percona-xtradb-cluster-crash-problem-and-loss-of-mysql-services/29718/1 "2024-04-16T08:07:09Z")

</div>

Hi,

There was an outage on the Prod database recently. A check was performed and the database was found to be closed. When I want to open the database, “Failed to start mysql.service: Unit mysql.service is masked.” I encountered the error.  
When I tried to open the database with the umask command, mysql main services were deleted from all nodes. “Failed to start mysql.service: Unit mysql.service not found.”

Then, I performed Reinstallation on all nodes and brought all nodes up with Bootstrap. I have no clue what caused this or why it was closed, so the log of the relevant database has been added for your review.

I don’t know if it is related to the problem or not, but I have an observation.

At the time of the problem, the errors shown below appeared in the log, now the same errors are starting to appear. I ask for your help to prevent any interruptions again.

2024-04-09T05:01:01.735511Z 0 [Warning] [MY-000000] [Galera] Handshake failed: peer did not return a certificate  
2024-04-09T05:01:04.799247Z 0 [Warning] [MY-000000] [Galera] Handshake failed: peer did not return a certificate  
2024-04-09T05:01:04.826104Z 0 [Warning] [MY-000000] [Galera] Handshake failed: wrong version number  
2024-04-09T05:01:04.929789Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unknown protocol  
2024-04-09T05:01:05.968724Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unknown protocol  
2024-04-09T05:01:06.004839Z 0 [Warning] [MY-000000] [Galera] Handshake failed: version too low  
2024-04-09T05:01:06.038211Z 0 [Warning] [MY-000000] [Galera] Handshake failed: version too low  
2024-04-09T05:01:07.069188Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unsupported protocol  
2024-04-09T05:01:08.102054Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unsupported protocol  
2024-04-09T05:01:09.133675Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unsupported protocol  
2024-04-09T05:01:10.169407Z 0 [Warning] [MY-000000] [Galera] Handshake failed: unsupported protocol

Main node : NODE1\_156

[node3\_error\_158.log](https://forums.percona.com/uploads/short-url/2YqCtQ3e9N54gvRjQRGzCA1g80u.log) (623.6 KB)  
[node2\_error\_157.log](https://forums.percona.com/uploads/short-url/eUYzvi5ksnRXIgM8zAwFr5nFNOE.log) (633.4 KB)  
[node1\_error\_156.log](https://forums.percona.com/uploads/short-url/oIoyOmQKaB76vXZgnYWFWDUt6le.log) (1.2 MB)

---

<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:** [April 18, 2024, 1:01pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-crash-problem-and-loss-of-mysql-services/29718/2 "2024-04-18T13:01:55Z")

</div>

Please read through MySQL’s error logs that you attached.

> 2023-09-26T11:23:50.656217Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘encrypt=4’.  
> 2023-09-26T11:23:50.656546Z 0 [ERROR] [MY-013236] [Server] The designated data directory /data/mysql/ is unusable. You can remove all files that the server added to it.

> 2023-09-22T08:20:11.487612Z 0 [Note] [MY-000000] [WSREP-SST] Trying to terminate (89210) socat -u openssl-listen:4444,reuseaddr,cert=/data/mysql/server-cert.pem,key=/data/mysql/server-key.pem,cafile=/data/mysql/ca.pem,verify=1,retry=30 stdio | /usr/bin/pxc\_extra/pxb-8.0/bin/xbstream -x with SIGTERM  
> 2023-09-22T08:20:11.493857Z 0 [Note] [MY-000000] [WSREP-SST] Terminated  
> 2023-09-22T08:20:12.497333Z 0 [ERROR] [MY-000000] [WSREP-SST] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* FATAL ERROR \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
> 2023-09-22T08:20:12.497468Z 0 [ERROR] [MY-000000] [WSREP-SST] Possible timeout in receving first data from donor in gtid/keyring stage

You’ve got some issue with your SSL certificates. I suggest you remove all the encryption/SSL settings and get your cluster back online first. Then try to bring SSL back into the config.