Per T205045#4878367 we should alter the newly created config var in production T213809 to be a smaller value.
The wikibase config options i "addEntityUsagesBatchSize"
Docs can be seen @ https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Wikibase/+/485849/5/docs/options.wiki
Default value is currently 500
We should try decreasing this value to 300, and monitor the occurrence of errors.
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Set EntityUsageTable addUsage batch size to 300 | operations/mediawiki-config | master | +6 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T30599 Deadlock tracking bug (tracking) | |||
| Resolved | PRODUCTION ERROR | Ladsgroup | T205045 Exception from LinksUpdate: Deadlock found in database query (from Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages) | ||
| Resolved | Ladsgroup | T215146 Decrease EntityUsageTable addUsage batch size to 300 |
Change 488907 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 300
Change 488907 merged by jenkins-bot:
[operations/mediawiki-config@master] Set EntityUsageTable addUsage batch size to 300
Mentioned in SAL (#wikimedia-operations) [2019-02-07T12:39:52Z] <ladsgroup@deploy1001> Synchronized wmf-config/InitialiseSettings.php: SWAT: [[gerrit:488907|Set EntityUsageTable addUsage batch size to 300 (T215146)]], Part I (duration: 00m 55s)