Page MenuHomePhabricator
Create Task
Maniphest T318955

Drop fr_comment and fr_text from flaggedrevs table in production
Closed, ResolvedPublic
Actions

Description

Dropped in code but never actually applied in production: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/FlaggedRevs/+/1bbd5fa1cd681ee0221e45945234476826f142ed%5E%21

  1. ALTERs to run: TBD
  2. Where to run those changes: flaggedrevs.dblist
  3. When to run those changes: At any time
  4. If the schema change is backwards compatible: Nope
  5. If the schema change has been tested already on some of the test/beta wikis: This has been around for ten years on new wikis.
  6. if the data should be made available on the labs replicas and/or dumps: The table only contains public data.
    • s1: Done
    • s2: Done
    • s3: Done
    • s4: NA
    • s5: Done
    • s6: Done
    • s7: Done
    • s8: NA

Details

SubjectRepoBranchLines +/-
filtered_tables.txt: Remove unused columnsoperations/puppetproduction+0 -2
Add drop_fr_comment_fr_text_T318955.pyoperations/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.Nov 7 2022, 11:46 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T11:46:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P38250 and previous config saved to /var/cache/conftool/dbconfig/20221107-114649-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 12:27 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T12:27:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T318955)', diff saved to https://phabricator.wikimedia.org/P38266 and previous config saved to /var/cache/conftool/dbconfig/20221107-122737-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 12:28 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T12:28:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38267 and previous config saved to /var/cache/conftool/dbconfig/20221107-122814-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 12:35 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T12:35:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38269 and previous config saved to /var/cache/conftool/dbconfig/20221107-123528-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T12:47:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P38273 and previous config saved to /var/cache/conftool/dbconfig/20221107-124706-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:20 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:20:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38285 and previous config saved to /var/cache/conftool/dbconfig/20221107-132048-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:21 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:21:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2177 (T318955)', diff saved to https://phabricator.wikimedia.org/P38286 and previous config saved to /var/cache/conftool/dbconfig/20221107-132109-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:28 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:28:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T318955)', diff saved to https://phabricator.wikimedia.org/P38288 and previous config saved to /var/cache/conftool/dbconfig/20221107-132824-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:32:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P38290 and previous config saved to /var/cache/conftool/dbconfig/20221107-133225-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:32:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1175 (T318955)', diff saved to https://phabricator.wikimedia.org/P38291 and previous config saved to /var/cache/conftool/dbconfig/20221107-133246-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 1:36 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T13:36:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T318955)', diff saved to https://phabricator.wikimedia.org/P38295 and previous config saved to /var/cache/conftool/dbconfig/20221107-133638-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 2:13 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T14:13:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T318955)', diff saved to https://phabricator.wikimedia.org/P38313 and previous config saved to /var/cache/conftool/dbconfig/20221107-141344-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 2:22 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T14:22:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T318955)', diff saved to https://phabricator.wikimedia.org/P38317 and previous config saved to /var/cache/conftool/dbconfig/20221107-142157-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 2:22 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T14:22:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1179 (T318955)', diff saved to https://phabricator.wikimedia.org/P38318 and previous config saved to /var/cache/conftool/dbconfig/20221107-142219-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 2:26 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T14:26:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T318955)', diff saved to https://phabricator.wikimedia.org/P38320 and previous config saved to /var/cache/conftool/dbconfig/20221107-142610-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 3:11 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T15:11:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T318955)', diff saved to https://phabricator.wikimedia.org/P38336 and previous config saved to /var/cache/conftool/dbconfig/20221107-151130-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 3:11 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T15:11:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1189 (T318955)', diff saved to https://phabricator.wikimedia.org/P38337 and previous config saved to /var/cache/conftool/dbconfig/20221107-151151-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 3:15 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T15:15:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T318955)', diff saved to https://phabricator.wikimedia.org/P38338 and previous config saved to /var/cache/conftool/dbconfig/20221107-151543-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 4:01 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T16:01:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T318955)', diff saved to https://phabricator.wikimedia.org/P38353 and previous config saved to /var/cache/conftool/dbconfig/20221107-160102-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 4:01 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T16:01:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1198 (T318955)', diff saved to https://phabricator.wikimedia.org/P38354 and previous config saved to /var/cache/conftool/dbconfig/20221107-160124-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 4:05 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T16:05:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T318955)', diff saved to https://phabricator.wikimedia.org/P38356 and previous config saved to /var/cache/conftool/dbconfig/20221107-160516-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 4:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T16:50:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T318955)', diff saved to https://phabricator.wikimedia.org/P38374 and previous config saved to /var/cache/conftool/dbconfig/20221107-165036-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 4:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T16:59:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2105 (T318955)', diff saved to https://phabricator.wikimedia.org/P38379 and previous config saved to /var/cache/conftool/dbconfig/20221107-165943-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 5:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T17:06:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2105 (T318955)', diff saved to https://phabricator.wikimedia.org/P38381 and previous config saved to /var/cache/conftool/dbconfig/20221107-170658-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 5:52 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T17:52:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2105 (T318955)', diff saved to https://phabricator.wikimedia.org/P38394 and previous config saved to /var/cache/conftool/dbconfig/20221107-175217-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 5:52 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T17:52:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2109 (T318955)', diff saved to https://phabricator.wikimedia.org/P38395 and previous config saved to /var/cache/conftool/dbconfig/20221107-175228-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 5:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T17:59:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T318955)', diff saved to https://phabricator.wikimedia.org/P38400 and previous config saved to /var/cache/conftool/dbconfig/20221107-175943-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 6:45 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T18:45:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T318955)', diff saved to https://phabricator.wikimedia.org/P38418 and previous config saved to /var/cache/conftool/dbconfig/20221107-184502-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 6:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T18:50:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2149 (T318955)', diff saved to https://phabricator.wikimedia.org/P38421 and previous config saved to /var/cache/conftool/dbconfig/20221107-185035-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 6:58 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T18:58:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T318955)', diff saved to https://phabricator.wikimedia.org/P38424 and previous config saved to /var/cache/conftool/dbconfig/20221107-185800-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 7:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T19:43:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T318955)', diff saved to https://phabricator.wikimedia.org/P38440 and previous config saved to /var/cache/conftool/dbconfig/20221107-194319-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 7:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T19:43:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38441 and previous config saved to /var/cache/conftool/dbconfig/20221107-194335-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 7:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T19:50:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38443 and previous config saved to /var/cache/conftool/dbconfig/20221107-195049-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 8:36 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T20:36:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T318955)', diff saved to https://phabricator.wikimedia.org/P38458 and previous config saved to /var/cache/conftool/dbconfig/20221107-203609-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 8:36 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T20:36:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2177 (T318955)', diff saved to https://phabricator.wikimedia.org/P38460 and previous config saved to /var/cache/conftool/dbconfig/20221107-203626-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 8:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T20:43:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T318955)', diff saved to https://phabricator.wikimedia.org/P38464 and previous config saved to /var/cache/conftool/dbconfig/20221107-204340-ladsgroup.json

