Magento Forum

Can’t initialize indexer process. 
 
Silebis
Jr. Member
 
Avatar
Total Posts:  30
Joined:  2008-01-15
Opava
 

When i run reindex for catalog_product_attribute it will crash with Can’t initialize indexer process. All products from frontend aren´t showing!

CE 1.4.0.1

i tried run this, but without success

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKSUNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODESQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTESSQL_NOTES=0;

DROP TABLE IF EXISTS `mag_index_process_event`;
DROP TABLE IF EXISTS `mag_index_event`;
DROP TABLE IF EXISTS `mag_index_process`;

CREATE TABLE `mag_index_event` (
  `
event_idBIGINT(20UNSIGNED NOT NULL AUTO_INCREMENT,
  `
typeVARCHAR(64NOT NULL,
  `
entityVARCHAR(64NOT NULL,
  `
entity_pkBIGINT(20) DEFAULT NULL,
  `
created_atDATETIME NOT NULL,
  `
old_dataMEDIUMTEXT,
  `
new_dataMEDIUMTEXT,
  
PRIMARY KEY (`event_id`),
  
UNIQUE KEY `IDX_UNIQUE_EVENT` (`type`,`entity`,`entity_pk`)
ENGINE=INNODB DEFAULT CHARSET=utf8;


CREATE TABLE `mag_index_process` (
  `
process_idINT(10UNSIGNED NOT NULL AUTO_INCREMENT,
  `
indexer_codeVARCHAR(32NOT NULL,
  `
statusENUM('pending','working','require_reindex'NOT NULL DEFAULT 'pending',
  `
started_atDATETIME DEFAULT NULL,
  `
ended_atDATETIME DEFAULT NULL,
  `
modeENUM('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 `mag_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 `mag_index_process_event` (
  `
process_idINT(10UNSIGNED NOT NULL,
  `
event_idBIGINT(20UNSIGNED NOT NULL,
  `
statusENUM('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_PROCESSFOREIGN KEY (`event_id`) REFERENCES `mag_index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  
CONSTRAINT `FK_INDEX_PROCESS_EVENTFOREIGN KEY (`process_id`) REFERENCES `mag_index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE
ENGINE=INNODB DEFAULT CHARSET=utf8;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
SET SQL_NOTES=@OLD_SQL_NOTES;
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top