Page MenuHomePhabricator
Create Task
Maniphest T384592

Add normalization columns to categorylinks table
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run:
  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:Not at the moment

We also need to create the collation table in production: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1112833/4/sql/mysql/patch-collation.sql

Schema change progress

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
add_cl_collation_id_T384592.py: Fixed typorepos/sre/schema-changes!33marosteguiT384592main
add_cl_collation_id_T384592.py: New schema changerepos/sre/schema-changes!32marosteguiT384592main
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 4 2025, 12:00 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T00:00:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1241 (T384592)', diff saved to https://phabricator.wikimedia.org/P73112 and previous config saved to /var/cache/conftool/dbconfig/20250204-000010-marostegui.json

Stashbot added a comment.Feb 4 2025, 4:59 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T04:59:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T384592)', diff saved to https://phabricator.wikimedia.org/P73114 and previous config saved to /var/cache/conftool/dbconfig/20250204-045922-marostegui.json

Stashbot added a comment.Feb 4 2025, 5:44 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T05:44:44Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T384592)', diff saved to https://phabricator.wikimedia.org/P73117 and previous config saved to /var/cache/conftool/dbconfig/20250204-054443-marostegui.json

Stashbot added a comment.Feb 4 2025, 5:45 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T05:45:06Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1242 (T384592)', diff saved to https://phabricator.wikimedia.org/P73118 and previous config saved to /var/cache/conftool/dbconfig/20250204-054505-marostegui.json

Stashbot added a comment.Feb 4 2025, 10:44 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T10:44:22Z] <Amir1> foreachwiki sql.php /srv/mediawiki/php-1.44.0-wmf.14/sql/mysql/patch-collation.sql (T384592)

Stashbot added a comment.Feb 4 2025, 12:13 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T12:13:32Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T384592)', diff saved to https://phabricator.wikimedia.org/P73161 and previous config saved to /var/cache/conftool/dbconfig/20250204-121331-marostegui.json

Stashbot added a comment.Feb 4 2025, 7:52 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T19:52:12Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T384592)', diff saved to https://phabricator.wikimedia.org/P73187 and previous config saved to /var/cache/conftool/dbconfig/20250204-195211-marostegui.json

Stashbot added a comment.Feb 4 2025, 8:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T20:37:33Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T384592)', diff saved to https://phabricator.wikimedia.org/P73190 and previous config saved to /var/cache/conftool/dbconfig/20250204-203732-marostegui.json

Stashbot added a comment.Feb 4 2025, 8:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-04T20:37:55Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1244 (T384592)', diff saved to https://phabricator.wikimedia.org/P73191 and previous config saved to /var/cache/conftool/dbconfig/20250204-203754-marostegui.json

Stashbot added a comment.Feb 5 2025, 1:49 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T01:49:08Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T384592)', diff saved to https://phabricator.wikimedia.org/P73197 and previous config saved to /var/cache/conftool/dbconfig/20250205-014907-marostegui.json

Stashbot added a comment.Feb 5 2025, 2:34 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T02:34:29Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T384592)', diff saved to https://phabricator.wikimedia.org/P73200 and previous config saved to /var/cache/conftool/dbconfig/20250205-023428-marostegui.json

Stashbot added a comment.Feb 5 2025, 6:39 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T06:39:12Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1247 (T384592)', diff saved to https://phabricator.wikimedia.org/P73201 and previous config saved to /var/cache/conftool/dbconfig/20250205-063911-marostegui.json

Stashbot added a comment.Feb 5 2025, 1:14 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T13:14:57Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T384592)', diff saved to https://phabricator.wikimedia.org/P73232 and previous config saved to /var/cache/conftool/dbconfig/20250205-131456-marostegui.json

Stashbot added a comment.Feb 5 2025, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T14:00:17Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T384592)', diff saved to https://phabricator.wikimedia.org/P73240 and previous config saved to /var/cache/conftool/dbconfig/20250205-140017-marostegui.json

Stashbot added a comment.Feb 5 2025, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T14:00:39Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1248 (T384592)', diff saved to https://phabricator.wikimedia.org/P73241 and previous config saved to /var/cache/conftool/dbconfig/20250205-140039-marostegui.json

