# Mysql Galera Cluster Deadlock Error **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Tags:** mysql, percona, new-release\ **Created:** [January 10, 2024, 12:59pm UTC](https://forums.percona.com/t/mysql-galera-cluster-deadlock-error/27682 "2024-01-10T12:59:05Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Alican\_Cakir](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alican_cakir/32/13527_2.png) [@Alican\_Cakir](https://forums.percona.com/u/Alican_Cakir)\ **Post date:** [January 10, 2024, 12:59pm UTC](https://forums.percona.com/t/mysql-galera-cluster-deadlock-error/27682/1 "2024-01-10T12:59:05Z")
Hello, I have a mysql galera cluster with 5 nodes. My version is 8. Before installing this structure, I had mysql galera cluster 5.6 version with 3 nodes. I transferred the database from 5.6 to 8 using the dump restore method. There is a deadlock problem in my 5-node gallery cluster. How can I solve this problem? What is the problem causing this? I list the system’s resources below. OS : Red Hat Enterprise Linux 8.8 (Ootpa) Ram : 16GB vCPU : 10 I am sharing the Mysql configuration. innodb\_log\_files\_in\_group = 2 innodb\_autoinc\_lock\_mode = 2 innodb\_log\_file\_size = 256M innodb\_file\_per\_table = 1 innodb\_flush\_log\_at\_trx\_commit = 0 innodb\_buffer\_pool\_size = 4G innodb\_log\_buffer\_size = 64M innodb-read-io-threads = 8 innodb-write-io-threads = 8 innodb-buffer-pool-instances = 16 innodb\_autoinc\_lock\_mode = 2 tmp\_table\_size = 64M max\_heap\_table\_size = 64M max\_connections = 2000 thread\_cache\_size = 512 open-files-limit = 65535 table\_definition\_cache = 7000 table\_open\_cache = 7000 max\_allowed\_packet = 5G wsrep\_applier\_threads = 16 wsrep\_certify\_nonPK = 1 wsrep\_max\_ws\_rows = 131072 wsrep\_max\_ws\_size = 1073741824 wsrep\_debug = 0 wsrep\_retry\_autocommit = 5 wsrep\_auto\_increment\_control = 0 auto\_increment\_increment = 6 auto\_increment\_offset = 1 wsrep\_sync\_wait = 0 wsrep\_log\_conflicts = 1 wsrep\_sst\_donor\_rejects\_queries= 0 wsrep\_provider\_options = “pc.recovery=TRUE;pc.weight=2;gmcast.segment=1;socket.ssl\_compression=no;gcache.keep\_pages\_size=4;gcache.page\_size=128M;gcache.size=5024M;evs.send\_window=1024;evs.user\_send\_window=1024; evs.use\_aggregate = true; gcs.fc\_factor = 1; gcs.fc\_limit = 500; gcs.max\_packet\_size = 2097152;gcs.fc\_debug = 0; evs.inactive\_check\_period = PT10S; evs.inactive\_timeout = PT1M; evs.suspect\_timeout = PT30S; evs.stats\_report\_period = PT1M; evs.info\_log\_mask = 0; evs.install\_timeout = PT1M; evs.join\_retrans\_period = PT2S; evs.keepalive\_period = PT3S; evs.max\_install\_timeouts = 3; evs.use\_aggregate = true; evs.version = 0; evs.view\_forget\_timeout = PT5M; gcache.dir = /var/lib/mysql; gcache.name = /var/lib/mysql/galera.cache; gcs.fc\_debug = 0; gcs.fc\_master\_slave = NO; gcs.max\_packet\_size = 64500; gcs.max\_throttle = 0.25; gcs.recv\_q\_hard\_limit = 9223372036854775807; gcs.recv\_q\_soft\_limit = 0.25; gcs.sync\_donor = NO; gmcast.listen\_addr = tcp://0.0.0.0:4567; gmcast.mcast\_addr = ; gmcast.mcast\_ttl = 1; gmcast.peer\_timeout = PT3S; gmcast.time\_wait = PT5S; gmcast.version = 0; pc.checksum = true; pc.ignore\_quorum = false; pc.ignore\_sb = false; pc.linger = PT20S; pc.npvo = false; pc.version = 0; protonet.backend = asio; protonet.version = 0; repl.causal\_read\_timeout = PT30S; repl.commit\_order = 3” Can you support? ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [January 10, 2024, 1:04pm UTC](https://forums.percona.com/t/mysql-galera-cluster-deadlock-error/27682/2 "2024-01-10T13:04:45Z")
Hi @Alican_Cakir, Long back I did face a [deadlock after galera migration](https://kedar.nitty-witty.com/blog/mysql-to-galera-cluster-migration-deadlock-back-to-basics) issue but I doubt if that’s the case for you, just have a look. If not, can you provide a sample deadlock error that you’re seeing? Consider searching forums too: [Stability of 8.0.x - #3 by hmilkovi](https://forums.percona.com/t/stability-of-8-0-x/13005/3). Thanks, K ---
**Author:** ![Alican\_Cakir](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alican_cakir/32/13527_2.png) [@Alican\_Cakir](https://forums.percona.com/u/Alican_Cakir)\ **Post date:** [January 12, 2024, 9:15am UTC](https://forums.percona.com/t/mysql-galera-cluster-deadlock-error/27682/3 "2024-01-12T09:15:54Z")
Could it be related to a synchronization issue? Because there is a network problem between nodes