jcrespo added a comment. |
The LIMIT 1 FOR UPDATE (plus what marostegui comments) indicates that is not a lag problem, but a contention problem (Error: 1205 Lock wait timeout exceeded)- many items wanting to lock the same rows at the same time. There is nothing for the DBAs to do here, code should avoid contention (many locks or long locks to avoid errors). If many items have to be edited at the same time, for some reason, locking or coordination between threads should happen somehow outside of the database- the database is doing exactly what it was asked "lock this row exclusively and wait if it is already locked".
TASK DETAIL
EMAIL PREFERENCES
To: jcrespo
Cc: jcrespo, Marostegui, Ladsgroup, Aklapper, Billinghurst, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: jcrespo, Marostegui, Ladsgroup, Aklapper, Billinghurst, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs