DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 15

Thread: ORA-000060: Deadlock detected.

Threaded View

  1. #1
    Join Date
    Feb 2004
    Location
    Philippines
    Posts
    9

    ORA-000060: Deadlock detected.

    I'm having this kind of error on my sql statements.

    ORA-000060: Deadlock detected.

    Here is the exact error that i got:

    DEADLOCK DETECTED
    Current SQL statement for this session:
    INSERT INTO P_WORK_ITEM_VERSION(WORK_VERSION_ID,ACTIVITY_ID,PARENT_ACTIVITY_ID,WORK_ITEM_ID,PROCESS_TYPE_CODE,CU RRENT_IND,BOX_TYPE_CODE,VERSION,DELETED_IND,PRIORITY_CODE,STATUS_CODE,EMAIL_SENT_IND,VIEWED_IND,RECI PIENTS,SENDERS,SENDER_USER_ID,SENDER_APP_ID,SENT_DATETIME,BOX_ACTOR_TYPE_CODE,BOX_ACTOR_ID,BOX_APP_I D,OWNER_USER_ID,OWNER_APP_ID,HAS_ATTACHMENTS_IND,HAS_COMMENTS_IND,CREATION_DATETIME,CREATED_BY,LAST_ UPDATE_DATETIME,LAST_UPDATE_BY,ERROR_DISPLAY_MESSAGE,ERROR_EXCEPTION_MESSAGE,ERROR_DATETIME,EXPIRED_ IND,PREVIOUS_EXPIRED_IND,PROCESSED_IND,CASCADE_ITERATION,CASCADE_ASSIGN_DATETIME,REMOTE_IND,PERSONAL _SUBFLOW_CORRELATION,PARENT_VERSION_ID,PREVIOUS_ERROR_IND,EXPIRED_EMAIL_SENT_IND,ACTIVITY_PATH,RECLO CK) 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)
    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-000500bc-000003e3 13 20 X 18 19 S
    TX-0003009a-000003e8 18 19 X 13 20 S
    session 20: DID 0001-000D-00000002 session 19: DID 0001-0012-00000002
    session 19: DID 0001-0012-00000002 session 20: DID 0001-000D-00000002
    Rows waited on:
    Session 19: no row
    Session 20: no row

    What should I do to resolve this?.. Thanks!
    Last edited by sparco; 03-21-2004 at 10:06 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width