url_rewrite key constraint violation when the database has old rewrites about import HOT 5 CLOSED

Hi @amenk, I think we would need something like a reorganization of the URL rewrites that exactly executes the SQL statement you defined above. For example an additional command that runs the reorganization like vendor/bin/import-cli-simple import:products:url:reorg . Does that make sense for you?

from import.

@wagnert The problem is a bit that I do not know were the orphan rewrites come from. It might be due to past deletes via Pacemaker, in this case, would the URL rewrites be deleted as well? We have a custom job here, and might be missing the delete-rewrite-flag

from import.

@amenk I think neither Pacemaker during product deletion nor deleting a product in the Magento Admin will delete the URL rewrites. I do not validate this, but this may be the origin of your problem.

from import.

Hm okay, we should validate that :)

from import.

After testing, it has been fixed on 4.0.0 version already.

The two cleanups observers were built to fix this problem
"import_category.observer.clear.url.rewrite"
"import_product_url_rewrite.observer.clear.url.rewrite"

from import.