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

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

book

Article ID: 236703

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Mysql update routing_engines query error

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

Environment

Release : 21.x

Component : NETWORK FLOW ANALYSIS

Cause

routing_engines table very large 

Resolution

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