Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

ora-60 deadlock

Steve Bear_1
Frequent Advisor

ora-60 deadlock

dead lock

oracle (version 8.1.6) has generated a trace with deadlock ora-60.

trace output...

*** 2004-01-16 07:52:56.234
*** SESSION ID:(55.20) 2004-01-16 07:52:56.230
DEADLOCK DETECTED
Current SQL statement for this session:
INSERT INTO itc.ttisfc001100 (t$pdno,t$cprj,t$mitm,t$opro,t$cwar,t$qrdr,t$qntl,t$qdlv,t$qrjc,t$qrjp,t$qtbf,t$qbfd,t$qtbi,t$qtri,t$prdt,t$prdp,t$dldt,t$dldp,t
$apdt,t$cmdt,t$cldt,t$efdt,t$prcd,t$rwko,t$rpsd,t$nsdl,t$copr,t$matc,t$oprc,t$cpla,t$mupr,t$dvpr,t$covn,t$roul,t$oprn,t$matl,t$matn,t$subn,t$chel,t$sawl,t$cut
l,t$recn,t$insn,t$osta,t$nnts,t$pnpt,t$runi,t$ncmp,t$bfep,t$bfhr,t$mmpo,t$mmno,t$qoor,t$oprp,t$qcmo,t$qrjo,t$opcp,t$opcy,t$oprj,t$clot,t$post,t$comp,t$txta,t$
revi,t$Refcntd,t$Refcntu) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:
34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66)
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-0007000e-0000dd1f 14 55 X 22 57 X
TX-00090031-0000dd75 22 57 X 14 55 S
session 55: DID 0001-000E-00000004 session 57: DID 0001-0016-00000005
session 57: DID 0001-0016-00000005 session 55: DID 0001-000E-00000004
Rows waited on:
Session 57: obj - rowid = 00072448 - AAByRIABgAAAK8DAAJ
Session 55: no row
===================================================
PROCESS STATE


-----------------

Any suggestion ? what was the problem , why session-55 with "no rows"

Thanks,

4 REPLIES
Joseph Loo
Honored Contributor

Re: ora-60 deadlock

hi,

There is quite a bit of info on ora-60 and deadlock in Oracle Metalink 164661.1 and 62365.1.

see attachments for the above metalink documents.

regards.
what you do not see does not mean you should not believe
Jean-Luc Oudart
Honored Contributor

Re: ora-60 deadlock

As Oracle customer you should have access to Metalink.
Check the followings notes for explanation on deadlock :
<62365.1> What to do with "ORA-60 Deadlock Detected" Errors
<164661.1> Ora-60 And Deadlocks Most Common Causes


rgds,
Jean-Luc
fiat lux
Volker Borowski
Honored Contributor

Re: ora-60 deadlock

Well,

Metalink has some stuff on it.

Here is the shortcut:
Change storage clause INITRANS (default 1) to a higher value (5-10) (For table and indexes). In most cases, this gives you a better chance that the deadlock does not occur.
If you only do INSERTS, it might be sufficiant just to alter table/index.

If you have (or will have) massive concurrent updates on this table as well, you need to reorganize the table, so that the already allocated blocks get new INITRANS-entries.

Hope this helps
Volker
Martin Roesicke
Occasional Visitor

Re: ora-60 deadlock

Well,

seems, that you are using BaaN.
Update your Oracle Version to min. 8.1.7.4,
newest Portingset and newest Standard Objects.
Thats a well know problem in some Baan Sessions. At least you could contact BGS.

Martin