Finder / Smart Search Index Hangs on Large Content Sites about joomla-cms HOT 2 CLOSED

So I decided to resort to the CLI finder_indexer.php script and I get the following (I purged the Index from Joomla! Backend prior to running CLI script):

• Processed batch 2 in 8.225 seconds.
• Processed batch 3 in 9.309 seconds.
• Processed batch 4 in 15.008 seconds.
• Processed batch 5 in 10.954 seconds.
• Processed batch 6 in 8.943 seconds.
• Processed batch 7 in 11.124 seconds.
• Processed batch 8 in 11.733 seconds.
• Processed batch 9 in 11.457 seconds.
• Processed batch 10 in 9.973 seconds.
  PHP Fatal error: Uncaught exception 'Exception' with message 'Duplicate entry '3235-93612' for key 'PRIMARY' SQL=INSERT INTO d0y2o_finder_links_terms0 (link_id, term_id, weight) SELECT 3235, term_id, ROUND(SUM(context_weight), 8) FROM d0y2o_finder_tokens_aggregate WHERE map_suffix = '0' GROUP BY term ORDER BY term DESC' in /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/indexer.php:762
  Stack trace:
  #0 /var/www/clients/client0/web7/web/plugins/finder/content/content.php(317): FinderIndexer::index(Object(FinderIndexerR
  esult))
  #1 /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/adapter.php(242): plgFinderCont
  ent->index(Object(FinderIndexerResult))
  #2 [internal function]: FinderIndexerAdapter->onBuildIndex()
  #3 /var/www/clients/client0/web7/web/libraries/joomla/event/event.php(71): call_user_func_array(Array, Array)
  #4 /var/www/clients/client0/web7/web/libraries/joomla/event/dispatcher.php(161): JEvent->update(Array)
  #5 /var/www/clients in /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/indexer.php
  on line 762

Fatal error: Uncaught exception 'Exception' with message 'Duplicate entry '3235-93612' for key 'PRIMARY' SQL=INSERT INTO d0y2o_finder_links_terms0 (link_id, term_id, weight) SELECT 3235, term_id, ROUND(SUM(context_weight), 8) FROM d0y2o_finder_tokens_aggregate WHERE map_suffix = '0' GROUP BY term ORDER BY term DESC' in /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/indexer.php:762
Stack trace:
#0 /var/www/clients/client0/web7/web/plugins/finder/content/content.php(317): FinderIndexer::index(Object(FinderIndexerR
esult))
#1 /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/adapter.php(242): plgFinderCont
ent->index(Object(FinderIndexerResult))
#2 [internal function]: FinderIndexerAdapter->onBuildIndex()
#3 /var/www/clients/client0/web7/web/libraries/joomla/event/event.php(71): call_user_func_array(Array, Array)
#4 /var/www/clients/client0/web7/web/libraries/joomla/event/dispatcher.php(161): JEvent->update(Array)
#5 /var/www/clients in /var/www/clients/client0/web7/web/administrator/components/com_finder/helpers/indexer/indexer.php
on line 762

from joomla-cms.

Thanks for posting this, Christopher! Can you send a pull request? If you need to learn how, check out this tutorial:
http://docs.joomla.org/Git_for_Coders

I also created a tracker item for this issue:
http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=30864

You can receive notifications from it by signing in, going to the item, and clicking "Monitor Item" in the left column.

While we’re transitioning to a new integrated tracker, the JoomlaCode tracker is where we do most of Joomla's bug fixing. You can find out more about the process at:
http://docs.joomla.org/Filing_bugs_and_issues

I'm going to close this item, since we have the above JoomlaCode Tracker Item. If and when you submit a pull request, please reference the JoomlaCode Tracker Item URL:
http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=30864

Let me know if you have any questions and I'll be glad to answer. Thanks again, Christopher!

from joomla-cms.