Page MenuHomePhabricator
Create Task
Maniphest T413525

Add il_target_id to imagelinks table in wmf production
Closed, ResolvedPublic
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
    • codfw
    • eqiad
  • s5
    • codfw
    • eqiad
  • s6
    • codfw
    • eqiad
  • s7
    • codfw
    • eqiad
  • s8
    • codfw
    • eqiad
  • Puppet patch

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
filtered_tables.txt: Add il_target_idMarosteguioperations/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.Jan 16 2026, 2:31 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T14:31:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2245 (T413525)', diff saved to https://phabricator.wikimedia.org/P87628 and previous config saved to /var/cache/conftool/dbconfig/20260116-143122-marostegui.json

Stashbot added a comment.Jan 16 2026, 2:31 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T14:31:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2246 (T413525)', diff saved to https://phabricator.wikimedia.org/P87629 and previous config saved to /var/cache/conftool/dbconfig/20260116-143147-marostegui.json

Stashbot added a comment.Jan 16 2026, 5:10 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T17:10:17Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T413525)', diff saved to https://phabricator.wikimedia.org/P87632 and previous config saved to /var/cache/conftool/dbconfig/20260116-171016-marostegui.json

Stashbot added a comment.Jan 16 2026, 5:40 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T17:40:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T413525)', diff saved to https://phabricator.wikimedia.org/P87635 and previous config saved to /var/cache/conftool/dbconfig/20260116-174042-marostegui.json

Stashbot added a comment.Jan 16 2026, 5:41 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T17:41:07Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1244 (T413525)', diff saved to https://phabricator.wikimedia.org/P87636 and previous config saved to /var/cache/conftool/dbconfig/20260116-174107-marostegui.json

Stashbot added a comment.Jan 16 2026, 6:31 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T18:31:55Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2246 (T413525)', diff saved to https://phabricator.wikimedia.org/P87637 and previous config saved to /var/cache/conftool/dbconfig/20260116-183155-marostegui.json

Stashbot added a comment.Jan 16 2026, 7:02 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T19:02:21Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2246 (T413525)', diff saved to https://phabricator.wikimedia.org/P87643 and previous config saved to /var/cache/conftool/dbconfig/20260116-190220-marostegui.json

Stashbot added a comment.Jan 16 2026, 7:02 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T19:02:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87644 and previous config saved to /var/cache/conftool/dbconfig/20260116-190235-marostegui.json

Stashbot added a comment.Jan 16 2026, 9:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T21:24:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T413525)', diff saved to https://phabricator.wikimedia.org/P87647 and previous config saved to /var/cache/conftool/dbconfig/20260116-212411-marostegui.json

Stashbot added a comment.Jan 16 2026, 9:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T21:54:37Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T413525)', diff saved to https://phabricator.wikimedia.org/P87650 and previous config saved to /var/cache/conftool/dbconfig/20260116-215436-marostegui.json

Stashbot added a comment.Jan 16 2026, 11:01 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T23:01:35Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87656 and previous config saved to /var/cache/conftool/dbconfig/20260116-230134-marostegui.json

Stashbot added a comment.Jan 16 2026, 11:32 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-16T23:32:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87659 and previous config saved to /var/cache/conftool/dbconfig/20260116-233200-marostegui.json

Stashbot added a comment.Jan 17 2026, 1:23 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T01:23:04Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87660 and previous config saved to /var/cache/conftool/dbconfig/20260117-012303-marostegui.json

Stashbot added a comment.Jan 17 2026, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T05:06:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87661 and previous config saved to /var/cache/conftool/dbconfig/20260117-050635-marostegui.json

Stashbot added a comment.Jan 17 2026, 5:37 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T05:37:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T413525)', diff saved to https://phabricator.wikimedia.org/P87664 and previous config saved to /var/cache/conftool/dbconfig/20260117-053700-marostegui.json

