cancel
Showing results for 
Search instead for 
Did you mean: 

Ugrade 2.4.2-p1 to 2.4.3 error: SQLSTATE[23000]: Integrity constraint violation:

Ugrade 2.4.2-p1 to 2.4.3 error: SQLSTATE[23000]: Integrity constraint violation:

Hi,

I upgrade to 2.4.3 from 2.4.2-p1 with composer all work fine but when use command php bin/magento setup:upgrade have this error:

/php bin/magento setup:upgrade Cache types config flushed successfully
Cache cleared successfully
File system cleanup:
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/AdobeStock
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Amazon
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Composer
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/DOMDocumentFactory.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Dotdigitalgroup
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Klarna
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Laminas
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Magento
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Mageplaza
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Magestio
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/PayPal
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Psr
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/ReCaptcha
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Symfony
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Vertex
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/WeltPixel
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/code/Yotpo
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/adminhtml.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/app_action_list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/crontab.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/frontend.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/global.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/graphql.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/interception.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|adminhtml|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|crontab|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|frontend|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|graphql|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|webapi_rest|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/primary|global|webapi_soap|plugin-list.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/webapi_rest.php
/var/www/vhosts/XXXXXXX.com/httpdocs/generated/metadata/webapi_soap.php
/var/www/vhosts/XXXXXXX.com/httpdocs/pub/static/_cache
/var/www/vhosts/XXXXXXX.com/httpdocs/pub/static/adminhtml
/var/www/vhosts/XXXXXXX.com/httpdocs/pub/static/deployed_version.txt
/var/www/vhosts/XXXXXXX.com/httpdocs/pub/static/frontend
/var/www/vhosts/XXXXXXX.com/httpdocs/var/view_preprocessed/pub
Updating modules:
Cache cleared successfully
Schema creation/updates:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '112626' for key 'catalog_url_rewrite_produ ct_category.PRIMARY', query was: ALTER TABLE `catalog_url_rewrite_product_category` ADD CONSTRAINT PRIMARY KEY ( `url_rewrite_id`)

I have 3 domains and 3 languages ever work fine.

System:

php 7.4

mysql 8


I have made multiple upgrades to different versions and have never had this kind of problem before.

1 REPLY 1

Re: Ugrade 2.4.2-p1 to 2.4.3 error: SQLSTATE[23000]: Integrity constraint violation:

Solved