# OPTIMIZE TABLE cluster lock-up

**URL:** <https://forums.percona.com/t/optimize-table-cluster-lock-up/5840>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 3, 2017, 9:57am UTC](https://forums.percona.com/t/optimize-table-cluster-lock-up/5840 "2017-09-03T09:57:45Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Ralph\_Moser](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ralph_moser/32/7966_2.png) [@Ralph\_Moser](https://forums.percona.com/u/Ralph_Moser)\
**Post date:** [September 5, 2017, 3:05am UTC](https://forums.percona.com/t/optimize-table-cluster-lock-up/5840/3 "2017-09-05T03:05:03Z")

</div>

I know but we had no long running queries. All queries were showing that they are waiting for metadata lock, including the optimize queries. (Our longest runs for 0.3 seconds)  
Total deadlock situation.  
Two nodes hanging like that with the optimized table nearly finished in a #sql file and two cores fully loaded… One node operating normaly.  
​​​​​​Maybe I should mention that we are writing to all nodes.  
This would never have finished. I also checked disk io on the dead nodes. Nothing going on at all.

Regards

---

_[View the full topic](https://forums.percona.com/t/optimize-table-cluster-lock-up/5840)._