Page MenuHomePhabricator

Add user_is_temp field to the user table in MediaWiki core
Closed, ResolvedPublic

Description

Apply T333223 to WMF wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/918513/2/maintenance/archives/patch-user-user_is_temp.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: no change of the existing rules

This adds user.user_is_temp as discussed in T333223: Adding user_is_temp to the user table.

Progress:

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

Related Objects

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2023-06-09T07:05:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T336886)', diff saved to https://phabricator.wikimedia.org/P49344 and previous config saved to /var/cache/conftool/dbconfig/20230609-070459-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T07:05:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2116 (T336886)', diff saved to https://phabricator.wikimedia.org/P49345 and previous config saved to /var/cache/conftool/dbconfig/20230609-070520-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T07:21:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T336886)', diff saved to https://phabricator.wikimedia.org/P49346 and previous config saved to /var/cache/conftool/dbconfig/20230609-072118-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T08:06:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T336886)', diff saved to https://phabricator.wikimedia.org/P49349 and previous config saved to /var/cache/conftool/dbconfig/20230609-080637-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T08:07:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2130 (T336886)', diff saved to https://phabricator.wikimedia.org/P49350 and previous config saved to /var/cache/conftool/dbconfig/20230609-080708-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T08:23:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T336886)', diff saved to https://phabricator.wikimedia.org/P49351 and previous config saved to /var/cache/conftool/dbconfig/20230609-082310-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T09:08:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T336886)', diff saved to https://phabricator.wikimedia.org/P49354 and previous config saved to /var/cache/conftool/dbconfig/20230609-090829-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T09:21:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2145 (T336886)', diff saved to https://phabricator.wikimedia.org/P49355 and previous config saved to /var/cache/conftool/dbconfig/20230609-092141-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T09:36:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T336886)', diff saved to https://phabricator.wikimedia.org/P49356 and previous config saved to /var/cache/conftool/dbconfig/20230609-093638-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T10:21:57Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T336886)', diff saved to https://phabricator.wikimedia.org/P49359 and previous config saved to /var/cache/conftool/dbconfig/20230609-102156-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T10:22:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2146 (T336886)', diff saved to https://phabricator.wikimedia.org/P49360 and previous config saved to /var/cache/conftool/dbconfig/20230609-102217-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T10:37:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T336886)', diff saved to https://phabricator.wikimedia.org/P49361 and previous config saved to /var/cache/conftool/dbconfig/20230609-103711-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T11:22:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T336886)', diff saved to https://phabricator.wikimedia.org/P49364 and previous config saved to /var/cache/conftool/dbconfig/20230609-112229-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T11:22:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T336886)', diff saved to https://phabricator.wikimedia.org/P49365 and previous config saved to /var/cache/conftool/dbconfig/20230609-112250-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T11:37:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T336886)', diff saved to https://phabricator.wikimedia.org/P49366 and previous config saved to /var/cache/conftool/dbconfig/20230609-113724-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T12:22:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T336886)', diff saved to https://phabricator.wikimedia.org/P49369 and previous config saved to /var/cache/conftool/dbconfig/20230609-122243-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T12:23:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49370 and previous config saved to /var/cache/conftool/dbconfig/20230609-122303-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T12:40:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49371 and previous config saved to /var/cache/conftool/dbconfig/20230609-124002-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T13:25:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49377 and previous config saved to /var/cache/conftool/dbconfig/20230609-132520-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T13:25:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49378 and previous config saved to /var/cache/conftool/dbconfig/20230609-132541-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T13:41:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49379 and previous config saved to /var/cache/conftool/dbconfig/20230609-134137-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T14:26:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T336886)', diff saved to https://phabricator.wikimedia.org/P49382 and previous config saved to /var/cache/conftool/dbconfig/20230609-142655-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T14:27:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T336886)', diff saved to https://phabricator.wikimedia.org/P49383 and previous config saved to /var/cache/conftool/dbconfig/20230609-142731-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T14:43:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T336886)', diff saved to https://phabricator.wikimedia.org/P49384 and previous config saved to /var/cache/conftool/dbconfig/20230609-144305-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T15:28:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T336886)', diff saved to https://phabricator.wikimedia.org/P49387 and previous config saved to /var/cache/conftool/dbconfig/20230609-152824-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T15:28:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T336886)', diff saved to https://phabricator.wikimedia.org/P49388 and previous config saved to /var/cache/conftool/dbconfig/20230609-152845-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T15:44:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T336886)', diff saved to https://phabricator.wikimedia.org/P49390 and previous config saved to /var/cache/conftool/dbconfig/20230609-154428-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T16:29:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T336886)', diff saved to https://phabricator.wikimedia.org/P49393 and previous config saved to /var/cache/conftool/dbconfig/20230609-162946-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T16:30:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T336886)', diff saved to https://phabricator.wikimedia.org/P49394 and previous config saved to /var/cache/conftool/dbconfig/20230609-163007-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T16:46:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T336886)', diff saved to https://phabricator.wikimedia.org/P49395 and previous config saved to /var/cache/conftool/dbconfig/20230609-164644-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-09T17:32:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T336886)', diff saved to https://phabricator.wikimedia.org/P49398 and previous config saved to /var/cache/conftool/dbconfig/20230609-173202-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T10:13:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1138 (T336886)', diff saved to https://phabricator.wikimedia.org/P49406 and previous config saved to /var/cache/conftool/dbconfig/20230613-101310-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T10:22:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1138 (T336886)', diff saved to https://phabricator.wikimedia.org/P49408 and previous config saved to /var/cache/conftool/dbconfig/20230613-102227-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T11:07:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1138 (T336886)', diff saved to https://phabricator.wikimedia.org/P49414 and previous config saved to /var/cache/conftool/dbconfig/20230613-110746-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T11:15:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1167 (T336886)', diff saved to https://phabricator.wikimedia.org/P49415 and previous config saved to /var/cache/conftool/dbconfig/20230613-111549-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T12:16:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T336886)', diff saved to https://phabricator.wikimedia.org/P49418 and previous config saved to /var/cache/conftool/dbconfig/20230613-121611-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-06-13T13:01:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T336886)', diff saved to https://phabricator.wikimedia.org/P49421 and previous config saved to /var/cache/conftool/dbconfig/20230613-130129-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

Masters of s1 and s8 were not cooperating while I was operating. I'll have to do swtichovers for reboots anyway. Doing it later this week.

Mentioned in SAL (#wikimedia-operations) [2023-08-22T08:44:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T336886)', diff saved to https://phabricator.wikimedia.org/P50839 and previous config saved to /var/cache/conftool/dbconfig/20230822-084445-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-22T09:00:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T336886)', diff saved to https://phabricator.wikimedia.org/P50851 and previous config saved to /var/cache/conftool/dbconfig/20230822-090036-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-22T09:45:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T336886)', diff saved to https://phabricator.wikimedia.org/P50878 and previous config saved to /var/cache/conftool/dbconfig/20230822-094555-ladsgroup.json

Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.