Lately (.10 still) there has been lots of self-inflicted locks while trying to execute the same query from several application servers: https://logstash.wikimedia.org/#dashboard/temp/AVJ4kOSCptxhN1XaJd7F
{
"_index": "logstash-2016.01.25",
"_type": "mediawiki",
"_id": "AVJ4hI7sMRv_gmyx6mr7",
"_score": null,
"_source": {
"message": "DatabaseMysqlBase::replace\t10.64.32.22\t1205\tLock wait timeout exceeded; try restarting transaction (10.64.32.22)\tREPLACE INTO `module_deps` (md_module,md_skin,md_deps) VALUES ('ext.wikimediaBadges','vector|en','[\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-golden-star.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-problematic.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-proofread.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-silver-star.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-validated.png\\\"]')",
"@version": 1,
"@timestamp": "2016-01-25T11:21:38.000Z",
"type": "mediawiki",
"host": "mw1073",
"level": "ERROR",
"tags": [
"syslog",
"es",
"es",
"normalized_message_trimmed"
],
"channel": "wfLogDBError",
"url": "/w/load.php?debug=false&lang=en&modules=ext.cite.styles%7Cext.gadget.DRN-wizard%2CReferenceTooltips%2CWatchlistBase%2CWatchlistGreenIndicators%2Ccharinsert%2Cfeatured-articles-links%2CrefToolbar%2Cswitcher%2Cteahouse%7Cext.math.styles%7Cext.pygments%2CwikimediaBadges%7Cext.tmh.thumbnail.styles%7Cext.uls.nojs%7Cext.visualEditor.desktopArticleTarget.noscript%7Cmediawiki.legacy.commonPrint%2Cshared%7Cmediawiki.page.gallery.styles%7Cmediawiki.raggett%2CsectionAnchor%7Cmediawiki.skinning.interface%7Cskins.vector.styles%7Cwikibase.client.init&only=styles&skin=vector",
"ip": "10.64.32.106",
"http_method": "GET",
"server": "en.wikipedia.org",
"referrer": "https://en.wikipedia.org/wiki/Perceptron",
"uid": "a4c98f4",
"process_id": 8237,
"wiki": "enwiki",
"db_server": "10.64.32.22",
"db_name": "enwiki",
"db_user": "wikiuser",
"method": "DatabaseBase::reportQueryError",
"errno": 1205,
"error": "Lock wait timeout exceeded; try restarting transaction (10.64.32.22)",
"sql1line": "REPLACE INTO `module_deps` (md_module,md_skin,md_deps) VALUES ('ext.wikimediaBadges','vector|en','[\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-golden-star.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-problematic.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-proofread.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-silver-star.png\\\",\\\"extensions/Wikidata/extensions/WikimediaBadges/resources/skins/../images/badge-validated.png\\\"]')",
"fname": "DatabaseMysqlBase::replace",
"normalized_message": "DatabaseMysqlBase::replace\t10.64.32.22\t1205\tLock wait timeout exceeded; try restarting transaction (10.64.32.22)\tREPLACE INTO `module_deps` (md_module,md_skin,md_deps) VALUES ('ext.wikimediaBadges','vector|en','[\\\"extensions/Wikidata/extensions/WikimediaB"
},
"sort": [
1453720898000
]
}