Is there a way in Django to unlock the resources before the transaction is over or to auto restart the transaction if the deadlock is found?

[jeetpatel9]

I am not sure if this the right place to ask this question.

I have a model Orders in my Django rest-framework app. I am retrieving a list of orders based on some filter parameters and at the same time I am also locking orders using select_for_update().

Each order in the Orders model has a status and it could be OPEN, PARTIALLY_COMPLETED, COMPLETED or CANCELLED. However, one of my filter parameters will only consider the order with status OPEN or PARTIALLY_COMPLETED. So the retrieved list will have order with OPEN or PARTIALLY_COMPLETED status only.

Furthermore, each order in Orders model also has the parameter units. This represents the units at which the order was created. If the order is in OPEN state then all the units are unsold or if the order is in PARTIALLY_COMPLETED then unsold_units = units - sold_units. Deriving the unsold units for PARTIALLY_COMPLETED orders is done after retrieving the list of orders.

Now, let's assume the retrieved order list has 10 order and the total of unsold_units of the list is 1000. However, I just need 100 units so if the unsold_units of the first 3 orders is equal or over 100 units than the remaining orders must be unlocked immediately so that the other transaction can use it.

Is there a way in Django to unlock the resources before the transaction is over?

Is there a way to auto restart the transaction if the deadlock is found?