Page MenuHomePhabricator
Create Task
Maniphest T419635

Drop il_to column from imagelinks table in wmf production
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1248863/4/sql/mysql/patch-imagelinks-drop-il_to.sql
  2. Where to run those changes: all wikis
  3. When to run those changes: When DBA has time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: Already in beta cluster.
  6. If the data should be made available on the labs replicas and/or dumps: Yes

Progress

  • s1
    • codfw
    • eqiad
  • s2
    • codfw
    • eqiad
  • s3
    • codfw
    • eqiad
  • s4
    • codfw
    • eqiad
  • s5
    • codfw
    • eqiad
  • s6
    • codfw
    • eqiad
  • s7
    • codfw
    • eqiad
  • s8
    • codfw
    • eqiad

The server-by-server progress can be monitored on https://zarcillo.wikimedia.org/ui/schema_change (requires login)

  • Puppet patch

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
filtered_tables.txt: drop il_to column from imagelinks tableFederico Cerattooperations/puppetproduction+0 -1
Customize query in gerrit
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
drop_il_to_from_imagelinks_T419635: new schema changerepos/sre/schema-changes!62fcerattoT419635main
Customize query in GitLab

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.May 5 2026, 11:24 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T11:24:50Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1227 (T419635)', diff saved to https://phabricator.wikimedia.org/P92302 and previous config saved to /var/cache/conftool/dbconfig/20260505-112449-fceratto.json

Stashbot added a comment.May 5 2026, 1:42 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T13:42:58Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1227 (T419635)', diff saved to https://phabricator.wikimedia.org/P92319 and previous config saved to /var/cache/conftool/dbconfig/20260505-134257-fceratto.json

Stashbot added a comment.May 5 2026, 1:45 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T13:45:22Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2209 (T419635)', diff saved to https://phabricator.wikimedia.org/P92321 and previous config saved to /var/cache/conftool/dbconfig/20260505-134522-fceratto.json

Stashbot added a comment.May 5 2026, 2:22 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T14:22:07Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T419635)', diff saved to https://phabricator.wikimedia.org/P92329 and previous config saved to /var/cache/conftool/dbconfig/20260505-142206-fceratto.json

Stashbot added a comment.May 5 2026, 2:52 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T14:52:32Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T419635)', diff saved to https://phabricator.wikimedia.org/P92337 and previous config saved to /var/cache/conftool/dbconfig/20260505-145231-fceratto.json

Marostegui mentioned this in T425384: imagelinks table missing in pplwiki, several other tables missing in testcommonswiki.May 6 2026, 7:45 AM
Ladsgroup mentioned this in T425582: DB schema change in production - for ce_event_contributions.May 6 2026, 6:16 PM
Stashbot added a comment.May 8 2026, 8:04 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T08:04:38Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92427 and previous config saved to /var/cache/conftool/dbconfig/20260508-080438-fceratto.json

Stashbot added a comment.May 8 2026, 8:19 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T08:19:55Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92428 and previous config saved to /var/cache/conftool/dbconfig/20260508-081954-fceratto.json

Stashbot added a comment.May 8 2026, 8:50 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T08:50:19Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92431 and previous config saved to /var/cache/conftool/dbconfig/20260508-085018-fceratto.json

Stashbot added a comment.May 8 2026, 8:52 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T08:52:17Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1189 (T419635)', diff saved to https://phabricator.wikimedia.org/P92432 and previous config saved to /var/cache/conftool/dbconfig/20260508-085217-fceratto.json

Stashbot added a comment.May 8 2026, 9:02 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T09:02:31Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T419635)', diff saved to https://phabricator.wikimedia.org/P92433 and previous config saved to /var/cache/conftool/dbconfig/20260508-090230-fceratto.json

Stashbot added a comment.May 8 2026, 9:32 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-08T09:32:52Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T419635)', diff saved to https://phabricator.wikimedia.org/P92437 and previous config saved to /var/cache/conftool/dbconfig/20260508-093251-fceratto.json

FCeratto-WMF moved this task from In progress to Done on the DBA board.May 8 2026, 1:30 PM
FCeratto-WMF moved this task from Done to In progress on the DBA board.
Stashbot added a comment.May 11 2026, 8:56 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-11T08:56:44Z] <fceratto@cumin1003> START - Cookbook sre.mysql.pool pool db1230: T419635

Stashbot added a comment.May 11 2026, 9:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-11T09:42:09Z] <fceratto@cumin1003> END (PASS) - Cookbook sre.mysql.pool (exit_code=0) pool db1230: T419635

FCeratto-WMF updated the task description. (Show Details)May 12 2026, 2:38 PM
FCeratto-WMF closed subtask T422459: Re-run maintainviews on all clouddb* and an-redacteddb1001.eqiad.wmnet as Resolved.May 12 2026, 2:43 PM
FCeratto-WMF added a subtask: T426095: Switchover s8 master (db1209 -> db1193).May 12 2026, 4:11 PM
Marostegui added a comment.May 13 2026, 6:16 AM

@FCeratto-WMF you probably want to do the codfw masters switches before the eqiad ones

FCeratto-WMF added a subtask: T426291: Switchover s8 master (db2165 -> db2161).May 14 2026, 9:15 AM
FCeratto-WMF closed subtask T426291: Switchover s8 master (db2165 -> db2161) as Resolved.May 14 2026, 1:09 PM
Stashbot added a comment.May 14 2026, 1:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-14T13:53:15Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2165 (T419635)', diff saved to https://phabricator.wikimedia.org/P92533 and previous config saved to /var/cache/conftool/dbconfig/20260514-135315-fceratto.json

Stashbot added a comment.May 14 2026, 1:56 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-14T13:56:27Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2165 (T419635)', diff saved to https://phabricator.wikimedia.org/P92534 and previous config saved to /var/cache/conftool/dbconfig/20260514-135626-fceratto.json

FCeratto-WMF updated the task description. (Show Details)May 14 2026, 2:44 PM
Stashbot added a comment.May 18 2026, 10:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-18T10:08:32Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2179 (T419635)', diff saved to https://phabricator.wikimedia.org/P92561 and previous config saved to /var/cache/conftool/dbconfig/20260518-100831-fceratto.json

FCeratto-WMF updated the task description. (Show Details)May 18 2026, 10:40 AM
FCeratto-WMF added subtasks: T426590: Switchover s4 master (db2179 -> db2240), T426600: Switchover s5 master (db2192 -> db2213).May 18 2026, 11:41 AM
FCeratto-WMF changed the status of subtask T426590: Switchover s4 master (db2179 -> db2240) from Open to In Progress.
FCeratto-WMF changed the status of subtask T426600: Switchover s5 master (db2192 -> db2213) from Open to In Progress.
Stashbot added a comment.May 18 2026, 12:20 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-18T12:20:15Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T419635)', diff saved to https://phabricator.wikimedia.org/P92567 and previous config saved to /var/cache/conftool/dbconfig/20260518-122014-fceratto.json

Stashbot added a comment.May 18 2026, 12:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-18T12:50:39Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T419635)', diff saved to https://phabricator.wikimedia.org/P92570 and previous config saved to /var/cache/conftool/dbconfig/20260518-125038-fceratto.json

FCeratto-WMF closed subtask T426600: Switchover s5 master (db2192 -> db2213) as Resolved.May 18 2026, 2:18 PM
FCeratto-WMF mentioned this in T426087: Switchover s5 master (db1210 -> db1230).May 19 2026, 6:30 AM
FCeratto-WMF updated the task description. (Show Details)May 19 2026, 6:37 AM
FCeratto-WMF added a subtask: T426703: Switchover s1 master (db2212 -> db2203).May 19 2026, 7:18 AM
FCeratto-WMF updated the task description. (Show Details)May 25 2026, 12:19 PM
Marostegui added a subtask: T425622: Switchover s2 master (db1222 -> db1162).May 25 2026, 1:39 PM
FCeratto-WMF changed the status of subtask T425622: Switchover s2 master (db1222 -> db1162) from Open to In Progress.May 26 2026, 6:09 AM
FCeratto-WMF closed subtask T425622: Switchover s2 master (db1222 -> db1162) as Resolved.May 26 2026, 6:37 AM
Stashbot added a comment.May 26 2026, 6:48 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-26T06:48:34Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1222 (T419635)', diff saved to https://phabricator.wikimedia.org/P92916 and previous config saved to /var/cache/conftool/dbconfig/20260526-064833-fceratto.json

Stashbot added a comment.May 26 2026, 7:04 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-26T07:04:37Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1222 (T419635)', diff saved to https://phabricator.wikimedia.org/P92919 and previous config saved to /var/cache/conftool/dbconfig/20260526-070436-fceratto.json

Stashbot added a comment.May 26 2026, 7:35 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-26T07:35:00Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1222 (T419635)', diff saved to https://phabricator.wikimedia.org/P92926 and previous config saved to /var/cache/conftool/dbconfig/20260526-073459-fceratto.json

