Page MenuHomePhabricator
Create Task
Maniphest T302659

Adjust the field type of localuser.lu_attached_timestamp to fixed binary on wmf wikis
Closed, ResolvedPublic
Actions

Description

Apply parts of T300576 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralAuth/+/762531/3/db_patches/patch-localuser-lu_attached_timestamp.sql
  2. Where to run those changes: centralauth databases (s7)
  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

Details

SubjectRepoBranchLines +/-
change_localuser.lu_attached_timestamp_T302659.py: Replace the checkoperations/software/schema-changesmaster+6 -6
change_localuser.lu_attached_timestamp_T302659.py: New schema changeoperations/software/schema-changesmaster+41 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

Umherirrender created this task.Feb 26 2022, 7:24 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 26 2022, 7:24 AM
Stashbot added a comment.Feb 26 2022, 1:19 PM

Mentioned in SAL (#wikimedia-releng) [2022-02-26T13:19:51Z] <zabe> apply T302659 on deployment-prep centralauth databases

Umherirrender triaged this task as Lowest priority.Feb 26 2022, 3:34 PM
Zabe subscribed.Feb 26 2022, 3:43 PM
Zabe updated the task description. (Show Details)Feb 26 2022, 8:34 PM
Marostegui moved this task from Triage to Ready on the DBA board.Mar 7 2022, 6:09 AM
Marostegui assigned this task to • Kormat.Mar 8 2022, 7:15 AM
gerritbot added a comment.May 2 2022, 8:35 AM

Change 788288 had a related patch set uploaded (by Kormat; author: Kormat):

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

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

gerritbot added a project: Patch-For-Review.May 2 2022, 8:35 AM
gerritbot added a comment.May 2 2022, 8:59 AM

Change 788288 merged by jenkins-bot:

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

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

• Kormat mentioned this in rSCHCH55502aa6cc1a: change_localuser.lu_attached_timestamp_T302659.py: New schema change.May 2 2022, 9:00 AM
Maintenance_bot removed a project: Patch-For-Review.May 2 2022, 9:31 AM
Marostegui claimed this task.Jun 15 2022, 5:41 AM
Marostegui added subscribers: • Kormat, Marostegui.

I will do this

Marostegui moved this task from Ready to In progress on the DBA board.Jun 15 2022, 5:41 AM
Stashbot added a comment.Jun 15 2022, 5:42 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T05:42:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29745 and previous config saved to /var/cache/conftool/dbconfig/20220615-054252-marostegui.json

Marostegui added a comment.Jun 15 2022, 5:43 AM

Starting to deploy this schema change now

Stashbot added a comment.Jun 15 2022, 8:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T08:40:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29764 and previous config saved to /var/cache/conftool/dbconfig/20220615-084046-marostegui.json

Stashbot added a comment.Jun 15 2022, 8:41 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T08:41:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29765 and previous config saved to /var/cache/conftool/dbconfig/20220615-084151-marostegui.json

Stashbot added a comment.Jun 15 2022, 9:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T09:27:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29772 and previous config saved to /var/cache/conftool/dbconfig/20220615-092706-marostegui.json

gerritbot added a comment.Jun 15 2022, 9:44 AM

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

[operations/software/schema-changes@master] change_localuser.lu_attached_timestamp_T302659.py: Replaced the check

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

gerritbot added a project: Patch-For-Review.Jun 15 2022, 9:44 AM
gerritbot added a comment.Jun 15 2022, 9:48 AM

Change 805767 merged by jenkins-bot:

[operations/software/schema-changes@master] change_localuser.lu_attached_timestamp_T302659.py: Replace the check

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

Stashbot added a comment.Jun 15 2022, 10:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T10:02:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29775 and previous config saved to /var/cache/conftool/dbconfig/20220615-100235-marostegui.json

Marostegui mentioned this in rSCHCH8a73b12e875c: change_localuser.lu_attached_timestamp_T302659.py: Replace the check.Jun 15 2022, 10:24 AM
Maintenance_bot removed a project: Patch-For-Review.Jun 15 2022, 10:30 AM
Stashbot added a comment.Jun 15 2022, 11:29 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T11:29:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29795 and previous config saved to /var/cache/conftool/dbconfig/20220615-112924-marostegui.json

Stashbot added a comment.Jun 15 2022, 12:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T12:14:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29806 and previous config saved to /var/cache/conftool/dbconfig/20220615-121440-marostegui.json

Stashbot added a comment.Jun 16 2022, 9:11 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T09:11:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29868 and previous config saved to /var/cache/conftool/dbconfig/20220616-091131-marostegui.json

Stashbot added a comment.Jun 16 2022, 10:31 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T10:31:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29869 and previous config saved to /var/cache/conftool/dbconfig/20220616-103117-marostegui.json

Stashbot added a comment.Jun 16 2022, 11:16 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T11:16:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T302659)', diff saved to https://phabricator.wikimedia.org/P29873 and previous config saved to /var/cache/conftool/dbconfig/20220616-111632-marostegui.json

