Page MenuHomePhabricator
Create Task
Maniphest T268391

Schema change for timestamp fields of jobs table
Closed, ResolvedPublic
Actions

Description

(Part of T42626: Standardise type of timestamp database fields (MySQL) and T230428: Migrate tables.sql to abstract schema)

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/641701/7/maintenance/archives/patch-job_job_timestamp.sql And https://gerrit.wikimedia.org/r/c/mediawiki/core/+/641701/7/maintenance/archives/patch-job_job_token_timestamp.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: At 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: Tested in beta cluster.
  6. if the data should be made available on the labs replicas and/or dumps: Yes, data in this table is public

The table supposed to be empty in production.

Progress:

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • s10 (wikitech)
  • Labtestwiki (clouddb2001-dev)

Related Objects

Event Timeline

Ladsgroup created this task.Nov 22 2020, 12:32 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 22 2020, 12:32 AM
Marostegui triaged this task as Medium priority.Nov 23 2020, 7:19 AM
Marostegui added a project: DBA.
Marostegui moved this task from Triage to Ready on the DBA board.
Marostegui claimed this task.Dec 1 2020, 11:26 AM
Marostegui moved this task from Ready to In progress on the DBA board.Dec 14 2020, 8:17 AM
Marostegui added a comment.Dec 14 2020, 8:20 AM

Table was indeed empty on s6. So I have deployed it there first.

frwiki
  `job_timestamp` binary(14) DEFAULT NULL,
  `job_token_timestamp` binary(14) DEFAULT NULL,
jawiki
  `job_timestamp` binary(14) DEFAULT NULL,
  `job_token_timestamp` binary(14) DEFAULT NULL,
ruwiki
  `job_timestamp` binary(14) DEFAULT NULL,
  `job_token_timestamp` binary(14) DEFAULT NULL,
Marostegui updated the task description. (Show Details)Dec 14 2020, 8:21 AM
Marostegui updated the task description. (Show Details)Dec 14 2020, 12:23 PM
Marostegui updated the task description. (Show Details)Dec 14 2020, 12:28 PM
Marostegui updated the task description. (Show Details)Dec 15 2020, 9:20 AM
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)Dec 15 2020, 9:26 AM
Marostegui updated the task description. (Show Details)Dec 15 2020, 10:38 AM
Marostegui updated the task description. (Show Details)Dec 15 2020, 10:46 AM
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.Dec 15 2020, 12:09 PM
Marostegui updated the task description. (Show Details)Dec 16 2020, 6:28 AM
Marostegui added a comment.EditedDec 16 2020, 6:33 AM

s3 progress

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1004
  • db1124
  • db1123
  • db1112
  • db1095
  • db1078
  • db1075
  • clouddb1017
  • clouddb1013
Marostegui closed this task as Resolved.Dec 16 2020, 7:11 AM
Marostegui updated the task description. (Show Details)

All done

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