Before I start reading, I'm going to hazard a guess that this was caused by a uniqueness constraint on a nullable column.

After reading: ah, I was wrong. I feel like this was caused by a very specific library doing a very specific thing that the developer wasn't aware of; it has nothing to do with soft deletes as a concept at all.