maotouxiaozi commented 10 years ago

[root@www shell]# /www/wdlinux/php/bin/php -f indexer.php reindexall Product Attributes index was rebuilt successfully 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 GroupsCatalog Products index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-0-1' for key 'PRIMARY'' in /home/www/irtto/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace:

0 /home/www/irtto/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)

1 /home/www/irtto/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

2 /home/www/irtto/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

3 /home/www/irtto/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)

4 /home/www/irtto/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `gr...', Array)

5 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `gr...', Array)

6 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1974): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `gr...', Array)

7 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1947): Varien_Db_Adapter_Pdo_Mysql->insertArray('groupscatalog_p...', Array, Array)

8 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(316): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('groupscatalog_p...', Array)

9 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(240): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecordsIfMinChunkSizeReached(Array, 1000)

10 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(212): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecords(Object(Varien_Db_Statement_Pdo_Mysql))

11 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()

12 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()

13 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()

14 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()

15 /home/www/irtto/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()

16 /home/www/irtto/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()

17 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '219-0-1' for key 'PRIMARY'' in /home/www/irtto/public_html/lib/Zend/Db/Statement/Pdo.php:234 Stack trace:

0 /home/www/irtto/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

1 /home/www/irtto/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

2 /home/www/irtto/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)

3 /home/www/irtto/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `gr...', Array)

4 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `gr...', Array)

5 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1974): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `gr...', Array)

6 /home/www/irtto/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1947): Varien_Db_Adapter_Pdo_Mysql->insertArray('groupscatalog_p...', Array, Array)

7 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(316): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('groupscatalog_p...', Array)

8 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(240): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecordsIfMinChunkSizeReached(Array, 1000)

9 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(212): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecords(Object(Varien_Db_Statement_Pdo_Mysql))

10 /home/www/irtto/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()

11 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()

12 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()

13 /home/www/irtto/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()

14 /home/www/irtto/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()

15 /home/www/irtto/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()

16 {main}

GroupsCatalog Categories index was rebuilt successfully