Stashbot added a comment.Feb 5 2025, 8:42 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T20:42:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T384592)', diff saved to https://phabricator.wikimedia.org/P73266 and previous config saved to /var/cache/conftool/dbconfig/20250205-204208-marostegui.json

Stashbot added a comment.Feb 5 2025, 9:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T21:27:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T384592)', diff saved to https://phabricator.wikimedia.org/P73269 and previous config saved to /var/cache/conftool/dbconfig/20250205-212729-marostegui.json

Stashbot added a comment.Feb 5 2025, 9:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-05T21:27:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1249 (T384592)', diff saved to https://phabricator.wikimedia.org/P73270 and previous config saved to /var/cache/conftool/dbconfig/20250205-212751-marostegui.json

Stashbot added a comment.Feb 6 2025, 2:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T02:36:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T384592)', diff saved to https://phabricator.wikimedia.org/P73271 and previous config saved to /var/cache/conftool/dbconfig/20250206-023626-marostegui.json

Stashbot added a comment.Feb 6 2025, 3:21 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T03:21:48Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T384592)', diff saved to https://phabricator.wikimedia.org/P73274 and previous config saved to /var/cache/conftool/dbconfig/20250206-032148-marostegui.json

Stashbot added a comment.Feb 6 2025, 8:31 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T08:31:47Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2147 (T384592)', diff saved to https://phabricator.wikimedia.org/P73281 and previous config saved to /var/cache/conftool/dbconfig/20250206-083145-marostegui.json

Stashbot added a comment.Feb 6 2025, 2:21 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T14:21:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T384592)', diff saved to https://phabricator.wikimedia.org/P73314 and previous config saved to /var/cache/conftool/dbconfig/20250206-142102-marostegui.json

Stashbot added a comment.Feb 6 2025, 3:06 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T15:06:24Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T384592)', diff saved to https://phabricator.wikimedia.org/P73318 and previous config saved to /var/cache/conftool/dbconfig/20250206-150624-marostegui.json

Stashbot added a comment.Feb 6 2025, 3:07 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T15:07:02Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2155 (T384592)', diff saved to https://phabricator.wikimedia.org/P73319 and previous config saved to /var/cache/conftool/dbconfig/20250206-150702-marostegui.json

Stashbot added a comment.Feb 6 2025, 8:41 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T20:41:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T384592)', diff saved to https://phabricator.wikimedia.org/P73347 and previous config saved to /var/cache/conftool/dbconfig/20250206-204135-marostegui.json

Stashbot added a comment.Feb 6 2025, 9:26 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T21:26:56Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T384592)', diff saved to https://phabricator.wikimedia.org/P73351 and previous config saved to /var/cache/conftool/dbconfig/20250206-212656-marostegui.json

Stashbot added a comment.Feb 6 2025, 9:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-06T21:27:19Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2172 (T384592)', diff saved to https://phabricator.wikimedia.org/P73352 and previous config saved to /var/cache/conftool/dbconfig/20250206-212719-marostegui.json

Stashbot added a comment.Feb 7 2025, 2:56 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T02:56:29Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T384592)', diff saved to https://phabricator.wikimedia.org/P73354 and previous config saved to /var/cache/conftool/dbconfig/20250207-025628-marostegui.json

Stashbot added a comment.Feb 7 2025, 3:41 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T03:41:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T384592)', diff saved to https://phabricator.wikimedia.org/P73357 and previous config saved to /var/cache/conftool/dbconfig/20250207-034149-marostegui.json

Stashbot added a comment.Feb 7 2025, 9:15 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T09:15:00Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2206 (T384592)', diff saved to https://phabricator.wikimedia.org/P73374 and previous config saved to /var/cache/conftool/dbconfig/20250207-091459-marostegui.json

Stashbot added a comment.Feb 7 2025, 3:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T15:31:04Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2206 (T384592)', diff saved to https://phabricator.wikimedia.org/P73396 and previous config saved to /var/cache/conftool/dbconfig/20250207-153103-marostegui.json

Stashbot added a comment.Feb 7 2025, 4:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T16:16:24Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2206 (T384592)', diff saved to https://phabricator.wikimedia.org/P73399 and previous config saved to /var/cache/conftool/dbconfig/20250207-161624-marostegui.json

Stashbot added a comment.Feb 7 2025, 4:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T16:16:47Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2210 (T384592)', diff saved to https://phabricator.wikimedia.org/P73400 and previous config saved to /var/cache/conftool/dbconfig/20250207-161646-marostegui.json

Stashbot added a comment.Feb 7 2025, 9:18 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T21:18:52Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T384592)', diff saved to https://phabricator.wikimedia.org/P73406 and previous config saved to /var/cache/conftool/dbconfig/20250207-211851-marostegui.json

Stashbot added a comment.Feb 7 2025, 10:04 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T22:04:11Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2210 (T384592)', diff saved to https://phabricator.wikimedia.org/P73409 and previous config saved to /var/cache/conftool/dbconfig/20250207-220411-marostegui.json

Stashbot added a comment.Feb 7 2025, 10:04 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-07T22:04:34Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2219 (T384592)', diff saved to https://phabricator.wikimedia.org/P73410 and previous config saved to /var/cache/conftool/dbconfig/20250207-220433-marostegui.json

Stashbot added a comment.Feb 8 2025, 2:54 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T02:54:54Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T384592)', diff saved to https://phabricator.wikimedia.org/P73412 and previous config saved to /var/cache/conftool/dbconfig/20250208-025453-marostegui.json

Stashbot added a comment.Feb 8 2025, 3:40 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T03:40:15Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2219 (T384592)', diff saved to https://phabricator.wikimedia.org/P73415 and previous config saved to /var/cache/conftool/dbconfig/20250208-034015-marostegui.json

Stashbot added a comment.Feb 8 2025, 3:40 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T03:40:39Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2236 (T384592)', diff saved to https://phabricator.wikimedia.org/P73416 and previous config saved to /var/cache/conftool/dbconfig/20250208-034038-marostegui.json

Stashbot added a comment.Feb 8 2025, 8:32 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T08:32:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T384592)', diff saved to https://phabricator.wikimedia.org/P73417 and previous config saved to /var/cache/conftool/dbconfig/20250208-083201-marostegui.json

Stashbot added a comment.Feb 8 2025, 9:17 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T09:17:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T384592)', diff saved to https://phabricator.wikimedia.org/P73420 and previous config saved to /var/cache/conftool/dbconfig/20250208-091721-marostegui.json

Stashbot added a comment.Feb 8 2025, 9:17 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T09:17:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2237 (T384592)', diff saved to https://phabricator.wikimedia.org/P73421 and previous config saved to /var/cache/conftool/dbconfig/20250208-091745-marostegui.json

Stashbot added a comment.Feb 8 2025, 2:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T14:46:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T384592)', diff saved to https://phabricator.wikimedia.org/P73422 and previous config saved to /var/cache/conftool/dbconfig/20250208-144623-marostegui.json

Stashbot added a comment.Feb 8 2025, 3:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T15:31:44Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T384592)', diff saved to https://phabricator.wikimedia.org/P73425 and previous config saved to /var/cache/conftool/dbconfig/20250208-153144-marostegui.json

Stashbot added a comment.Feb 8 2025, 7:36 PM

Mentioned in SAL (#wikimedia-operations) [2025-02-08T19:36:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2240 (T384592)', diff saved to https://phabricator.wikimedia.org/P73426 and previous config saved to /var/cache/conftool/dbconfig/20250208-193620-marostegui.json

Stashbot added a comment.Feb 9 2025, 12:51 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-09T00:51:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T384592)', diff saved to https://phabricator.wikimedia.org/P73427 and previous config saved to /var/cache/conftool/dbconfig/20250209-005121-marostegui.json

Stashbot added a comment.Feb 9 2025, 1:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-02-09T01:36:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T384592)', diff saved to https://phabricator.wikimedia.org/P73430 and previous config saved to /var/cache/conftool/dbconfig/20250209-013642-marostegui.json

Ottomata added subscribers: mforns, Ottomata.Feb 11 2025, 6:59 PM

@mforns to verify that this schema change is okay for Commons Impact Metrics.

Ottomata moved this task from Incoming (new tickets) to Needs Clarification on the Data-Engineering board.Feb 11 2025, 6:59 PM
Marostegui closed this task as Resolved.Feb 12 2025, 9:14 PM
Marostegui updated the task description. (Show Details)

All done

Maintenance_bot moved this task from In progress to Done on the DBA board.Feb 12 2025, 9:29 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