Page MenuHomePhabricator

Schema change for timestamp fields of jobs table
Open, MediumPublic

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.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSun, Nov 22, 12:32 AM
Marostegui triaged this task as Medium priority.Mon, Nov 23, 7:19 AM
Marostegui added a project: DBA.
Marostegui moved this task from Triage to Ready on the DBA board.