Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 3
Can’t initialize indexer process - Product Prices
 
Dorgo
Sr. Member
 
Total Posts:  127
Joined:  2008-12-16
 

Just did a fresh install of 1.4.0.1 because old database was MyISAM

Had Cart2Cart service (http://www.shopping-cart-migration.com/) migrate my products, categories, orders and customers.
Not sure how they did it but there were a lot of issues and mistakes. Everything seems to be in there and working finally though.
First time using them… almost a tentative thumbs up. Depends if this error is related to the migration.

Now I have ‘Product Prices’ index status as ‘Processing’ and any attempt to reindex it results in “Can’t initialize indexer process.”
I have also once got “Some problem with reindexing process” but not sure what was different.

anyone have any ides?

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

I have the same issue on a magento cart where I used cart2cart demo migration.
Did you find out what was causing the issue?

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

When you select all and reindex you get Cant initialize indexer process.
When you select one option and reindex you get some problem with indexing process.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dorgo
Sr. Member
 
Total Posts:  127
Joined:  2008-12-16
 

Yep. That\’s it.
According to cart2cart it is a magento problem, not theirs.

The issue with categories related with Magento, not with migration process.
You can read more here - http://www.magentocommerce.com/boards/viewthread/76540/P60/
This should be fixed by Magento developers in further releases.

Currently we made the changes as advised on Magento public forum and all categories are shown now.

Unfortunately, person registered during migration should do it again.

I don\’t know. Seems more trouble than its worth. Has anyone found a good method to migrate products, categories,attributes/sets,orders and customers between 1.3 & 1.4 ?
has to be quick (live store will need to go offline to prevent new signups) and through dataflow or API not table-dumps because also moving from MyISAM to InnoDB.
Getting a bit desperate.

 
Magento Community Magento Community
Magento Community
Magento Community
 
DCAlmeida
Sr. Member
 
Avatar
Total Posts:  164
Joined:  2008-12-28
PRT
 
Dorgo - 05 April 2010 07:34 PM

Has anyone found a good method to migrate products, categories,attributes/sets,orders and customers between 1.3 & 1.4 ?

I always use that one and my migrations works fine.
I had same problem but the cause was not migration service but any error with your source product(s).

Clean all /var/report and then try to reindex all rows. Go to the same folder and see if there are any file. If yes download and open it with a text editor and post all the report.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Paul Whipp
Member
 
Total Posts:  48
Joined:  2009-03-23
 

For the reindexing problem where you see “can’t initialize indexer process” after an import, I’ve found that deleting the contents of var/locks seems to clear the problem, clearing var/reports has no effect. I think the locks can get out of date, particularly if you are directly manipulating the database. Luckily magento happily recreates the lock files if they are absent.

I have not had to import from magento 1.3 but I have imported from eshop and oscommerce.  I’d expect the Magento export/import products utility to work. It does not cover configurable products though - for that Scott Bolasevich’s utility works well - Bulk Product Import.

If all else fails, one can customise either the built in product importer or Scott’s utility for your particular needs.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dorgo
Sr. Member
 
Total Posts:  127
Joined:  2008-12-16
 

Thanks for your replies,

I tried deleting all files from /var/report (?) and var/locks and am still getting the same errors.
I get the same named files in var/locks/ each time:-
index_process_2.lock
index_process_8.lock

Both just contain a timestamp

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tbird
Jr. Member
 
Total Posts:  26
Joined:  2008-10-08
Germany
 

Hello,

i´ve the same problem to reindex the prices and therefor i think and the worst case:  NO products will display in the shop!

I´tried all suggestions, file-/dir permissions are correct, also the raw statement follow at mysql, but nothing helps…

DROP TABLE IF EXISTS `index_process_event`;
DROP TABLE IF EXISTS `index_event`;
DROP TABLE IF EXISTS `index_process`;

CREATE TABLE `index_event` (
`event_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` VARCHAR(64) NOT NULL,
`entity` VARCHAR(64) NOT NULL,
`entity_pk` BIGINT(20) DEFAULT NULL,
`created_at` DATETIME NOT NULL,
`old_data` MEDIUMTEXT,
`new_data` MEDIUMTEXT,
PRIMARY KEY (`event_id`),
UNIQUE KEY `IDX_UNIQUE_EVENT` (`type`,`entity`,`entity_pk`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `index_process` (
`process_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`indexer_code` VARCHAR(32) NOT NULL,
`status` ENUM(’pending’,’working’,’require_reindex’) NOT NULL DEFAULT ‘pending’,
`started_at` DATETIME DEFAULT NULL,
`ended_at` DATETIME DEFAULT NULL,
`mode` ENUM(’real_time’,’manual’) NOT NULL DEFAULT ‘real_time’,
PRIMARY KEY (`process_id`),
UNIQUE KEY `IDX_CODE` (`indexer_code`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `index_process`(`process_id`,`indexer_code`,`status`,`started_at`,`ended_at`,`mode`) VALUES (1,’catalog_product_attribute’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(2,’catalog_product_price’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(3,’catalog_url’,’pending’,’2010-02-13 19:12:15’,’2010-02-13 19:12:15’,’real_time’),(4,’catalog_product_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(5,’catalog_category_flat’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(6,’catalog_category_product’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(7,’catalogsearch_fulltext’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’),(8,’cataloginventory_stock’,’pending’,’2010-02-13 00:00:00’,’2010-02-13 00:00:00’,’real_time’);

CREATE TABLE `index_process_event` (
`process_id` INT(10) UNSIGNED NOT NULL,
`event_id` BIGINT(20) UNSIGNED NOT NULL,
`status` ENUM(’new’,’working’,’done’,’error’) NOT NULL DEFAULT ‘new’,
PRIMARY KEY (`process_id`,`event_id`),
KEY `FK_INDEX_EVNT_PROCESS` (`event_id`),
CONSTRAINT `FK_INDEX_EVNT_PROCESS` FOREIGN KEY (`event_id`) REFERENCES `index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_INDEX_PROCESS_EVENT` FOREIGN KEY (`process_id`) REFERENCES `index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

 
Magento Community Magento Community
Magento Community
Magento Community
 
merchantguru
Sr. Member
 
Avatar
Total Posts:  133
Joined:  2008-10-05
San Francisco
 

I’m getting same problem & error messages as Dorgo, including clearing the locks and they come back. I’ve also cleared cache just for kicks.

Anyone find a fix?

 
Magento Community Magento Community
Magento Community
Magento Community
 
onesimpleman
Jr. Member
 
Total Posts:  24
Joined:  2008-04-14
 

I repaired the database and cleared /var/locks and it works good now . Happy that I can go ahead with a full cart2cart transfer grin

 
Magento Community Magento Community
Magento Community
Magento Community
 
merchantguru
Sr. Member
 
Avatar
Total Posts:  133
Joined:  2008-10-05
San Francisco
 

I repaired by doing mysqldump & reload, clearing locks, and it didn’t work. Did you do anything special?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dorgo
Sr. Member
 
Total Posts:  127
Joined:  2008-12-16
 

onesimpleman: how did you repair database? With MySQL or another tool? How safe is this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ogray
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2010-04-02
 

Try this queries:

DELETE cpop.* FROM catalog_product_option_price AS cpop
INNER JOIN catalog_product_option 
AS cpo
ON cpo
.option_id cpop.option_id
WHERE
cpo
.type 'checkbox' OR
cpo.type 'radio' OR
cpo.type 'drop_down';

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
INNER JOIN catalog_product_option_type_value 
AS cpotv
ON cpotv
.option_type_id cpotp.option_type_id
INNER JOIN catalog_product_option 
AS cpo
ON cpotv
.option_id cpo.option_id
WHERE
cpo
.type <> 'checkbox' AND
cpo.type <> 'radio' AND
cpo.type <> 'drop_down';
But don’t forget to BACKUP before executing!
 
Magento Community Magento Community
Magento Community
Magento Community
 
janus03
Jr. Member
 
Total Posts:  9
Joined:  2009-07-14
Aarhus, Denmark
 
ogray - 21 May 2010 06:21 AM

Try this queries:

DELETE cpop.* FROM catalog_product_option_price AS cpop
INNER JOIN catalog_product_option 
AS cpo
ON cpo
.option_id cpop.option_id
WHERE
cpo
.type 'checkbox' OR
cpo.type 'radio' OR
cpo.type 'drop_down';

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
INNER JOIN catalog_product_option_type_value 
AS cpotv
ON cpotv
.option_type_id cpotp.option_type_id
INNER JOIN catalog_product_option 
AS cpo
ON cpotv
.option_id cpo.option_id
WHERE
cpo
.type <> 'checkbox' AND
cpo.type <> 'radio' AND
cpo.type <> 'drop_down';
But don’t forget to BACKUP before executing!

Brilliant. This did it for me. Thanks a lot!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dorgo
Sr. Member
 
Total Posts:  127
Joined:  2008-12-16
 

awesome. Now indexing product prices correctly.

Your the man ogray.

 
Magento Community Magento Community
Magento Community
Magento Community
 
adolmedia
Jr. Member
 
Avatar
Total Posts:  16
Joined:  2009-04-02
 

Hi everyone,

For peoples facing problem with Catalog product fulltext search re-indexing with error message

“Some problem with reindexing process.” or “Can’t initialize indexer process”,

please find below the fix.

Create a file called “search-reindex.php” inside your magento root folder and put the following code.

<?php
require_once 'app/Mage.php';
umask);
Mage :: app"default" );
Mage::log("Started Rebuilding Search Index At: " date("d/m/y h:i:s"));
$sql "truncate catalogsearch_fulltext;";
$mysqli Mage::getSingleton('core/resource')->getConnection('core_write');
$mysqli->query($sql);
$process Mage::getModel('index/process')->load(7);
$process->reindexAll();
Mage::log("Finished Rebuilding Search Index At: " date("d/m/y h:i:s"));

Then run this script by visiting www.yourdomain.com/search-reindex.php in your browser.

That’s it. It will now work like a charm.

Regards,
Rahman - AdolMedia

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