Page MenuHomePhabricator
Create Task
Maniphest T297189

Schema change for dropping ft_title and ft_namespace
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/743403/2/backend/schema/mysql/patch-flaggedtemplates-fr_title.sql
  2. Where to run those changes: flaggedrevs.dblist[1]
  3. When to run those changes: Any time.
  4. If the schema change is backwards compatible: No
  5. If the schema change has been tested already on some of the test/beta wikis: Yes. Beta cluster. had some learnings[2]
  6. If the data should be made available on the cloud services replicas and/or dumps: It's public but the maintain-views has name of this field mentioned, probably we should remove that.

[1] The table exists only in fifty wikis and out of those it's mostly empty in lots of them but it's massive (~100GB) in several including arwiki, dewiki, huwiki, plwiki, ruwiki.
[2]The table might include data that cause alter to fail, we need to delete any rows that ft_tmp_rev_id is either 0 or NULL

  • s1 (enwiki)
    • Fix clouddb views
  • s2 (eowiki fiwiki idwiki plwiki trwiki)
    • Fix clouddb views
  • s3 (alswiki bawiki bewiki bnwiki bswiki cawikinews cewiki ckbwiki de_labswikimedia dewikiquote dewiktionary elwikinews en_labswikimedia enwikibooks enwikinews eswikinews fawikinews flaggedrevs_labswikimedia frwikinews hewikisource hiwiki iawiki iswiktionary kawiki lawikisource mkwiki ptwikibooks ptwikinews ptwikisource plwikisource plwiktionary ruwikinews ruwikiquote ruwikisource ruwiktionary siwiki sqwiki tawikinews test2wiki trwikiquote ukwiktionary vecwiki zh_classicalwiki)
    • Fix clouddb views
  • s5 (dewiki)
    • Fix clouddb views
  • s6 (frwiki ruwiki)
    • Fix clouddb views
  • s7 (arwiki fawiki huwiki ukwiki)
    • Fix clouddb views

Details

SubjectRepoBranchLines +/-
filtered_tables.txt: Remove ft_title and ft_namespaceoperations/puppetproduction+0 -2
drop_ft_title_ft_namesapce_T297189.py: New schema changeoperations/software/schema-changesmaster+38 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Apr 6 2022, 7:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T19:14:02Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1162 (T297189)', diff saved to https://phabricator.wikimedia.org/P24170 and previous config saved to /var/cache/conftool/dbconfig/20220406-191402-marostegui.json

Stashbot added a comment.Apr 6 2022, 7:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T19:59:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1162 (T297189)', diff saved to https://phabricator.wikimedia.org/P24173 and previous config saved to /var/cache/conftool/dbconfig/20220406-195917-marostegui.json

Stashbot added a comment.Apr 6 2022, 7:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T19:59:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24174 and previous config saved to /var/cache/conftool/dbconfig/20220406-195925-marostegui.json

Stashbot added a comment.Apr 6 2022, 8:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T20:50:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24176 and previous config saved to /var/cache/conftool/dbconfig/20220406-205040-marostegui.json

Stashbot added a comment.Apr 6 2022, 9:35 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T21:35:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24179 and previous config saved to /var/cache/conftool/dbconfig/20220406-213557-marostegui.json

Stashbot added a comment.Apr 6 2022, 9:36 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T21:36:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24180 and previous config saved to /var/cache/conftool/dbconfig/20220406-213605-marostegui.json

Stashbot added a comment.Apr 6 2022, 10:36 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T22:36:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24183 and previous config saved to /var/cache/conftool/dbconfig/20220406-223603-marostegui.json

Stashbot added a comment.Apr 6 2022, 11:21 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T23:21:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24189 and previous config saved to /var/cache/conftool/dbconfig/20220406-232118-marostegui.json

Stashbot added a comment.Apr 6 2022, 11:21 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-06T23:21:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1182 (T297189)', diff saved to https://phabricator.wikimedia.org/P24190 and previous config saved to /var/cache/conftool/dbconfig/20220406-232126-marostegui.json

Stashbot added a comment.Apr 7 2022, 12:12 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T00:12:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1182 (T297189)', diff saved to https://phabricator.wikimedia.org/P24191 and previous config saved to /var/cache/conftool/dbconfig/20220407-001254-marostegui.json

