I am having this strange issue when trying to upgrade magento 2.4.2p1 to 2.4.3

In bin/magento setup:upgrade

I get:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '543741' for key 'catalog_url_rewrite_product_category.PRIMARY', query was: ALTER TABLE `catalog_url_rewrite_product_category` ADD CONSTRAINT  PRIMARY KEY (`url_rewrite_id`)

I found entry in table




and deleted it. But I still can't setup:upgrade

I also tried to empty url.rewrite table but again no luck

I am stuck. Any help much appreciated!

  • any solution please?
    – Efex
    Aug 23, 2021 at 22:24
  • @Efex yes. Solved. Check my answer please
    – G. G.
    Aug 24, 2021 at 12:57

6 Answers 6


This solution worked for me (DO NOT RUN THIS ON PRODUCTION!)

delete from catalog_url_rewrite_product_category
    where url_rewrite_id in (select url_rewrite_id from
        (select * from
               (select url_rewrite_id, count(*) as c from catalog_url_rewrite_product_category
group by url_rewrite_id) as q1 having c > 1) as q2);

For production use this one: (First check on your test environment)

CREATE TABLE tmp_catalog_url_rewrite_product_category_backup AS SELECT * FROM catalog_url_rewrite_product_category;
TRUNCATE catalog_url_rewrite_product_category;
INSERT INTO catalog_url_rewrite_product_category SELECT * FROM tmp_catalog_url_rewrite_product_category_backup GROUP BY url_rewrite_id, category_id, product_id;
DROP TABLE tmp_catalog_url_rewrite_product_category_backup;
  • Good point! More complicated queries though. Will check it…
    – G. G.
    Oct 22, 2021 at 7:36

Problem solved. It seems that when you upgrade to 2.4.3 Magento discovers duplicates in catalog_url_rewrite_product_category table. I haven't figure out from where they came as in 2.4.2 version all worked fine. No errors anywhere. I am suspecting that these came from migration. My store was migrated from version 1.

To solve this issue I created a new temporary table in database running this query:

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

With this the new table which created has removed all the duplicates.

So then I added the same relations from catalog_url_rewrite_product_category , deleted table catalog_url_rewrite_product_category and renamed the temporary table.

With this


worked fine.

I am still looking if this solution didn't created any other issues but for now all seem fine

Caution: Don't do this in production instance and always take backup the database before.

  • What you mean exactly? Can you be more specific?
    – G. G.
    Sep 19, 2021 at 1:10
  • SELECT DISTINCT url_rewrite_id, category_id, product_id FROM catalog_url_rewrite_product_category; Will be equal to: SELECT * FROM catalog_url_rewrite_product_category; As each record is distinct. You cannot have duplicated url_rewrite_id. Sep 20, 2021 at 9:45
  • Yes. That’s what we need. A new table without duplicate url_rewrite_id. I don’t really follow you. What is the problem with this?
    – G. G.
    Sep 20, 2021 at 15:09
  • @G.G. I have done exactly as you say but still having another error anotepad.com/notes/c7d6ea2c
    – Luan Tran
    Sep 21, 2021 at 6:53
  • @DuyLuân you have missed the step where you should add the right relations from old table catalog_url_rewrite_product_category. You have wrong relations
    – G. G.
    Sep 21, 2021 at 17:41

A neater solution would be to use:

ALTER IGNORE TABLE catalog_url_rewrite_product_category ADD UNIQUE KEY (url_rewrite_id, category_id, product_id)

This forces MySQL to delete the duplicate entries on the table, after which you can delete the new index if you wish too.

  • Will check this and update you
    – G. G.
    Nov 23, 2021 at 15:43

It's a bug in Magento 2.4.3 upgrade procedure, see GitHub for details:


You can apply on of the workaround posted here.


You can just use this script here https://takeoff.digital/2022/09/15/duplicate-primary-key-error-in-magento-2/
Please read the explanations in the above url if it doesn't make sense for you as this will generate a couple of text files which you will then have to execute in your mysql editor.

$servername = "localhost";
$username = "username";
$password = "pass";
$dbname = "yourdb";
$deletefile = "path/del.txt";
$insfile = "path/ins.txt";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error)
    die("Connection failed: " . $conn->connect_error);

$sql = "SELECT url_rewrite_id  FROM database_name.catalog_url_rewrite_product_category group by url_rewrite_id having count(*) > 1 order by url_rewrite_id desc;";
$result = $conn->query($sql);

if ($result->num_rows > 0)
    while ($row = $result->fetch_assoc())
        $roid = $row["url_rewrite_id"];
        $line = "DELETE FROM database_name.catalog_url_rewrite_product_category where url_rewrite_id = '$roid';" . "\n";
        file_put_contents($deletefile, $line, FILE_APPEND | LOCK_EX);
        $query2 = "SELECT * FROM database_name.catalog_url_rewrite_product_category WHERE url_rewrite_id = '$roid' limit 1;" . "\n";
        $data = $conn->query($query2)->fetch_assoc();
        $urid = $data["url_rewrite_id"];
        $catid = $data["category_id"];
        $pid = $data["product_id"];
        $insquery = "INSERT INTO database_name.catalog_url_rewrite_product_category (url_rewrite_id, category_id, product_id) VALUES('$urid', '$catid','$pid');" . "\n";
        file_put_contents($insfile, $insquery, FILE_APPEND | LOCK_EX);

If you are trying to update your store the last Magento version (once this post was written 2.4.3 is latest), and you are getting the following error message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '***' for key 'PRIMARY', query was: ALTER TABLE `catalog_url_rewrite_product_category` ADD CONSTRAINT  PRIMARY KEY (`url_rewrite_id`)

Then this is because you are having duplicated url rewrites on your database. So, to solve this out, you will need to remove those useless and duplicated entries. To reach this out successfully, i suggest performing the following steps gettng logged into your database:

CREATE TABLE catalog_url_rewrite_product_category_nodup AS SELECT * FROM catalog_url_rewrite_product_category;
truncate table catalog_url_rewrite_product_category_nodup;
insert into catalog_url_rewrite_product_category_nodup (select distinct * from catalog_url_rewrite_product_category);
truncate table catalog_url_rewrite_product_category;
insert into catalog_url_rewrite_product_category (select * from catalog_url_rewrite_product_category_nodup);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.