Page MenuHomePhabricator
Create Task
Maniphest T313070

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

Description

Apply T310452 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Wikibase/+/804781/5/repo/sql/mysql/archives/patch-wb_changes-change_timestamp.sql
  2. Where to run those changes: s8
  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 already 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_change_time_T313070.py: New schema changeoperations/software/schema-changesmaster+41 -0
Customize query in gerrit

Related Objects

Mentioned In
rSCHCH14849d7669a9: change_change_time_T313070.py: New schema change
Mentioned Here
P31376 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)'
P31375 dbctl commit (dc=all): 'Depooling db1101:3318 (T313070)'
P31374 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)'
P31371 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)'
P31370 dbctl commit (dc=all): 'Depooling db1126 (T313070)'
P31369 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)'
P31366 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)'
P31365 dbctl commit (dc=all): 'Depooling db1177 (T313070)'
P31364 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T313070)'
P31359 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T313070)'
P31352 dbctl commit (dc=all): 'Depooling db1178 (T313070)'
P31351 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)'
P31343 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)'
P31342 dbctl commit (dc=all): 'Depooling db1177 (T313070)'
P31341 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)'
P31334 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)'
P31333 dbctl commit (dc=all): 'Depooling db1126 (T313070)'
P31332 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)'
P31324 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)'
P31323 dbctl commit (dc=all): 'Depooling db1101:3318 (T313070)'
P31322 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T313070)'
P31312 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T313070)'
P31311 dbctl commit (dc=all): 'Depooling db1114 (T313070)'
P31310 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T313070)'
P31301 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T313070)'
P31300 dbctl commit (dc=all): 'Depooling db1099:3318 (T313070)'
P31299 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T313070)'
P31289 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T313070)'
P31287 dbctl commit (dc=all): 'Depooling db1109 (T313070)'
P31286 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T313070)'
P31279 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T313070)'
P31277 dbctl commit (dc=all): 'Depooling db1167 (T313070)'
P31276 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T313070)'
P31269 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T313070)'
P31268 dbctl commit (dc=all): 'Depooling db1172 (T313070)'
P31267 dbctl commit (dc=all): 'Repooling after maintenance db1111 (T313070)'
P31260 dbctl commit (dc=all): 'Repooling after maintenance db1111 (T313070)'
P31257 dbctl commit (dc=all): 'Depooling db1111 (T313070)'
T310452: Standardise type for change_time column in Wikibase repo

Event Timeline

Umherirrender created this task.Jul 14 2022, 5:20 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 14 2022, 5:20 PM
Umherirrender triaged this task as Lowest priority.Jul 14 2022, 5:20 PM
• Marostegui claimed this task.Jul 15 2022, 7:11 AM
• Marostegui moved this task from Triage to Ready on the DBA board.
gerritbot added a comment.Jul 15 2022, 7:16 AM

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

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

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

gerritbot added a project: Patch-For-Review.Jul 15 2022, 7:16 AM
gerritbot added a comment.Jul 15 2022, 9:28 AM

Change 814097 merged by jenkins-bot:

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

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

• Marostegui mentioned this in rSCHCH14849d7669a9: change_change_time_T313070.py: New schema change.Jul 15 2022, 9:29 AM
Maintenance_bot removed a project: Patch-For-Review.Jul 15 2022, 9:30 AM
• Marostegui moved this task from Ready to In progress on the DBA board.Jul 15 2022, 12:44 PM
• Marostegui added a comment.Jul 18 2022, 5:21 AM

Starting its deployment

Stashbot added a comment.Jul 18 2022, 5:22 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T05:22:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1111 (T313070)', diff saved to https://phabricator.wikimedia.org/P31257 and previous config saved to /var/cache/conftool/dbconfig/20220718-052250-marostegui.json

Stashbot added a comment.Jul 18 2022, 6:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T06:23:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T313070)', diff saved to https://phabricator.wikimedia.org/P31260 and previous config saved to /var/cache/conftool/dbconfig/20220718-062304-marostegui.json

Stashbot added a comment.Jul 18 2022, 7:08 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T07:08:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T313070)', diff saved to https://phabricator.wikimedia.org/P31267 and previous config saved to /var/cache/conftool/dbconfig/20220718-070820-marostegui.json

Stashbot added a comment.Jul 18 2022, 7:08 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T07:08:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1172 (T313070)', diff saved to https://phabricator.wikimedia.org/P31268 and previous config saved to /var/cache/conftool/dbconfig/20220718-070840-marostegui.json

Stashbot added a comment.Jul 18 2022, 7:09 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T07:09:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T313070)', diff saved to https://phabricator.wikimedia.org/P31269 and previous config saved to /var/cache/conftool/dbconfig/20220718-070946-marostegui.json

Stashbot added a comment.Jul 18 2022, 7:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T07:55:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T313070)', diff saved to https://phabricator.wikimedia.org/P31276 and previous config saved to /var/cache/conftool/dbconfig/20220718-075501-marostegui.json

Stashbot added a comment.Jul 18 2022, 7:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T07:55:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1167 (T313070)', diff saved to https://phabricator.wikimedia.org/P31277 and previous config saved to /var/cache/conftool/dbconfig/20220718-075527-marostegui.json

Stashbot added a comment.Jul 18 2022, 8:07 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T08:07:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T313070)', diff saved to https://phabricator.wikimedia.org/P31279 and previous config saved to /var/cache/conftool/dbconfig/20220718-080735-marostegui.json

Stashbot added a comment.Jul 18 2022, 8:52 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T08:52:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T313070)', diff saved to https://phabricator.wikimedia.org/P31286 and previous config saved to /var/cache/conftool/dbconfig/20220718-085251-marostegui.json