Stashbot added a comment.Apr 7 2022, 12:58 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T00:58:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1182 (T297189)', diff saved to https://phabricator.wikimedia.org/P24194 and previous config saved to /var/cache/conftool/dbconfig/20220407-005809-marostegui.json

Stashbot added a comment.Apr 7 2022, 12:58 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T00:58:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24195 and previous config saved to /var/cache/conftool/dbconfig/20220407-005817-marostegui.json

Stashbot added a comment.Apr 7 2022, 1:58 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T01:58:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24196 and previous config saved to /var/cache/conftool/dbconfig/20220407-015832-marostegui.json

Stashbot added a comment.Apr 7 2022, 2:43 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T02:43:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24199 and previous config saved to /var/cache/conftool/dbconfig/20220407-024347-marostegui.json

Stashbot added a comment.Apr 7 2022, 4:42 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T04:41:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1146:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24200 and previous config saved to /var/cache/conftool/dbconfig/20220407-044158-marostegui.json

Marostegui updated the task description. (Show Details)Apr 7 2022, 4:44 AM
Stashbot added a comment.Apr 7 2022, 5:42 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T05:42:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24202 and previous config saved to /var/cache/conftool/dbconfig/20220407-054213-marostegui.json

Stashbot added a comment.Apr 7 2022, 6:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T06:27:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24206 and previous config saved to /var/cache/conftool/dbconfig/20220407-062728-marostegui.json

Stashbot added a comment.Apr 7 2022, 6:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T06:27:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24207 and previous config saved to /var/cache/conftool/dbconfig/20220407-062736-marostegui.json

Stashbot added a comment.Apr 7 2022, 7:46 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T07:46:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24213 and previous config saved to /var/cache/conftool/dbconfig/20220407-074654-marostegui.json

Marostegui updated the task description. (Show Details)Apr 7 2022, 8:22 AM
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Apr 7 2022, 8:32 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T08:32:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T297189)', diff saved to https://phabricator.wikimedia.org/P24217 and previous config saved to /var/cache/conftool/dbconfig/20220407-083209-marostegui.json

Stashbot added a comment.Apr 7 2022, 8:41 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-07T08:41:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1146:3312 (T297189)', diff saved to https://phabricator.wikimedia.org/P24219 and previous config saved to /var/cache/conftool/dbconfig/20220407-084140-marostegui.json

Marostegui added a comment.Apr 7 2022, 10:42 AM

s2 master done as well.

Marostegui updated the task description. (Show Details)Apr 7 2022, 10:43 AM
Stashbot added a comment.Apr 11 2022, 4:43 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T04:43:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1127 (T297189)', diff saved to https://phabricator.wikimedia.org/P24366 and previous config saved to /var/cache/conftool/dbconfig/20220411-044302-marostegui.json

Stashbot added a comment.Apr 11 2022, 5:50 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T05:50:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T297189)', diff saved to https://phabricator.wikimedia.org/P24375 and previous config saved to /var/cache/conftool/dbconfig/20220411-055037-marostegui.json

Stashbot added a comment.Apr 11 2022, 6:35 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T06:35:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T297189)', diff saved to https://phabricator.wikimedia.org/P24378 and previous config saved to /var/cache/conftool/dbconfig/20220411-063552-marostegui.json

Stashbot added a comment.Apr 11 2022, 6:36 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T06:36:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T297189)', diff saved to https://phabricator.wikimedia.org/P24379 and previous config saved to /var/cache/conftool/dbconfig/20220411-063601-marostegui.json

Stashbot added a comment.Apr 11 2022, 7:36 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T07:36:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T297189)', diff saved to https://phabricator.wikimedia.org/P24385 and previous config saved to /var/cache/conftool/dbconfig/20220411-073615-marostegui.json

Stashbot added a comment.Apr 11 2022, 8:21 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T08:21:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T297189)', diff saved to https://phabricator.wikimedia.org/P24392 and previous config saved to /var/cache/conftool/dbconfig/20220411-082130-marostegui.json

Zabe renamed this task from Schema change for dropping ft_title and ft_namesapce to Schema change for dropping ft_title and ft_namespace.Apr 11 2022, 9:35 AM
Stashbot added a comment.Apr 11 2022, 10:33 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T10:33:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T297189)', diff saved to https://phabricator.wikimedia.org/P24402 and previous config saved to /var/cache/conftool/dbconfig/20220411-103336-marostegui.json

