Page MenuHomePhabricator
Create Task
Maniphest T415786

Update imagelinks primary key on wmf production
Closed, ResolvedPublic
Actions

Description

  1. ALTER to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1222603/7/sql/mysql/patch-imagelinks-pk.sql
  2. Where to run those changes: all.dblist
  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: Change is running in beta cluster
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed

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

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
db1236: Disable notificationsoperations/puppetproduction+2 -1
db2204: Disable notificationsoperations/puppetproduction+2 -1
Customize query in gerrit
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
change_pk_imagelinks_T415786.py: New schema changerepos/sre/schema-changes!60marosteguiT415786main
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.Feb 21 2026, 1:32 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-21T13:32:20Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T415786)', diff saved to https://phabricator.wikimedia.org/P88950 and previous config saved to /var/cache/conftool/dbconfig/20260221-133219-marostegui.json

Stashbot added a comment.Feb 21 2026, 2:17 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-21T14:17:45Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T415786)', diff saved to https://phabricator.wikimedia.org/P88953 and previous config saved to /var/cache/conftool/dbconfig/20260221-141744-marostegui.json

Stashbot added a comment.Feb 21 2026, 2:18 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-21T14:18:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2237 (T415786)', diff saved to https://phabricator.wikimedia.org/P88954 and previous config saved to /var/cache/conftool/dbconfig/20260221-141809-marostegui.json

Stashbot added a comment.Feb 21 2026, 4:36 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-21T16:36:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T415786)', diff saved to https://phabricator.wikimedia.org/P88955 and previous config saved to /var/cache/conftool/dbconfig/20260221-163612-marostegui.json

Stashbot added a comment.Feb 21 2026, 5:21 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-21T17:21:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T415786)', diff saved to https://phabricator.wikimedia.org/P88958 and previous config saved to /var/cache/conftool/dbconfig/20260221-172135-marostegui.json

Stashbot added a comment.Feb 22 2026, 2:38 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T02:38:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T415786)', diff saved to https://phabricator.wikimedia.org/P88959 and previous config saved to /var/cache/conftool/dbconfig/20260222-023847-marostegui.json

Stashbot added a comment.Feb 22 2026, 3:24 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T03:24:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T415786)', diff saved to https://phabricator.wikimedia.org/P88962 and previous config saved to /var/cache/conftool/dbconfig/20260222-032412-marostegui.json

Stashbot added a comment.Feb 22 2026, 4:49 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T04:49:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1247 (T415786)', diff saved to https://phabricator.wikimedia.org/P88963 and previous config saved to /var/cache/conftool/dbconfig/20260222-044859-marostegui.json

Stashbot added a comment.Feb 22 2026, 2:41 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T14:41:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2245 (T415786)', diff saved to https://phabricator.wikimedia.org/P88964 and previous config saved to /var/cache/conftool/dbconfig/20260222-144110-marostegui.json

Stashbot added a comment.Feb 22 2026, 5:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T17:50:17Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T415786)', diff saved to https://phabricator.wikimedia.org/P88965 and previous config saved to /var/cache/conftool/dbconfig/20260222-175016-marostegui.json

Stashbot added a comment.Feb 22 2026, 6:35 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T18:35:41Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T415786)', diff saved to https://phabricator.wikimedia.org/P88968 and previous config saved to /var/cache/conftool/dbconfig/20260222-183541-marostegui.json

Stashbot added a comment.Feb 22 2026, 6:36 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-22T18:36:06Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1248 (T415786)', diff saved to https://phabricator.wikimedia.org/P88969 and previous config saved to /var/cache/conftool/dbconfig/20260222-183605-marostegui.json

Stashbot added a comment.Feb 23 2026, 3:56 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T03:56:20Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2245 (T415786)', diff saved to https://phabricator.wikimedia.org/P88970 and previous config saved to /var/cache/conftool/dbconfig/20260223-035619-marostegui.json

Stashbot added a comment.Feb 23 2026, 4:41 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T04:41:45Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2245 (T415786)', diff saved to https://phabricator.wikimedia.org/P88973 and previous config saved to /var/cache/conftool/dbconfig/20260223-044144-marostegui.json

Stashbot added a comment.Feb 23 2026, 4:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T04:42:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2246 (T415786)', diff saved to https://phabricator.wikimedia.org/P88974 and previous config saved to /var/cache/conftool/dbconfig/20260223-044209-marostegui.json

