Ugrade 2.3.3 to 2.4.3 error: Integrity constraint violation

[firassalladebd]

Hi Folks,

I was trying to upgrade to upgrade from 2.3.3 to 2.4.3 in my test environment. While trying to run bin/magento setup:upgrade,

The below error appeared:

Cache cleared successfully
Schema creation/updates:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2902914' for key 'catalog_url_rewrite_product_category.PRIMARY', query was: ALTER TABLE `catalog_url_rewrite_product_category` ADD CONSTRAINT PRIMARY KEY (`url_rewrite_id`)

When I checked DB, looks like 3264 of duplicate  rows are there:

SELECT url_rewrite_id, COUNT(url_rewrite_id) FROM catalog_url_rewrite_product_category GROUP BY url_rewrite_id HAVING COUNT(url_rewrite_id) > 1;

.

.

.

3264 rows in set (0.02 sec)

1. What is the reason for this?

2. How can we solve this issue?

Also is there any official tool from Magento for running database sanity checks before upgrades?

[Milople]

Hi @firassalladebd,

Hope you are doing well!

I am not getting the actual reason behind this, but I will let you know once I will get it. So, for now, you can try the following solution.

NOTE: Kindly take a backup of your database and check in the dev site first.

1. Created a new temporary table in the database running this query

CREATE TABLE copy_of_table SELECT DISTINCT url_rewrite_id, category_id, product_id FROM catalog_url_rewrite_product_category;

2. Add the same relation from catalog_url_rewrite_product_category

3. Delete table catalog_url_rewrite_product_category and renamed the temporary table.

Run the following command:

bin/magento setup:upgrade

Solved?

Accept as a solution and Click KUDOS!

Thank you!

[LitExtension Expert]

1. Created a new temporary table in the database running this query

CREATE TABLE copy_of_table SELECT DISTINCT url_rewrite_id, category_id, product_id FROM catalog_url_rewrite_product_category;

2. Add the same relation from catalog_url_rewrite_product_category

3. Delete table catalog_url_rewrite_product_category and renamed the temporary table.

Run the following command: bin/magento setup:upgrade

[zeekinfo]

Hi,

am also facing same issues but i did what you said but it can't fix.