# Cluster does not execute INSERT and UPDATE, many "wsrep in pre-commit stage"

**URL:** <https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 16, 2014, 5:42am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479 "2014-05-16T05:42:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![emakon](https://avatars.discourse-cdn.com/v4/letter/e/ecc23a/32.png) [@emakon](https://forums.percona.com/u/emakon)\
**Post date:** [May 16, 2014, 5:42am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/1 "2014-05-16T05:42:45Z")

</div>

Hi,

we have a cluster with 3 nodes. Everything worked fine until now. All nodes are up, but they do not execute INSERTs, UPDATEs. SELECTS are executed. How do we get the cluster back to work?

Regards

Martin

---

<div class="post-metadata">

**Author:** ![emakon](https://avatars.discourse-cdn.com/v4/letter/e/ecc23a/32.png) [@emakon](https://forums.percona.com/u/emakon)\
**Post date:** [May 16, 2014, 6:00am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/2 "2014-05-16T06:00:23Z")

</div>

I did some more investigation. The “SHOW ENGINE INNODB STATUS” shows many locked tables. But still no idea what to do… We can access the servers without any problem.

---

<div class="post-metadata">

**Author:** ![emakon](https://avatars.discourse-cdn.com/v4/letter/e/ecc23a/32.png) [@emakon](https://forums.percona.com/u/emakon)\
**Post date:** [May 16, 2014, 6:26am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/3 "2014-05-16T06:26:50Z")

</div>

I stopped node 3 and restarted it. Now it makes a full SST (why?). This may take a while… A few queries have been executed, but now node 1 and 2 are still stuck.

---

<div class="post-metadata">

**Author:** ![emakon](https://avatars.discourse-cdn.com/v4/letter/e/ecc23a/32.png) [@emakon](https://forums.percona.com/u/emakon)\
**Post date:** [May 16, 2014, 6:39am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/4 "2014-05-16T06:39:56Z")

</div>

One of our programmers created a new table and inserted some data (5 MB). Does this lock the whole cluster??

---

<div class="post-metadata">

**Author:** ![emakon](https://avatars.discourse-cdn.com/v4/letter/e/ecc23a/32.png) [@emakon](https://forums.percona.com/u/emakon)\
**Post date:** [May 16, 2014, 8:29am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/5 "2014-05-16T08:29:39Z")

</div>

Ok, the cluster is still blocked. We have to take it down. What causes the cluster to fail like that?

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [May 29, 2014, 3:10am UTC](https://forums.percona.com/t/cluster-does-not-execute-insert-and-update-many-wsrep-in-pre-commit-stage/3479/6 "2014-05-29T03:10:53Z")

</div>

What kind of table was that? What is the “show create table tablename\G”.  
You need to provide at least the output of

```auto
show status like 'ws%';

```

and relevant error log parts to help you on that.