Page MenuHomePhabricator
Create Task
Maniphest T419635

Drop il_to column from imagelinks table in wmf production
Open, MediumPublic
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 (done except masters)
    • eqiad (done except masters)
  • s2
    • codfw (done except masters)
    • eqiad (done except masters)
  • s3
    • codfw (done except masters)
    • eqiad (done except masters)
  • s4
    • codfw (done except masters)
    • eqiad (done except masters)
  • s5
    • codfw (done except masters)
    • eqiad (done except masters)
  • s6
    • codfw (done except masters)
    • eqiad (done except masters)
  • s7
    • codfw (done except masters)
    • eqiad
  • s8
    • codfw (done except masters)
    • eqiad (done except masters)
  • Puppet patch

Details

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.Tue, Apr 28, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T11:36:07Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T419635)', diff saved to https://phabricator.wikimedia.org/P91772 and previous config saved to /var/cache/conftool/dbconfig/20260428-113606-fceratto.json

Stashbot added a comment.Tue, Apr 28, 11:36 AM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T11:36:24Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2223 (T419635)', diff saved to https://phabricator.wikimedia.org/P91773 and previous config saved to /var/cache/conftool/dbconfig/20260428-113623-fceratto.json

Stashbot added a comment.Tue, Apr 28, 11:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T11:44:35Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2223 (T419635)', diff saved to https://phabricator.wikimedia.org/P91774 and previous config saved to /var/cache/conftool/dbconfig/20260428-114434-fceratto.json

Stashbot added a comment.Tue, Apr 28, 12:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T12:14:58Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2223 (T419635)', diff saved to https://phabricator.wikimedia.org/P91777 and previous config saved to /var/cache/conftool/dbconfig/20260428-121458-fceratto.json

Stashbot added a comment.Tue, Apr 28, 12:15 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T12:15:35Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2228 (T419635)', diff saved to https://phabricator.wikimedia.org/P91779 and previous config saved to /var/cache/conftool/dbconfig/20260428-121530-fceratto.json

Stashbot added a comment.Tue, Apr 28, 12:22 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T12:22:12Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2228 (T419635)', diff saved to https://phabricator.wikimedia.org/P91782 and previous config saved to /var/cache/conftool/dbconfig/20260428-122211-fceratto.json

Stashbot added a comment.Tue, Apr 28, 12:52 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-28T12:52:37Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2228 (T419635)', diff saved to https://phabricator.wikimedia.org/P91790 and previous config saved to /var/cache/conftool/dbconfig/20260428-125236-fceratto.json

Stashbot added a comment.Thu, Apr 30, 11:39 AM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T11:39:11Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1159 (T419635)', diff saved to https://phabricator.wikimedia.org/P92038 and previous config saved to /var/cache/conftool/dbconfig/20260430-113910-fceratto.json

Stashbot added a comment.Thu, Apr 30, 11:40 AM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T11:40:21Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1159 (T419635)', diff saved to https://phabricator.wikimedia.org/P92040 and previous config saved to /var/cache/conftool/dbconfig/20260430-114020-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:10 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:10:45Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1159 (T419635)', diff saved to https://phabricator.wikimedia.org/P92048 and previous config saved to /var/cache/conftool/dbconfig/20260430-121044-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:11 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:11:31Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1161 (T419635)', diff saved to https://phabricator.wikimedia.org/P92049 and previous config saved to /var/cache/conftool/dbconfig/20260430-121130-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:13 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:13:41Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T419635)', diff saved to https://phabricator.wikimedia.org/P92050 and previous config saved to /var/cache/conftool/dbconfig/20260430-121340-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:44 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:44:05Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T419635)', diff saved to https://phabricator.wikimedia.org/P92058 and previous config saved to /var/cache/conftool/dbconfig/20260430-124405-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:44 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:44:30Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1185 (T419635)', diff saved to https://phabricator.wikimedia.org/P92059 and previous config saved to /var/cache/conftool/dbconfig/20260430-124429-fceratto.json

Stashbot added a comment.Thu, Apr 30, 12:45 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T12:45:40Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1185 (T419635)', diff saved to https://phabricator.wikimedia.org/P92061 and previous config saved to /var/cache/conftool/dbconfig/20260430-124539-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:16 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:16:04Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1185 (T419635)', diff saved to https://phabricator.wikimedia.org/P92066 and previous config saved to /var/cache/conftool/dbconfig/20260430-131604-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:16 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:16:30Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1200 (T419635)', diff saved to https://phabricator.wikimedia.org/P92067 and previous config saved to /var/cache/conftool/dbconfig/20260430-131629-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:17 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:17:40Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1200 (T419635)', diff saved to https://phabricator.wikimedia.org/P92068 and previous config saved to /var/cache/conftool/dbconfig/20260430-131739-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:48 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:48:05Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1200 (T419635)', diff saved to https://phabricator.wikimedia.org/P92074 and previous config saved to /var/cache/conftool/dbconfig/20260430-134804-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:48 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:48:31Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92075 and previous config saved to /var/cache/conftool/dbconfig/20260430-134829-fceratto.json

