# Percona if down two node

**URL:** https://forums.percona.com/t/percona-if-down-two-node/28249
**Category:** Percona XtraDB Cluster 8.x
**Created:** [February 5, 2024, 7:30am UTC](https://forums.percona.com/t/percona-if-down-two-node/28249 "2024-02-05T07:30:43Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![ahung](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@ahung](https://forums.percona.com/u/ahung)
#### Post date: [February 5, 2024, 7:30am UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/1 "2024-02-05T07:30:43Z")

</div>

Hello team, I have a situation that I am having a 5-node cluster set up and when the user goes to the database and makes this query  
SHOW CREATE VIEW ticket\_section\_extended;  
The mysql of two nodes stops and the cluster stops responding, any ideas can help with this, because as I understand it, it should not stop writing or reading the databases because three nodes are active and for a query I think I shouldn’t stop a query. Here I leave my conf and tell me what it could be or if something else needs to be added to the configuration, thank you.

```auto
[client]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
server-id=1
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
log-error=/var/log/mysql/error.log
pid-file=/var/run/mysqld/mysqld.pid

pxc_encrypt_cluster_traffic=ON
max_connections = 680
max_allowed_packet = 256M

wsrep_provider_options=“cert.optimistic_pa=NO”
wsrep_certification_rules=‘OPTIMIZED’

# Binary log expiration period is 604800 seconds, which equals 7 days

binlog_expire_logs_seconds=604800

######## wsrep ###############

# Path to Galera library

wsrep_provider=/usr/lib/galera4/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://10.120.1.19, 10.120.1.20, 10.120.1.21, 10.120.1.22, 10.120.1.23

# In order for Galera to work correctly binlog format should be ROW

binlog_format=ROW
transaction_isolation = READ-COMMITTED

# Using the MyISAM storage engine is not recommended.

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=10.120.1.19

# Cluster name

wsrep_cluster_name=pxc-cluster

#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc-cluster-node-1

#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
#pxc_strict_mode=ENFORCING
pxc_strict_mode=PERMISSIVE

# SST method

wsrep_sst_method=xtrabackup-v2

wsrep_provider_options=“socket.ssl_key=server-key.pem;socket.ssl_cert=server-cert.pem;socket.ssl_ca=ca.pem”

[sst]
encrypt=4
ssl-key=server-key.pem
ssl-ca=ca.pem

skip-log-bin
character-set-server=utf8
default_time_zone=“+00:00”

```

---

<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: [February 5, 2024, 4:36pm UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/2 "2024-02-05T16:36:19Z")

</div>

Hello @ahung,  
We need to see mysql error logs (not systemctl status) on the failed 2 nodes when they crashed.

---

<div class="post-metadata">

### Author: ![ahung](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@ahung](https://forums.percona.com/u/ahung)
#### Post date: [February 6, 2024, 12:58pm UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/3 "2024-02-06T12:58:23Z")

</div>

=================================================  
2024-02-06T12:36:03.437993Z 2 [Note] [MY-000000] [WSREP] wsrep\_notify\_cmd is not defined, skipping notification.  
2024-02-06T12:36:03.446946Z 2 [Note] [MY-000000] [Galera] Recording CC from group: 609  
2024-02-06T12:36:03.447027Z 2 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 601  
2024-02-06T12:36:03.447040Z 2 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1  
2024-02-06T12:36:06.213261Z 0 [Note] [MY-000000] [Galera] cleaning up f802a28c-82b5 (ssl://10.120.1.22:4567)  
2024-02-06T12:46:19.396029Z 2872 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn’t recommend use of LOCK TABLE/FLUSH TABLE

 WITH READ LOCK/FOR EXPORT with pxc\_strict\_mode = PERMISSIVE  
2024-02-06T12:47:14.947146Z 2872 [Note] [MY-000000] [WSREP] Initiating SST cancellation  
2024-02-06T12:47:14Z UTC - mysqld got signal 11 ;  
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.  
BuildID[sha1]=82e0381828780a878c13947ae9217abad3e30d93  
Server Version: 8.0.35-27.1 Percona XtraDB Cluster (GPL), Release rel27, Revision 84d9464, WSREP version 26.1.4.3, wsrep\_26.1.4.3

Thread pointer: 0x7f067c191370  
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 = 7f06d44f3b70 thread\_stack 0x100000  
/usr/sbin/mysqld(my\_print\_stacktrace(unsigned char const\*, unsigned long)+0x41) [0x562f07a61ce1]  
/usr/sbin/mysqld(print\_fatal\_signal(int)+0x39f) [0x562f06a8cb2f]  
/usr/sbin/mysqld(handle\_fatal\_signal+0xd8) [0x562f06a8cc18]  
/lib/x86\_64-linux-gnu/libc.so.6(+0x42520) [0x7f073127f520]  
/usr/sbin/mysqld(Item\_field::fix\_outer\_field(THD\*, Field\*\*, Item\*\*)+0xf1) [0x562f065fa631]  
/usr/sbin/mysqld(Item\_field::fix\_fields(THD\*, Item\*\*)+0x462) [0x562f065fb652]  
/usr/sbin/mysqld(Item\_func::fix\_func\_arg(THD\*, Item\*\*)+0x2f) [0x562f0666ee3f]  
/usr/sbin/mysqld(Item\_func::fix\_fields(THD\*, Item\*\*)+0xc7) [0x562f0666efb7]  
/usr/sbin/mysqld(setup\_fields(THD\*, unsigned long, bool, bool, bool, mem\_root\_deque\<Item\*\> const\*, mem\_root\_deque\<Item\*\>_, Bounds\_checked\_array\<Item_\>)+0x209) [0x562f068519c9]  
/usr/sbin/mysqld(Query\_block::prepare(THD\*, mem\_root\_deque\<Item\*\>_)+0x368) [0x562f06955698]  
/usr/sbin/mysqld(Query\_expression::prepare(THD_, Query\_result\*, mem\_root\_deque\<Item\*\>_, unsigned long long, unsigned long long)+0x173) [0x562f069ea323]  
/usr/sbin/mysqld(Item\_subselect::fix\_fields(THD_, Item\*\*)+0x7f) [0x562f066d406f]  
/usr/sbin/mysqld(setup\_fields(THD\*, unsigned long, bool, bool, bool, mem\_root\_deque\<Item\*\> const\*, mem\_root\_deque\<Item\*\>_, Bounds\_checked\_array\<Item_\>)+0x209) [0x562f068519c9]  
/usr/sbin/mysqld(Query\_block::prepare(THD\*, mem\_root\_deque\<Item\*\>_)+0x368) [0x562f06955698]  
/usr/sbin/mysqld(Query\_expression::prepare(THD_, Query\_result\*, mem\_root\_deque\<Item\*\>_, unsigned long long, unsigned long long)+0x173) [0x562f069ea323]  
/usr/sbin/mysqld(Table\_ref::resolve\_derived(THD_, bool)+0x286) [0x562f068a0236]  
/usr/sbin/mysqld(mysqld\_show\_create(THD\*, Table\_ref\*)+0xcc5) [0x562f0697f345]  
/usr/sbin/mysqld(Sql\_cmd\_show\_create\_table::execute\_inner(THD\*)+0xff) [0x562f069820bf]  
/usr/sbin/mysqld(mysql\_execute\_command(THD\*, bool)+0x1eef) [0x562f068fbf5f]  
/usr/sbin/mysqld(dispatch\_sql\_command(THD\*, Parser\_state\*, bool)+0x610) [0x562f069009c0]  
/usr/sbin/mysqld(+0x1269ff5) [0x562f06900ff5]  
/usr/sbin/mysqld(dispatch\_command(THD\*, COM\_DATA const\*, enum\_server\_command)+0x39a7) [0x562f069057d7]  
/usr/sbin/mysqld(do\_command(THD\*)+0x204) [0x562f06905e84]  
/usr/sbin/mysqld(+0x13e5418) [0x562f06a7c418]  
/usr/sbin/mysqld(+0x2872e99) [0x562f07f09e99]  
/lib/x86\_64-linux-gnu/libc.so.6(+0x94ac3) [0x7f07312d1ac3]  
/lib/x86\_64-linux-gnu/libc.so.6(+0x126850) [0x7f0731363850]

Trying to get some variables.  
Some pointers may be invalid and cause the dump to abort.  
Query (7f067c4aab90): show create table `intervention_section_extended`  
Connection ID (thread ID): 2872  
Status: NOT\_KILLED

---

<div class="post-metadata">

### Author: ![Mughees\_Ahmed](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mughees_ahmed/32/9028_2.png) [@Mughees\_Ahmed](https://forums.percona.com/u/Mughees_Ahmed)
#### Post date: [February 6, 2024, 1:12pm UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/4 "2024-02-06T13:12:15Z")

</div>

> [@ahung](#):
>
> [Note] [MY-000000] [WSREP] Initiating SST cancellation  
> 2024-02-06T12:47:14Z UTC - mysqld got signal 11 ;

you seem to hitting bugg [[PXC-3455] - Percona JIRA](https://perconadev.atlassian.net/browse/PXC-3455), can you please share which version of MySQL you are using

---

<div class="post-metadata">

### Author: ![ahung](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@ahung](https://forums.percona.com/u/ahung)
#### Post date: [February 6, 2024, 2:59pm UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/5 "2024-02-06T14:59:01Z")

</div>

when I do this query on my percona cluster the mysql process stops

SHOW CREATE VIEW ticket\_section\_extended;

---

<div class="post-metadata">

### Author: ![ahung](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@ahung](https://forums.percona.com/u/ahung)
#### Post date: [February 6, 2024, 3:01pm UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/6 "2024-02-06T15:01:17Z")

</div>

ii percona-release 1.0-27.generic all Package to install Percona gpg key and APT repos  
ii percona-xtradb-cluster 1:8.0.35-27-1.jammy amd64 Percona XtraDB Cluster with Galera  
ii percona-xtradb-cluster-client 1:8.0.35-27-1.jammy amd64 Percona XtraDB Cluster database client binaries  
ii percona-xtradb-cluster-common 1:8.0.35-27-1.jammy amd64 Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)  
ii percona-xtradb-cluster-garbd 1:8.0.35-27-1.jammy amd64 Garbd components of Percona XtraDB Cluster  
ii percona-xtradb-cluster-garbd-debug 1:8.0.35-27-1.jammy amd64 Debugging package for Percona XtraDB Cluster Garbd.  
ii percona-xtradb-cluster-server 1:8.0.35-27-1.jammy amd64 Percona XtraDB Cluster database server binaries

---

<div class="post-metadata">

### Author: ![Mughees\_Ahmed](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mughees_ahmed/32/9028_2.png) [@Mughees\_Ahmed](https://forums.percona.com/u/Mughees_Ahmed)
#### Post date: [February 7, 2024, 1:54am UTC](https://forums.percona.com/t/percona-if-down-two-node/28249/7 "2024-02-07T01:54:13Z")

</div>

Is it possible for you to share the views and involved table structure?