I am getting following error message:Ġ2:25:25,899 ERROR Error executing update for rawSQL: UPDATE PRODDTA.I have a multi-threaded batch process running on Production that fails due to "ORA-00060 : Deadlock detected while waiting for resource". O/S info: user: psft, term:, ospid: 15567, machine: s2-btcĪpplication name: (TNS V1-V3), hash value=0 Information on the OTHER waiting sessions: Session 129: obj - rowid = 00007100 - AAAHEAAAqAAALKeAAA Session 234: obj - rowid = 00007102 - AAAHEPAApAAALyqAAF Resource Name process session holds waits process session holds waits Information may aid in determining the deadlock: It is aĭeadlock due to user error in the design of an application The following deadlock is not an ORACLE error. JOBN=:BND6,IBUPMJ=:BND7,IBTDAY=:BND8 WHERE ( IBITM = :KEY1 AND IBMCU = :KEY2 ) UPDATE PRODDTA.F4102 SET IBITM=:BND1,IBMCU=:BND2,IBMRPC=:BND3,IBUSER=:BND4,IBPID=:BND5,IB Oracle9i Release 9.2.0.5.0 - 64bit Production JDB4200003 - OPEN TABLE NOT CLOSED = F4102 Oracle 9.2.0.5 on a Sun Fire V440 8 Gb RAM, 4 CPU, Solaris 9 We run stress tests on our platform and after 2 hours, we meet deadlocks on 2 tables.Į1 8.94 L1 on a Sun Fire V440 4 Gb RAM, 2 CPU, Solaris 9
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |