开发者社区> 问答> 正文

mysql 死锁


LATEST DETECTED DEADLOCK

2018-04-19 11:12:36 2afede43e700
* (1) TRANSACTION:
TRANSACTION 104877736810, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 12 lock struct(s), heap size 2936, 14 row lock(s), undo log entries 18
MySQL thread id 321467514, OS thread handle 0x2afedf834700, query id 398212894965 10.30.50.73 snz_app_1 updating
update location set RECORD_VERSION=3589, ALLOCATED_QTY=715.00000, UPDATED_DTM_LOC='2018-04-19 11:12:36' where location_ID=1795599055 and RECORD_VERSION=3588
* (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 7889 page no 181697 n bits 96 index PRIMARY of table snz.location trx table locks 4 total table locks 6 trx id 104877736810 lock_mode X locks rec but not gap waiting lock hold time 0 wait time before grant 0
* (2) TRANSACTION:
TRANSACTION 104877736953, ACTIVE 0 sec starting index read, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
11 lock struct(s), heap size 2936, 11 row lock(s), undo log entries 14
MySQL thread id 321476058, OS thread handle 0x2afede43e700, query id 398212895160 10.30.50.73 snz_app_1 updating
update location set RECORD_VERSION=1447, ALLOCATED_QTY=187.00000, UPDATED_DTM_LOC='2018-04-19 11:12:36' where location_ID=1795894481 and RECORD_VERSION=1446
* (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 7889 page no 181697 n bits 96 index PRIMARY of table snz.location trx table locks 4 total table locks 6 trx id 104877736953 lock_mode X locks rec but not gap lock hold time 0 wait time before grant 0
* (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 7889 page no 426162 n bits 104 index PRIMARY of table snz.location trx table locks 4 total table locks 6 trx id 104877736953 lock_mode X locks rec but not gap waiting lock hold time 0 wait time before grant 0

* WE ROLL BACK TRANSACTION (2)

TRANSACTIONS

展开
收起
paulzhu8597 2018-04-25 18:40:42 2392 0
0 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载
阿里云企业级自治数据库 RDS 详解 立即下载
阿里云MySQL云数据库产品体系介绍 立即下载

相关镜像