Stashbot added a comment.Thu, Apr 30, 1:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T13:50:41Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92076 and previous config saved to /var/cache/conftool/dbconfig/20260430-135040-fceratto.json

Stashbot added a comment.Thu, Apr 30, 2:21 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T14:21:05Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T419635)', diff saved to https://phabricator.wikimedia.org/P92084 and previous config saved to /var/cache/conftool/dbconfig/20260430-142105-fceratto.json

Stashbot added a comment.Thu, Apr 30, 2:26 PM

Mentioned in SAL (#wikimedia-operations) [2026-04-30T14:26:44Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1230 (T419635)', diff saved to Unable to send diff to phaste and previous config saved to /var/cache/conftool/dbconfig/20260430-142639-fceratto.json

FCeratto-WMF mentioned this in rSCHCH425f5a824ab2: drop_il_to_from_imagelinks: support setting replicas.Mon, May 4, 11:52 AM
Stashbot added a comment.Mon, May 4, 2:33 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-04T14:33:35Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2229 (T419635)', diff saved to https://phabricator.wikimedia.org/P92215 and previous config saved to /var/cache/conftool/dbconfig/20260504-143334-fceratto.json

Stashbot added a comment.Mon, May 4, 2:42 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-04T14:42:14Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2229 (T419635)', diff saved to https://phabricator.wikimedia.org/P92216 and previous config saved to /var/cache/conftool/dbconfig/20260504-144213-fceratto.json

Stashbot added a comment.Mon, May 4, 3:12 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-04T15:12:38Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2229 (T419635)', diff saved to https://phabricator.wikimedia.org/P92219 and previous config saved to /var/cache/conftool/dbconfig/20260504-151238-fceratto.json

Stashbot added a comment.Mon, May 4, 3:22 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-04T15:22:39Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2229 (T419635)', diff saved to https://phabricator.wikimedia.org/P92220 and previous config saved to /var/cache/conftool/dbconfig/20260504-152238-fceratto.json

Stashbot added a comment.Mon, May 4, 3:24 PM

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

Stashbot added a comment.Mon, May 4, 3:55 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-04T15:55:15Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2229 (T419635)', diff saved to https://phabricator.wikimedia.org/P92224 and previous config saved to /var/cache/conftool/dbconfig/20260504-155514-fceratto.json

Stashbot added a comment.Tue, May 5, 8:46 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T08:46:16Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db2213 (T419635)', diff saved to https://phabricator.wikimedia.org/P92254 and previous config saved to /var/cache/conftool/dbconfig/20260505-084616-fceratto.json

Stashbot added a comment.Tue, May 5, 8:54 AM

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

Stashbot added a comment.Tue, May 5, 9:24 AM

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

Stashbot added a comment.Tue, May 5, 9:33 AM

Mentioned in SAL (#wikimedia-operations) [2026-05-05T09:33:06Z] <fceratto@cumin1003> dbctl commit (dc=all): 'Depooling db1173 (T419635)', diff saved to https://phabricator.wikimedia.org/P92269 and previous config saved to /var/cache/conftool/dbconfig/20260505-093305-fceratto.json

Stashbot added a comment.Tue, May 5, 9:36 AM

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

FCeratto-WMF updated the task description. (Show Details)Tue, May 5, 9:47 AM
Stashbot added a comment.Tue, May 5, 10:40 AM

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

Stashbot added a comment.Tue, May 5, 10:54 AM

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

Stashbot added a comment.Tue, May 5, 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.Tue, May 5, 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.Tue, May 5, 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.Tue, May 5, 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.Tue, May 5, 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.Wed, May 6, 7:45 AM
Ladsgroup mentioned this in T425582: DB schema change in production - for ce_event_contributions.Wed, May 6, 6:16 PM
Stashbot added a comment.Fri, May 8, 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.Fri, May 8, 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.Fri, May 8, 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.Fri, May 8, 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.Fri, May 8, 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.Fri, May 8, 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.Fri, May 8, 1:30 PM
FCeratto-WMF moved this task from Done to In progress on the DBA board.
Stashbot added a comment.Mon, May 11, 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.Mon, May 11, 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

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