wsrv001 current # php shell/indexer.php reindexall
Product Attributes index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '958-193-4-426' for key 'PRIMARY'' in /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Varien/Db/Adapter/Pdo/Mysql.php(1537): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...', Array)
#6 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(261): Varien_Db_Adapter_Pdo_Mysql->insertArray('catalog_product...', Array, Array)
#7 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(235): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_saveIndexData(Array)
#8 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(84): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_prepareMultiselectIndex(NULL, NULL)
#9 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Abstract.php(47): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_prepareIndex()
#10 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav.php(185): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Abstract->reindexAll()
#11 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav->reindexAll()
#12 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#13 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#14 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#15 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/shell/indexer.php(198): Mage_Shell_Compiler->run()
#16 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '958-193-4-426' for key 'PRIMARY'' in /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#3 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#4 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/lib/Varien/Db/Adapter/Pdo/Mysql.php(1537): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...', Array)
#5 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(261): Varien_Db_Adapter_Pdo_Mysql->insertArray('catalog_product...', Array, Array)
#6 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(235): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_saveIndexData(Array)
#7 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Source.php(84): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_prepareMultiselectIndex(NULL, NULL)
#8 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Abstract.php(47): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Source->_prepareIndex()
#9 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav.php(185): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Abstract->reindexAll()
#10 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav->reindexAll()
#11 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#12 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#13 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#14 /mnt/var/www/dev-mothercare-elc/releases/20110722-19/shell/indexer.php(198): Mage_Shell_Compiler->run()
#15 {main}
Product Prices index was rebuilt successfully
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Catalog Search Index index was rebuilt successfully
Stock Status index was rebuilt successfully
Tag Aggregation Data index was rebuilt successfully