SES Crawler execution against ContentDB Database Receives Errors ORA-01555: snapshot too old (Doc ID 783052.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Secure Enterprise Search - Version: 10.1.8.4 to 11.1.2
This problem can occur on any platform.

Symptoms

When running the SES ContentDB JDBC crawler (10.1.8.4) against a large container within ContentDB (more than 100,000 documents) we get the following error:

ORA-01555: snapshot too old: rollback segment number 4 with name "_SYSSMU4$" too small.

The crawler log file contains:

13:06:39:737 ERROR filter_0 EQP-80432: Exception while queueing document: ORA-01555: snapshot too old: rollback segment number 4 with name "_SYSSMU4$" too small . Ignoring the
documen....
13:06:39:738 ERROR filter_0 ORA-01555: snapshot too old: rollback segment number 4 with name "_SYSSMU4$" too small

java.sql.SQLException
oracle.jdbc.driver.DatabaseError:throwSqlException:125
oracle.jdbc.driver.T4CTTIoer:processError:316
oracle.jdbc.driver.T4CTTIoer:processError:282
oracle.jdbc.driver.T4C8Oall:receive:639
oracle.jdbc.driver.T4CPreparedStatement:doOall8:185
oracle.jdbc.driver.T4CPreparedStatement:fetch:692
oracle.jdbc.driver.OracleResultSetImpl:close_or_fetch_from_next:258
oracle.jdbc.driver.OracleResultSetImpl:next:193
oracle.search.plugin.cdbjdbc.CdbJdbcPlugin:reQueueFolder:1272
oracle.search.plugin.cdbjdbc.CdbJdbcPlugin:queueDocuments:1132
oracle.search.plugin.cdbjdbc.CdbJdbcPlugin:crawl:1323
oracle.search.crawler.CrawlingThread:run:1578


The ContentDB database alert.log includes the following information:

Mon Feb 9 18:00:26 2009 Thread 1 advanced to log sequence 7810 Current log# 5 seq# 7810 mem# 0:
/data1/ContentDB/cdb/redo05.log

Mon Feb 9 18:01:14 2009 ORA-01555 caused by SQL statement below (SQL ID: 8hrx00yw0cmuh, Query
Duration=659 sec, SCN: 0x0000.48a4347d):

Mon Feb 9 18:01:14 2009
select documentid from IFS_SYS.odmzv_secured_document doc
where doc.parentfolder id in
( select fold.folderid from IFS_SYS.odmzv_folder_hierarchy fold
start with fold.folderid = :1 connect by prior fold.folderid = fold.parentfolderid)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms