Page MenuHomePhabricator
Create Task
Maniphest T415786

Update imagelinks primary key on wmf production
Open, MediumPublic
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 pending old DC master
    • eqiad
  • s3
    • codfw
    • eqiad
  • s4
    • codfw WIP
    • eqiad WIP
  • 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 Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Wed, Feb 4, 10:40 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T10:40:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T415786)', diff saved to https://phabricator.wikimedia.org/P88639 and previous config saved to /var/cache/conftool/dbconfig/20260204-104035-marostegui.json

Stashbot added a comment.Wed, Feb 4, 11:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T11:08:30Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T415786)', diff saved to https://phabricator.wikimedia.org/P88640 and previous config saved to /var/cache/conftool/dbconfig/20260204-110829-marostegui.json

Stashbot added a comment.Wed, Feb 4, 11:38 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T11:38:55Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1251 (T415786)', diff saved to https://phabricator.wikimedia.org/P88643 and previous config saved to /var/cache/conftool/dbconfig/20260204-113854-marostegui.json

Stashbot added a comment.Wed, Feb 4, 11:47 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T11:47:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2150 (T415786)', diff saved to https://phabricator.wikimedia.org/P88644 and previous config saved to /var/cache/conftool/dbconfig/20260204-114718-marostegui.json

Stashbot added a comment.Wed, Feb 4, 12:32 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T12:32:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2150 (T415786)', diff saved to https://phabricator.wikimedia.org/P88647 and previous config saved to /var/cache/conftool/dbconfig/20260204-123243-marostegui.json

Stashbot added a comment.Wed, Feb 4, 12:33 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T12:33:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2159 (T415786)', diff saved to https://phabricator.wikimedia.org/P88648 and previous config saved to /var/cache/conftool/dbconfig/20260204-123308-marostegui.json

Stashbot added a comment.Wed, Feb 4, 2:16 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T14:16:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2159 (T415786)', diff saved to https://phabricator.wikimedia.org/P88650 and previous config saved to /var/cache/conftool/dbconfig/20260204-141559-marostegui.json

Marostegui updated the task description. (Show Details)Wed, Feb 4, 2:17 PM
Marostegui updated the task description. (Show Details)
GGoncalves-WMF mentioned this in T416481: Adapt Sqoop for imagelinks schema changes.Wed, Feb 4, 2:32 PM
Marostegui added a subtask: T416480: Switchover s1 master (db1184 -> db1163).Wed, Feb 4, 2:44 PM
gerritbot added a comment.Wed, Feb 4, 2:47 PM

Change #1236760 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db1236: Disable notifications

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

gerritbot added a project: Patch-For-Review.Wed, Feb 4, 2:47 PM

Change #1236760 merged by Marostegui:

[operations/puppet@production] db1236: Disable notifications

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

Marostegui closed subtask T416356: Switchover s7 master (db1236 -> db1181) as Resolved.Wed, Feb 4, 2:50 PM
Marostegui updated the task description. (Show Details)Wed, Feb 4, 2:53 PM
Stashbot added a comment.Wed, Feb 4, 3:01 PM

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

Stashbot added a comment.Wed, Feb 4, 3:01 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T15:01:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2168 (T415786)', diff saved to https://phabricator.wikimedia.org/P88657 and previous config saved to /var/cache/conftool/dbconfig/20260204-150138-marostegui.json

Maintenance_bot removed a project: Patch-For-Review.Wed, Feb 4, 3:31 PM
Marostegui updated the task description. (Show Details)Wed, Feb 4, 3:48 PM
ops-monitoring-bot added a comment.Wed, Feb 4, 3:48 PM

Start pool of db1236 gradually with 4 steps - After schema change - marostegui@cumin1003

ops-monitoring-bot added a comment.Wed, Feb 4, 4:34 PM

Completed pool of db1236 gradually with 4 steps - After schema change - marostegui@cumin1003

Stashbot added a comment.Wed, Feb 4, 4:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T16:50:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2168 (T415786)', diff saved to https://phabricator.wikimedia.org/P88664 and previous config saved to /var/cache/conftool/dbconfig/20260204-165022-marostegui.json

Stashbot added a comment.Wed, Feb 4, 5:35 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T17:35:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2168 (T415786)', diff saved to https://phabricator.wikimedia.org/P88667 and previous config saved to /var/cache/conftool/dbconfig/20260204-173547-marostegui.json

Stashbot added a comment.Wed, Feb 4, 5:36 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T17:36:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2182 (T415786)', diff saved to https://phabricator.wikimedia.org/P88668 and previous config saved to /var/cache/conftool/dbconfig/20260204-173612-marostegui.json

Stashbot added a comment.Wed, Feb 4, 7:19 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T19:19:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2182 (T415786)', diff saved to https://phabricator.wikimedia.org/P88670 and previous config saved to /var/cache/conftool/dbconfig/20260204-191947-marostegui.json

Stashbot added a comment.Wed, Feb 4, 8:05 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T20:05:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2182 (T415786)', diff saved to https://phabricator.wikimedia.org/P88673 and previous config saved to /var/cache/conftool/dbconfig/20260204-200512-marostegui.json

Stashbot added a comment.Wed, Feb 4, 11:16 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-04T23:16:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2208 (T415786)', diff saved to https://phabricator.wikimedia.org/P88674 and previous config saved to /var/cache/conftool/dbconfig/20260204-231600-marostegui.json

Stashbot added a comment.Thu, Feb 5, 12:43 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T00:43:54Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2208 (T415786)', diff saved to https://phabricator.wikimedia.org/P88676 and previous config saved to /var/cache/conftool/dbconfig/20260205-004353-marostegui.json

Stashbot added a comment.Thu, Feb 5, 1:29 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T01:29:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2208 (T415786)', diff saved to https://phabricator.wikimedia.org/P88679 and previous config saved to /var/cache/conftool/dbconfig/20260205-012918-marostegui.json

Stashbot added a comment.Thu, Feb 5, 1:29 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T01:29:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2220 (T415786)', diff saved to https://phabricator.wikimedia.org/P88680 and previous config saved to /var/cache/conftool/dbconfig/20260205-012942-marostegui.json

Stashbot added a comment.Thu, Feb 5, 2:58 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T02:58:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2220 (T415786)', diff saved to https://phabricator.wikimedia.org/P88681 and previous config saved to /var/cache/conftool/dbconfig/20260205-025845-marostegui.json

Stashbot added a comment.Thu, Feb 5, 3:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T03:44:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2220 (T415786)', diff saved to https://phabricator.wikimedia.org/P88684 and previous config saved to /var/cache/conftool/dbconfig/20260205-034410-marostegui.json

Stashbot added a comment.Thu, Feb 5, 3:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T03:44:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2221 (T415786)', diff saved to https://phabricator.wikimedia.org/P88685 and previous config saved to /var/cache/conftool/dbconfig/20260205-034435-marostegui.json

Stashbot added a comment.Thu, Feb 5, 5:14 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T05:14:41Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2221 (T415786)', diff saved to https://phabricator.wikimedia.org/P88686 and previous config saved to /var/cache/conftool/dbconfig/20260205-051441-marostegui.json

Stashbot added a comment.Thu, Feb 5, 6:00 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T06:00:06Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2221 (T415786)', diff saved to https://phabricator.wikimedia.org/P88689 and previous config saved to /var/cache/conftool/dbconfig/20260205-060006-marostegui.json

Stashbot added a comment.Thu, Feb 5, 6:00 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T06:00:31Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2222 (T415786)', diff saved to https://phabricator.wikimedia.org/P88690 and previous config saved to /var/cache/conftool/dbconfig/20260205-060031-marostegui.json

Marostegui closed subtask T416299: Switchover s3 master (db2205 -> db2209) as Resolved.Thu, Feb 5, 6:31 AM
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Thu, Feb 5, 7:30 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T07:30:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2222 (T415786)', diff saved to https://phabricator.wikimedia.org/P88695 and previous config saved to /var/cache/conftool/dbconfig/20260205-073011-marostegui.json

Stashbot added a comment.Thu, Feb 5, 8:15 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-05T08:15:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2222 (T415786)', diff saved to https://phabricator.wikimedia.org/P88698 and previous config saved to /var/cache/conftool/dbconfig/20260205-081536-marostegui.json

Marostegui updated the task description. (Show Details)Thu, Feb 5, 8:19 AM
ops-monitoring-bot added a comment.Thu, Feb 5, 8:56 AM

Start pool of db2205 gradually with 4 steps - After schema change - marostegui@cumin1003

Marostegui updated the task description. (Show Details)Thu, Feb 5, 8:56 AM
Marostegui added a subtask: T416554: Switchover s1 master (db2203 -> db2212).Thu, Feb 5, 8:59 AM
Marostegui added a subtask: T416555: Switchover s7 master (db2218 -> db2220).
Marostegui closed subtask T416480: Switchover s1 master (db1184 -> db1163) as Resolved.Thu, Feb 5, 9:08 AM
Marostegui updated the task description. (Show Details)
ops-monitoring-bot added a comment.Thu, Feb 5, 9:41 AM

Completed pool of db2205 gradually with 4 steps - After schema change - marostegui@cumin1003

Marostegui updated the task description. (Show Details)Thu, Feb 5, 10:56 AM
ops-monitoring-bot added a comment.Thu, Feb 5, 12:56 PM

Start pool of db2204 gradually with 4 steps - After schema change - marostegui@cumin1003

ops-monitoring-bot added a comment.Thu, Feb 5, 1:41 PM

Completed pool of db2204 gradually with 4 steps - After schema change - marostegui@cumin1003

Marostegui closed subtask T416554: Switchover s1 master (db2203 -> db2212) as Resolved.Mon, Feb 9, 6:20 AM
Marostegui updated the task description. (Show Details)Mon, Feb 9, 6:23 AM
Marostegui updated the task description. (Show Details)Mon, Feb 9, 7:54 AM
Marostegui closed subtask T416555: Switchover s7 master (db2218 -> db2220) as Resolved.Tue, Feb 10, 6:41 AM
Marostegui updated the task description. (Show Details)Tue, Feb 10, 6:59 AM
Marostegui changed the task status from Open to Stalled.Tue, Feb 10, 8:23 AM
Marostegui updated the task description. (Show Details)
Marostegui moved this task from In progress to Blocked on the DBA board.

This is all done - stalling until @Zabe let us know we can proceed with s4.

Marostegui mentioned this in T417301: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_name' in 'WHERE' Function: MediaWiki\FileRepo\File\LocalFile::loadExtraFromDB Query: SELECT * FROM (SELECT fr_metadata AS `img_metadata` FROM `file` JOIN `filere.Thu, Feb 12, 7:10 PM
Zabe changed the task status from Stalled to Open.Sun, Feb 15, 11:05 PM
Zabe updated the task description. (Show Details)
In T415786#11600346, @Marostegui wrote:

This is all done - stalling until @Zabe let us know we can proceed with s4.

s4 is ready now.

Tacsipacsi subscribed.Mon, Feb 16, 5:07 AM
In T415786#11618609, @Zabe wrote:

s4 is ready now.

Does this mean that T413668: Run the data migration of imagelinks finished on s4? If yes, could you update that task?

Marostegui added a comment.Mon, Feb 16, 6:12 AM
In T415786#11618609, @Zabe wrote:
In T415786#11600346, @Marostegui wrote:

This is all done - stalling until @Zabe let us know we can proceed with s4.

s4 is ready now.

Thanks! Starting it!

Stashbot added a comment.Mon, Feb 16, 6:19 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-16T06:19:41Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2147 (T415786)', diff saved to https://phabricator.wikimedia.org/P88824 and previous config saved to /var/cache/conftool/dbconfig/20260216-061940-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Feb 16, 6:21 AM
Marostegui moved this task from Blocked to In progress on the DBA board.
Stashbot added a comment.Mon, Feb 16, 7:40 PM

Mentioned in SAL (#wikimedia-operations) [2026-02-16T19:40:27Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1160 (T415786)', diff saved to https://phabricator.wikimedia.org/P88829 and previous config saved to /var/cache/conftool/dbconfig/20260216-194026-marostegui.json

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