Project

General

Profile

Actions
Copy link

Bug #2060

closed

Documents not indexed because of error generated during indexing of documents

Added by Saurabh Garg about 19 years ago. Updated over 18 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Saurabh Garg
Category:
metacat
Target version:
1.6
Start date:
04/04/2005
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2060

Description

Sometimes given below errors have been seen in the log files. These are
generated because of lack of coordination between the thread updating the
xml_nodes and the thread updating the xml_index table. The result is that
sometimes you have documents which are not indexed.

MetaCat: Error in DBSAXHandler.checkDocumentTable Couldn't find the docid for
index build in reseaonable time!
MetaCat: SQL Exception while inserting path index in DocumentImpl.buildIndex
for document test.200594171957
MetaCat: ORA-02291: integrity constraint (SGARG.XML_INDEX_DOCID_FK) violated -
parent key not found

java.sql.SQLException: ORA-02291: integrity constraint
(SGARG.XML_INDEX_DOCID_FK) violated - parent key not found

at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:125)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:181)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows
(T4CPreparedStatement.java:543)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1028)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:2888)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:2960)
        at edu.ucsb.nceas.metacat.DocumentImpl.updateNodeIndex
(DocumentImpl.java:1345)
        at edu.ucsb.nceas.metacat.DocumentImpl.buildIndex
(DocumentImpl.java:1214)
        at edu.ucsb.nceas.metacat.DBSAXHandler.run(DBSAXHandler.java:444)
        at java.lang.Thread.run(Thread.java:534)

MetaCat: SQL Exception while inserting path index in DocumentImpl.buildIndex
for document test.20059417224
MetaCat: ORA-00001: unique constraint (SGARG.XML_INDEX_PK) violated

java.sql.SQLException: ORA-00001: unique constraint (SGARG.XML_INDEX_PK)
violated

at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:125)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:181)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows
(T4CPreparedStatement.java:543)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1028)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:2888)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:2960)
        at edu.ucsb.nceas.metacat.DocumentImpl.updateNodeIndex
(DocumentImpl.java:1345)
        at edu.ucsb.nceas.metacat.DocumentImpl.buildIndex
(DocumentImpl.java:1214)
        at edu.ucsb.nceas.metacat.DBSAXHandler.run(DBSAXHandler.java:444)
        at java.lang.Thread.run(Thread.java:534)
Actions
Copy link

Also available in: Atom PDF