系统中出现死锁的日志如下:
*** (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