[Koha-bugs] [Bug 33987] Combine multiple db updates in C4::ImportBatch::BatchCommitRecords for efficiency/avoiding possible deadlocks

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

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

--- Comment #6 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Kyle M Hall from comment #0)
> When replacing existing records BatchCommitRecords will the table
> import_records will be updated three times for three different fields by
> three different queries. Not only is this inefficient ( especially for large
> batches ), it seems that this is causing the dreaded "Lock wait timeout
> exceeded; try restarting transaction" error on some mysql/mariadb
> configurations.

Patch is fine.
Would be nice if this would prevent a deadlock. But I dont think that this is
the ultimate solution. We need to dig a bit deeper still probably.
Continuing on 33972

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