Page MenuHomePhabricator
Create Task
Maniphest T403362

Change row format of cx_corpora
Closed, ResolvedPublic
Actions

Description

After the data being compressed (T399084), now we should change the row format to default which triggers an alter and optimizes the table

Only needed on wikishared in x1.

Related Objects
Search...

Event Timeline

Ladsgroup created this task.Sep 1 2025, 8:27 AM
Restricted Application added a project: Data-Engineering. · View Herald TranscriptSep 1 2025, 8:27 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
CodeReviewBot added a project: Patch-For-Review.Sep 1 2025, 8:32 AM

ladsgroup opened https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/48

Add drop_cl_to_T402925.py

Stashbot added a comment.Sep 1 2025, 8:42 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T08:42:54Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db1179 (T403362)', diff saved to https://phabricator.wikimedia.org/P82283 and previous config saved to /var/cache/conftool/dbconfig/20250901-084254-ladsgroup.json

Ladsgroup moved this task from Triage to In progress on the DBA board.Sep 1 2025, 8:44 AM
Ladsgroup mentioned this in rSCHCH590fdbd65ac9: Add change_cx_corpora_row_format_T403362.py.Sep 1 2025, 9:03 AM
Stashbot added a comment.Sep 1 2025, 9:15 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T09:15:32Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T403362)', diff saved to https://phabricator.wikimedia.org/P82287 and previous config saved to /var/cache/conftool/dbconfig/20250901-091531-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 10:00 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T10:00:56Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T403362)', diff saved to https://phabricator.wikimedia.org/P82294 and previous config saved to /var/cache/conftool/dbconfig/20250901-100054-ladsgroup.json

Ladsgroup mentioned this in T399084: Compress data on cxc_corpora table in production.Sep 1 2025, 10:10 AM
Stashbot added a comment.Sep 1 2025, 11:47 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:47:26Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db1224 (T403362)', diff saved to https://phabricator.wikimedia.org/P82304 and previous config saved to /var/cache/conftool/dbconfig/20250901-114725-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 12:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T12:47:52Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T403362)', diff saved to https://phabricator.wikimedia.org/P82310 and previous config saved to /var/cache/conftool/dbconfig/20250901-124751-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 1:33 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T13:33:15Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T403362)', diff saved to https://phabricator.wikimedia.org/P82317 and previous config saved to /var/cache/conftool/dbconfig/20250901-133314-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 3:17 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T15:17:58Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db1237 (T403362)', diff saved to https://phabricator.wikimedia.org/P82332 and previous config saved to /var/cache/conftool/dbconfig/20250901-151757-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 3:40 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T15:40:29Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1237 (T403362)', diff saved to https://phabricator.wikimedia.org/P82334 and previous config saved to /var/cache/conftool/dbconfig/20250901-154028-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 4:25 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T16:25:53Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1237 (T403362)', diff saved to https://phabricator.wikimedia.org/P82338 and previous config saved to /var/cache/conftool/dbconfig/20250901-162552-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 6:09 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T18:09:58Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db2186 (T403362)', diff saved to https://phabricator.wikimedia.org/P82339 and previous config saved to /var/cache/conftool/dbconfig/20250901-180958-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 7:10 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T19:10:00Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2186 (T403362)', diff saved to https://phabricator.wikimedia.org/P82340 and previous config saved to /var/cache/conftool/dbconfig/20250901-190959-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 7:55 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T19:55:23Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2186 (T403362)', diff saved to https://phabricator.wikimedia.org/P82345 and previous config saved to /var/cache/conftool/dbconfig/20250901-195522-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 7:55 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T19:55:45Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db2191 (T403362)', diff saved to https://phabricator.wikimedia.org/P82346 and previous config saved to /var/cache/conftool/dbconfig/20250901-195545-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 8:55 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T20:55:12Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2191 (T403362)', diff saved to https://phabricator.wikimedia.org/P82347 and previous config saved to /var/cache/conftool/dbconfig/20250901-205511-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 9:40 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T21:40:35Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2191 (T403362)', diff saved to https://phabricator.wikimedia.org/P82351 and previous config saved to /var/cache/conftool/dbconfig/20250901-214034-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 9:40 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T21:40:58Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db2196 (T403362)', diff saved to https://phabricator.wikimedia.org/P82352 and previous config saved to /var/cache/conftool/dbconfig/20250901-214057-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 10:38 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T22:38:08Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2196 (T403362)', diff saved to https://phabricator.wikimedia.org/P82353 and previous config saved to /var/cache/conftool/dbconfig/20250901-223807-ladsgroup.json

