Incorrect balance during race condition

[laravel-enso]

Incorrect balance during race condition

[raftx24]

Can you give your test script? how do you update your model?

[panadol007]

Hi Raftx24,

Thank you for your reply.
In my scenario, to be precise:
1 User has multiple Companies
1 Company has multiple Accounts
ALSO 1 Company has multiple Users

The update process is:
while ($outstanding > 0) {
$oldestTopup = $this->topups()->where('balanceamount', '>', 0)->orderBy('created_at')->first();
if (is_null($oldestTopup))
return false;

        if ($oldestTopup->balanceamount >= $outstanding) {
            // Log::info("Enough balance to deduct");
            $oldestTopup->balanceamount -= $outstanding; 
            $outstanding = 0;
        }
        else {
            $outstanding -= $oldestTopup->balanceamount; 
            $oldestTopup->balanceamount = 0;
        }
        $oldestTopup->save();
    }

I implemented versioning trait in Account model
But when try to implement versioning trait in Company model, it produce error saying no relationship between \App\versionings and \App\Company

[raftx24]

• For the race condition problem, you need to use lockForUpdate or something similar(you can look at pessimistic-locking) because this package cannot control concurrency in this way!
• For the second issue, please give me the classes(with relation methods) and exception trace