# ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

**URL:** <https://forums.percona.com/t/error-1205-hy000-lock-wait-timeout-exceeded-try-restarting-transaction/25987>\
**Category:** Percona XtraDB Cluster 8.x\
**Tags:** percona\
**Created:** [October 17, 2023, 5:18pm UTC](https://forums.percona.com/t/error-1205-hy000-lock-wait-timeout-exceeded-try-restarting-transaction/25987 "2023-10-17T17:18:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sunil\_Kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sunil_kumar/32/7044_2.png) [@Sunil\_Kumar](https://forums.percona.com/u/Sunil_Kumar)\
**Post date:** [October 17, 2023, 5:18pm UTC](https://forums.percona.com/t/error-1205-hy000-lock-wait-timeout-exceeded-try-restarting-transaction/25987/1 "2023-10-17T17:18:42Z")

</div>

I am having 3 node Percona XtraDB Cluster 8.X…

Table has 20million rows… sample data… when I do below error coming…

mysql\> INSERT INTO temp\_link\_clicks SELECT \* FROM link\_clicks;  
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Sometimes … deadlock message coming…

Any hint to fix this … any parameter need to be disabled… or enabled?

---

<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:** [October 17, 2023, 8:38pm UTC](https://forums.percona.com/t/error-1205-hy000-lock-wait-timeout-exceeded-try-restarting-transaction/25987/2 "2023-10-17T20:38:27Z")

</div>

Hello @Sunil_Kumar,  
With 20 million rows, you should look at [Streaming Replication — Galera Cluster Documentation](https://galeracluster.com/library/documentation/streaming-replication.html) to optimize this transaction.