看了楼主的跟踪文件
Deadlock graph:
---------Blocker(s)-----------------Waiter(s)---------
Resource Name
process session holds waitsprocess session holds waits
TX-0010002d-000048ae 139 169 X
3599 X ---这里是TX锁
TX-00130003-0000325f3599 X
139 169 X
Rows waited on:
Session 99: obj - rowid = 00007618 - AAAHYYABNAAAhMvACF
(dictionary objn - 30232, file - 77, block - 135983, slot - 133)
Session 169: obj - rowid = 00007862 - AAAHhiAAiAAATpPACd
(dictionary objn - 30818, file - 34, block - 80463, slot - 157)
更新不同对象,不同的行怎么会发生TX锁?难到是bug不成?想不明白。
up一下。希望有高手解答。
|