MySql 更新死锁问题 Deadlock found when trying to get lock; try restarting transaction

文章导航-readme

MySql 更新死锁问题 Deadlock found when trying to get lock; try restarting transaction

1.场景

//table1
CREATE TABLE `retailtrades` (
  `TradeId` bigint(20) NOT NULL COMMENT '主键',
  `TradeCode` varchar(20) NOT NULL COMMENT '交易单号',
  `TradeAmount` decimal(14,4) NOT NULL COMMENT '交易金额',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `TradeState` tinyint(4) NOT NULL COMMENT '交易状态 1:未支付 2:已支付 3:支付异常',
  `SuccessTime` datetime DEFAULT NULL COMMENT '支付成功时间',
  PRIMARY KEY (`TradeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='零售交易单表';

//ta