mysql update 锁死 原因_Mysql update后insert造成死锁原因分析及解决

  • Post author:
  • Post category:mysql


系统中出现死锁的日志如下:

*** (1) TRANSACTION:TRANSACTION 1331088253, ACTIVE 0sec inserting

mysql tablesin use 1, locked 1LOCK WAIT7 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 4MySQL thread id14699751, OS thread handle 0x7fc5eaeda700, query id 382901670 172.18.140.10 bms update

INSERT INTO `finance_settlement_detail` (`order_detail_id`, `tenant_id`, `store_id`, `order_id`, `working_type_id`, `working_item_id`, `working_item_base_id`, `working_type_name`, `item_code_all`, `achievements_code`, `price_code`, `item_name_all`, `copies_num`, `one_copies_num`, `show_copies_num`, `unit_num`, `unit_price`, `discount`, `amount`, `standard_unit_price`, `standard_total_price`, `item_code1`, `item_name1`, `item_code2`, `i



版权声明:本文为weixin_29962351原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。