Page MenuHomePhabricator
Create Task
Maniphest T348183

Apply schema change for changing img_size, oi_size, us_size, and fa_size to BIGINT
Closed, ResolvedPublic
Actions

Description

Per T191805

We want to change the db fields that store a file size to be 64-bit integers. Please apply the following 4 schema changes on all wikis.

This change is backwards compatible.
dc-masters don't need switchover (except on s4)

Progress:

  • s1
  • s2
  • s3:
  • s4: will be done around 13:00 today
  • s5
  • s6
  • s7
  • s8: Done
  • labstestwiki

Details

SubjectRepoBranchLines +/-
homedir: add tmux.confoperations/puppetproduction+1 -0
auto_schema: add T348183.pyoperations/softwaremaster+71 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Dec 5 2023, 8:31 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T20:31:36Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T348183)', diff saved to https://phabricator.wikimedia.org/P54203 and previous config saved to /var/cache/conftool/dbconfig/20231205-203136-arnaudb.json

Stashbot added a comment.Dec 5 2023, 8:31 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T20:31:58Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db1219 (T348183)', diff saved to https://phabricator.wikimedia.org/P54204 and previous config saved to /var/cache/conftool/dbconfig/20231205-203158-arnaudb.json

Stashbot added a comment.Dec 5 2023, 8:41 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T20:41:48Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T348183)', diff saved to https://phabricator.wikimedia.org/P54205 and previous config saved to /var/cache/conftool/dbconfig/20231205-204147-arnaudb.json

Stashbot added a comment.Dec 5 2023, 9:27 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T21:27:07Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T348183)', diff saved to https://phabricator.wikimedia.org/P54208 and previous config saved to /var/cache/conftool/dbconfig/20231205-212707-arnaudb.json

Stashbot added a comment.Dec 5 2023, 9:51 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T21:51:36Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2116 (T348183)', diff saved to https://phabricator.wikimedia.org/P54209 and previous config saved to /var/cache/conftool/dbconfig/20231205-215135-arnaudb.json

Stashbot added a comment.Dec 5 2023, 10:02 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T22:02:57Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T348183)', diff saved to https://phabricator.wikimedia.org/P54210 and previous config saved to /var/cache/conftool/dbconfig/20231205-220256-arnaudb.json

Stashbot added a comment.Dec 5 2023, 10:48 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T22:48:17Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T348183)', diff saved to https://phabricator.wikimedia.org/P54213 and previous config saved to /var/cache/conftool/dbconfig/20231205-224816-arnaudb.json

Stashbot added a comment.Dec 5 2023, 10:48 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T22:48:39Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2130 (T348183)', diff saved to https://phabricator.wikimedia.org/P54214 and previous config saved to /var/cache/conftool/dbconfig/20231205-224838-arnaudb.json

Stashbot added a comment.Dec 5 2023, 10:59 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T22:59:06Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T348183)', diff saved to https://phabricator.wikimedia.org/P54215 and previous config saved to /var/cache/conftool/dbconfig/20231205-225905-arnaudb.json

Stashbot added a comment.Dec 5 2023, 11:44 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T23:44:26Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T348183)', diff saved to https://phabricator.wikimedia.org/P54218 and previous config saved to /var/cache/conftool/dbconfig/20231205-234425-arnaudb.json

Stashbot added a comment.Dec 5 2023, 11:52 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-05T23:52:13Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2145 (T348183)', diff saved to https://phabricator.wikimedia.org/P54219 and previous config saved to /var/cache/conftool/dbconfig/20231205-235213-arnaudb.json

Stashbot added a comment.Dec 6 2023, 12:02 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T00:02:36Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T348183)', diff saved to https://phabricator.wikimedia.org/P54220 and previous config saved to /var/cache/conftool/dbconfig/20231206-000236-arnaudb.json

Stashbot added a comment.Dec 6 2023, 12:47 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T00:47:56Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T348183)', diff saved to https://phabricator.wikimedia.org/P54223 and previous config saved to /var/cache/conftool/dbconfig/20231206-004756-arnaudb.json

Stashbot added a comment.Dec 6 2023, 12:48 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T00:48:20Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2146 (T348183)', diff saved to https://phabricator.wikimedia.org/P54224 and previous config saved to /var/cache/conftool/dbconfig/20231206-004820-arnaudb.json

