Code was added in T213817
Once this code as landed in production we should turn on seperate DB connections for wikidata item ID generation.
Config was introduced in https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Wikibase/+/485859/2/repo/config/Wikibase.default.php
This should be deployed in 2 stages:
Once deployed on test entity creation should be tested.
Entity creation rate and errors should be watched during the deployment time on wikidata.org
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | PRODUCTION ERROR | Addshore | T194299 Lock wait timeout exceeded in SqlIdGenerator::generateNewId | ||
| Resolved | Ladsgroup | T215147 Deploy separate DB connection for ID insertions on wikidata.org |
Change 488114 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[operations/mediawiki-config@master] Use separate DB connection for ID insertions on testwikidatawiki
Change 488114 merged by jenkins-bot:
[operations/mediawiki-config@master] Use separate DB connection for ID insertions on testwikidatawiki
Mentioned in SAL (#wikimedia-operations) [2019-02-06T12:17:30Z] <ladsgroup@deploy1001> Synchronized wmf-config/InitialiseSettings.php: SWAT: [[gerrit:488114|Use separate DB connection for ID insertions on testwikidatawiki (T215147)]], Part I (duration: 00m 55s)
Mentioned in SAL (#wikimedia-operations) [2019-02-06T12:19:31Z] <ladsgroup@deploy1001> Synchronized wmf-config/Wikibase.php: SWAT: [[gerrit:488114|Use separate DB connection for ID insertions on testwikidatawiki (T215147)]], Part II (duration: 00m 54s)
So I deployed this and you can test it, it seems slow to me. @Addshore Can you take a look?
Test seems fine for me.
@Ladsgroup if you have time today do you think you could push this out onto wikidata.org? :) (It's been stuck here for a while)
Change 491484 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[operations/mediawiki-config@master] Set wmgWikibaseRepoIdGeneratorSeparateDbConnection to true for wikidata
Change 491484 merged by jenkins-bot:
[operations/mediawiki-config@master] Set wmgWikibaseRepoIdGeneratorSeparateDbConnection to true for wikidata
Mentioned in SAL (#wikimedia-operations) [2019-02-21T19:19:49Z] <ladsgroup@deploy1001> Synchronized wmf-config/InitialiseSettings.php: SWAT [[gerrit:491484|Set wmgWikibaseRepoIdGeneratorSeparateDbConnection to true for wikidata (T215147)]] (duration: 00m 56s)