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

After MySQL restart, Magento failed
 
Aleksander Andrijenko
Jr. Member
 
Total Posts:  22
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:  22
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