Stashbot added a comment.Dec 6 2023, 12:59 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T00:59:24Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T348183)', diff saved to https://phabricator.wikimedia.org/P54225 and previous config saved to /var/cache/conftool/dbconfig/20231206-005923-arnaudb.json

Stashbot added a comment.Dec 6 2023, 1:44 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T01:44:43Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T348183)', diff saved to https://phabricator.wikimedia.org/P54228 and previous config saved to /var/cache/conftool/dbconfig/20231206-014443-arnaudb.json

Stashbot added a comment.Dec 6 2023, 1:45 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T01:45:07Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T348183)', diff saved to https://phabricator.wikimedia.org/P54229 and previous config saved to /var/cache/conftool/dbconfig/20231206-014506-arnaudb.json

Stashbot added a comment.Dec 6 2023, 1:55 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T01:55:19Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T348183)', diff saved to https://phabricator.wikimedia.org/P54230 and previous config saved to /var/cache/conftool/dbconfig/20231206-015519-arnaudb.json

Stashbot added a comment.Dec 6 2023, 2:40 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T02:40:45Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T348183)', diff saved to https://phabricator.wikimedia.org/P54233 and previous config saved to /var/cache/conftool/dbconfig/20231206-024045-arnaudb.json

Stashbot added a comment.Dec 6 2023, 2:41 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T02:41:08Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54234 and previous config saved to /var/cache/conftool/dbconfig/20231206-024108-arnaudb.json

Stashbot added a comment.Dec 6 2023, 2:55 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T02:55:03Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54235 and previous config saved to /var/cache/conftool/dbconfig/20231206-025503-arnaudb.json

Stashbot added a comment.Dec 6 2023, 3:40 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T03:40:23Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54238 and previous config saved to /var/cache/conftool/dbconfig/20231206-034022-arnaudb.json

Stashbot added a comment.Dec 6 2023, 3:40 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T03:40:46Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54239 and previous config saved to /var/cache/conftool/dbconfig/20231206-034045-arnaudb.json

Stashbot added a comment.Dec 6 2023, 3:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T03:51:19Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54240 and previous config saved to /var/cache/conftool/dbconfig/20231206-035119-arnaudb.json

Stashbot added a comment.Dec 6 2023, 4:36 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T04:36:39Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T348183)', diff saved to https://phabricator.wikimedia.org/P54243 and previous config saved to /var/cache/conftool/dbconfig/20231206-043638-arnaudb.json

Stashbot added a comment.Dec 6 2023, 4:37 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T04:37:19Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T348183)', diff saved to https://phabricator.wikimedia.org/P54244 and previous config saved to /var/cache/conftool/dbconfig/20231206-043718-arnaudb.json

Stashbot added a comment.Dec 6 2023, 4:47 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T04:47:37Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T348183)', diff saved to https://phabricator.wikimedia.org/P54245 and previous config saved to /var/cache/conftool/dbconfig/20231206-044737-arnaudb.json

Stashbot added a comment.Dec 6 2023, 5:32 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T05:32:57Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T348183)', diff saved to https://phabricator.wikimedia.org/P54248 and previous config saved to /var/cache/conftool/dbconfig/20231206-053256-arnaudb.json

Stashbot added a comment.Dec 6 2023, 5:33 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T05:33:22Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T348183)', diff saved to https://phabricator.wikimedia.org/P54249 and previous config saved to /var/cache/conftool/dbconfig/20231206-053321-arnaudb.json

Stashbot added a comment.Dec 6 2023, 5:43 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T05:43:40Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T348183)', diff saved to https://phabricator.wikimedia.org/P54250 and previous config saved to /var/cache/conftool/dbconfig/20231206-054339-arnaudb.json

Stashbot added a comment.Dec 6 2023, 6:29 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T06:29:00Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T348183)', diff saved to https://phabricator.wikimedia.org/P54254 and previous config saved to /var/cache/conftool/dbconfig/20231206-062859-arnaudb.json

Stashbot added a comment.Dec 6 2023, 6:29 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T06:29:24Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T348183)', diff saved to https://phabricator.wikimedia.org/P54255 and previous config saved to /var/cache/conftool/dbconfig/20231206-062922-arnaudb.json

