下面是发生死锁时候的日志文件。问题重点,那种死锁会不让insert数据。任意数据。手动输入到insert语句。
我本地环境模拟的死锁。可以执行insert语句。
----------------------------------------
*** 2011-11-11 15:00:06.843
*** SERVICE NAME:(SYS$USERS) 2011-11-11 15:00:06.671
*** SESSION ID:(248.6026) 2011-11-11 15:00:06.671
DEADLOCK DETECTED
[Transaction Deadlock]
Current SQL statement for this session:
UPDATE office_workflowinstance SET WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AD1B00002AD1}',PARENTWORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-8A9C-B29000001EA5}' WHERE WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AD1B00002AD1}'
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
TM-00033bb9-00000000 21 248 SX SSX 33 223 SX SSX
TM-00033bb9-00000000 33 223 SX SSX 21 248 SX SSX
session 248: DID 0001-0015-00001D38 session 223: DID 0001-0021-000004F0
session 223: DID 0001-0021-000004F0 session 248: DID 0001-0015-00001D38
Rows waited on:
Session 223: obj - rowid = 00033BB1 - AAAzuxAAFAAG+kAAAA
(dictionary objn - 211889, file - 5, block - 1829120, slot - 0)
Session 248: obj - rowid = 00033AF4 - AAAzr0AAFAAFqxUAAA
(dictionary objn - 211700, file - 5, block - 1485908, slot - 0)
Information on the OTHER waiting sessions:
Session 223:
pid=33 serial=13712 audsid=5661856 user: 56/RISENET
O/S info: user: , term: , ospid: 1234, machine: app
program:
Current SQL Statement:
UPDATE office_workflowinstance SET WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AC5600002ACA}',PARENTWORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-8678-FD2100001F1C}' WHERE WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AC5600002ACA}'
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
我本地环境模拟的死锁。可以执行insert语句。
----------------------------------------
*** 2011-11-11 15:00:06.843
*** SERVICE NAME:(SYS$USERS) 2011-11-11 15:00:06.671
*** SESSION ID:(248.6026) 2011-11-11 15:00:06.671
DEADLOCK DETECTED
[Transaction Deadlock]
Current SQL statement for this session:
UPDATE office_workflowinstance SET WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AD1B00002AD1}',PARENTWORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-8A9C-B29000001EA5}' WHERE WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AD1B00002AD1}'
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
TM-00033bb9-00000000 21 248 SX SSX 33 223 SX SSX
TM-00033bb9-00000000 33 223 SX SSX 21 248 SX SSX
session 248: DID 0001-0015-00001D38 session 223: DID 0001-0021-000004F0
session 223: DID 0001-0021-000004F0 session 248: DID 0001-0015-00001D38
Rows waited on:
Session 223: obj - rowid = 00033BB1 - AAAzuxAAFAAG+kAAAA
(dictionary objn - 211889, file - 5, block - 1829120, slot - 0)
Session 248: obj - rowid = 00033AF4 - AAAzr0AAFAAFqxUAAA
(dictionary objn - 211700, file - 5, block - 1485908, slot - 0)
Information on the OTHER waiting sessions:
Session 223:
pid=33 serial=13712 audsid=5661856 user: 56/RISENET
O/S info: user: , term: , ospid: 1234, machine: app
program:
Current SQL Statement:
UPDATE office_workflowinstance SET WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AC5600002ACA}',PARENTWORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-8678-FD2100001F1C}' WHERE WORKFLOWINSTANCE_GUID='{AC10646E-FFFF-FFFF-916B-AC5600002ACA}'
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
解决方案 »
- 帮帮忙,急用!!!
- 这个程序那里错了哦,哎,不明白
- 想给200分的,但是最多只可以给100分。跪求动态insert语句的思路。希望可以耐心看完我的问题。
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- 请问在Oracle中怎么求两个时间相差的天数
- 触发器支不支持事务?如果不支持怎么写?
- (100)如何知道一个表中某个外键所在的表名?最好详细点!
- 告急,请问如何从一张表中导出 指定字段 的记录集到一个文本文件中,且字段以(,\t)为分隔符
- 表删除,不产生日志!能做到么?
- select 中有blob字段 时如果需要对blob字段做排序时怎么做?
- oracle DG 归档日志不能应用问题
- oracle 11g 全文索引
你是说在死锁的时候,可以INSERT?
还是说希望在死锁的时候,不要INSERT?
http://blog.csdn.net/zq9017197/article/details/6909873