Marostegui added subtasks: T418080: Switchover s4 master (db2240 -> db2179), T418079: Switchover s4 master (db1244 -> db1160).Feb 23 2026, 6:25 AM
Stashbot added a comment.Feb 23 2026, 7:21 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T07:21:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T415786)', diff saved to https://phabricator.wikimedia.org/P88975 and previous config saved to /var/cache/conftool/dbconfig/20260223-072119-marostegui.json

Stashbot added a comment.Feb 23 2026, 8:06 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T08:06:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T415786)', diff saved to https://phabricator.wikimedia.org/P88978 and previous config saved to /var/cache/conftool/dbconfig/20260223-080644-marostegui.json

Stashbot added a comment.Feb 23 2026, 8:06 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T08:06:58Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1249 (T415786)', diff saved to https://phabricator.wikimedia.org/P88979 and previous config saved to /var/cache/conftool/dbconfig/20260223-080657-marostegui.json

Stashbot added a comment.Feb 23 2026, 5:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T17:24:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2246 (T415786)', diff saved to https://phabricator.wikimedia.org/P88983 and previous config saved to /var/cache/conftool/dbconfig/20260223-172421-marostegui.json

Stashbot added a comment.Feb 23 2026, 6:09 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T18:09:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2246 (T415786)', diff saved to https://phabricator.wikimedia.org/P88987 and previous config saved to /var/cache/conftool/dbconfig/20260223-180947-marostegui.json

Stashbot added a comment.Feb 23 2026, 6:10 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T18:10:12Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2247 (T415786)', diff saved to https://phabricator.wikimedia.org/P88988 and previous config saved to /var/cache/conftool/dbconfig/20260223-181011-marostegui.json

Stashbot added a comment.Feb 23 2026, 8:59 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T20:59:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T415786)', diff saved to https://phabricator.wikimedia.org/P88990 and previous config saved to /var/cache/conftool/dbconfig/20260223-205921-marostegui.json

Stashbot added a comment.Feb 23 2026, 9:44 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T21:44:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T415786)', diff saved to https://phabricator.wikimedia.org/P88993 and previous config saved to /var/cache/conftool/dbconfig/20260223-214447-marostegui.json

Stashbot added a comment.Feb 23 2026, 9:45 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-23T21:45:12Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1252 (T415786)', diff saved to https://phabricator.wikimedia.org/P88994 and previous config saved to /var/cache/conftool/dbconfig/20260223-214512-marostegui.json

Stashbot added a comment.Feb 24 2026, 6:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T06:08:02Z] <marostegui> Deploy schema change on dbstore1007:3314 T415786

Marostegui updated the task description. (Show Details)Feb 24 2026, 6:25 AM
Stashbot added a comment.Feb 24 2026, 7:02 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T07:02:42Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2247 (T415786)', diff saved to https://phabricator.wikimedia.org/P88998 and previous config saved to /var/cache/conftool/dbconfig/20260224-070241-marostegui.json

Stashbot added a comment.Feb 24 2026, 7:48 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T07:48:07Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2247 (T415786)', diff saved to https://phabricator.wikimedia.org/P89001 and previous config saved to /var/cache/conftool/dbconfig/20260224-074806-marostegui.json

Stashbot added a comment.Feb 24 2026, 7:48 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T07:48:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2248 (T415786)', diff saved to https://phabricator.wikimedia.org/P89002 and previous config saved to /var/cache/conftool/dbconfig/20260224-074831-marostegui.json

Stashbot added a comment.Feb 24 2026, 10:56 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T10:56:52Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T415786)', diff saved to https://phabricator.wikimedia.org/P89003 and previous config saved to /var/cache/conftool/dbconfig/20260224-105651-marostegui.json

Stashbot added a comment.Feb 24 2026, 11:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T11:42:17Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T415786)', diff saved to https://phabricator.wikimedia.org/P89007 and previous config saved to /var/cache/conftool/dbconfig/20260224-114217-marostegui.json

Stashbot added a comment.Feb 24 2026, 11:42 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T11:42:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1260 (T415786)', diff saved to https://phabricator.wikimedia.org/P89008 and previous config saved to /var/cache/conftool/dbconfig/20260224-114242-marostegui.json

