I Am getting error when I am removing .html from Category URL Suffix.
Unique constraint violation found.
Anyone have genuine solution for this.
This can be caused by duplicate entries for the same product in url_rewrite database table.
You can check duplicate entries using below query.
SELECT * FROM url_rewrite WHERE entity_type = 'product'
To resolve your issue Follow this link
I hope it helps.