Dead lock detected while creating intermedia index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dead lock detected while creating intermedia index

  1. #1
    Join Date
    Oct 2004
    Posts
    18

    Dead lock detected while creating intermedia index

    I created the context INDEX AS follows;

    BEGIN
    ctx_ddl.create_preference('MYSTORAGE','BASIC_STORAGE');
    ctx_ddl.set_attribute('MYSTORAGE', 'I_TABLE_CLAUSE','tablespace INDEX_TBS INITRANS 3
    MAXTRANS 255 STORAGE (INITIAL 512K NEXT 512K PCTINCREASE 0)');
    END;

    My TABLE have two COLUMNS

    Description VARCHAR2(256)
    Long_Description VARCHAR2(2000);

    I am creating the INDEX ON the above TABLE:

    CREATE INDEX index_name ON TABLE(Long_Description)
    INDEXTYPE IS CTXSYS.CONTEXT
    parameters('storage MYSTORAGE');

    Some times not always, While creating the INDEX I found the following error:

    ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
    ORA-20000: Oracle Text error:
    DRG-50857: oracle error in drekmap (lob write)
    ORA-00060: deadlock detected while waiting for resource

    Can any body suggest what is possible reason.


    Thanking you for ur early reply,
    Sankaram

  2. #2
    Join Date
    Oct 2004
    Posts
    18
    This is the trace file contents:-
    -------------------------------------------------------------
    ORACLE V9.2.0.4.0 - Production vsnsta=0
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    DEADLOCK DETECTED
    No current SQL statement being executed.
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    6A63574C 244 package body CTXSYS.DRIDISP
    6A63574C 412 package body CTXSYS.DRIDISP
    6A63574C 369 package body CTXSYS.DRIDISP
    6A6B89B8 744 package body CTXSYS.DRIDDL
    6A4D7578 152 CTXSYS.TEXTINDEXMETHODS
    68DBE630 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.
    -----------------------------------------------------------------

    Some times I am getting this error also

    ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
    ORA-20000: Oracle Text error:
    ORA-01403: no data found


    I think while creating context indexes we are getting this deadlock error.

    Thanks for ur early reply.
    Sankaram

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