Page MenuHomePhabricator

Add default values to cul_user and cul_user_text
Closed, ResolvedPublic

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/873048/5/schema/mysql/patch-cu_log-defaults.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: beta cluster don't have checkuser
  6. if the data should be made available on the labs replicas and/or dumps: No, data is private.

Progress

  • s1
  • s2 NOT NEEDED
  • s3
  • s4
  • s5
  • s6 NOT NEEDED
  • s7 NOT NEEDED
  • s8
  • labtestwiki

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
ResolvedZabe
Resolved Marostegui

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Marostegui moved this task from Ready to In progress on the DBA board.

s6 already have these values, so not needed there.

s6 already have these values, so not needed there.

same with s7

Mentioned in SAL (#wikimedia-operations) [2023-01-04T08:26:49Z] <marostegui> dbmaint codfw deploy schema change on s4 T326011

Mentioned in SAL (#wikimedia-operations) [2023-01-04T08:26:52Z] <marostegui> dbmaint eqiad deploy schema change on s4 T326011

Mentioned in SAL (#wikimedia-operations) [2023-01-04T08:26:55Z] <marostegui> dbmaint eqiad deploy schema change on s8 T326011

Mentioned in SAL (#wikimedia-operations) [2023-01-04T08:26:58Z] <marostegui> dbmaint codfw deploy schema change on s8 T326011

s6 already have these values, so not needed there.

same with s7

Same with s1

s6 already have these values, so not needed there.

same with s7

Same with s1

Same with s2

Mentioned in SAL (#wikimedia-operations) [2023-01-04T09:37:49Z] <marostegui> dbmaint codfw deploy schema change on s5 T326011

Mentioned in SAL (#wikimedia-operations) [2023-01-04T10:04:48Z] <marostegui> dbmaint eqiad deploy schema change on s5 T326011

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

[operations/software/schema-changes@master] change_cul_user_T326011.py: New schema change

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

Mentioned in SAL (#wikimedia-operations) [2023-01-04T11:50:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2109 (T326011)', diff saved to https://phabricator.wikimedia.org/P42763 and previous config saved to /var/cache/conftool/dbconfig/20230104-115011-marostegui.json

Change 875288 merged by jenkins-bot:

[operations/software/schema-changes@master] change_cul_user_T326011.py: New schema change

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

Mentioned in SAL (#wikimedia-operations) [2023-01-04T11:58:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T326011)', diff saved to https://phabricator.wikimedia.org/P42765 and previous config saved to /var/cache/conftool/dbconfig/20230104-115844-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T12:44:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T326011)', diff saved to https://phabricator.wikimedia.org/P42771 and previous config saved to /var/cache/conftool/dbconfig/20230104-124403-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T12:44:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2127 (T326011)', diff saved to https://phabricator.wikimedia.org/P42772 and previous config saved to /var/cache/conftool/dbconfig/20230104-124424-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T12:53:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2127 (T326011)', diff saved to https://phabricator.wikimedia.org/P42773 and previous config saved to /var/cache/conftool/dbconfig/20230104-125310-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T13:38:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2127 (T326011)', diff saved to https://phabricator.wikimedia.org/P42777 and previous config saved to /var/cache/conftool/dbconfig/20230104-133830-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T13:45:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2149 (T326011)', diff saved to https://phabricator.wikimedia.org/P42778 and previous config saved to /var/cache/conftool/dbconfig/20230104-134544-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T13:54:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T326011)', diff saved to https://phabricator.wikimedia.org/P42779 and previous config saved to /var/cache/conftool/dbconfig/20230104-135429-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T14:39:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T326011)', diff saved to https://phabricator.wikimedia.org/P42782 and previous config saved to /var/cache/conftool/dbconfig/20230104-143949-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T14:40:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2156 (T326011)', diff saved to https://phabricator.wikimedia.org/P42783 and previous config saved to /var/cache/conftool/dbconfig/20230104-144025-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T14:48:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T326011)', diff saved to https://phabricator.wikimedia.org/P42784 and previous config saved to /var/cache/conftool/dbconfig/20230104-144853-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T15:34:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T326011)', diff saved to https://phabricator.wikimedia.org/P42787 and previous config saved to /var/cache/conftool/dbconfig/20230104-153413-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T15:34:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2177 (T326011)', diff saved to https://phabricator.wikimedia.org/P42788 and previous config saved to /var/cache/conftool/dbconfig/20230104-153435-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T15:43:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T326011)', diff saved to https://phabricator.wikimedia.org/P42789 and previous config saved to /var/cache/conftool/dbconfig/20230104-154308-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T16:30:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T326011)', diff saved to https://phabricator.wikimedia.org/P42792 and previous config saved to /var/cache/conftool/dbconfig/20230104-162828-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T16:45:42Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1112 (T326011)', diff saved to https://phabricator.wikimedia.org/P42793 and previous config saved to /var/cache/conftool/dbconfig/20230104-164504-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T16:49:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T326011)', diff saved to https://phabricator.wikimedia.org/P42794 and previous config saved to /var/cache/conftool/dbconfig/20230104-164915-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T17:34:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T326011)', diff saved to https://phabricator.wikimedia.org/P42797 and previous config saved to /var/cache/conftool/dbconfig/20230104-173434-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T17:34:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1123 (T326011)', diff saved to https://phabricator.wikimedia.org/P42798 and previous config saved to /var/cache/conftool/dbconfig/20230104-173455-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T17:39:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1123 (T326011)', diff saved to https://phabricator.wikimedia.org/P42799 and previous config saved to /var/cache/conftool/dbconfig/20230104-173905-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T18:24:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1123 (T326011)', diff saved to https://phabricator.wikimedia.org/P42802 and previous config saved to /var/cache/conftool/dbconfig/20230104-182425-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T18:27:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1166 (T326011)', diff saved to https://phabricator.wikimedia.org/P42803 and previous config saved to /var/cache/conftool/dbconfig/20230104-182700-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T18:31:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T326011)', diff saved to https://phabricator.wikimedia.org/P42804 and previous config saved to /var/cache/conftool/dbconfig/20230104-183108-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T19:16:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T326011)', diff saved to https://phabricator.wikimedia.org/P42807 and previous config saved to /var/cache/conftool/dbconfig/20230104-191627-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T19:16:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1175 (T326011)', diff saved to https://phabricator.wikimedia.org/P42808 and previous config saved to /var/cache/conftool/dbconfig/20230104-191648-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T19:20:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T326011)', diff saved to https://phabricator.wikimedia.org/P42809 and previous config saved to /var/cache/conftool/dbconfig/20230104-192057-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T20:06:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T326011)', diff saved to https://phabricator.wikimedia.org/P42812 and previous config saved to /var/cache/conftool/dbconfig/20230104-200617-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T20:06:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1179 (T326011)', diff saved to https://phabricator.wikimedia.org/P42813 and previous config saved to /var/cache/conftool/dbconfig/20230104-200638-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T20:10:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T326011)', diff saved to https://phabricator.wikimedia.org/P42814 and previous config saved to /var/cache/conftool/dbconfig/20230104-201047-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T20:56:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T326011)', diff saved to https://phabricator.wikimedia.org/P42817 and previous config saved to /var/cache/conftool/dbconfig/20230104-205607-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T20:56:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1189 (T326011)', diff saved to https://phabricator.wikimedia.org/P42818 and previous config saved to /var/cache/conftool/dbconfig/20230104-205628-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T21:00:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T326011)', diff saved to https://phabricator.wikimedia.org/P42819 and previous config saved to /var/cache/conftool/dbconfig/20230104-210036-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T21:45:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T326011)', diff saved to https://phabricator.wikimedia.org/P42824 and previous config saved to /var/cache/conftool/dbconfig/20230104-214555-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T21:46:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1198 (T326011)', diff saved to https://phabricator.wikimedia.org/P42825 and previous config saved to /var/cache/conftool/dbconfig/20230104-214616-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T21:50:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T326011)', diff saved to https://phabricator.wikimedia.org/P42826 and previous config saved to /var/cache/conftool/dbconfig/20230104-215025-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-01-04T22:35:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1198 (T326011)', diff saved to https://phabricator.wikimedia.org/P42831 and previous config saved to /var/cache/conftool/dbconfig/20230104-223545-marostegui.json

Marostegui updated the task description. (Show Details)

This is all done