Magento Forum

   
Page 1 of 2
Can’t initialize indexer process - Product Attributes
 
DaymoH
Sr. Member
 
Total Posts:  106
Joined:  2008-09-18
 

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 messageSQLSTATE[23000]Integrity constraint violation1452 Cannot add or update a child rowa foreign key constraint fails (`db_magent0/catalog_product_index_eav`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_ENTITYFOREIGN 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

 
Magento Community Magento Community
Magento Community
Magento Community
 
DaymoH
Sr. Member
 
Total Posts:  106
Joined:  2008-09-18
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mooooo
Jr. Member
 
Total Posts:  16
Joined:  2010-07-10
 

Hmmm, that didn\’t work for me.

 
Magento Community Magento Community
Magento Community
Magento Community
 
spectrumaudio
Member
 
Total Posts:  39
Joined:  2008-07-22
 

I am having the same error “Cannot initialize the indexer process” for Product Attributes only

Using 1.4.1.1

Anyone find a solution?

 
Magento Community Magento Community
Magento Community
Magento Community
 
mooooo
Jr. Member
 
Total Posts:  16
Joined:  2010-07-10
 

Try deleting your products then re-importing; worked for me recently on 1.4.1.0

 
Magento Community Magento Community
Magento Community
Magento Community
 
spectrumaudio
Member
 
Total Posts:  39
Joined:  2008-07-22
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
guillaume7684
Sr. Member
 
Total Posts:  241
Joined:  2008-10-20
 
DaymoH - 06 August 2010 04: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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
yo5ofh
Jr. Member
 
Total Posts:  8
Joined:  2008-11-02
 

Anybody found a solution for this problem??? Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
DeeperID
Jr. Member
 
Total Posts:  3
Joined:  2011-03-18
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
jvb888
Jr. Member
 
Total Posts:  4
Joined:  2010-01-22
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
kneemahp
Sr. Member
 
Total Posts:  116
Joined:  2008-08-07
 

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/

 
Magento Community Magento Community
Magento Community
Magento Community
 
qiqiy
Jr. Member
 
Total Posts:  2
Joined:  2010-10-22
 

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 :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
jfedgar
Jr. Member
 
Total Posts:  4
Joined:  2012-02-12
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
dbashyal
Sr. Member
 
Avatar
Total Posts:  164
Joined:  2008-09-12
rockdale, sydney, australia
 

its easy to fix, check this: http://learntipsandtricks.com/blog/92/114/magento-index-management-Cannot-initialize-the-indexer-process

 
Magento Community Magento Community
Magento Community
Magento Community
 
jrossi
Jr. Member
 
Avatar
Total Posts:  1
Joined:  2012-12-14
Glen Allen, VA
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
goed_ballwin
Jr. Member
 
Total Posts:  8
Joined:  2011-12-05
 

I have tried everything here to no avail. The issue I am seeing is when trying to reindex product attributes. I get the following error:

Product Attributes index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '38579-401-1-579' for key 'PRIMARY'' in /var/www/html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace
:
#0 /var/www/html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /var/www/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#5 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#6 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Source.php(162): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#7 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Source.php(83): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Source->_prepareSelectIndex(NULL, NULL)
#8 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Abstract.php(50): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Source->_prepareIndex()
#9 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav.php(185): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Abstract->reindexAll()
#10 /var/www/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Eav->reindexAll()
#11 /var/www/html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#12 /var/www/html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#13 /var/www/html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#14 /var/www/html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#15 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '38579-401-1-579' for key 'PRIMARY'' in /var/www/html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace
:
#0 /var/www/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Source.php(162): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#6 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Source.php(83): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Source->_prepareSelectIndex(NULL, NULL)
#7 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav/Abstract.php(50): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Source->_prepareIndex()
#8 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav.php(185): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Abstract->reindexAll()
#9 /var/www/html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Eav->reindexAll()
#10 /var/www/html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /var/www/html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#12 /var/www/html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /var/www/html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#14 {main}

If I delete the item listed, it rolls to the next one. I have tried repairing the database and no joy. Any help would be appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 2