magento2: Saving Product Configuration with many colors and lengths fails

I have a product with 20 colors in 16 lengths and the large number of items fails to save with the following error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magento2.catalog_product_entity, CONSTRAINT CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID FOREIGN KEY (attribute_set_id) REFERENCES eav_attribute_set (attribute_set_id) ON DELE), query was: INSERT INTO catalog_product_entity (type_id, sku) VALUES (?, ?)

Configurations with small numbers of results (up to 30 or more) work fine. The problem only crops up when the Product record number get high (like over 300) Running on debian 8 with 6 cores

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 18 (6 by maintainers)

Most upvoted comments

Hello, I have the same problem with Magento 2.0.2 Server Deb8 PHP 5.6 max_input_vars -> 5000

I try with only 2 configurations

Julien