Page MenuHomePhabricator
Create Task
Maniphest T343198

Add pl_target_id column to pagelinks in production
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/941474/2/maintenance/archives/patch-pagelinks-target_id.sql
  2. Where to run those changes: everywhere
  3. When to run those changes: any 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: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: Possibly adding the column to be viewable to users

Progress:

  • s1: Done
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done
  • labstestwiki

Details

SubjectRepoBranchLines +/-
Update pagelinks to add pl_target_idoperations/software/schema-changesmaster+38 -0
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.Oct 16 2023, 7:36 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-16T07:36:53Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T343198)', diff saved to https://phabricator.wikimedia.org/P52967 and previous config saved to /var/cache/conftool/dbconfig/20231016-073653-arnaudb.json

Stashbot added a comment.Oct 16 2023, 7:37 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-16T07:37:31Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T343198)', diff saved to https://phabricator.wikimedia.org/P52968 and previous config saved to /var/cache/conftool/dbconfig/20231016-073731-arnaudb.json

ABran-WMF updated the task description. (Show Details)Oct 16 2023, 9:49 AM
ABran-WMF updated the task description. (Show Details)
Stashbot added a comment.Oct 16 2023, 3:32 PM

Mentioned in SAL (#wikimedia-operations) [2023-10-16T15:32:48Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T343198)', diff saved to https://phabricator.wikimedia.org/P52971 and previous config saved to /var/cache/conftool/dbconfig/20231016-153247-arnaudb.json

Stashbot added a comment.Oct 16 2023, 4:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-10-16T16:18:07Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T343198)', diff saved to https://phabricator.wikimedia.org/P52974 and previous config saved to /var/cache/conftool/dbconfig/20231016-161806-arnaudb.json

Stashbot added a comment.Oct 16 2023, 4:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-10-16T16:18:40Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T343198)', diff saved to https://phabricator.wikimedia.org/P52975 and previous config saved to /var/cache/conftool/dbconfig/20231016-161829-arnaudb.json

Stashbot added a comment.Oct 17 2023, 1:25 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-17T01:24:59Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T343198)', diff saved to https://phabricator.wikimedia.org/P52978 and previous config saved to /var/cache/conftool/dbconfig/20231017-012459-arnaudb.json

Stashbot added a comment.Oct 17 2023, 2:10 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-17T02:10:18Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T343198)', diff saved to https://phabricator.wikimedia.org/P52981 and previous config saved to /var/cache/conftool/dbconfig/20231017-021018-arnaudb.json

Stashbot added a comment.Oct 17 2023, 2:10 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-17T02:10:41Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T343198)', diff saved to https://phabricator.wikimedia.org/P52982 and previous config saved to /var/cache/conftool/dbconfig/20231017-021040-arnaudb.json

Stashbot added a comment.Oct 17 2023, 11:06 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-17T11:06:58Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T343198)', diff saved to https://phabricator.wikimedia.org/P52988 and previous config saved to /var/cache/conftool/dbconfig/20231017-110658-arnaudb.json

Stashbot added a comment.Oct 17 2023, 11:52 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-17T11:52:17Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T343198)', diff saved to https://phabricator.wikimedia.org/P52994 and previous config saved to /var/cache/conftool/dbconfig/20231017-115217-arnaudb.json

ABran-WMF updated the task description. (Show Details)Oct 17 2023, 12:01 PM
Ladsgroup updated the task description. (Show Details)Oct 18 2023, 10:50 AM
ABran-WMF updated the task description. (Show Details)Oct 18 2023, 1:27 PM
ABran-WMF updated the task description. (Show Details)Oct 26 2023, 1:35 PM
Stashbot added a comment.Oct 31 2023, 9:50 AM

