Page MenuHomePhabricator
Create Task
Maniphest T413525

Add il_target_id to imagelinks table in wmf production
Open, Stalled, MediumPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1163485/7/sql/mysql/patch-imagelinks-add-il_target_id.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 Blocked by T411163 T411164 - needs to wait until those schema changes are finished there
  • s5
    • codfw
    • eqiad
  • s6
    • codfw
    • eqiad
  • s7
    • codfw
    • eqiad
  • s8
    • codfw
    • eqiad
  • Puppet patch

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
filtered_tables.txt: Add il_target_idoperations/puppetproduction+1 -0
Customize query in gerrit
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
add_il_target_id_T413525.py: New schema changerepos/sre/schema-changes!55marosteguiT413525main
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.Mon, Jan 12, 2:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:14:30Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T413525)', diff saved to https://phabricator.wikimedia.org/P87357 and previous config saved to /var/cache/conftool/dbconfig/20260112-141429-marostegui.json

Stashbot added a comment.Mon, Jan 12, 2:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:14:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2170 (T413525)', diff saved to https://phabricator.wikimedia.org/P87358 and previous config saved to /var/cache/conftool/dbconfig/20260112-141443-marostegui.json

Stashbot added a comment.Mon, Jan 12, 2:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:14:55Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1195 (T413525)', diff saved to https://phabricator.wikimedia.org/P87359 and previous config saved to /var/cache/conftool/dbconfig/20260112-141454-marostegui.json

Stashbot added a comment.Mon, Jan 12, 2:45 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:45:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1195 (T413525)', diff saved to https://phabricator.wikimedia.org/P87363 and previous config saved to /var/cache/conftool/dbconfig/20260112-144518-marostegui.json

Stashbot added a comment.Mon, Jan 12, 2:46 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:46:02Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1196 (T413525)', diff saved to https://phabricator.wikimedia.org/P87364 and previous config saved to /var/cache/conftool/dbconfig/20260112-144602-marostegui.json

Stashbot added a comment.Mon, Jan 12, 2:48 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T14:48:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T413525)', diff saved to https://phabricator.wikimedia.org/P87365 and previous config saved to /var/cache/conftool/dbconfig/20260112-144843-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:19 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:19:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T413525)', diff saved to https://phabricator.wikimedia.org/P87368 and previous config saved to /var/cache/conftool/dbconfig/20260112-151908-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:19 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:19:34Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2173 (T413525)', diff saved to https://phabricator.wikimedia.org/P87369 and previous config saved to /var/cache/conftool/dbconfig/20260112-151934-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:20 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:20:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T413525)', diff saved to https://phabricator.wikimedia.org/P87370 and previous config saved to /var/cache/conftool/dbconfig/20260112-152025-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:50:50Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T413525)', diff saved to https://phabricator.wikimedia.org/P87374 and previous config saved to /var/cache/conftool/dbconfig/20260112-155049-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:51 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:51:14Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1206 (T413525)', diff saved to https://phabricator.wikimedia.org/P87375 and previous config saved to /var/cache/conftool/dbconfig/20260112-155113-marostegui.json

Stashbot added a comment.Mon, Jan 12, 3:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T15:53:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T413525)', diff saved to https://phabricator.wikimedia.org/P87376 and previous config saved to /var/cache/conftool/dbconfig/20260112-155356-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:22 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:22:05Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T413525)', diff saved to https://phabricator.wikimedia.org/P87379 and previous config saved to /var/cache/conftool/dbconfig/20260112-162204-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:24:21Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T413525)', diff saved to https://phabricator.wikimedia.org/P87380 and previous config saved to /var/cache/conftool/dbconfig/20260112-162421-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:24:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2174 (T413525)', diff saved to https://phabricator.wikimedia.org/P87381 and previous config saved to /var/cache/conftool/dbconfig/20260112-162445-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:52 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:52:30Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T413525)', diff saved to https://phabricator.wikimedia.org/P87384 and previous config saved to /var/cache/conftool/dbconfig/20260112-165229-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:52 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:52:54Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1218 (T413525)', diff saved to https://phabricator.wikimedia.org/P87385 and previous config saved to /var/cache/conftool/dbconfig/20260112-165253-marostegui.json

Stashbot added a comment.Mon, Jan 12, 4:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T16:57:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T413525)', diff saved to https://phabricator.wikimedia.org/P87386 and previous config saved to /var/cache/conftool/dbconfig/20260112-165718-marostegui.json

Stashbot added a comment.Mon, Jan 12, 5:23 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T17:23:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T413525)', diff saved to https://phabricator.wikimedia.org/P87389 and previous config saved to /var/cache/conftool/dbconfig/20260112-172259-marostegui.json

Stashbot added a comment.Mon, Jan 12, 5:27 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T17:27:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T413525)', diff saved to https://phabricator.wikimedia.org/P87390 and previous config saved to /var/cache/conftool/dbconfig/20260112-172744-marostegui.json

Stashbot added a comment.Mon, Jan 12, 5:28 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T17:28:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2176 (T413525)', diff saved to https://phabricator.wikimedia.org/P87391 and previous config saved to /var/cache/conftool/dbconfig/20260112-172808-marostegui.json

Stashbot added a comment.Mon, Jan 12, 5:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T17:53:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T413525)', diff saved to https://phabricator.wikimedia.org/P87394 and previous config saved to /var/cache/conftool/dbconfig/20260112-175324-marostegui.json