Stashbot added a comment.Nov 7 2022, 9:30 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-07T21:29:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T318955)', diff saved to Unable to send diff to phaste and previous config saved to /var/cache/conftool/dbconfig/20221107-212900-ladsgroup.json

Stashbot added a comment.Nov 15 2022, 2:15 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-15T14:15:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1136 (T318955)', diff saved to https://phabricator.wikimedia.org/P39736 and previous config saved to /var/cache/conftool/dbconfig/20221115-141513-ladsgroup.json

Stashbot added a comment.Nov 15 2022, 2:17 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-15T14:17:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1136 (T318955)', diff saved to https://phabricator.wikimedia.org/P39737 and previous config saved to /var/cache/conftool/dbconfig/20221115-141723-ladsgroup.json

Stashbot added a comment.Nov 15 2022, 3:02 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-15T15:02:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1136 (T318955)', diff saved to https://phabricator.wikimedia.org/P39749 and previous config saved to /var/cache/conftool/dbconfig/20221115-150242-ladsgroup.json

Stashbot added a comment.Nov 17 2022, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-17T11:36:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P40097 and previous config saved to /var/cache/conftool/dbconfig/20221117-113621-ladsgroup.json

Stashbot added a comment.Nov 17 2022, 11:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-17T11:40:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P40099 and previous config saved to /var/cache/conftool/dbconfig/20221117-114013-ladsgroup.json

Stashbot added a comment.Nov 17 2022, 12:25 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-17T12:25:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T318955)', diff saved to https://phabricator.wikimedia.org/P40103 and previous config saved to /var/cache/conftool/dbconfig/20221117-122532-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Nov 22 2022, 2:50 PM
Ladsgroup updated the task description. (Show Details)Nov 24 2022, 11:16 PM
Ladsgroup updated the task description. (Show Details)Nov 29 2022, 7:14 AM
Ladsgroup updated the task description. (Show Details)Dec 8 2022, 5:07 AM
Ladsgroup updated the task description. (Show Details)Jan 10 2023, 5:25 PM
Ladsgroup updated the task description. (Show Details)Jan 17 2023, 3:33 PM
Ladsgroup updated the task description. (Show Details)Jan 19 2023, 9:18 AM
Ladsgroup updated the task description. (Show Details)Jan 23 2023, 7:22 AM
Ladsgroup updated the task description. (Show Details)Jan 23 2023, 10:47 AM
Ladsgroup updated the task description. (Show Details)
Ladsgroup closed this task as Resolved.Jan 23 2023, 4:58 PM
Ladsgroup updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Jan 23 2023, 5:15 PM
gerritbot added a comment.Tue, Jul 16, 8:55 AM

Change #1054496 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] filtered_tables.txt: Remove unused columns

https://gerrit.wikimedia.org/r/1054496

gerritbot added a project: Patch-For-Review.Tue, Jul 16, 8:55 AM

Change #1054496 merged by Marostegui:

[operations/puppet@production] filtered_tables.txt: Remove unused columns

https://gerrit.wikimedia.org/r/1054496

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 · Credits