Mentioned in SAL (#wikimedia-operations) [2023-10-31T09:50:54Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2179 (T343198)', diff saved to https://phabricator.wikimedia.org/P53088 and previous config saved to /var/cache/conftool/dbconfig/20231031-095054-arnaudb.json

ABran-WMF updated the task description. (Show Details)Oct 31 2023, 9:51 AM
Stashbot added a comment.Oct 31 2023, 2:35 PM

Mentioned in SAL (#wikimedia-operations) [2023-10-31T14:35:46Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T343198)', diff saved to https://phabricator.wikimedia.org/P53116 and previous config saved to /var/cache/conftool/dbconfig/20231031-143545-arnaudb.json

Stashbot added a comment.Oct 31 2023, 3:21 PM

Mentioned in SAL (#wikimedia-operations) [2023-10-31T15:21:05Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T343198)', diff saved to https://phabricator.wikimedia.org/P53119 and previous config saved to /var/cache/conftool/dbconfig/20231031-152105-arnaudb.json

Ladsgroup updated the task description. (Show Details)Nov 1 2023, 12:00 PM
ABran-WMF updated the task description. (Show Details)Nov 9 2023, 7:16 AM
Stashbot added a comment.Nov 9 2023, 2:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-11-09T14:18:56Z] <arnaudb@cumin1001> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on db2112.codfw.wmnet with reason: schema update via T343198

ops-monitoring-bot added a comment.Nov 9 2023, 2:18 PM

Icinga downtime and Alertmanager silence (ID=2d06dea4-a510-4f77-af4c-ddfa14b26885) set by arnaudb@cumin1001 for 1 day, 0:00:00 on 1 host(s) and their services with reason: schema update via T343198

db2112.codfw.wmnet
Stashbot added a comment.Nov 9 2023, 2:19 PM

Mentioned in SAL (#wikimedia-operations) [2023-11-09T14:19:00Z] <arnaudb@cumin1001> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on db2112.codfw.wmnet with reason: schema update via T343198

ABran-WMF updated the task description. (Show Details)Nov 9 2023, 3:26 PM
Ladsgroup closed this task as Resolved.Nov 9 2023, 4:36 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
Ladsgroup reopened this task as Open.Dec 7 2023, 6:02 PM

The column is everywhere but indexes are missing in at least most of s6. How that happened? Anyway, I'm running this again.

Ladsgroup added a comment.Dec 7 2023, 6:02 PM

e.g. in s6:

Result: {"needed in some dbs": ["db1165", "db1168", "db1180", "db1187", "db1201", "db1213:3316", "db1224", "db1225:3316", "db1231", "dbstore1005:3316"], "already done in all dbs": ["db2097:3316", "db2117", "db2124", "db2129", "db2151", "db2158", "db2169:3316", "db2171:3316", "db2180", "db2193"]}
Stashbot added a comment.Dec 7 2023, 6:04 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T18:04:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1165 (T343198)', diff saved to https://phabricator.wikimedia.org/P54277 and previous config saved to /var/cache/conftool/dbconfig/20231207-180427-ladsgroup.json

Ladsgroup mentioned this in T352879: Update the sqoop configuration for mediawiki to obtain linktarget from the production replicas, instead of wikireplicas.Dec 7 2023, 6:06 PM
Ladsgroup added a comment.EditedDec 7 2023, 6:10 PM

s4 and s5 are fine. Checking the rest.

s2 is fine.

Ladsgroup added a comment.Dec 7 2023, 6:13 PM

All other sections are fine.

Ladsgroup added a comment.Dec 7 2023, 6:20 PM

Missing on master of s6 in eqiad too but everything else seems to be fine.

Stashbot added a comment.Dec 7 2023, 6:44 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T18:44:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T343198)', diff saved to https://phabricator.wikimedia.org/P54278 and previous config saved to /var/cache/conftool/dbconfig/20231207-184406-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 7:29 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T19:29:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T343198)', diff saved to https://phabricator.wikimedia.org/P54281 and previous config saved to /var/cache/conftool/dbconfig/20231207-192926-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 7:29 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T19:29:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1168 (T343198)', diff saved to https://phabricator.wikimedia.org/P54282 and previous config saved to /var/cache/conftool/dbconfig/20231207-192949-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 8:12 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T20:12:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T343198)', diff saved to https://phabricator.wikimedia.org/P54283 and previous config saved to /var/cache/conftool/dbconfig/20231207-201234-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 8:57 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T20:57:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T343198)', diff saved to https://phabricator.wikimedia.org/P54287 and previous config saved to /var/cache/conftool/dbconfig/20231207-205753-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 8:58 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T20:58:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1180 (T343198)', diff saved to https://phabricator.wikimedia.org/P54288 and previous config saved to /var/cache/conftool/dbconfig/20231207-205817-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 9:41 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T21:41:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T343198)', diff saved to https://phabricator.wikimedia.org/P54289 and previous config saved to /var/cache/conftool/dbconfig/20231207-214114-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 10:26 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T22:26:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T343198)', diff saved to https://phabricator.wikimedia.org/P54292 and previous config saved to /var/cache/conftool/dbconfig/20231207-222633-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 10:26 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T22:26:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1187 (T343198)', diff saved to https://phabricator.wikimedia.org/P54293 and previous config saved to /var/cache/conftool/dbconfig/20231207-222656-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 11:07 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T23:07:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T343198)', diff saved to https://phabricator.wikimedia.org/P54294 and previous config saved to /var/cache/conftool/dbconfig/20231207-230749-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 11:53 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T23:53:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T343198)', diff saved to https://phabricator.wikimedia.org/P54297 and previous config saved to /var/cache/conftool/dbconfig/20231207-235310-ladsgroup.json

Stashbot added a comment.Dec 7 2023, 11:53 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T23:53:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1201 (T343198)', diff saved to https://phabricator.wikimedia.org/P54298 and previous config saved to /var/cache/conftool/dbconfig/20231207-235333-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 12:35 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T00:35:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T343198)', diff saved to https://phabricator.wikimedia.org/P54299 and previous config saved to /var/cache/conftool/dbconfig/20231208-003532-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 1:20 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T01:20:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T343198)', diff saved to https://phabricator.wikimedia.org/P54302 and previous config saved to /var/cache/conftool/dbconfig/20231208-012051-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 1:21 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T01:21:15Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1213:3316 (T343198)', diff saved to https://phabricator.wikimedia.org/P54303 and previous config saved to /var/cache/conftool/dbconfig/20231208-012115-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 2:14 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T02:14:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3316 (T343198)', diff saved to https://phabricator.wikimedia.org/P54304 and previous config saved to /var/cache/conftool/dbconfig/20231208-021422-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 2:59 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T02:59:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3316 (T343198)', diff saved to https://phabricator.wikimedia.org/P54307 and previous config saved to /var/cache/conftool/dbconfig/20231208-025942-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 3:00 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T03:00:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1224 (T343198)', diff saved to https://phabricator.wikimedia.org/P54308 and previous config saved to /var/cache/conftool/dbconfig/20231208-030005-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 3:33 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T03:33:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T343198)', diff saved to https://phabricator.wikimedia.org/P54309 and previous config saved to /var/cache/conftool/dbconfig/20231208-033306-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 4:18 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T04:18:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T343198)', diff saved to https://phabricator.wikimedia.org/P54312 and previous config saved to /var/cache/conftool/dbconfig/20231208-041826-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T05:06:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1231 (T343198)', diff saved to https://phabricator.wikimedia.org/P54313 and previous config saved to /var/cache/conftool/dbconfig/20231208-050624-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 5:41 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T05:41:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1231 (T343198)', diff saved to https://phabricator.wikimedia.org/P54314 and previous config saved to /var/cache/conftool/dbconfig/20231208-054116-ladsgroup.json

Stashbot added a comment.Dec 8 2023, 6:26 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T06:26:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1231 (T343198)', diff saved to https://phabricator.wikimedia.org/P54317 and previous config saved to /var/cache/conftool/dbconfig/20231208-062636-ladsgroup.json

Ladsgroup closed this task as Resolved.Dec 11 2023, 11:58 AM

We heavily checked everywhere and fixed any remaining ones.

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