Stashbot added a comment.Feb 24 2026, 4:55 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T16:55:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2248 (T415786)', diff saved to https://phabricator.wikimedia.org/P89010 and previous config saved to /var/cache/conftool/dbconfig/20260224-165542-marostegui.json

Stashbot added a comment.Feb 24 2026, 5:41 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-24T17:41:08Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2248 (T415786)', diff saved to https://phabricator.wikimedia.org/P89013 and previous config saved to /var/cache/conftool/dbconfig/20260224-174107-marostegui.json

Stashbot added a comment.Feb 25 2026, 1:39 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-25T01:39:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T415786)', diff saved to https://phabricator.wikimedia.org/P89018 and previous config saved to /var/cache/conftool/dbconfig/20260225-013921-marostegui.json

Stashbot added a comment.Feb 25 2026, 2:24 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-25T02:24:50Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T415786)', diff saved to https://phabricator.wikimedia.org/P89021 and previous config saved to /var/cache/conftool/dbconfig/20260225-022446-marostegui.json

Stashbot added a comment.Feb 25 2026, 2:25 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-25T02:25:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1261 (T415786)', diff saved to https://phabricator.wikimedia.org/P89022 and previous config saved to /var/cache/conftool/dbconfig/20260225-022502-marostegui.json

Marostegui updated the task description. (Show Details)Feb 25 2026, 5:37 AM
Stashbot added a comment.Feb 25 2026, 3:41 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-25T15:41:17Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1261 (T415786)', diff saved to https://phabricator.wikimedia.org/P89024 and previous config saved to /var/cache/conftool/dbconfig/20260225-154116-marostegui.json

Ottomata moved this task from Incoming (new tickets) to Tag with Radar on the Data-Engineering board.Feb 25 2026, 5:06 PM
Ottomata added a project: Data-Engineering-Radar.
Stashbot added a comment.Feb 26 2026, 5:22 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-26T05:22:31Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1262 (T415786)', diff saved to https://phabricator.wikimedia.org/P89028 and previous config saved to /var/cache/conftool/dbconfig/20260226-052230-marostegui.json

Stashbot added a comment.Feb 26 2026, 6:07 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-26T06:07:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1262 (T415786)', diff saved to https://phabricator.wikimedia.org/P89031 and previous config saved to /var/cache/conftool/dbconfig/20260226-060755-marostegui.json

Stashbot added a comment.Feb 26 2026, 6:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-26T06:08:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1263 (T415786)', diff saved to https://phabricator.wikimedia.org/P89032 and previous config saved to /var/cache/conftool/dbconfig/20260226-060809-marostegui.json

Stashbot added a comment.Feb 26 2026, 7:29 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-26T19:29:28Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T415786)', diff saved to https://phabricator.wikimedia.org/P89066 and previous config saved to /var/cache/conftool/dbconfig/20260226-192927-marostegui.json

Stashbot added a comment.Feb 26 2026, 8:14 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-26T20:14:52Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T415786)', diff saved to https://phabricator.wikimedia.org/P89069 and previous config saved to /var/cache/conftool/dbconfig/20260226-201451-marostegui.json

Marostegui updated the task description. (Show Details)Feb 27 2026, 5:51 AM
Marostegui closed subtask T418079: Switchover s4 master (db1244 -> db1160) as Resolved.Feb 27 2026, 6:08 AM
Marostegui mentioned this in T418079: Switchover s4 master (db1244 -> db1160).
Marostegui updated the task description. (Show Details)Feb 27 2026, 6:17 AM
Marostegui updated the task description. (Show Details)Mar 2 2026, 6:10 AM
Marostegui closed subtask T418080: Switchover s4 master (db2240 -> db2179) as Resolved.Mar 2 2026, 6:15 AM
Marostegui updated the task description. (Show Details)Mar 2 2026, 6:20 AM
Marostegui closed this task as Resolved.Mar 3 2026, 5:51 AM
Marostegui updated the task description. (Show Details)

Finally all done!

Maintenance_bot moved this task from In progress to Done on the DBA board.Mar 3 2026, 6:29 AM
Zabe mentioned this in T425384: imagelinks table missing in pplwiki, several other tables missing in testcommonswiki.May 6 2026, 9:26 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