Nothing Special   »   [go: up one dir, main page]
Page MenuHomePhabricator
Create Task
Maniphest T270055

Schema change for timestamp field of uploadstash
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/+/649102/2/maintenance/archives/patch-uploadstash-us_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

Turning it from VARBINARY(14) to BINARY(14)

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • wikitech
  • labtestwiki

Related Objects

Event Timeline

Ladsgroup created this task.Dec 13 2020, 7:30 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 13 2020, 7:30 PM
LSobanski triaged this task as Medium priority.Dec 14 2020, 10:22 AM
LSobanski moved this task from Triage to Ready on the DBA board.
LSobanski subscribed.
Marostegui claimed this task.Jan 21 2021, 7:34 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jan 21 2021, 7:39 AM

Altered db2114 on s6, leaving it for a few hours to make sure nothing breaks (even if the table is empty there)

# for i in frwiki jawiki ruwiki; do mysql.py -hdb2114 $i -e "show create table uploadstash\G" | grep us_timestamp ; done
  `us_timestamp` binary(14) NOT NULL,
  KEY `us_timestamp` (`us_timestamp`)
  `us_timestamp` binary(14) NOT NULL,
  KEY `us_timestamp` (`us_timestamp`)
  `us_timestamp` binary(14) NOT NULL,
  KEY `us_timestamp` (`us_timestamp`)
Marostegui moved this task from Ready to In progress on the DBA board.Jan 21 2021, 7:40 AM
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.
Marostegui updated the task description. (Show Details)Jan 21 2021, 1:34 PM
Marostegui updated the task description. (Show Details)Jan 21 2021, 3:30 PM
Marostegui updated the task description. (Show Details)Jan 21 2021, 3:50 PM
Marostegui updated the task description. (Show Details)Jan 22 2021, 6:33 AM
Marostegui updated the task description. (Show Details)Jan 22 2021, 6:44 AM
Marostegui updated the task description. (Show Details)Jan 22 2021, 6:58 AM
Marostegui updated the task description. (Show Details)Jan 22 2021, 7:38 AM
Marostegui updated the task description. (Show Details)Jan 25 2021, 6:39 AM
Stashbot added a comment.Jan 27 2021, 5:50 AM

Mentioned in SAL (#wikimedia-operations) [2021-01-27T05:50:03Z] <marostegui> Deploy schema change on s3 T270055

Marostegui closed this task as Resolved.Jan 28 2021, 6:10 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 · Credits