Stashbot added a comment.Jan 17 2026, 5:37 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T05:37:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1248 (T413525)', diff saved to https://phabricator.wikimedia.org/P87665 and previous config saved to /var/cache/conftool/dbconfig/20260117-053725-marostegui.json

Stashbot added a comment.Jan 17 2026, 9:15 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T09:15:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T413525)', diff saved to https://phabricator.wikimedia.org/P87671 and previous config saved to /var/cache/conftool/dbconfig/20260117-091547-marostegui.json

Stashbot added a comment.Jan 17 2026, 9:46 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T09:46:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T413525)', diff saved to https://phabricator.wikimedia.org/P87674 and previous config saved to /var/cache/conftool/dbconfig/20260117-094612-marostegui.json

Stashbot added a comment.Jan 17 2026, 9:46 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T09:46:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1249 (T413525)', diff saved to https://phabricator.wikimedia.org/P87675 and previous config saved to /var/cache/conftool/dbconfig/20260117-094637-marostegui.json

Stashbot added a comment.Jan 17 2026, 1:39 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T13:39:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T413525)', diff saved to https://phabricator.wikimedia.org/P87681 and previous config saved to /var/cache/conftool/dbconfig/20260117-133901-marostegui.json

Stashbot added a comment.Jan 17 2026, 2:09 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T14:09:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T413525)', diff saved to https://phabricator.wikimedia.org/P87684 and previous config saved to /var/cache/conftool/dbconfig/20260117-140926-marostegui.json

Stashbot added a comment.Jan 17 2026, 2:09 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T14:09:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1252 (T413525)', diff saved to https://phabricator.wikimedia.org/P87685 and previous config saved to /var/cache/conftool/dbconfig/20260117-140950-marostegui.json

Stashbot added a comment.Jan 17 2026, 6:11 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T18:11:14Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T413525)', diff saved to https://phabricator.wikimedia.org/P87686 and previous config saved to /var/cache/conftool/dbconfig/20260117-181113-marostegui.json

Stashbot added a comment.Jan 17 2026, 6:41 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T18:41:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T413525)', diff saved to https://phabricator.wikimedia.org/P87689 and previous config saved to /var/cache/conftool/dbconfig/20260117-184138-marostegui.json

Stashbot added a comment.Jan 17 2026, 6:42 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T18:42:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1260 (T413525)', diff saved to https://phabricator.wikimedia.org/P87690 and previous config saved to /var/cache/conftool/dbconfig/20260117-184203-marostegui.json

Stashbot added a comment.Jan 17 2026, 10:43 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T22:43:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T413525)', diff saved to https://phabricator.wikimedia.org/P87693 and previous config saved to /var/cache/conftool/dbconfig/20260117-224351-marostegui.json

Stashbot added a comment.Jan 17 2026, 11:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T23:14:16Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T413525)', diff saved to https://phabricator.wikimedia.org/P87699 and previous config saved to /var/cache/conftool/dbconfig/20260117-231416-marostegui.json

Stashbot added a comment.Jan 17 2026, 11:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-17T23:14:42Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1261 (T413525)', diff saved to https://phabricator.wikimedia.org/P87700 and previous config saved to /var/cache/conftool/dbconfig/20260117-231441-marostegui.json

Stashbot added a comment.Jan 18 2026, 3:11 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-18T03:11:50Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1261 (T413525)', diff saved to https://phabricator.wikimedia.org/P87706 and previous config saved to /var/cache/conftool/dbconfig/20260118-031149-marostegui.json

Stashbot added a comment.Jan 18 2026, 3:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-18T03:42:14Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1261 (T413525)', diff saved to https://phabricator.wikimedia.org/P87709 and previous config saved to /var/cache/conftool/dbconfig/20260118-034214-marostegui.json

Stashbot added a comment.Jan 18 2026, 3:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-18T03:42:29Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1263 (T413525)', diff saved to https://phabricator.wikimedia.org/P87710 and previous config saved to /var/cache/conftool/dbconfig/20260118-034228-marostegui.json

