当前位置:   article > 正文

MySQL死锁套路:一次诡异的批量插入死锁问题分析_批量写入出现死锁

批量写入出现死锁

线上最近出现了批量insert的死锁,百思不得解。死锁记录如下:

  1. 2018-10-26T11:04:41.759589Z 8530809 [Note] InnoDB:
  2. *** (1) TRANSACTION:
  3. TRANSACTION 1202026765, ACTIVE 0 sec inserting
  4. mysql tables in use 1, locked 1
  5. LOCK WAIT 3 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
  6. MySQL thread id 8532863, OS thread handle 139858337453824, query id 16231472122 10.111.10.143 seewo update
  7. INSERT IGNORE INTO xx_performance_type_label_relation(label_id, performance_type_id, type, create_time)
  8. VALUES
  9. ('bb0394e670644168a998a93a3ed521bc', '06b96ee0bab84d71bb17bf9645d3aa54', 1, now())
  10. ,
  11. ('bb0394e670644168a998a93a3ed521bc', '27d82e2331b241e1a9c9c0a74ec21099', -1, now())
  12. ,
  13. ('bb0394e670644168a998a93a3ed521bc', '3100b5978fb24f56b327d25732a7d7a7', 1, now())
  14. ,
  15. ('bb0394e670644168a998a93a3ed521bc', '435a1e19ce6e4e5bbb84240b3b34cf03', 1, now())
  16. ,
  17. ('bb0394e670644168a998a93a3ed521bc', '447fe27199ca40e289ef2834469d9a78', 1, now())
  18. ,
  19. ('bb0394e670644168a998a93a3ed521bc', '87a52c4d00844b5bb9eb75e8fe34202a', 1, now())
  20. ,
  21. ('bb0394e670644168a998a93a3ed521bc', 'c6a0e26983bd4fae837d5ee2f4efeef8', 1, now())
  22. 2018-10-26T11:04:41.759635Z 8530809 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  23. RECORD LOCKS space id 505 page no 9912 n bits 288 index uk_performance_type_id_label_id of table `masaike`.`xx_performance_type_label_relation` trx id 1202026765 lock_mode X locks gap before rec insert intention waiting
  24. 2018-10-26T11:04:41.759674Z 8530809 [Note] InnoDB: *** (2) TRANSACTION:
  25. TRANSACTION 1202026764, ACTIVE 0 sec inserting
  26. mysql tables in use 1, locked 1
  27. 3 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
  28. MySQL thread id 8530809, OS thread handle 139858469242624, query id 16231472119 10.111.10.153 seewo update
  29. INSERT IGNORE INTO xx_performance_type_label_relation(label_id, performance_type_id, type, create_time)
  30. VALUES
  31. ('bb0394e670644168a998a93a3ed521bc', '06b96ee0bab84d71bb17bf9645d3aa54', 1, now())
  32. ,
  33. ('bb0394e670644168a998a93a3ed521bc', '27d82e2331b241e1a9c9c0a74ec21099', -1, now())
  34. ,
  35. ('bb0394e670644168a998a93a3ed521bc', '3100b5978fb24f56b327d25732a7d7a7', 1, now())
  36. ,
  37. ('bb0394e670644168a998a93a3ed521bc', '435a1e19ce6e4e5bbb84240b3b34cf03', 1, now())
  38. ,
  39. ('bb0394e670644168a998a93a3ed521bc', '447fe27199ca40e289ef2834469d9a78', 1, now())
  40. ,
  41. ('bb0394e670644168a998a93a3ed521bc', '87a52
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/一键难忘520/article/detail/997868
推荐阅读
相关标签
  

闽ICP备14008679号