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

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

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?

2

Hello @Sunil_Kumar,
With 20 million rows, you should look at Streaming Replication — Galera Cluster Documentation to optimize this transaction.