Stashbot added a comment.Mon, Jan 12, 5:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T17:53:50Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1219 (T413525)', diff saved to https://phabricator.wikimedia.org/P87395 and previous config saved to /var/cache/conftool/dbconfig/20260112-175349-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:02 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:02:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T413525)', diff saved to https://phabricator.wikimedia.org/P87396 and previous config saved to /var/cache/conftool/dbconfig/20260112-180247-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:24:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T413525)', diff saved to https://phabricator.wikimedia.org/P87399 and previous config saved to /var/cache/conftool/dbconfig/20260112-182431-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:33 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:33:12Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T413525)', diff saved to https://phabricator.wikimedia.org/P87400 and previous config saved to /var/cache/conftool/dbconfig/20260112-183311-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:33 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:33:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2188 (T413525)', diff saved to https://phabricator.wikimedia.org/P87401 and previous config saved to /var/cache/conftool/dbconfig/20260112-183336-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:54:57Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T413525)', diff saved to https://phabricator.wikimedia.org/P87404 and previous config saved to /var/cache/conftool/dbconfig/20260112-185456-marostegui.json

Stashbot added a comment.Mon, Jan 12, 6:55 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T18:55:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1232 (T413525)', diff saved to https://phabricator.wikimedia.org/P87405 and previous config saved to /var/cache/conftool/dbconfig/20260112-185521-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:01 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:01:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T413525)', diff saved to https://phabricator.wikimedia.org/P87406 and previous config saved to /var/cache/conftool/dbconfig/20260112-190144-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:24:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T413525)', diff saved to https://phabricator.wikimedia.org/P87409 and previous config saved to /var/cache/conftool/dbconfig/20260112-192401-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:32 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:32:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T413525)', diff saved to https://phabricator.wikimedia.org/P87411 and previous config saved to /var/cache/conftool/dbconfig/20260112-193209-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:54:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T413525)', diff saved to https://phabricator.wikimedia.org/P87414 and previous config saved to /var/cache/conftool/dbconfig/20260112-195425-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:54:50Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1234 (T413525)', diff saved to https://phabricator.wikimedia.org/P87415 and previous config saved to /var/cache/conftool/dbconfig/20260112-195450-marostegui.json

Stashbot added a comment.Mon, Jan 12, 7:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T19:57:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2203 (T413525)', diff saved to https://phabricator.wikimedia.org/P87416 and previous config saved to /var/cache/conftool/dbconfig/20260112-195731-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:25 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:25:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T413525)', diff saved to https://phabricator.wikimedia.org/P87417 and previous config saved to /var/cache/conftool/dbconfig/20260112-202512-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:28 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:28:24Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2203 (T413525)', diff saved to https://phabricator.wikimedia.org/P87418 and previous config saved to /var/cache/conftool/dbconfig/20260112-202823-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:55 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:55:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T413525)', diff saved to https://phabricator.wikimedia.org/P87423 and previous config saved to /var/cache/conftool/dbconfig/20260112-205537-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:56 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:56:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1235 (T413525)', diff saved to https://phabricator.wikimedia.org/P87424 and previous config saved to /var/cache/conftool/dbconfig/20260112-205602-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:58 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:58:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2203 (T413525)', diff saved to https://phabricator.wikimedia.org/P87425 and previous config saved to /var/cache/conftool/dbconfig/20260112-205848-marostegui.json

Stashbot added a comment.Mon, Jan 12, 8:59 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T20:59:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2216 (T413525)', diff saved to https://phabricator.wikimedia.org/P87426 and previous config saved to /var/cache/conftool/dbconfig/20260112-205912-marostegui.json

Stashbot added a comment.Mon, Jan 12, 9:27 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T21:27:07Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T413525)', diff saved to https://phabricator.wikimedia.org/P87427 and previous config saved to /var/cache/conftool/dbconfig/20260112-212706-marostegui.json

Stashbot added a comment.Mon, Jan 12, 9:30 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T21:30:42Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T413525)', diff saved to https://phabricator.wikimedia.org/P87428 and previous config saved to /var/cache/conftool/dbconfig/20260112-213041-marostegui.json

Stashbot added a comment.Mon, Jan 12, 9:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T21:57:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T413525)', diff saved to https://phabricator.wikimedia.org/P87433 and previous config saved to /var/cache/conftool/dbconfig/20260112-215731-marostegui.json

Stashbot added a comment.Mon, Jan 12, 10:01 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T22:01:06Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T413525)', diff saved to https://phabricator.wikimedia.org/P87434 and previous config saved to /var/cache/conftool/dbconfig/20260112-220104-marostegui.json

Stashbot added a comment.Mon, Jan 12, 10:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T22:50:16Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1251 (T413525)', diff saved to https://phabricator.wikimedia.org/P87435 and previous config saved to /var/cache/conftool/dbconfig/20260112-225015-marostegui.json

Stashbot added a comment.Mon, Jan 12, 11:21 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T23:21:45Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T413525)', diff saved to https://phabricator.wikimedia.org/P87438 and previous config saved to /var/cache/conftool/dbconfig/20260112-232144-marostegui.json

Stashbot added a comment.Mon, Jan 12, 11:52 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-12T23:52:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T413525)', diff saved to https://phabricator.wikimedia.org/P87444 and previous config saved to /var/cache/conftool/dbconfig/20260112-235209-marostegui.json

Marostegui changed the task status from Open to Stalled.Tue, Jan 13, 6:45 AM
Marostegui updated the task description. (Show Details)
Marostegui moved this task from In progress to Blocked on the DBA board.

Everything is done but s4. Right now there are two massive schema changes running in s4 (T411163 T411164 ) so I will deploy this one there, once those other two are done.

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