[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 596015 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Add some deprecated annotations to some old terms classes https://gerrit.wikimedia.org/r/596015 TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 596015 had a related patch set uploaded (by Addshore; owner: Addshore): [mediawiki/extensions/Wikibase@master] Add some deprecated annotations to some old terms classes https://gerrit.wikimedia.org/r/596015 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-04-07T01:05:04Z] Synchronized php-1.35.0-wmf.26/extensions/Wikibase/repo/includes/Store/Sql/DatabaseSchemaUpdater.php: T208425 T249565

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 586480 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@wmf/1.35.0-wmf.26] Follow-up a956c655 : Only avoid dropping wb_items_per_site so prod can be merged

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 586467 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Do not try to drop wb_items_per_site when there's no wb_terms table https://gerrit.wikimedia.org/r/586467 TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-04-07T00:01:28Z] Synchronized php-1.35.0-wmf.26/extensions/Wikibase/repo/includes/Store/Sql/DatabaseSchemaUpdater.php: Do not try to drop things when theres no wb_terms table T208425

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 586469 **merged** by Addshore: [mediawiki/extensions/Wikibase@wmf/1.35.0-wmf.26] Do not try to drop things when there's no wb_terms table https://gerrit.wikimedia.org/r/586469 TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 586469 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@wmf/1.35.0-wmf.26] Do not try to drop things when there's no wb_terms table https://gerrit.wikimedia.org/r/586469 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 586467 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Do not try to drop things when there's no wb_terms table https://gerrit.wikimedia.org/r/586467 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Mahir256 added a comment. In T208425#5992965 , @Bugreporter wrote: > To find the number of labels in a specific languages, you can use ElasticSearch: https://www.wikidata.org/w/index.php?search=haslabel%3Abn though this will not work

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Bugreporter added a comment. To find the number of labels in a specific languages, you can use ElasticSearch: https://www.wikidata.org/w/index.php?search=haslabel%3Abn though this will not work in aliases. TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Marostegui added a comment. Following up the conversation on IRC with @Ladsgroup I have renamed `wb_terms` to `T208425_wb_terms` on the following hosts and wikis (all in codfw): root@cumin1001:/home/marostegui# for i in db2106 db2109 db2081; do echo $i; mysql.py -h$i

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-03-18T14:17:58Z] Rename wb_terms on codfw hosts: s8 (wikidatawiki - db2081), s3 (testwikidatawiki - db2109), s4 (commonswiki, testcommonswiki - db2106) T208425 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Ladsgroup added a comment. In T208425#5979419 , @Bugreporter wrote: > In T208425#5978810 , @Stashbot wrote: > >> Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:58:04Z]

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Bugreporter added a comment. In T208425#5978810 , @Stashbot wrote: > Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:58:04Z] Synchronized wmf-config/InitialiseSettings.php: [[gerrit:579925|Stop writing to old term store

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:58:04Z] Synchronized wmf-config/InitialiseSettings.php: [[gerrit:579925|Stop writing to old term store (wb_terms table) in wikidata (T208425 )]], take II (duration:

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:55:47Z] Synchronized wmf-config/InitialiseSettings.php: [[gerrit:579925|Stop writing to old term store (wb_terms table) in wikidata (T208425 )]] (duration: 01m 08s)

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 580881 **merged** by jenkins-bot: [operations/mediawiki-config@master] Stop writing to old term store (wb_terms table) in wikidata https://gerrit.wikimedia.org/r/580881 TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 580881 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [operations/mediawiki-config@master] Stop writing to old term store (wb_terms table) in wikidata https://gerrit.wikimedia.org/r/580881 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:48:31Z] Synchronized wmf-config/InitialiseSettings.php: [[gerrit:579925|Stop writing to old term store in testwikidatawiki (T208425 )]], take II (duration: 01m 07s)

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2020-03-18T10:45:44Z] Synchronized wmf-config/InitialiseSettings.php: [[gerrit:579925|Stop writing to old term store in testwikidatawiki (T208425 )]] (duration: 01m 07s) TASK

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 580876 **merged** by jenkins-bot: [operations/mediawiki-config@master] Stop writing to old term store in testwikidatawiki https://gerrit.wikimedia.org/r/580876 TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

gerritbot added a comment. Change 580876 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [operations/mediawiki-config@master] Stop writing to old term store in testwikidatawiki https://gerrit.wikimedia.org/r/580876 TASK DETAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Marostegui added a comment. In T208425#5978156 , @Stashbot wrote: > Mentioned in SAL (#wikimedia-releng) [2020-03-18T03:16:34Z] dropping wb_terms table from wikidatawiki in beta cluster (T219123

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-releng) [2020-03-18T03:16:34Z] dropping wb_terms table from wikidatawiki in beta cluster (T219123 T219175 T208425

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Addshore added a comment. We will also do this in SQL as we progress through reading from more of the new schemas. See T219123#5844088 where this has already been done. TASK DETAIL https://phabricator.wikimedia.org/T208425 EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

jcrespo added a comment. Thanks a lot for the work on this- may I suggest a step before the next step (after rebuilding) of "checking all data, old and new, is consistent". This is a lot of data, and even on well thought processes missing rows were discovered after I requested a comparison

[Wikidata-bugs] [Maniphest] [Commented On] T208425: [EPIC] Kill the wb_terms table

Addshore added a comment. In T208425#5054567 , @jcrespo wrote: > I see you are going to ask DBAs at T219145 , that is great. > > As a heads up, because I saw there is a chance of starting