Stashbot added a comment.Apr 11 2022, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T11:36:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T297189)', diff saved to https://phabricator.wikimedia.org/P24410 and previous config saved to /var/cache/conftool/dbconfig/20220411-113657-marostegui.json

Stashbot added a comment.Apr 11 2022, 12:22 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T12:22:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T297189)', diff saved to https://phabricator.wikimedia.org/P24415 and previous config saved to /var/cache/conftool/dbconfig/20220411-122212-marostegui.json

Stashbot added a comment.Apr 11 2022, 12:22 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T12:22:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24416 and previous config saved to /var/cache/conftool/dbconfig/20220411-122220-marostegui.json

Stashbot added a comment.Apr 11 2022, 1:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T13:48:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24421 and previous config saved to /var/cache/conftool/dbconfig/20220411-134848-marostegui.json

Stashbot added a comment.Apr 11 2022, 2:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T14:34:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24427 and previous config saved to /var/cache/conftool/dbconfig/20220411-143403-marostegui.json

Stashbot added a comment.Apr 11 2022, 2:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T14:34:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24428 and previous config saved to /var/cache/conftool/dbconfig/20220411-143411-marostegui.json

Stashbot added a comment.Apr 11 2022, 3:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T15:47:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24430 and previous config saved to /var/cache/conftool/dbconfig/20220411-154725-marostegui.json

Stashbot added a comment.Apr 11 2022, 4:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T16:32:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24437 and previous config saved to /var/cache/conftool/dbconfig/20220411-163240-marostegui.json

Stashbot added a comment.Apr 11 2022, 4:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T16:32:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24438 and previous config saved to /var/cache/conftool/dbconfig/20220411-163248-marostegui.json

Stashbot added a comment.Apr 11 2022, 5:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T17:34:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24442 and previous config saved to /var/cache/conftool/dbconfig/20220411-173423-marostegui.json

Stashbot added a comment.Apr 11 2022, 6:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T18:19:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T297189)', diff saved to https://phabricator.wikimedia.org/P24448 and previous config saved to /var/cache/conftool/dbconfig/20220411-181939-marostegui.json

Stashbot added a comment.Apr 11 2022, 6:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T18:19:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1181 (T297189)', diff saved to https://phabricator.wikimedia.org/P24449 and previous config saved to /var/cache/conftool/dbconfig/20220411-181947-marostegui.json

Stashbot added a comment.Apr 11 2022, 7:02 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T19:02:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T297189)', diff saved to https://phabricator.wikimedia.org/P24452 and previous config saved to /var/cache/conftool/dbconfig/20220411-190257-marostegui.json

Stashbot added a comment.Apr 11 2022, 7:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-04-11T19:48:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T297189)', diff saved to https://phabricator.wikimedia.org/P24459 and previous config saved to /var/cache/conftool/dbconfig/20220411-194812-marostegui.json

Marostegui updated the task description. (Show Details)Apr 12 2022, 4:56 AM
Stashbot added a comment.Apr 12 2022, 9:01 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-12T09:01:38Z] <marostegui> dbmaint s7@eqiad T297189

Marostegui updated the task description. (Show Details)Apr 12 2022, 9:49 AM
Stashbot added a comment.Apr 18 2022, 10:30 AM

Mentioned in SAL (#wikimedia-operations) [2022-04-18T10:30:23Z] <marostegui> dbmaint s1@eqiad T297189

Marostegui updated the task description. (Show Details)Apr 18 2022, 10:32 AM
Marostegui mentioned this in T306148: clouddb1021 missing network firmware bnx2x/bnx2x-e2-7.13.21.0.fw in Debian 11 Bullseye.
Marostegui closed this task as Resolved.Apr 18 2022, 10:34 AM

Recreating the views on clouddb1021 for this table is pending due to T306148
I have asked there to get it done once that task is fixed (T306148#7860656)

The rest of this task is finished.

Marostegui mentioned this in T296380: flaggedtemplates table is still too big.Apr 18 2022, 10:35 AM
Maintenance_bot moved this task from In progress to Done on the DBA board.Apr 18 2022, 11:29 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL