https://eslizn.com/posts/prevent-deadlock-caused-by-uncommitted-transactions/