[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 The from issuing incorrect AD - hoc SQL. The following
Information may aid in determining the deadlock:
Deadlock graph:
-- -- -- -- -- -- -- -- -- Blocker (s) -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Waiter (s) -- -- -- -- -- -- -- -- --
The Resource Name process session doesn waits process session doesn waits
TX - 00080004-0000356 - d 30 1993 X 63 2135 S
TX - 0002001 - d - 000032 - AD 63 2135 X 67 432 S
TX - 0004000 - f - 00002680-67, 432 X 58 1424 S
TX - 00170019-00002985, 58, 1424 X 30 1993 S
The session 1993: DID 2135:0001-001 - e - 0000001 - b session DID 0001-003 - f - 00000005
The session 2135: DID 432:0001-003 - f - 00000005 session DID the 0001-0043-0000 0005
The session 432: DID the 0001-0043-0000 0005 session 1424: DID 0001-003 - a - 00000006
The session 1424: DID 1993:0001-003 - a - 00000006 session DID 0001-001 - e - 0000001 - b
Rows waited on:
The Session 1993: no row
The Session 2135: obj - rowid=0000403 - d - AAAEA9AAfAAAAJIAAA
File - (dictionary objn - 16445, 31, block - 584, slot 0)
The Session 432: no row
The Session 1424: obj - rowid=0000403 - d - AAAEA9AAdAAHErcAAA
(a dictionary objn - 16445, the file - 29, block - 1854172, slot 0)
-- -- -- -- -- Information for OTHER waiting sessions -- -- -- -- --
The Session 2135:
Sid: 2135 ser: 37 audsid: 46/CUT 16230041 user:
Flags: (0 x45) USR/- flags_idl: (0 x1) BSY/-/-/-/-/-
Flags2: (0 x40009) -/-/INC
Pid: 63 O/S info: user: grid, term: UNKNOWN, ospid: 128279
Image: oracle @ dbs0xjlcprc01
The client details:
O/S info: user: devuser, term: ospid: 11536
Machine: mds0xjlcprc01 program: odbcserver @ mds0xjlcprc01 (TNS V1 - V3)
The application name: odbcserver @ mds0xjlcprc01 (TNS V1 and V3), hash value=https://bbs.csdn.net/topics/4150815403
The current SQL:
Insert into the cut. Mlc_dataserver_ddt (SETTLEMENT_DATE BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date (' 20180724 ', 'yyyymmdd'), '015 d89230120180723071629bf63', '03201807241735578 b2d5d8923016201, sysdate)
The Session 432:
Sid: 432 ser: 11 audsid: 16230045 user: 46/CUT
Flags: (0 x45) USR/- flags_idl: (0 x1) BSY/-/-/-/-/-
Flags2: (0 x40009) -/-/INC
Pid: 67 O/S info: user: grid, term: UNKNOWN, ospid: 128289
Image: oracle @ dbs0xjlcprc01
The client details:
O/S info: user: devuser, term: ospid: 11524
Machine: mds0xjlcprc01 program: odbcserver @ mds0xjlcprc01 (TNS V1 - V3)
The application name: odbcserver @ mds0xjlcprc01 (TNS V1 and V3), hash value=https://bbs.csdn.net/topics/4150815403
The current SQL:
Insert into the cut. Mlc_dataserver_ddt (SETTLEMENT_DATE BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date (' 20180724 ', 'yyyymmdd'), '015 d89230120180723080129cb64', '0320180724173557932 d5d8923016201, sysdate)
The Session 1424:
Sid: 1424 ser: 53 audsid: 46/CUT 16230036 user:
Flags: (0 x45) USR/- flags_idl: (0 x1) BSY/-/-/-/-/-
Flags2: (0 x40009) -/-/INC
Pid: 58 O/S info: user: grid, term: UNKNOWN, ospid: 128271
Image: oracle @ dbs0xjlcprc01
The client details:
O/S info: user: devuser, term: ospid: 11510
Machine: mds0xjlcprc01 program: odbcserver @ mds0xjlcprc01 (TNS V1 - V3)
The application name: odbcserver @ mds0xjlcprc01 (TNS V1 and V3), hash value=https://bbs.csdn.net/topics/4150815403
The current SQL:
Insert into the cut. Mlc_dataserver_ddt (SETTLEMENT_DATE BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date (' 20180724 ', 'yyyymmdd'), '015 d89230120180723080129c264', '0320180724173557922 d5d8923016201, sysdate)
CodePudding user response:
Insert the same primary key, before the statement did not submit may produce the lock