Call-back icon  Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento

eCommerce Software for Online Growth

Magento Forum

   
After MySQL restart, Magento failed
 
Aleksander Andrijenko
Jr. Member
 
Total Posts:  21
Joined:  2007-12-16
 

After MySQL daemon restart Magento is printing the following:

Zend_Db_Statement_Exception Object
(
[message:protected] => SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`itriga_bestprice/catalog_category_entity_varchar`, CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE)
[string:private] =>
[code:protected] => 0
[file:protected] => /var/www/vhosts/best-price.lv/httpdocs/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 238
[trace:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/lib/Zend/Db/Statement.php
[line] => 283
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => 1
[1] => 3
[2] => 22
[3] => Root Catalog
[4] => 0
)

)

)

[1] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/lib/Zend/Db/Adapter/Abstract.php
[line] => 406
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => 1
[1] => 3
[2] => 22
[3] => Root Catalog
[4] => 0
)

)

)

[2] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 206
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `catalog_category_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (?, ?, ?, ?, ?)
[1] => Array
(
[0] => 1
[1] => 3
[2] => 22
[3] => Root Catalog
[4] => 0
)

)

)

[3] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/lib/Zend/Db/Adapter/Abstract.php
[line] => 484
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `catalog_category_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (?, ?, ?, ?, ?)
[1] => Array
(
[0] => 1
[1] => 3
[2] => 22
[3] => Root Catalog
[4] => 0
)

)

)

[4] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Abstract.php
[line] => 112
[function] => insert
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => catalog_category_entity_varchar
[1] => Array
(
[entity_id] => 1
[entity_type_id] => 3
[attribute_id] => 22
[value] => Root Catalog
[store_id] => 0
)

)

)

[5] => Array
(
[file] => /var/www/vhosts/best-price.lv/httpdocs/app/code/core/Mage/Eav/Model/Entity/Abstract.php
[line] => 933
[function] => _insertAttribute
[class] => Mage_Catalog_Model_Resource_Eav_Mysql4_Abstract
[type] => ->
[args] => Array
(
[0] => Mage_Catalog_Model_Category Object
(
[_designAttributes:private] => Array
(
[0] => custom_design
[1] => custom_design_apply
[2] => custom_design_from
[3] => custom_desi

 
Magento Community Magento Community
Magento Community
Magento Community
 
Aleksander Andrijenko
Jr. Member
 
Total Posts:  21
Joined:  2007-12-16
 

Can somebody help with this problem?

As Iunderstand something is with Innodb, after restart. But repair is not helping, all tables are healthy.

What is the solution?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
Sales: Call 877.832.5289 (North America) 310.295.4144 (International)
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
52312 users|441 users currently online|105635 forum posts