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

David Cook <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #11 from David Cook <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to