Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Page MenuHomePhabricator
Create Task
Maniphest T326011

Add default values to cul_user and cul_user_text
Closed, ResolvedPublic
Actions

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

Details

SubjectRepoBranchLines +/-
change_cul_user_T326011.py: New schema changeoperations/software/schema-changesmaster+41 -0
Customize query in gerrit

Related Objects
Search...

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
· · ·
ResolvedZabeT233004 Update CheckUser for actor and comment table
Resolved• MarosteguiT326011 Add default values to cul_user and cul_user_text
· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
• Marostegui updated the task description. (Show Details)Jan 4 2023, 7:49 AM
• Marostegui moved this task from Ready to In progress on the DBA board.
• Marostegui added a comment.Jan 4 2023, 8:16 AM

s6 already have these values, so not needed there.

• Marostegui updated the task description. (Show Details)Jan 4 2023, 8:16 AM
• Marostegui added a comment.Jan 4 2023, 8:19 AM
In T326011#8497018, @Marostegui wrote:

s6 already have these values, so not needed there.

same with s7

• Marostegui updated the task description. (Show Details)Jan 4 2023, 8:19 AM
• Marostegui updated the task description. (Show Details)Jan 4 2023, 8:24 AM
Stashbot added a comment.Jan 4 2023, 8:26 AM

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

Stashbot added a comment.Jan 4 2023, 8:26 AM

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

Stashbot added a comment.Jan 4 2023, 8:26 AM

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

Stashbot added a comment.Jan 4 2023, 8:26 AM

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

• Marostegui updated the task description. (Show Details)Jan 4 2023, 8:28 AM
In T326011#8497021, @Marostegui wrote:
In T326011#8497018, @Marostegui wrote:

s6 already have these values, so not needed there.

same with s7

Same with s1

• Marostegui updated the task description. (Show Details)Jan 4 2023, 8:29 AM
• Marostegui added a comment.Jan 4 2023, 9:34 AM
In T326011#8497045, @Marostegui wrote:
In T326011#8497021, @Marostegui wrote:
In T326011#8497018, @Marostegui wrote:

s6 already have these values, so not needed there.

same with s7

Same with s1

Same with s2

• Marostegui updated the task description. (Show Details)Jan 4 2023, 9:34 AM
Stashbot added a comment.Jan 4 2023, 9:37 AM

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

Stashbot added a comment.Jan 4 2023, 10:04 AM

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

• Marostegui updated the task description. (Show Details)Jan 4 2023, 10:06 AM
gerritbot added a comment.Jan 4 2023, 11:46 AM

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

gerritbot added a project: Patch-For-Review.Jan 4 2023, 11:46 AM
Stashbot added a comment.Jan 4 2023, 11:50 AM

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

gerritbot added a comment.Jan 4 2023, 11:50 AM

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

Stashbot added a comment.Jan 4 2023, 11:58 AM

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

Maintenance_bot removed a project: Patch-For-Review.Jan 4 2023, 12:31 PM
Stashbot added a comment.Jan 4 2023, 12:44 PM

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

Stashbot added a comment.Jan 4 2023, 12:44 PM

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

Stashbot added a comment.Jan 4 2023, 12:53 PM

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

• Marostegui mentioned this in rSCHCHb0146684fcad: change_cul_user_T326011.py: New schema change.Jan 4 2023, 1:07 PM
Stashbot added a comment.Jan 4 2023, 1:38 PM

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

Stashbot added a comment.Jan 4 2023, 1:45 PM

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

Stashbot added a comment.Jan 4 2023, 1:54 PM

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

Stashbot added a comment.Jan 4 2023, 2:39 PM

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

Stashbot added a comment.Jan 4 2023, 2:40 PM

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

Stashbot added a comment.Jan 4 2023, 2:48 PM

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

Stashbot added a comment.Jan 4 2023, 3:34 PM

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

Stashbot added a comment.Jan 4 2023, 3:34 PM

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

Stashbot added a comment.Jan 4 2023, 3:43 PM

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

Stashbot added a comment.Jan 4 2023, 4:30 PM

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

Stashbot added a comment.Jan 4 2023, 4:45 PM

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

Stashbot added a comment.Jan 4 2023, 4:49 PM

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

Stashbot added a comment.Jan 4 2023, 5:34 PM

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

Stashbot added a comment.Jan 4 2023, 5:34 PM

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

Stashbot added a comment.Jan 4 2023, 5:39 PM

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

Stashbot added a comment.Jan 4 2023, 6:24 PM

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

Stashbot added a comment.Jan 4 2023, 6:27 PM

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

Stashbot added a comment.Jan 4 2023, 6:31 PM

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

Stashbot added a comment.Jan 4 2023, 7:16 PM

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

Stashbot added a comment.Jan 4 2023, 7:16 PM

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

Stashbot added a comment.Jan 4 2023, 7:20 PM

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

Stashbot added a comment.Jan 4 2023, 8:06 PM

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

Stashbot added a comment.Jan 4 2023, 8:06 PM

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

Stashbot added a comment.Jan 4 2023, 8:10 PM

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

Stashbot added a comment.Jan 4 2023, 8:56 PM

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

Stashbot added a comment.Jan 4 2023, 8:56 PM

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

Stashbot added a comment.Jan 4 2023, 9:00 PM

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

Stashbot added a comment.Jan 4 2023, 9:45 PM

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

Stashbot added a comment.Jan 4 2023, 9:46 PM

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

Stashbot added a comment.Jan 4 2023, 9:50 PM

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

Stashbot added a comment.Jan 4 2023, 10:35 PM

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 closed this task as Resolved.Jan 5 2023, 6:35 AM
• Marostegui updated the task description. (Show Details)

This is all done

Maintenance_bot moved this task from In progress to Done on the DBA board.Jan 5 2023, 7:15 AM
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