Page MenuHomePhabricator
Create Task
Maniphest T402010

Add new rc_name_source_patrolled_timestamp index to recentchanges table in wmf production
Closed, ResolvedPublic
Actions

Description

  1. ALTER to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1178894/3/sql/mysql/patch-recentchanges-rc_name_source_patrolled_timestamp.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: Done
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done

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.Aug 19 2025, 11:59 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T11:59:27Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1173 (T402010)', diff saved to https://phabricator.wikimedia.org/P81499 and previous config saved to /var/cache/conftool/dbconfig/20250819-115926-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 12:01 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T12:01:48Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T402010)', diff saved to https://phabricator.wikimedia.org/P81500 and previous config saved to /var/cache/conftool/dbconfig/20250819-120147-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T12:47:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T402010)', diff saved to https://phabricator.wikimedia.org/P81503 and previous config saved to /var/cache/conftool/dbconfig/20250819-124709-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T12:47:31Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81504 and previous config saved to /var/cache/conftool/dbconfig/20250819-124731-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 12:49 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T12:49:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81505 and previous config saved to /var/cache/conftool/dbconfig/20250819-124952-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 1:35 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T13:35:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81508 and previous config saved to /var/cache/conftool/dbconfig/20250819-133515-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 1:35 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T13:35:37Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1187 (T402010)', diff saved to https://phabricator.wikimedia.org/P81509 and previous config saved to /var/cache/conftool/dbconfig/20250819-133537-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 1:38 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T13:38:59Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T402010)', diff saved to https://phabricator.wikimedia.org/P81510 and previous config saved to /var/cache/conftool/dbconfig/20250819-133858-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 1:51 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T13:51:12Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81511 and previous config saved to /var/cache/conftool/dbconfig/20250819-135112-fceratto.json

Stashbot added a comment.Aug 19 2025, 1:53 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T13:53:41Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81513 and previous config saved to /var/cache/conftool/dbconfig/20250819-135340-fceratto.json

Stashbot added a comment.Aug 19 2025, 2:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:24:21Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T402010)', diff saved to https://phabricator.wikimedia.org/P81518 and previous config saved to /var/cache/conftool/dbconfig/20250819-142420-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 2:25 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:25:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1231 (T402010)', diff saved to https://phabricator.wikimedia.org/P81519 and previous config saved to /var/cache/conftool/dbconfig/20250819-142514-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 2:28 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:28:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1231 (T402010)', diff saved to https://phabricator.wikimedia.org/P81521 and previous config saved to /var/cache/conftool/dbconfig/20250819-142832-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 2:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:39:03Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81522 and previous config saved to /var/cache/conftool/dbconfig/20250819-143903-fceratto.json

Stashbot added a comment.Aug 19 2025, 2:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:39:27Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81523 and previous config saved to /var/cache/conftool/dbconfig/20250819-143926-fceratto.json

Stashbot added a comment.Aug 19 2025, 2:42 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T14:41:59Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81524 and previous config saved to /var/cache/conftool/dbconfig/20250819-144158-fceratto.json

Stashbot added a comment.Aug 19 2025, 3:13 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:13:55Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1231 (T402010)', diff saved to https://phabricator.wikimedia.org/P81529 and previous config saved to /var/cache/conftool/dbconfig/20250819-151354-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 3:14 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:14:46Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81530 and previous config saved to /var/cache/conftool/dbconfig/20250819-151446-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 3:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:16:56Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81531 and previous config saved to /var/cache/conftool/dbconfig/20250819-151656-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 3:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:27:21Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81532 and previous config saved to /var/cache/conftool/dbconfig/20250819-152720-fceratto.json

Stashbot added a comment.Aug 19 2025, 3:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:27:44Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2169 (T402010)', diff saved to https://phabricator.wikimedia.org/P81533 and previous config saved to /var/cache/conftool/dbconfig/20250819-152743-fceratto.json

Stashbot added a comment.Aug 19 2025, 3:30 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T15:30:15Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2169 (T402010)', diff saved to https://phabricator.wikimedia.org/P81534 and previous config saved to /var/cache/conftool/dbconfig/20250819-153015-fceratto.json

