Full Deployments Are Causing Large SRCH_UPDATE_QUEUE, Which Is Causing Search Indexes To Take Longer Than Expected (Doc ID 1474507.1)

Last updated on OCTOBER 20, 2015

Applies to:

Oracle ATG Web Commerce Search - Version 10.0 to 10.0.3.1 [Release 10]
Information in this document applies to any platform.

Symptoms

Performing a Content Administration (CA) Full Deployment is causing the /atg/search/repository/IncrementalItemQueueRepository.item (srch_update_queue table) to fill up. Consequently, Search indexes are taking an extraordinarily long amount of time to complete and may have appear to hang. If the srch_update_queue is truncated prior to running the Search Full Index, the index completes in a fraction of the time.  

Thread dumps taken when the problem is happening will show that the index is trying to clean up, meaning delete the entries in the srch_update_queue table.

Thread from SearchAdmin instance:

Changes

The configuration has been confirmed as follows...

-- All instances have their ProductCatalogOutputConfig.IncrementalUpdateSeconds=-1
-- And enableIncrementalLoading=false for those same IOCs
-- The only exception to the above is the ProductCatalogOutputConfig.enableIncrementalLoading on the instance SearchAdmin is using for its {Search_Project}-> Content Set.

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