/opt/app/oracle/admin/psyy/udump/psyy_ora_16780.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/app/oracle/product/9.2/
System name: Linux
Node name: ibm
Release: 2.6.9-78.ELsmp
Version: #1 SMP Wed Jul 9 15:46:26 EDT 2008
Machine: x86_64
Instance name: psyy
Redo thread mounted by this instance: 1
Oracle process number: 134
Unix process pid: 16780, image: oracle@ibm (TNS V1-V3)*** 2009-11-09 08:41:08.341
*** SESSION ID:(24.1765) 2009-11-09 08:41:08.340
DEADLOCK DETECTED
Current SQL statement for this session:
update bms_st_sum_qty set Fitoutqty=nvl(Fitoutqty,0)+ :goodsqty where rowid = 'AAAIEIAAMAAEnOxACC'
----- PL/SQL Call Stack -----
object line object
handle number name
0x1016ba7f8 1120 package body SYS.DBMS_SYS_SQL
0xf1b1fa78 323 package body SYS.DBMS_SQL
0x10475c5b0 869 package body PSYY.BMS_STIO_CALC_PK
0x10475c5b0 3801 package body PSYY.BMS_STIO_CALC_PK
0x10475c5b0 4241 package body PSYY.BMS_STIO_CALC_PK
0x1067d8588 1 anonymous block
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-00040004-0001e0b0 134 24 X 125 212 X
TX-00090001-0001e458 125 212 X 134 24 X
session 24: DID 0001-0086-000000C1 session 212: DID 0001-007D-0000010D
session 212: DID 0001-007D-0000010D session 24: DID 0001-0086-000000C1
Rows waited on:
Session 212: obj - rowid = 00008108 - AAAIEIAAMAAEnO5AC6
(dictionary objn - 33032, file - 12, block - 1209273, slot - 186)
Session 24: obj - rowid = 00008108 - AAAIEIAAMAAEnOxACC
(dictionary objn - 33032, file - 12, block - 1209265, slot - 130)
Information on the OTHER waiting sessions:
Session 212:
pid=125 serial=58625 audsid=272008 user: 61/PSYY
O/S info: user: Administrator, term: LSKP-SK, ospid: 1448:1444, machine: WORKGROUP\LSKP-SK
program: bms3.exe
application name: bms3.exe, hash value=0
Current SQL Statement:
update bms_st_sum_qty set Fitoutqty=nvl(Fitoutqty,0)+ :goodsqty where rowid = 'AAAIEIAAMAAEnO5AC6'
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
Process global information:
process: 0xe42c9d20, call: 0xe60943d8, xact: 0xe64cd668, curses: 0xe430b508, usrses: 0xe430b508
----------------------------------------
SO: 0xe42c9d20, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=134, calls cur/top: 0xe60943d8/0xeae17a08, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 4
last post received-location: kslpsr
last process to post me: e42a0f10 1 6
last post sent: 0 0 49
last post sent-location: kcbzww
last process posted by me: e42b0fa8 131 0
(latch info) wait_event=0 bits=10
holding 5000a598 Parent+children enqueue hash chains level=4
Location from where latch is held: ksqcmi: kslgpl:
Context saved from call: 0
state=busy
recovery area:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/app/oracle/product/9.2/
System name: Linux
Node name: ibm
Release: 2.6.9-78.ELsmp
Version: #1 SMP Wed Jul 9 15:46:26 EDT 2008
Machine: x86_64
Instance name: psyy
Redo thread mounted by this instance: 1
Oracle process number: 134
Unix process pid: 16780, image: oracle@ibm (TNS V1-V3)*** 2009-11-09 08:41:08.341
*** SESSION ID:(24.1765) 2009-11-09 08:41:08.340
DEADLOCK DETECTED
Current SQL statement for this session:
update bms_st_sum_qty set Fitoutqty=nvl(Fitoutqty,0)+ :goodsqty where rowid = 'AAAIEIAAMAAEnOxACC'
----- PL/SQL Call Stack -----
object line object
handle number name
0x1016ba7f8 1120 package body SYS.DBMS_SYS_SQL
0xf1b1fa78 323 package body SYS.DBMS_SQL
0x10475c5b0 869 package body PSYY.BMS_STIO_CALC_PK
0x10475c5b0 3801 package body PSYY.BMS_STIO_CALC_PK
0x10475c5b0 4241 package body PSYY.BMS_STIO_CALC_PK
0x1067d8588 1 anonymous block
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-00040004-0001e0b0 134 24 X 125 212 X
TX-00090001-0001e458 125 212 X 134 24 X
session 24: DID 0001-0086-000000C1 session 212: DID 0001-007D-0000010D
session 212: DID 0001-007D-0000010D session 24: DID 0001-0086-000000C1
Rows waited on:
Session 212: obj - rowid = 00008108 - AAAIEIAAMAAEnO5AC6
(dictionary objn - 33032, file - 12, block - 1209273, slot - 186)
Session 24: obj - rowid = 00008108 - AAAIEIAAMAAEnOxACC
(dictionary objn - 33032, file - 12, block - 1209265, slot - 130)
Information on the OTHER waiting sessions:
Session 212:
pid=125 serial=58625 audsid=272008 user: 61/PSYY
O/S info: user: Administrator, term: LSKP-SK, ospid: 1448:1444, machine: WORKGROUP\LSKP-SK
program: bms3.exe
application name: bms3.exe, hash value=0
Current SQL Statement:
update bms_st_sum_qty set Fitoutqty=nvl(Fitoutqty,0)+ :goodsqty where rowid = 'AAAIEIAAMAAEnO5AC6'
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
Process global information:
process: 0xe42c9d20, call: 0xe60943d8, xact: 0xe64cd668, curses: 0xe430b508, usrses: 0xe430b508
----------------------------------------
SO: 0xe42c9d20, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=134, calls cur/top: 0xe60943d8/0xeae17a08, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 4
last post received-location: kslpsr
last process to post me: e42a0f10 1 6
last post sent: 0 0 49
last post sent-location: kcbzww
last process posted by me: e42b0fa8 131 0
(latch info) wait_event=0 bits=10
holding 5000a598 Parent+children enqueue hash chains level=4
Location from where latch is held: ksqcmi: kslgpl:
Context saved from call: 0
state=busy
recovery area:
解决方案 »
- 请教实现如下功能的sql
- OEM备份oracle连接主机失败,密码错误
- linux as5下执行SH报错,syntax error near unexpected token '(',请大哥大姐帮帮忙!
- 复杂视图的问题
- windows2000server + 9.0.1.1 ---> windows server 2003 + 9.2.0.4
- 关于oracle10g的监听程序
- 怎样恢复Oracle数据(没有归档)
- 帮忙把一段sqlserver的函数转成oracle.
- 急,编译的时候出错
- 关掉Oracle9自带Web服务器或者改变其端口
- ORACLE 如何引发一个应用级别的异常
- 两表间的判断和赋值
oracle的TM锁、TX锁知识完全普及
http://blog.csdn.net/crazylaa/archive/2009/12/08/4966787.aspx