Call-back icon  Questions? Contact our sales team to a request a quote

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
 
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
60320 users|877 users currently online|119444 forum posts