-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|