FCeratto-WMF updated the task description. (Show Details)May 26 2026, 8:21 AM
FCeratto-WMF closed subtask T426590: Switchover s4 master (db2179 -> db2240) as Resolved.May 28 2026, 6:02 AM
FCeratto-WMF changed the status of subtask T426095: Switchover s8 master (db1209 -> db1193) from Open to In Progress.
Stashbot added a comment.May 28 2026, 8:49 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-28T08:49:06Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1209 (T419635)', diff saved to https://phabricator.wikimedia.org/P93326 and previous config saved to /var/cache/conftool/dbconfig/20260528-084906-fceratto.json

Stashbot added a comment.May 28 2026, 8:52 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-28T08:52:17Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1209 (T419635)', diff saved to https://phabricator.wikimedia.org/P93327 and previous config saved to /var/cache/conftool/dbconfig/20260528-085216-fceratto.json

Stashbot added a comment.May 28 2026, 9:22 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-28T09:22:46Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1209 (T419635)', diff saved to https://phabricator.wikimedia.org/P93335 and previous config saved to /var/cache/conftool/dbconfig/20260528-092239-fceratto.json

FCeratto-WMF updated the task description. (Show Details)May 28 2026, 9:25 AM
Stashbot added a comment.Jun 2 2026, 7:58 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-02T07:57:59Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1181 (T419635)', diff saved to https://phabricator.wikimedia.org/P93498 and previous config saved to /var/cache/conftool/dbconfig/20260602-075759-fceratto.json

Stashbot added a comment.Jun 2 2026, 8:00 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-02T08:00:11Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T419635)', diff saved to https://phabricator.wikimedia.org/P93499 and previous config saved to /var/cache/conftool/dbconfig/20260602-080011-fceratto.json

Stashbot added a comment.Jun 2 2026, 8:30 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-02T08:30:34Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T419635)', diff saved to https://phabricator.wikimedia.org/P93505 and previous config saved to /var/cache/conftool/dbconfig/20260602-083033-fceratto.json

FCeratto-WMF closed subtask T426095: Switchover s8 master (db1209 -> db1193) as Resolved.Jun 2 2026, 9:17 AM
FCeratto-WMF updated the task description. (Show Details)Jun 5 2026, 1:15 PM
Stashbot added a comment.Jun 15 2026, 7:24 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-15T07:24:46Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1163 (T419635)', diff saved to https://phabricator.wikimedia.org/P94110 and previous config saved to /var/cache/conftool/dbconfig/20260615-072446-fceratto.json

Stashbot added a comment.Jun 15 2026, 7:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-15T07:44:18Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T419635)', diff saved to https://phabricator.wikimedia.org/P94112 and previous config saved to /var/cache/conftool/dbconfig/20260615-074417-fceratto.json

Stashbot added a comment.Jun 15 2026, 8:14 AM

Mentioned in SAL (#wikimedia-operations) [2026-06-15T08:14:41Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T419635)', diff saved to https://phabricator.wikimedia.org/P94117 and previous config saved to /var/cache/conftool/dbconfig/20260615-081440-fceratto.json

FCeratto-WMF updated the task description. (Show Details)Jun 15 2026, 9:37 AM

The rollout on the database hosts is completed (See https://zarcillo.wikimedia.org/ui/schema_change )

Marostegui added a comment.Jun 15 2026, 9:44 AM

Cool - then just remove the colum from modules/role/files/mariadb/filtered_tables.txt and this can be closed.

gerritbot added a comment.Jun 15 2026, 10:12 AM

Change #1302113 had a related patch set uploaded (by Federico Ceratto; author: Federico Ceratto):

[operations/puppet@production] filtered_tables.txt: drop il_to column from imagelinks table

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

gerritbot added a project: Patch-For-Review.Jun 15 2026, 10:12 AM
gerritbot added a comment.Jun 15 2026, 10:29 AM

Change #1302113 merged by Federico Ceratto:

[operations/puppet@production] filtered_tables.txt: drop il_to column from imagelinks table

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

FCeratto-WMF updated the task description. (Show Details)Jun 15 2026, 10:30 AM

puppet-merged, can we close this?

Maintenance_bot removed a project: Patch-For-Review.Jun 15 2026, 10:31 AM
Marostegui added a comment.Jun 15 2026, 10:33 AM
In T419635#12017985, @FCeratto-WMF wrote:

puppet-merged, can we close this?

T419635#12017813

FCeratto-WMF closed this task as Resolved.Jun 19 2026, 1:07 PM
Maintenance_bot moved this task from In progress to Done on the DBA board.Jun 19 2026, 1:29 PM
FCeratto-WMF mentioned this in rSCHCHd544b978222c: drop_il_to_from_imagelinks: support setting replicas.Jul 21 2026, 7:58 AM
FCeratto-WMF mentioned this in rSCHCH8ee079180e81: drop_il_to_from_imagelinks: support setting replicas.Jul 21 2026, 9:25 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 · Credits