Stashbot added a comment.Aug 19 2025, 4:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:02:19Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T402010)', diff saved to https://phabricator.wikimedia.org/P81538 and previous config saved to /var/cache/conftool/dbconfig/20250819-160218-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 4:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:02:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81539 and previous config saved to /var/cache/conftool/dbconfig/20250819-160230-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 4:04 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:04:41Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81540 and previous config saved to /var/cache/conftool/dbconfig/20250819-160439-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 4:50 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:50:03Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T402010)', diff saved to https://phabricator.wikimedia.org/P81543 and previous config saved to /var/cache/conftool/dbconfig/20250819-165003-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 4:50 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:50:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2169 (T402010)', diff saved to https://phabricator.wikimedia.org/P81544 and previous config saved to /var/cache/conftool/dbconfig/20250819-165015-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 4:51 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T16:51:25Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2169 (T402010)', diff saved to https://phabricator.wikimedia.org/P81545 and previous config saved to /var/cache/conftool/dbconfig/20250819-165124-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 5:36 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T17:36:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2169 (T402010)', diff saved to https://phabricator.wikimedia.org/P81550 and previous config saved to /var/cache/conftool/dbconfig/20250819-173646-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 5:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T17:37:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81551 and previous config saved to /var/cache/conftool/dbconfig/20250819-173709-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 5:38 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T17:38:34Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81552 and previous config saved to /var/cache/conftool/dbconfig/20250819-173833-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 6:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T18:23:58Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T402010)', diff saved to https://phabricator.wikimedia.org/P81555 and previous config saved to /var/cache/conftool/dbconfig/20250819-182356-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 6:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T18:24:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2193 (T402010)', diff saved to https://phabricator.wikimedia.org/P81556 and previous config saved to /var/cache/conftool/dbconfig/20250819-182419-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 6:26 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T18:26:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2193 (T402010)', diff saved to https://phabricator.wikimedia.org/P81557 and previous config saved to /var/cache/conftool/dbconfig/20250819-182642-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 7:12 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T19:12:04Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2193 (T402010)', diff saved to https://phabricator.wikimedia.org/P81560 and previous config saved to /var/cache/conftool/dbconfig/20250819-191204-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 7:13 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T19:13:11Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2214 (T402010)', diff saved to https://phabricator.wikimedia.org/P81561 and previous config saved to /var/cache/conftool/dbconfig/20250819-191311-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 7:15 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T19:15:38Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2214 (T402010)', diff saved to https://phabricator.wikimedia.org/P81562 and previous config saved to /var/cache/conftool/dbconfig/20250819-191537-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:01 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:01:00Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2214 (T402010)', diff saved to https://phabricator.wikimedia.org/P81565 and previous config saved to /var/cache/conftool/dbconfig/20250819-200100-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:01 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:01:23Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2217 (T402010)', diff saved to https://phabricator.wikimedia.org/P81566 and previous config saved to /var/cache/conftool/dbconfig/20250819-200122-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:03 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:03:51Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T402010)', diff saved to https://phabricator.wikimedia.org/P81567 and previous config saved to /var/cache/conftool/dbconfig/20250819-200350-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:49 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:49:14Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T402010)', diff saved to https://phabricator.wikimedia.org/P81570 and previous config saved to /var/cache/conftool/dbconfig/20250819-204913-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:49 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:49:36Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2224 (T402010)', diff saved to https://phabricator.wikimedia.org/P81571 and previous config saved to /var/cache/conftool/dbconfig/20250819-204935-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 8:52 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T20:52:04Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2224 (T402010)', diff saved to https://phabricator.wikimedia.org/P81572 and previous config saved to /var/cache/conftool/dbconfig/20250819-205203-ladsgroup.json

Stashbot added a comment.Aug 19 2025, 9:37 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-19T21:37:26Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2224 (T402010)', diff saved to https://phabricator.wikimedia.org/P81575 and previous config saved to /var/cache/conftool/dbconfig/20250819-213725-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Aug 19 2025, 9:45 PM

I'm going to run this live (not with replication though). This is too fast.

Ladsgroup updated the task description. (Show Details)Aug 19 2025, 9:50 PM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 12:01 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 12:20 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 12:35 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 12:48 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 11:21 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 11:39 AM
Ladsgroup updated the task description. (Show Details)Aug 20 2025, 12:00 PM
Ladsgroup closed this task as Resolved.Aug 20 2025, 1:36 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
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