Stashbot added a comment.Jan 18 2026, 7:34 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-18T07:34:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T413525)', diff saved to https://phabricator.wikimedia.org/P87711 and previous config saved to /var/cache/conftool/dbconfig/20260118-073445-marostegui.json

Stashbot added a comment.Jan 18 2026, 8:05 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-18T08:05:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T413525)', diff saved to https://phabricator.wikimedia.org/P87714 and previous config saved to /var/cache/conftool/dbconfig/20260118-080510-marostegui.json

Marostegui updated the task description. (Show Details)Jan 19 2026, 6:26 AM
Stashbot added a comment.Jan 19 2026, 6:28 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T06:28:14Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1262 (T413525)', diff saved to https://phabricator.wikimedia.org/P87732 and previous config saved to /var/cache/conftool/dbconfig/20260119-062813-marostegui.json

Stashbot added a comment.Jan 19 2026, 6:29 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T06:29:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2248 (T413525)', diff saved to https://phabricator.wikimedia.org/P87733 and previous config saved to /var/cache/conftool/dbconfig/20260119-062926-marostegui.json

Marostegui added a comment.Jan 19 2026, 6:29 AM

Some hosts were not done in codfw:
db2248, db2240

And in eqiad
db1262

I am running it now on them.

Stashbot added a comment.Jan 19 2026, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T09:40:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2248 (T413525)', diff saved to https://phabricator.wikimedia.org/P87737 and previous config saved to /var/cache/conftool/dbconfig/20260119-094048-marostegui.json

Stashbot added a comment.Jan 19 2026, 10:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T10:08:53Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1262 (T413525)', diff saved to https://phabricator.wikimedia.org/P87740 and previous config saved to /var/cache/conftool/dbconfig/20260119-100852-marostegui.json

Stashbot added a comment.Jan 19 2026, 10:11 AM

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

Stashbot added a comment.Jan 19 2026, 10:11 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T10:11:37Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2240 (T413525)', diff saved to https://phabricator.wikimedia.org/P87742 and previous config saved to /var/cache/conftool/dbconfig/20260119-101136-marostegui.json

Stashbot added a comment.Jan 19 2026, 10:39 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T10:39:18Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1262 (T413525)', diff saved to https://phabricator.wikimedia.org/P87745 and previous config saved to /var/cache/conftool/dbconfig/20260119-103917-marostegui.json

Marostegui added a comment.Jan 19 2026, 11:24 AM

db1262 done

Marostegui closed subtask T414542: Switchover s4 master (db1160 -> db1244) as Resolved.Jan 19 2026, 11:38 AM
Marostegui added a comment.Jan 19 2026, 11:46 AM

Running this schema change on the old s4 eqiad master: db1160

Stashbot added a comment.Jan 19 2026, 1:56 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-19T13:56:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T413525)', diff saved to https://phabricator.wikimedia.org/P87750 and previous config saved to /var/cache/conftool/dbconfig/20260119-135602-marostegui.json

Stashbot added a comment.Jan 19 2026, 2:26 PM

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

Marostegui updated the task description. (Show Details)Jan 20 2026, 6:17 AM
Marostegui closed subtask T414543: Switchover s4 master (db2179 -> db2240) as Resolved.Jan 20 2026, 6:27 AM

Running it on the old s4 master: db2179

Marostegui updated the task description. (Show Details)Jan 20 2026, 6:52 AM
Marostegui closed this task as Resolved.Jan 20 2026, 12:07 PM
Marostegui updated the task description. (Show Details)

This is all done

Maintenance_bot moved this task from In progress to Done on the DBA board.Jan 20 2026, 12:29 PM
Ladsgroup subscribed.Jan 20 2026, 1:09 PM

\o/ Thank you!

Zache mentioned this in T422206: fiwiki_p.imagelinks view is broken on Toolforge replica (ERROR 1356), while enwiki_p works.Apr 2 2026, 6:28 PM
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