Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:50:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86380 and previous config saved to /var/cache/conftool/dbconfig/20251203-135000-marostegui.json

Wed, Dec 3, 1:50 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 1:50 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:04:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86375 and previous config saved to /var/cache/conftool/dbconfig/20251203-130437-marostegui.json

Wed, Dec 3, 1:04 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 1:04 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:00:02Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86374 and previous config saved to /var/cache/conftool/dbconfig/20251203-130002-marostegui.json

Wed, Dec 3, 1:00 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 1:00 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:59:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86373 and previous config saved to /var/cache/conftool/dbconfig/20251203-125938-marostegui.json

Wed, Dec 3, 12:59 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 12:59 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:14:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86367 and previous config saved to /var/cache/conftool/dbconfig/20251203-121409-marostegui.json

Wed, Dec 3, 12:14 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 12:14 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:09:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86366 and previous config saved to /var/cache/conftool/dbconfig/20251203-120933-marostegui.json

Wed, Dec 3, 12:09 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 12:09 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:09:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86365 and previous config saved to /var/cache/conftool/dbconfig/20251203-120909-marostegui.json

Wed, Dec 3, 12:09 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 12:09 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:23:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86362 and previous config saved to /var/cache/conftool/dbconfig/20251203-112345-marostegui.json

Wed, Dec 3, 11:23 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 11:23 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:19:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86361 and previous config saved to /var/cache/conftool/dbconfig/20251203-111910-marostegui.json

Wed, Dec 3, 11:19 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 11:19 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:18:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86360 and previous config saved to /var/cache/conftool/dbconfig/20251203-111846-marostegui.json

Wed, Dec 3, 11:18 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 11:18 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T10:33:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86357 and previous config saved to /var/cache/conftool/dbconfig/20251203-103323-marostegui.json

Wed, Dec 3, 10:33 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 10:33 AM · Data-Engineering, Schema-change-in-production, DBA

Ladsgroup updated the task description for T411497: Drop modtoken and flags from cache tables.

Wed, Dec 3, 6:22 AM · Schema-change-in-production, Data-Engineering, DBA

ops-monitoring-bot added a comment to T411497: Drop modtoken and flags from cache tables.

Depooled pc1011.eqiad.wmnet and pc2011.codfw.wmnet Schema change - marostegui@cumin1003 - T411497

Wed, Dec 3, 6:15 AM · Schema-change-in-production, Data-Engineering, DBA

ops-monitoring-bot added a comment to T411497: Drop modtoken and flags from cache tables.

Depooled pc1011.eqiad.wmnet and pc2011.codfw.wmnet Schema change - marostegui@cumin1003 - T411497

Wed, Dec 3, 6:15 AM · Schema-change-in-production, Data-Engineering, DBA

Marostegui added a comment to T411497: Drop modtoken and flags from cache tables.

Of course this needs depooling for each alter as the table is around 50G

Wed, Dec 3, 6:13 AM · Schema-change-in-production, Data-Engineering, DBA

Ladsgroup added a comment to T411497: Drop modtoken and flags from cache tables.

In T411497#11426803, @Marostegui wrote:

Thank you both. After @Krinkle's message above, I am not sure whether I can proceed deleting them on parsercache or I should wait until the code is cleaned up?

Wed, Dec 3, 6:05 AM · Schema-change-in-production, Data-Engineering, DBA

Marostegui moved T411497: Drop modtoken and flags from cache tables from Triage to In progress on the DBA board.

Wed, Dec 3, 5:59 AM · Schema-change-in-production, Data-Engineering, DBA

Marostegui added a comment to T411497: Drop modtoken and flags from cache tables.

For the ALTER I will just proceed on msX for now.

Wed, Dec 3, 5:59 AM · Schema-change-in-production, Data-Engineering, DBA

Marostegui added a comment to T411497: Drop modtoken and flags from cache tables.

Thank you both. After @Krinkle's message above, I am not sure whether I can proceed deleting them (on both parsercache and ms*) or I should wait until the code is cleaned up?

Wed, Dec 3, 5:58 AM · Schema-change-in-production, Data-Engineering, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T05:44:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86343 and previous config saved to /var/cache/conftool/dbconfig/20251203-054438-marostegui.json

Wed, Dec 3, 5:44 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 5:44 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T05:44:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86342 and previous config saved to /var/cache/conftool/dbconfig/20251203-054414-marostegui.json

Wed, Dec 3, 5:44 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 5:44 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-03T04:58:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86339 and previous config saved to /var/cache/conftool/dbconfig/20251203-045851-marostegui.json

Wed, Dec 3, 4:59 AM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 4:58 AM · Data-Engineering, Schema-change-in-production, DBA

Marostegui updated the task description for T411164: Drop rev_sha1 from revision table in wmf production.

Wed, Dec 3, 4:56 AM · Data-Engineering, Schema-change-in-production, DBA

Marostegui updated the task description for T411163: Drop ar_sha1 from archive table in wmf production.

Wed, Dec 3, 4:56 AM · Data-Engineering, Schema-change-in-production, DBA

Tue, Dec 2

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-02T23:43:57Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86337 and previous config saved to /var/cache/conftool/dbconfig/20251202-234356-marostegui.json

Tue, Dec 2, 11:44 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Tue, Dec 2, 11:44 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-02T23:43:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86336 and previous config saved to /var/cache/conftool/dbconfig/20251202-234332-marostegui.json

Tue, Dec 2, 11:43 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Tue, Dec 2, 11:43 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-02T22:58:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86333 and previous config saved to /var/cache/conftool/dbconfig/20251202-225809-marostegui.json

Tue, Dec 2, 10:58 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Tue, Dec 2, 10:58 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411164: Drop rev_sha1 from revision table in wmf production.

Mentioned in SAL (#wikimedia-operations) [2025-12-02T22:51:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1212 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86332 and previous config saved to /var/cache/conftool/dbconfig/20251202-225122-marostegui.json

Tue, Dec 2, 10:51 PM · Data-Engineering, Schema-change-in-production, DBA

Stashbot added a comment to T411163: Drop ar_sha1 from archive table in wmf production.

Tue, Dec 2, 10:51 PM · Data-Engineering, Schema-change-in-production, DBA

Schema-change-in-productionTagActivePublicWatch Project

Members (4)

Watchers (4)

Details

Recent ActivityView All

Today

Yesterday

Tue, Dec 2

Schema-change-in-productionTag
ActivePublic
Watch Project

Recent Activity
View All