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:
https://community.magento.com/t5/Magento-2-x-Technical-Issues/Magento-2-unique-constraint-violation-found-when-generating/m-p/450745#M14359
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