# Cluster locks, insert/update issues

**URL:** <https://forums.percona.com/t/cluster-locks-insert-update-issues/4766>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 10, 2016, 10:17am UTC](https://forums.percona.com/t/cluster-locks-insert-update-issues/4766 "2016-03-10T10:17:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Faq](https://avatars.discourse-cdn.com/v4/letter/f/c68b51/32.png) [@Faq](https://forums.percona.com/u/Faq)\
**Post date:** [March 10, 2016, 10:17am UTC](https://forums.percona.com/t/cluster-locks-insert-update-issues/4766/1 "2016-03-10T10:17:56Z")

</div>

Hello,  
We’ve attempted a second migration to Percona cluster and we’re having issues realted inserts /updates on nodes.  
This is our 3 node cluster configuration: [URL][http://wklejto.pl/249433[/URL]](http://wklejto.pl/249433%5B/URL%5D)  
node1 :  
80GB ram  
4TB Raid 6 array, hdd 15k [FC 6gbit]  
Intel(R) Xeon(R) CPU E5-2420 v2 @ 2.20GHz [24 cores]

node2 :  
80GB ram  
4TB Raid 6 array, hdd 15k [FC 6gbit]  
Intel(R) Xeon(R) CPU E5-2420 v2 @ 2.20GHz [24 cores]

node3 :  
80GB ram  
4TB Raid 6 array, hdd 15k [FC 6gbit]  
Intel(R) Xeon(R) CPU E5-2420 0 @ 1.90GHz [24 cores]

1gbps link between servers

1. making updates on node 2 to table 1, while making insterts on node 1 to table 1 makes database unresponsive
2. making large updates on node 2 in table 2
3. we’ve also experienced today a total server lock, “BF lock wait long”, to unlock we’ve had to restart first node, and move writing to node 2  
Is there anything we can do in this situation when we can’t write anything to DB ?

Any ideas what we should change?  
Load avarage:  
node 2 [writing]: 6  
node 1 [some writes, mostly selects]: 2  
node 3 [mostly selects]: 2

We have 2 main tables in our DB.  
We write to / update T1 on node 2,  
and write to / update T2 on node 1

We do this to avoid deadlocks while using same tables on multiple nodes.

Thanks in advance,  
Faq

---

<div class="post-metadata">

**Author:** ![rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@rodrigo](https://forums.percona.com/u/rodrigo)\
**Post date:** [March 13, 2017, 5:14am UTC](https://forums.percona.com/t/cluster-locks-insert-update-issues/4766/2 "2017-03-13T05:14:25Z")

</div>

I think I am having the same problem here:  
[url][https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1671542[/url]](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1671542%5B/url%5D)