Stashbot added a comment.Dec 6 2023, 7:07 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T07:07:50Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T348183)', diff saved to https://phabricator.wikimedia.org/P54256 and previous config saved to /var/cache/conftool/dbconfig/20231206-070749-arnaudb.json

Stashbot added a comment.Dec 6 2023, 7:53 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T07:53:10Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T348183)', diff saved to https://phabricator.wikimedia.org/P54259 and previous config saved to /var/cache/conftool/dbconfig/20231206-075309-arnaudb.json

Stashbot added a comment.Dec 6 2023, 7:53 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T07:53:33Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2188 (T348183)', diff saved to https://phabricator.wikimedia.org/P54260 and previous config saved to /var/cache/conftool/dbconfig/20231206-075333-arnaudb.json

Stashbot added a comment.Dec 6 2023, 8:04 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T08:04:09Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T348183)', diff saved to https://phabricator.wikimedia.org/P54261 and previous config saved to /var/cache/conftool/dbconfig/20231206-080409-arnaudb.json

Stashbot added a comment.Dec 6 2023, 8:49 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-06T08:49:29Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T348183)', diff saved to https://phabricator.wikimedia.org/P54264 and previous config saved to /var/cache/conftool/dbconfig/20231206-084928-arnaudb.json

ABran-WMF updated the task description. (Show Details)Dec 7 2023, 10:01 AM
ABran-WMF updated the task description. (Show Details)Dec 7 2023, 10:50 AM
ABran-WMF updated the task description. (Show Details)Dec 7 2023, 11:31 AM
ABran-WMF updated the task description. (Show Details)Dec 7 2023, 3:04 PM
Stashbot added a comment.Dec 7 2023, 3:07 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T15:07:51Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db2104 (T348183)', diff saved to https://phabricator.wikimedia.org/P54270 and previous config saved to /var/cache/conftool/dbconfig/20231207-150750-arnaudb.json

Stashbot added a comment.Dec 7 2023, 3:11 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T15:11:53Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2104 (T348183)', diff saved to https://phabricator.wikimedia.org/P54271 and previous config saved to /var/cache/conftool/dbconfig/20231207-151152-arnaudb.json

Stashbot added a comment.Dec 7 2023, 3:57 PM

Mentioned in SAL (#wikimedia-operations) [2023-12-07T15:57:13Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2104 (T348183)', diff saved to https://phabricator.wikimedia.org/P54274 and previous config saved to /var/cache/conftool/dbconfig/20231207-155712-arnaudb.json

ABran-WMF updated the task description. (Show Details)Dec 8 2023, 9:14 AM
Stashbot added a comment.Dec 8 2023, 9:16 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T09:16:29Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Depooling db1206 (T348183)', diff saved to https://phabricator.wikimedia.org/P54318 and previous config saved to /var/cache/conftool/dbconfig/20231208-091628-arnaudb.json

Stashbot added a comment.Dec 8 2023, 9:28 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T09:28:18Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T348183)', diff saved to https://phabricator.wikimedia.org/P54319 and previous config saved to /var/cache/conftool/dbconfig/20231208-092817-arnaudb.json

Stashbot added a comment.Dec 8 2023, 10:13 AM

Mentioned in SAL (#wikimedia-operations) [2023-12-08T10:13:37Z] <arnaudb@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T348183)', diff saved to https://phabricator.wikimedia.org/P54322 and previous config saved to /var/cache/conftool/dbconfig/20231208-101337-arnaudb.json

ABran-WMF updated the task description. (Show Details)Dec 11 2023, 3:37 PM
ABran-WMF changed the task status from Open to In Progress.Dec 20 2023, 3:42 PM
Marostegui subscribed.Jan 29 2024, 2:35 PM

labtestwiki host can be done anytime

ssh clouddb2002-dev.codfw.wmnet
sudo mysql -A labtestwiki

And run the statement there just like that.

ABran-WMF updated the task description. (Show Details)Feb 8 2024, 7:41 AM
ABran-WMF closed this task as Resolved.Feb 8 2024, 1:14 PM
ABran-WMF updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Feb 8 2024, 1:29 PM
Bawolff added a comment.Feb 8 2024, 7:06 PM

Thank you for all your work on this :)

ABran-WMF awarded a token.Feb 9 2024, 7:42 AM
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