解决1205 - Lock wait timeout exceeded； try restarting transaction

记录一笔

执行

INSERT INTO `etp`.`seller_balance`( `seller_id`, `sb_value`, `sb_value_currency`, `rl_settling_value`, `settling_value`, `settling_done_value`, `settling_hold_value`, `internal_value`, `internal_withdraw_value`, `internal_hold_value`, `internal_value_currency`, `foreign_value`, `foreign_withdraw_value`, `foreign_hold_value`, `foreign_value_currency`, `add_time`, `update_time`) VALUES ( 2802, 33.0600, 'USD', 0.0000, 63.2900, 168.0000, 30.2300, 0.0000, 1134.4000, 0.0000, 'CNY', 0.0000, 0.0000, 0.0000, 'USD', '2017-01-11 10:44:21', '2018-05-31 13:39:19');

mysql报错如下

INSERT INTO `etp`.`seller_balance`( `seller_id`, `sb_value`, `sb_value_currency`, `rl_settling_value`, `settling_value`, `settling_done_value`, `settling_hold_value`, `internal_value`, `internal_withdraw_value`, `internal_hold_value`, `internal_value_currency`, `foreign_value`, `foreign_withdraw_value`, `foreign_hold_value`, `foreign_value_currency`, `add_time`, `update_time`) VALUES ( 2802, 33.0600, 'USD', 0.0000, 63.2900, 168.0000, 30.2300, 0.0000, 1134.4000, 0.0000, 'CNY', 0.0000, 0.0000, 0.0000, 'USD', '2017-01-11 10:44:21', '2018-05-31 13:39:19')
> 1205 - Lock wait timeout exceeded; try restarting transaction
> 时间: 121.023s

关键字：1205 - Lock wait timeout exceeded; try restarting transaction

执行

select * from information_schema.innodb_trx;

显示

 上图中需要关注两个字段，trx_state(线程状态)和 trx_mysql_thread_id（用来杀死现场的线程id）

如上，得知id为39062；执行杀死操作

kill 39062;

 继续操作以上插入语句，得到如下结果