Stashbot added a comment.Jun 16 2022, 12:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T12:33:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1127 (T302659)', diff saved to https://phabricator.wikimedia.org/P29875 and previous config saved to /var/cache/conftool/dbconfig/20220616-123357-marostegui.json

Stashbot added a comment.Jun 16 2022, 2:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T14:06:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T302659)', diff saved to https://phabricator.wikimedia.org/P29882 and previous config saved to /var/cache/conftool/dbconfig/20220616-140613-marostegui.json

Stashbot added a comment.Jun 16 2022, 2:51 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T14:51:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T302659)', diff saved to https://phabricator.wikimedia.org/P29887 and previous config saved to /var/cache/conftool/dbconfig/20220616-145128-marostegui.json

Stashbot added a comment.Jun 16 2022, 2:51 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T14:51:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1181 (T302659)', diff saved to https://phabricator.wikimedia.org/P29888 and previous config saved to /var/cache/conftool/dbconfig/20220616-145136-marostegui.json

Stashbot added a comment.Jun 16 2022, 3:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T15:33:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T302659)', diff saved to https://phabricator.wikimedia.org/P29891 and previous config saved to /var/cache/conftool/dbconfig/20220616-153320-marostegui.json

Stashbot added a comment.Jun 16 2022, 4:18 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T16:18:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T302659)', diff saved to https://phabricator.wikimedia.org/P29894 and previous config saved to /var/cache/conftool/dbconfig/20220616-161835-marostegui.json

Stashbot added a comment.Jun 16 2022, 4:18 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T16:18:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T302659)', diff saved to https://phabricator.wikimedia.org/P29895 and previous config saved to /var/cache/conftool/dbconfig/20220616-161844-marostegui.json

Stashbot added a comment.Jun 16 2022, 4:52 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T16:52:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T302659)', diff saved to https://phabricator.wikimedia.org/P29896 and previous config saved to /var/cache/conftool/dbconfig/20220616-165210-marostegui.json

Stashbot added a comment.Jun 16 2022, 5:37 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T17:37:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T302659)', diff saved to https://phabricator.wikimedia.org/P29899 and previous config saved to /var/cache/conftool/dbconfig/20220616-173725-marostegui.json

Stashbot added a comment.Jun 16 2022, 5:37 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T17:37:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T302659)', diff saved to https://phabricator.wikimedia.org/P29900 and previous config saved to /var/cache/conftool/dbconfig/20220616-173738-marostegui.json

Stashbot added a comment.Jun 16 2022, 6:10 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T18:10:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T302659)', diff saved to https://phabricator.wikimedia.org/P29901 and previous config saved to /var/cache/conftool/dbconfig/20220616-181005-marostegui.json

Stashbot added a comment.Jun 16 2022, 6:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-16T18:55:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T302659)', diff saved to https://phabricator.wikimedia.org/P29904 and previous config saved to /var/cache/conftool/dbconfig/20220616-185520-marostegui.json

Marostegui moved this task from In progress to Blocked on the DBA board.Jun 21 2022, 5:06 AM

This was done, only pending the master that requires a switchover. I will try to schedule it for next week.

Marostegui closed subtask T311033: Switchover s7 master db1136 -> db1181 as Resolved.Jun 28 2022, 6:17 AM
Marostegui closed this task as Resolved.Jun 28 2022, 6:59 AM
In T302659#8015588, @Marostegui wrote:

This was done, only pending the master that requires a switchover. I will try to schedule it for next week.

db1136 was done

Stashbot added a comment.Jun 28 2022, 7:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-28T07:02:45Z] <marostegui> dbmaint s7@eqiad T302659

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