MySQL Forums
Forum List  »  InnoDB

mysql inno db foregin key issue
Posted by: ahsan iqbal
Date: August 03, 2022 12:47PM

I've noticed following error when i run the command: "SHOW ENGINE INNODB STATUS". please help to resolve this issue.Thanks

==>error in the output:

------------------------
LATEST FOREIGN KEY ERROR
------------------------
2022-08-03 11:00:07 0x2ba966f1b700 Transaction:
TRANSACTION 40098216622, ACTIVE 0 sec inserting
mysql tables in use 9, locked 9
7 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
MySQL thread id 2761834, OS thread handle 48006576584448, query id 397991231 10.104.1.56 kent update
INSERT INTO `catalog_product_entity_varchar` (`attribute_id`,`store_id`,`row_id`,`value`) VALUES ('3993', '0', '0', '0') ON DUPLICATE KEY UPDATE `attribute_id` = VALUES(`attribute_id`), `store_id` = VALUES(`store_id`), `row_id` = VALUES(`row_id`), `value` = VALUES(`value`)
Foreign key constraint fails for table `kent_magento`.`catalog_product_entity_varchar`:
,CONSTRAINT `CAT_PRD_ENTT_VCHR_ROW_ID_CAT_PRD_ENTT_ROW_ID` FOREIGN KEY (`row_id`) REFERENCES `catalog_product_entity` (`row_id`) ON DELETE CASCADE

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql inno db foregin key issue
633
August 03, 2022 12:47PM
394
August 04, 2022 12:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.