Stashbot added a comment.Sep 1 2025, 11:23 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-01T23:23:31Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2196 (T403362)', diff saved to https://phabricator.wikimedia.org/P82356 and previous config saved to /var/cache/conftool/dbconfig/20250901-232330-ladsgroup.json

Stashbot added a comment.Sep 2 2025, 1:59 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-02T01:59:28Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db2231 (T403362)', diff saved to https://phabricator.wikimedia.org/P82357 and previous config saved to /var/cache/conftool/dbconfig/20250902-015927-ladsgroup.json

Stashbot added a comment.Sep 2 2025, 2:57 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-02T02:57:04Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2231 (T403362)', diff saved to https://phabricator.wikimedia.org/P82358 and previous config saved to /var/cache/conftool/dbconfig/20250902-025704-ladsgroup.json

Stashbot added a comment.Sep 2 2025, 3:42 AM

Mentioned in SAL (#wikimedia-operations) [2025-09-02T03:42:27Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2231 (T403362)', diff saved to https://phabricator.wikimedia.org/P82361 and previous config saved to /var/cache/conftool/dbconfig/20250902-034226-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Sep 2 2025, 11:35 AM
Ottomata moved this task from Incoming (new tickets) to Tag with Radar on the Data-Engineering board.Sep 10 2025, 4:31 PM
Ottomata added a project: Data-Engineering-Radar.
Marostegui triaged this task as Medium priority.Nov 4 2025, 11:41 AM
Marostegui subscribed.

@Ladsgroup do you want me to take over?

Ladsgroup added a comment.Nov 4 2025, 12:25 PM

It just need primary switchovers, if you want to do it, I'd be grateful.

Marostegui added a comment.Nov 4 2025, 12:28 PM
In T403362#11339611, @Ladsgroup wrote:

It just need primary switchovers, if you want to do it, I'd be grateful.

I will take care of that

Marostegui added a subtask: T409167: Switchover x1 master (db1220 -> db1237).Nov 4 2025, 12:29 PM
Marostegui added a subtask: T409168: Switchover x1 master (db2215 -> db2191).
Ladsgroup added a comment.Nov 4 2025, 12:35 PM

Thanks <3

Marostegui closed subtask T409167: Switchover x1 master (db1220 -> db1237) as Resolved.Nov 4 2025, 12:50 PM

@Ladsgroup eqiad master has been switched - I am repooling it but if you want me to depool it and you will take care of repooling back, let me know. If not, it will be fully pooled in 4 steps.

Marostegui added a comment.Nov 4 2025, 3:03 PM

It is fully repooled now

Ladsgroup added a comment.Nov 4 2025, 6:24 PM

Thanks!

Stashbot added a comment.Nov 4 2025, 7:09 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-04T19:09:47Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db1220 (T403362)', diff saved to https://phabricator.wikimedia.org/P84789 and previous config saved to /var/cache/conftool/dbconfig/20251104-190946-ladsgroup.json

Marostegui closed subtask T409168: Switchover x1 master (db2215 -> db2191) as Resolved.Nov 5 2025, 6:29 AM

@Ladsgroup codfw master has been switched at T409168: Switchover x1 master (db2215 -> db2191)

Ladsgroup added a comment.Nov 5 2025, 11:49 AM

Thanks!

Stashbot added a comment.Nov 5 2025, 11:54 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-05T11:54:38Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Depooling db2215 (T403362)', diff saved to https://phabricator.wikimedia.org/P84887 and previous config saved to /var/cache/conftool/dbconfig/20251105-115437-ladsgroup.json

Stashbot added a comment.Nov 5 2025, 2:09 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-05T14:09:35Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2215 (T403362)', diff saved to https://phabricator.wikimedia.org/P84904 and previous config saved to /var/cache/conftool/dbconfig/20251105-140934-ladsgroup.json

Stashbot added a comment.Nov 5 2025, 2:54 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-05T14:54:58Z] <ladsgroup@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2215 (T403362)', diff saved to https://phabricator.wikimedia.org/P84915 and previous config saved to /var/cache/conftool/dbconfig/20251105-145457-ladsgroup.json

Ladsgroup closed this task as Resolved.Nov 5 2025, 3:04 PM
Ladsgroup moved this task from In progress to Done on the DBA board.
Ladsgroup updated the task description. (Show Details)
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