Sounds oddly similar to a database deadlock. Wonder who the optimizer will select as the victim. But that's what happens when you put all your manufacturing in

Sounds oddly similar to a database deadlock. Wonder who the optimizer will select as the victim. But that's what happens when you put all your manufacturing in one large transaction.