Magento - Can’t initialize indexer process - Product Attributes - Magento 1.4.0 Upgrade Issues - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Can’t initialize indexer process - Product Attributes

DaymoH Total Posts: 96 Joined: 2008-09-18 Ignore user	I am trying to reindex the product attributes and am getting the error Can’t initialize indexer process. The product attributes are stuck on ‘Processing’ in my exception.log I am getting 2010-08-06T07:01:06+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db_magent0/catalog_product_index_eav`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON ) I’ve tried al kinds of thingsd from the forums and none are fixing it, any ideas? Thanks
	Posted: August 6 2010 \| top

DaymoH Total Posts: 96 Joined: 2008-09-18 Ignore user	If I set System>Configuration>Inventory>Display Out of Stock Products to NO I can re-index no problem. Anyone any clues how to fix it?, and I hope that helps someone.
	Posted: August 6 2010 \| top \| # 1

mooooo Total Posts: 16 Joined: 2010-07-10 Ignore user	Hmmm, that didn\’t work for me.
	Posted: August 15 2010 \| top \| # 2

spectrumaudio Total Posts: 39 Joined: 2008-07-22 Ignore user	I am having the same error “Cannot initialize the indexer process” for Product Attributes only Using 1.4.1.1 Anyone find a solution?
	Posted: September 1 2010 \| top \| # 3

mooooo Total Posts: 16 Joined: 2010-07-10 Ignore user	Try deleting your products then re-importing; worked for me recently on 1.4.1.0
	Posted: September 1 2010 \| top \| # 4

spectrumaudio Total Posts: 39 Joined: 2008-07-22 Ignore user	If I set System>Configuration>Inventory>Display Out of Stock Products to NO I can re-index no problem. Anyone any clues how to fix it?, and I hope that helps someone. I just tried this again and it worked for me.
	Posted: September 1 2010 \| top \| # 5

guillaume7684 Total Posts: 239 Joined: 2008-10-20 Ignore user	DaymoH - 06 August 2010 05:18 AM If I set System>Configuration>Inventory>Display Out of Stock Products to NO I can re-index no problem. Anyone any clues how to fix it?, and I hope that helps someone. Hi, I have exactly the same problem as yours. When I set: Display Out of Stock Products to NO I can reindex without problem When I set: YES I have this error message: There was a problem with reindexing process. And the line “Product Attributes” Index product attributes for layered navigation building is in status “processing” Can you help me, please? Thank you.
	Posted: February 18 2011 \| top \| # 6

yo5ofh Total Posts: 8 Joined: 2008-11-02 Ignore user	Anybody found a solution for this problem??? Thanks
	Posted: February 27 2011 \| top \| # 7

DeeperID Total Posts: 3 Joined: 2011-03-18 Ignore user	I had this same issue, found this forum post but the steps didn’t lead me to the solution unfortunately. The subject was a good match though. In my situation, the indexer process encountered an integrity constraint error with the indexing table ‘catalog_product_index_eav’. That may be helpful or not depending on what error you’re actually running into so the way I determined the error was looking at the latest messages in the “/var/log/system.log” file. In our case it mentioned an error like this: 2011-03-24T23:54:47+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1487-577-1-464’ for key ‘PRIMARY’ Then on the subsequent lines there was mention of each file (trace) that lead up to the error. It ended up that several of our products had duplicate entries for a multiselect attribute (which was a fault of our own from setting attributes in code for several reasons). At any rate, I hope that helps people when tracking down their actual issue with the reindexing because the steps above, although they may work for some, they didn’t work for us because the issue halting our indexing process was a result of bad data.
	Posted: March 25 2011 \| top \| # 8

jvb888 Total Posts: 4 Joined: 2010-01-22 Ignore user	I had a problem reindexing the layered navigation with the option “Display Out of Stock Products” set to Yes. The Product Attributes (Index product attributes for layered navigation building) keeped on processing after a manual reindex click. I solved my problem by adding the reindex by adding the following line to the /etc/crontab : 01 6 * * * root /usr/bin/php5 -f <magento dir>/shell/indexer.php reindexall After the daily job all indexes were rebuild succesfully
	Posted: April 28 2011 \| top \| # 9

kneemahp Total Posts: 114 Joined: 2008-08-07 Ignore user	This worked for me! run this in your sql ALTER TABLE admin_assert ENGINE = InnoDB; ALTER TABLE admin_role ENGINE = InnoDB; ALTER TABLE admin_rule ENGINE = InnoDB; ALTER TABLE admin_user ENGINE = InnoDB; ALTER TABLE api_assert ENGINE = InnoDB; ALTER TABLE api_role ENGINE = InnoDB; ALTER TABLE api_rule ENGINE = InnoDB; ALTER TABLE api_user ENGINE = InnoDB; ALTER TABLE catalogindex_eav ENGINE = InnoDB; ALTER TABLE catalogindex_minimal_price ENGINE = InnoDB; ALTER TABLE catalogindex_price ENGINE = InnoDB; ALTER TABLE cataloginventory_stock_item ENGINE = InnoDB; ALTER TABLE catalogrule ENGINE = InnoDB; ALTER TABLE catalogrule_product ENGINE = InnoDB; ALTER TABLE catalogrule_product_price ENGINE = InnoDB; ALTER TABLE catalogsearch_query ENGINE = InnoDB; ALTER TABLE catalog_category_entity ENGINE = InnoDB; ALTER TABLE catalog_category_entity_datetime ENGINE = InnoDB; ALTER TABLE catalog_category_entity_decimal ENGINE = InnoDB; ALTER TABLE catalog_category_entity_int ENGINE = InnoDB; ALTER TABLE catalog_category_entity_text ENGINE = InnoDB; ALTER TABLE catalog_category_entity_varchar ENGINE = InnoDB; ALTER TABLE catalog_category_product ENGINE = InnoDB; ALTER TABLE catalog_category_product_index ENGINE = InnoDB; ALTER TABLE catalog_compare_item ENGINE = InnoDB; ALTER TABLE catalog_product_bundle_option ENGINE = InnoDB; ALTER TABLE catalog_product_bundle_option_value ENGINE = InnoDB; ALTER TABLE catalog_product_bundle_selection ENGINE = InnoDB; ALTER TABLE catalog_product_enabled_index ENGINE = InnoDB; ALTER TABLE catalog_product_entity_datetime ENGINE = InnoDB; ALTER TABLE catalog_product_entity_decimal ENGINE = InnoDB; ALTER TABLE catalog_product_entity_gallery ENGINE = InnoDB; ALTER TABLE catalog_product_entity_int ENGINE = InnoDB; ALTER TABLE catalog_product_entity_media_gallery ENGINE = InnoDB; ALTER TABLE catalog_product_entity_media_gallery_value ENGINE = InnoDB; ALTER TABLE catalog_product_entity_text ENGINE = InnoDB; ALTER TABLE catalog_product_entity_tier_price ENGINE = InnoDB; ALTER TABLE catalog_product_entity_varchar ENGINE = InnoDB; ALTER TABLE catalog_product_link ENGINE = InnoDB; ALTER TABLE catalog_product_link_attribute ENGINE = InnoDB; ALTER TABLE catalog_product_link_attribute_decimal ENGINE = InnoDB; ALTER TABLE catalog_product_link_attribute_int ENGINE = InnoDB; ALTER TABLE catalog_product_link_attribute_varchar ENGINE = InnoDB; ALTER TABLE catalog_product_link_type ENGINE = InnoDB; ALTER TABLE catalog_product_option ENGINE = InnoDB; ALTER TABLE catalog_product_option_price ENGINE = InnoDB; ALTER TABLE catalog_product_option_title ENGINE = InnoDB; ALTER TABLE catalog_product_option_type_price ENGINE = InnoDB; ALTER TABLE catalog_product_option_type_title ENGINE = InnoDB; ALTER TABLE catalog_product_option_type_value ENGINE = InnoDB; ALTER TABLE catalog_product_super_attribute ENGINE = InnoDB; ALTER TABLE catalog_product_super_attribute_label ENGINE = InnoDB; ALTER TABLE catalog_product_super_attribute_pricing ENGINE = InnoDB; ALTER TABLE catalog_product_super_link ENGINE = InnoDB; ALTER TABLE catalog_product_website ENGINE = InnoDB; ALTER TABLE checkout_agreement ENGINE = InnoDB; ALTER TABLE checkout_agreement_store ENGINE = InnoDB; ALTER TABLE cms_block ENGINE = InnoDB; ALTER TABLE cms_block_store ENGINE = InnoDB; ALTER TABLE cms_page ENGINE = InnoDB; ALTER TABLE cms_page_store ENGINE = InnoDB; ALTER TABLE core_config_data ENGINE = InnoDB; ALTER TABLE core_email_template ENGINE = InnoDB; ALTER TABLE core_flag ENGINE = InnoDB; ALTER TABLE core_layout_link ENGINE = InnoDB; ALTER TABLE core_layout_update ENGINE = InnoDB; ALTER TABLE core_resource ENGINE = InnoDB; ALTER TABLE core_session ENGINE = InnoDB; ALTER TABLE core_store ENGINE = InnoDB; ALTER TABLE core_store_group ENGINE = InnoDB; ALTER TABLE core_translate ENGINE = InnoDB; ALTER TABLE core_url_rewrite ENGINE = InnoDB; ALTER TABLE cron_schedule ENGINE = InnoDB; ALTER TABLE customer_address_entity ENGINE = InnoDB; ALTER TABLE customer_address_entity_datetime ENGINE = InnoDB; ALTER TABLE customer_address_entity_decimal ENGINE = InnoDB; ALTER TABLE customer_address_entity_int ENGINE = InnoDB; ALTER TABLE customer_address_entity_text ENGINE = InnoDB; ALTER TABLE customer_address_entity_varchar ENGINE = InnoDB; ALTER TABLE customer_entity ENGINE = InnoDB; ALTER TABLE customer_entity_datetime ENGINE = InnoDB; ALTER TABLE customer_entity_decimal ENGINE = InnoDB; ALTER TABLE customer_entity_int ENGINE = InnoDB; ALTER TABLE customer_entity_text ENGINE = InnoDB; ALTER TABLE customer_entity_varchar ENGINE = InnoDB; ALTER TABLE customer_group ENGINE = InnoDB; ALTER TABLE dataflow_batch ENGINE = InnoDB; ALTER TABLE dataflow_batch_export ENGINE = InnoDB; ALTER TABLE dataflow_batch_import ENGINE = InnoDB; ALTER TABLE dataflow_import_data ENGINE = InnoDB; ALTER TABLE dataflow_profile ENGINE = InnoDB; ALTER TABLE dataflow_profile_history ENGINE = InnoDB; ALTER TABLE dataflow_session ENGINE = InnoDB; ALTER TABLE design_change ENGINE = InnoDB; ALTER TABLE directory_country ENGINE = InnoDB; ALTER TABLE directory_country_region ENGINE = InnoDB; ALTER TABLE directory_country_region_name ENGINE = InnoDB; ALTER TABLE directory_currency_rate ENGINE = InnoDB; ALTER TABLE eav_attribute_group ENGINE = InnoDB; ALTER TABLE eav_attribute_option ENGINE = InnoDB; ALTER TABLE eav_attribute_option_value ENGINE = InnoDB; ALTER TABLE eav_attribute_set ENGINE = InnoDB; ALTER TABLE eav_entity ENGINE = InnoDB; ALTER TABLE eav_entity_attribute ENGINE = InnoDB; ALTER TABLE eav_entity_datetime ENGINE = InnoDB; ALTER TABLE eav_entity_decimal ENGINE = InnoDB; ALTER TABLE eav_entity_int ENGINE = InnoDB; ALTER TABLE eav_entity_text ENGINE = InnoDB; ALTER TABLE eav_entity_type ENGINE = InnoDB; ALTER TABLE eav_entity_varchar ENGINE = InnoDB; ALTER TABLE gift_message ENGINE = InnoDB; ALTER TABLE googlebase_attributes ENGINE = InnoDB; ALTER TABLE googlebase_items ENGINE = InnoDB; ALTER TABLE googlebase_types ENGINE = InnoDB; ALTER TABLE googlecheckout_api_debug ENGINE = InnoDB; ALTER TABLE googleoptimizer_code ENGINE = InnoDB; ALTER TABLE newsletter_problem ENGINE = InnoDB; ALTER TABLE newsletter_queue ENGINE = InnoDB; ALTER TABLE newsletter_queue_link ENGINE = InnoDB; ALTER TABLE newsletter_queue_store_link ENGINE = InnoDB; ALTER TABLE newsletter_subscriber ENGINE = InnoDB; ALTER TABLE newsletter_template ENGINE = InnoDB; ALTER TABLE paygate_authorizenet_debug ENGINE = InnoDB; ALTER TABLE paypaluk_api_debug ENGINE = InnoDB; ALTER TABLE paypal_api_debug ENGINE = InnoDB; ALTER TABLE poll ENGINE = InnoDB; ALTER TABLE poll_answer ENGINE = InnoDB; ALTER TABLE poll_store ENGINE = InnoDB; ALTER TABLE poll_vote ENGINE = InnoDB; ALTER TABLE product_alert_price ENGINE = InnoDB; ALTER TABLE rating ENGINE = InnoDB; ALTER TABLE rating_entity ENGINE = InnoDB; ALTER TABLE rating_option ENGINE = InnoDB; ALTER TABLE rating_option_vote ENGINE = InnoDB; ALTER TABLE rating_option_vote_aggregated ENGINE = InnoDB; ALTER TABLE rating_store ENGINE = InnoDB; ALTER TABLE rating_title ENGINE = InnoDB; ALTER TABLE report_event ENGINE = InnoDB; ALTER TABLE report_event_types ENGINE = InnoDB; ALTER TABLE review ENGINE = InnoDB; ALTER TABLE review_detail ENGINE = InnoDB; ALTER TABLE review_entity ENGINE = InnoDB; ALTER TABLE review_entity_summary ENGINE = InnoDB; ALTER TABLE review_status ENGINE = InnoDB; ALTER TABLE review_store ENGINE = InnoDB; ALTER TABLE salesrule ENGINE = InnoDB; ALTER TABLE salesrule_customer ENGINE = InnoDB; ALTER TABLE sales_flat_order_item ENGINE = InnoDB; ALTER TABLE sales_flat_quote ENGINE = InnoDB; ALTER TABLE sales_flat_quote_address ENGINE = InnoDB; ALTER TABLE sales_flat_quote_address_item ENGINE = InnoDB; ALTER TABLE sales_flat_quote_item ENGINE = InnoDB; ALTER TABLE sales_flat_quote_item_option ENGINE = InnoDB; ALTER TABLE sales_flat_quote_payment ENGINE = InnoDB; ALTER TABLE sales_flat_quote_shipping_rate ENGINE = InnoDB; This is where i got the idea http://www.magentocommerce.com/boards/error.php/viewreply/239933/ Signature Visit my breathalyzer website for the latest alcohol testers
	Posted: May 5 2011 \| top \| # 10

qiqiy Total Posts: 2 Joined: 2010-10-22 Ignore user	It’s not work for me, i use magento 1.5 ,when reindex Catalog Search Index, show “There was a problem with reindexing process.” what’s the proble :(
	Posted: August 17 2011 \| top \| # 11

jfedgar Total Posts: 4 Joined: 2012-02-12 Ignore user	For me, the solution in this post helped: http://www.magentocommerce.com/boards/viewthread/261848/ The part that helped me: First, search for “catalog_product_flat” there should only be 1 matching table. For us, its catalog_product_flat_1 Then run under SQL: SET FOREIGN_KEY_CHECKS=0; DROP TABLE catalog_product_flat_1 Then in SSH, run: php path/to/shell/indexer.php --reindex catalog_product_flat
	Posted: February 22 2012 \| top \| # 12

dbashyal Total Posts: 159 Joined: 2008-09-12 rockdale, sydney, australia Ignore user	its easy to fix, check this: http://learntipsandtricks.com/blog/92/114/magento-index-management-Cannot-initialize-the-indexer-process Signature --- Developed 10 ecommerce sites with Magento and counting --------------------- My Portfolio \| Magento Tips & Tricks \| Twitter \| Facebook \| My Search Engine
	Posted: March 2 2012 \| top \| # 13

jrossi Total Posts: 1 Joined: 2012-12-14 Ignore user	simple solution: if you get this message in the var/logs/exception.log file 2011-03-24T23:54:47+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1487-577-1-464’ for key ‘PRIMARY’ go to product id “1487” in the magento backend and save it. I got that product id from the “Duplicate entry” error in the exception log if you get the message again, you will have to do this for the next “Duplicate entry” product id, however, i have never seen this on more than 1 product.
	Posted: January 30 2013 \| top \| # 14

Monty22 Total Posts: 650 Joined: 2013-01-01 Ignore user	Try first to clean Magento cache. If no success, run official DB repair tool. How to repair the magento database: 1. Download repair tool from Magento and unzip the package. 2. Upload magento-db-repair-tool-1.1.php to your server 3. Backup your current database (call it ‘magentoDB1′). Export this database and then import it into a new database (let’s call it ‘magentoDB2′). 4. Install a fresh Magento using ‘magentoDB2′. 5. Now open the the URL in browser: http://www.youdomain.com/magento-db-repair-tool-1.0.php. 6. Enter ‘magentoDB1′ as ‘corrupted’ and ‘magentoDB2′ as ‘reference’. Enter all necessary information and click ‘Continue’ button. Wait and see result.. If you have still any problem or show this error there was a problem with reindexing process. product flat data then go to phpmyadmin and empty this table “catalog_product_flat_1“. `SQLSTATE[HY000]: General error: 1005 Can't create table '.\database_name\catalog_category_flat_store_1.frm (errno: 150)` Solution: `ALTER TABLE catalog_category_entity ENGINE=INNODB; ALTER TABLE core_store ENGINE=INNODB;` Note: If you empty any table first take backup before empty that. Monty iLoveMage No1 web development and Magento extension Store. Signature Get 15% discount on all our extensions Use code MON15 \| Risk-free purchase with our 14 days Money Back Guarantee policy!
	Posted: February 6 2013 \| top \| # 15

Magento Community

Magento Community

Back to top

After upgrade to 1.4.1.1 -- ERR (3): Warning: getimagesize

Fatal error: Call to undefined method addExpressionAttributeToSelect()