I am using Magento 22.214.171.124 and am using Magmi CLI to run imports - this error below occurs both on magmi and normal importing.
Everything is working fine and importing correctly however I have a problem with indexing for Catalog Url Rewrites.
I have tried this in the manual shell through SSH -
/public_html/shell/ php indexer.php --reindex catalog_url
And this just times out and doesn’t stop.
(I have also deleted the locks) - to ensure that this is not what is causing it to fail, cleared cache and deleted sessions. Tried different sequence of indexes.
My product /category stucture is setup as below
Product Category 1
SubCategory 1 (7000 items)-
SubCategory 2 (7000 items Same items as above)-
SubCategory 3 (7000 items Same items as above)-
Product Category 2 (658 items)
Product Category 3
SubCategory 1 (60 items)
SubCategory 2 (45 items)
Product Category 4
I believe it may be something to do with the way the structure is setup that it is causing it to fail. I have turned logging on in magento admin and I do not get any exceptions or system errors.
If I truncate core_url_rewrite and run the indexing job it will work fine. It’s only after I go to do my second -reindex it never finishes.
I have also disabled the below from the Url.php page (processes index) to make sure there is no exception causing it to fail.
// Mage::throwException(Mage::helper(’catalog’)->__(’An error occurred while saving the URL rewrite’));
I am really out of ideas and do not know where to look next.
There seems to be many errors out there with the catalog_url rewrite index however it is all mixed and does not provide a thorough solution or reason as to why people do what they choose to do.
Please let me know if you need any extra info from me - I’m sure there are a few others out there in the same boat.
Any help is greatly appreciated.