magento2 – Magento 2 unique constraint violation found when submit order

I am facing an issue of unique constraint violation found while submit order from magento backend. This issue only comes if my previous order was failed due to some technical reason and I am trying to re-submit that order again by filling details again on that order create screen.

I am using credit card payment method. I have tried below solution:
but it won’t work. Can anyone help me out as soon as possible? as website is live and I am facing this critical issue. Below is screenshot for your reference:

error screenshot