Stashbot added a comment.Jul 18 2022, 8:53 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T08:53:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1109 (T313070)', diff saved to https://phabricator.wikimedia.org/P31287 and previous config saved to /var/cache/conftool/dbconfig/20220718-085312-marostegui.json

Stashbot added a comment.Jul 18 2022, 8:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T08:55:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T313070)', diff saved to https://phabricator.wikimedia.org/P31289 and previous config saved to /var/cache/conftool/dbconfig/20220718-085518-marostegui.json

Stashbot added a comment.Jul 18 2022, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T09:40:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T313070)', diff saved to https://phabricator.wikimedia.org/P31299 and previous config saved to /var/cache/conftool/dbconfig/20220718-094033-marostegui.json

Stashbot added a comment.Jul 18 2022, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T09:40:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31300 and previous config saved to /var/cache/conftool/dbconfig/20220718-094043-marostegui.json

Stashbot added a comment.Jul 18 2022, 9:41 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T09:41:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31301 and previous config saved to /var/cache/conftool/dbconfig/20220718-094150-marostegui.json

Stashbot added a comment.Jul 18 2022, 10:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T10:27:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31310 and previous config saved to /var/cache/conftool/dbconfig/20220718-102706-marostegui.json

Stashbot added a comment.Jul 18 2022, 10:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T10:27:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1114 (T313070)', diff saved to https://phabricator.wikimedia.org/P31311 and previous config saved to /var/cache/conftool/dbconfig/20220718-102726-marostegui.json

Stashbot added a comment.Jul 18 2022, 10:28 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T10:28:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T313070)', diff saved to https://phabricator.wikimedia.org/P31312 and previous config saved to /var/cache/conftool/dbconfig/20220718-102832-marostegui.json

Stashbot added a comment.Jul 18 2022, 11:13 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T11:13:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T313070)', diff saved to https://phabricator.wikimedia.org/P31322 and previous config saved to /var/cache/conftool/dbconfig/20220718-111348-marostegui.json

Stashbot added a comment.Jul 18 2022, 11:14 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T11:14:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31323 and previous config saved to /var/cache/conftool/dbconfig/20220718-111409-marostegui.json

Stashbot added a comment.Jul 18 2022, 11:15 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T11:15:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31324 and previous config saved to /var/cache/conftool/dbconfig/20220718-111515-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:00 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:00:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31332 and previous config saved to /var/cache/conftool/dbconfig/20220718-120030-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:00 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:00:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31333 and previous config saved to /var/cache/conftool/dbconfig/20220718-120051-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:01 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:01:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31334 and previous config saved to /var/cache/conftool/dbconfig/20220718-120157-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:47:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31341 and previous config saved to /var/cache/conftool/dbconfig/20220718-124712-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:47:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31342 and previous config saved to /var/cache/conftool/dbconfig/20220718-124732-marostegui.json

Stashbot added a comment.Jul 18 2022, 12:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T12:48:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31343 and previous config saved to /var/cache/conftool/dbconfig/20220718-124838-marostegui.json

Stashbot added a comment.Jul 18 2022, 1:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T13:33:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31351 and previous config saved to /var/cache/conftool/dbconfig/20220718-133354-marostegui.json

Stashbot added a comment.Jul 18 2022, 1:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T13:34:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1178 (T313070)', diff saved to https://phabricator.wikimedia.org/P31352 and previous config saved to /var/cache/conftool/dbconfig/20220718-133414-marostegui.json

Stashbot added a comment.Jul 18 2022, 2:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T14:34:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T313070)', diff saved to https://phabricator.wikimedia.org/P31359 and previous config saved to /var/cache/conftool/dbconfig/20220718-143428-marostegui.json

• Marostegui closed this task as Resolved.Jul 18 2022, 2:38 PM

All done, including the master

Stashbot added a comment.Jul 18 2022, 3:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T15:19:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T313070)', diff saved to https://phabricator.wikimedia.org/P31364 and previous config saved to /var/cache/conftool/dbconfig/20220718-151944-marostegui.json

Stashbot added a comment.Jul 18 2022, 3:20 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T15:20:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31365 and previous config saved to /var/cache/conftool/dbconfig/20220718-152026-marostegui.json

Stashbot added a comment.Jul 18 2022, 3:21 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T15:21:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31366 and previous config saved to /var/cache/conftool/dbconfig/20220718-152132-marostegui.json

Maintenance_bot moved this task from In progress to Done on the DBA board.Jul 18 2022, 3:29 PM
Stashbot added a comment.Jul 18 2022, 4:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:06:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T313070)', diff saved to https://phabricator.wikimedia.org/P31369 and previous config saved to /var/cache/conftool/dbconfig/20220718-160648-marostegui.json

Stashbot added a comment.Jul 18 2022, 4:07 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:07:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31370 and previous config saved to /var/cache/conftool/dbconfig/20220718-160708-marostegui.json

Stashbot added a comment.Jul 18 2022, 4:08 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:08:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31371 and previous config saved to /var/cache/conftool/dbconfig/20220718-160813-marostegui.json

Stashbot added a comment.Jul 18 2022, 4:53 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:53:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T313070)', diff saved to https://phabricator.wikimedia.org/P31374 and previous config saved to /var/cache/conftool/dbconfig/20220718-165329-marostegui.json

Stashbot added a comment.Jul 18 2022, 4:53 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:53:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31375 and previous config saved to /var/cache/conftool/dbconfig/20220718-165349-marostegui.json

Stashbot added a comment.Jul 18 2022, 4:54 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-18T16:54:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T313070)', diff saved to https://phabricator.wikimedia.org/P31376 and previous config saved to /var/cache/conftool/dbconfig/20220718-165455-marostegui.json

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