[Koha-bugs] [Bug 20086] AddRenewal is not executed as a transaction and can results in partial success and doubled fines

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20086

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #11 from David Cook <dcook at prosentient.com.au> ---
According to Bug 26457, the same deadlocks are still occurring. 

Based on Didier's report, this whole sub transaction probably made it worse?

Interesting that the problem happened before adding the (too) large transaction
though. 

In Didier's report, the lock contention seems to be due to the "WHERE
borrowernumber =" causing the issuesborridx index to be locked. That shouldn't
be an issue for this bug report, since there wasn't a large transaction that
would cause waiting for locks...

I'm guessing that some of the fine logic is slow though, and since the renewals
are processed asynchronously, doing a large volume of renewals at once could
cause lock contention I suppose...

Anyway, best to continue this at Bug 26457...

-- 
You are receiving this mail because:
You are watching all bug changes.