Mysql update routing_engines query error
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Release : 21.x
Component : NETWORK FLOW ANALYSIS
routing_engines table very large
Logon Harvester Server
Open the command prompt and run:
Take a fresh dump of routing_engines table from harvester. (The default password for root is “root@123”)
mysqldump –uroot –p<password> -P 3308 harvester routing_engines > harvester_routing_engines.sql
mysql –uroot –p<password>
Check how many entries has in this table:
mysql> use harvester;
mysql> select count(*) from routing_engines;
Delete entries in routing_engines table.
mysql> delete from routing_engines limit 40000;
Repeats the delete command until the table to be empty