I'm using Magento v2.3.4 and i ran this command to do performance testing

php bin/magento setup:performance:generate-fixtures -s setup/performance-toolkit/profiles/ce/small.xml

the process stop when Generating cart price rules. and showing this error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (Mage.salesrule_customer_group, CONSTRAINT FK_71F63034CF7894F1A68FD81554D91D9C FOREIGN KEY (customer_group_id) REFERENCES customer_group (customer_group_id) ON DELETE CASC), query was: INSERT INTO salesrule_customer_group (customer_group_id,rule_id) VALUES (?, ?), (?, ?), (?, ?), (?, ?) ON DUPLICATE KEY UPDATE rule_id = VALUES(rule_id)

  • Do you have any data in DB. Fixture generator designed to use on empty (just installed) database – KAndy Sep 25 '20 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.