delete from IWBTAX t where iaxksq in (select ksq from
(select ipdprf as prf,ipdfrm as frm,ipdtkt as tkt,ipdksq as ksq from iwbpdt
union select ivtprf as prf,ivtfrm as frm,ivttkt as tkt,ivtksq as ksq from iwbvtk
union select irtprf as prf,irtfrm as frm,irttkt as tkt,irtksq as ksq from iwbrtk)
where (prf,frm,tkt) in ((:prf,:frm,:tkt)))
这里用了 三个 绑定变量,两个会话提供的值,也是不一样的,并且至少提供了多次值。
会话 1, 提供的 C1, C2, C3 ,会话2 提供 D1, D2, D3 ,两个会话都没的提交。
此时,会话 1 又提供 D1,D2, D3, 会话 2 提供 C1, C2, C3 ;
这时会话就会形成。
一个开发也找不到了吗? 如果找不到,那就不让多个会话一起删除数据。
我知道兄弟,
*** 2018-03-18 01:25:39.378
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-000f001b-002dc2e3 51 177 X 20 234 S
TX-00150001-000ef565 20 234 X 51 177 S
session 177: DID 0001-0033-00000B9B session 234: DID 0001-0014-00001985
session 234: DID 0001-0014-00001985 session 177: DID 0001-0033-00000B9B
Rows waited on:
Session 177: obj - rowid = 00013437 - AAAWIFAGGAADLFQAAA
(dictionary objn - 78903, file - 390, block - 831824, slot - 0)
Session 234: obj - rowid = 00013437 - AAAWIFAGGAADLcrAAA
(dictionary objn - 78903, file - 390, block - 833323, slot - 0)
----- Information for the OTHER waiting sessions -----
Session 234:
sid: 234 ser: 39915 audsid: 18424972 user: 85/IPRA
flags: (0x100045) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 20 O/S info: user: oracle, term: UNKNOWN, ospid: 54067284
image: oracle@P740_01_LA
client details:
O/S info: user: appadm, term: SQ-IPRA-APP-1, ospid: 7388:8008
machine: SQ\SQ-IPRA-APP-1 program: Server.WinUi.Job.exe
current SQL:
delete from IWBTAX t where iaxksq in (select ksq from
(select ipdprf as prf,ipdfrm as frm,ipdtkt as tkt,ipdksq as ksq from iwbpdt
union select ivtprf as prf,ivtfrm as frm,ivttkt as tkt,ivtksq as ksq from iwbvtk
union select irtprf as prf,irtfrm as frm,irttkt as tkt,irtksq as ksq from iwbrtk)
where (prf,frm,tkt) in ((:prf,:frm,:tkt)))
----- End of information for the OTHER waiting sessions -----
Information for THIS session:
----- Current SQL Statement for this session (sql_id=620uuhpsnkb6u) -----
delete from IWBTAX t where iaxksq in (select ksq from
(select ipdprf as prf,ipdfrm as frm,ipdtkt as tkt,ipdksq as ksq from iwbpdt
union select ivtprf as prf,ivtfrm as frm,ivttkt as tkt,ivtksq as ksq from iwbvtk
union select irtprf as prf,irtfrm as frm,irttkt as tkt,irtksq as ksq from iwbrtk)
where (prf,frm,tkt) in ((:prf,:frm,:tkt)))
但是这个你怎么解释?