jcrespo added a comment.
Could this job have caused:
/* JobRunner::commitMasterChanges 127.0.0.1 */
GET_LOCK('jobrunner-serial-commit', 30) AS lockstatus /*
31bdf25cc42f95f4f4a9b493cafe0299 db1024 plwiki 11s */ /* localhost */
we had another large lag spike around the same time than other touchusages, but
it could have just been a coincidence? This other "query" caused 7000 hits with
an avg waiting time of 15 seconds, causing lag on s2. If not, I will open
another ticket for this other issue.
Another proof that touchUsages may be too aaggressive is that sometimes it
conflicts with itself. Updating by primary key, as suggested, should solve this.
Wikibase\Client\Usage\Sql\EntityUsageTable::touchUsages 10.64.16.13 1205 Lock
wait timeout exceeded; try restarting transaction (10.64.16.13) UPDATE
`wbc_entity_usage` SET eu_touched = '20150822101128' WHERE eu_page_id =
'616905' AND ((eu_aspect = 'S' AND eu_entity_id = 'Q14484217'))
BTW, thank you for looking at this- you have been a really responsive team, and
this is really appreciated.
TASK DETAIL
https://phabricator.wikimedia.org/T107319
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: jcrespo
Cc: gerritbot, JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori,
jcrespo, Aklapper, aude, Wikidata-bugs, Malyacko
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
