3

Magento Reindex Stuck on "Reindex Required"

As you can see above, when I reindex I am shown a message stating that the reindex was successful. However the status of the index does not change from "Reindex Required".

Efforts:

  • Removed files within ./var/locks/
  • Truncated index tables
  • Tried shell command. Despite success messages I still see "Reindex Required"

    $ php ./shell/indexer.php --reindexall
    Product Attributes index was rebuilt successfully in 00:00:02
    Product Prices index was rebuilt successfully in 00:00:01  
    Catalog Search Index index was rebuilt successfully in 00:00:05
    Stock Status index was rebuilt successfully in 00:00:00
    Tag Aggregation Data index was rebuilt successfully in 00:00:00
    Catalog URL Rewrites index was rebuilt successfully in 00:00:41
    Product Flat Data index was rebuilt successfully in 00:00:03
    Category Flat Data index was rebuilt successfully in 00:00:00
    Category Products index was rebuilt successfully in 00:00:00
    
  • 1
    Please try to index from command line – Amit Bera Jun 24 '15 at 6:30
  • @AmitBera - I apologize, I should have mentioned that I have given that a shot prior to creating this message. Please see my updated post for details. – TylersSN Jun 24 '15 at 6:45
  • 1
    Do the lock files get recreated but then not removed? Perhaps you should check the folder permissions for var/locks so that they can be removed - perhaps chmod to 777 for starters, see if that helps. – Jon Holland Jun 24 '15 at 8:36
2

Humbled, I submit my resolution to this problem.

Magento was reading from a different database than it was updating. In .app/etc/local.xml I had implemented <core_read>,<core_write>, and in a previous dev environment and no longer needed to reference two databases.

I removed the sections to resolve this.

  • 1
    Oops? lol. It was too weird after reindexing from cli. – Vernard Luz Jun 24 '15 at 14:13
  • Exactly. And when saving other admin configurations, the saves being reported as successful, and not seeing the updates C= – TylersSN Jun 24 '15 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.