Page MenuHomePhabricator
Projects Schema-change-in-production

Schema-change-in-productionTag
ActivePublic
Watch Project

Members (4)

Watchers (3)

Details

Description

This is to track schema changes operation work in Wikimedia production.

Workboard: https://phabricator.wikimedia.org/project/board/1060/?filter=oIMnKhOjALmY

More info: https://wikitech.wikimedia.org/wiki/Schema_changes and https://www.mediawiki.org/wiki/Development_policy

Recent Activity
View All

Today

Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T16:51:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T352010)', diff saved to https://phabricator.wikimedia.org/P62259 and previous config saved to /var/cache/conftool/dbconfig/20240509-165141-ladsgroup.json

Thu, May 9, 4:51 PM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T15:25:02Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T364299)', diff saved to https://phabricator.wikimedia.org/P62258 and previous config saved to /var/cache/conftool/dbconfig/20240509-152501-marostegui.json

Thu, May 9, 3:25 PM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T14:39:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T364299)', diff saved to https://phabricator.wikimedia.org/P62255 and previous config saved to /var/cache/conftool/dbconfig/20240509-143938-marostegui.json

Thu, May 9, 2:40 PM · Schema-change-in-production, DBA
Marostegui added a subtask for T352010: Gradually drop old pagelinks columns: T364546: namespaceDupes is not respecting links migration stage (again).
Thu, May 9, 2:18 PM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T14:08:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2211 (T364299)', diff saved to https://phabricator.wikimedia.org/P62253 and previous config saved to /var/cache/conftool/dbconfig/20240509-140858-marostegui.json

Thu, May 9, 2:09 PM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T13:44:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2192 (T364299)', diff saved to https://phabricator.wikimedia.org/P62249 and previous config saved to /var/cache/conftool/dbconfig/20240509-134412-marostegui.json

Thu, May 9, 1:44 PM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T12:58:49Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2192 (T364299)', diff saved to Unable to send diff to phaste and previous config saved to /var/cache/conftool/dbconfig/20240509-125843-marostegui.json

Thu, May 9, 12:58 PM · Schema-change-in-production, DBA
Marostegui added a subtask for T355609: Make cuc_id a bigint: T364541: Switchover s8 master (db1209 -> db1192).
Thu, May 9, 12:47 PM · Schema-change-in-production, DBA
Marostegui added a subtask for T356166: Drop cl_collation_ext index from categorylinks in production: T364541: Switchover s8 master (db1209 -> db1192).
Thu, May 9, 12:47 PM · Schema-change-in-production, DBA
Marostegui added a subtask for T364299: Make rc_id a bigint: T364541: Switchover s8 master (db1209 -> db1192).
Thu, May 9, 12:46 PM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T11:44:18Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T364299)', diff saved to https://phabricator.wikimedia.org/P62236 and previous config saved to /var/cache/conftool/dbconfig/20240509-114417-marostegui.json

Thu, May 9, 11:44 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T11:11:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2178 (T364299)', diff saved to https://phabricator.wikimedia.org/P62233 and previous config saved to /var/cache/conftool/dbconfig/20240509-111100-marostegui.json

Thu, May 9, 11:11 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T11:10:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2171 (T364299)', diff saved to https://phabricator.wikimedia.org/P62232 and previous config saved to /var/cache/conftool/dbconfig/20240509-111037-marostegui.json

Thu, May 9, 11:10 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T10:25:12Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2171 (T364299)', diff saved to https://phabricator.wikimedia.org/P62226 and previous config saved to /var/cache/conftool/dbconfig/20240509-102512-marostegui.json

Thu, May 9, 10:25 AM · Schema-change-in-production, DBA
Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T10:00:12Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1189 (T352010)', diff saved to Unable to send diff to phaste and previous config saved to /var/cache/conftool/dbconfig/20240509-100006-ladsgroup.json

Thu, May 9, 10:00 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T09:59:44Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T352010)', diff saved to https://phabricator.wikimedia.org/P62222 and previous config saved to /var/cache/conftool/dbconfig/20240509-095943-ladsgroup.json

Thu, May 9, 9:59 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T09:53:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2171 (T364299)', diff saved to https://phabricator.wikimedia.org/P62221 and previous config saved to /var/cache/conftool/dbconfig/20240509-095313-marostegui.json

Thu, May 9, 9:53 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T09:52:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T364299)', diff saved to https://phabricator.wikimedia.org/P62220 and previous config saved to /var/cache/conftool/dbconfig/20240509-095249-marostegui.json

Thu, May 9, 9:53 AM · Schema-change-in-production, DBA
Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T09:14:14Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T352010)', diff saved to https://phabricator.wikimedia.org/P62214 and previous config saved to /var/cache/conftool/dbconfig/20240509-091413-ladsgroup.json

Thu, May 9, 9:14 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T09:07:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T364299)', diff saved to https://phabricator.wikimedia.org/P62213 and previous config saved to /var/cache/conftool/dbconfig/20240509-090726-marostegui.json

Thu, May 9, 9:07 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T08:37:06Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2157 (T364299)', diff saved to https://phabricator.wikimedia.org/P62210 and previous config saved to /var/cache/conftool/dbconfig/20240509-083705-marostegui.json

Thu, May 9, 8:37 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T08:36:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T364299)', diff saved to https://phabricator.wikimedia.org/P62209 and previous config saved to /var/cache/conftool/dbconfig/20240509-083643-marostegui.json

Thu, May 9, 8:37 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T07:51:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T364299)', diff saved to https://phabricator.wikimedia.org/P62200 and previous config saved to /var/cache/conftool/dbconfig/20240509-075118-marostegui.json

Thu, May 9, 7:51 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T07:15:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2128 (T364299)', diff saved to https://phabricator.wikimedia.org/P62190 and previous config saved to /var/cache/conftool/dbconfig/20240509-071527-marostegui.json

Thu, May 9, 7:15 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T07:14:49Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2123 (T364299)', diff saved to https://phabricator.wikimedia.org/P62189 and previous config saved to /var/cache/conftool/dbconfig/20240509-071449-marostegui.json

Thu, May 9, 7:15 AM · Schema-change-in-production, DBA
Dreamy_Jazz added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Thanks!

Thu, May 9, 7:03 AM · CheckUser, Schema-change-in-production, DBA
Marostegui added a subtask for T356166: Drop cl_collation_ext index from categorylinks in production: T364523: Switchover s6 master (db1173 -> db1231).
Thu, May 9, 6:39 AM · Schema-change-in-production, DBA
Marostegui added a subtask for T364299: Make rc_id a bigint: T364523: Switchover s6 master (db1173 -> db1231).
Thu, May 9, 6:39 AM · Schema-change-in-production, DBA
Marostegui added a subtask for T355609: Make cuc_id a bigint: T364523: Switchover s6 master (db1173 -> db1231).
Thu, May 9, 6:37 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T06:29:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2123 (T364299)', diff saved to https://phabricator.wikimedia.org/P62176 and previous config saved to /var/cache/conftool/dbconfig/20240509-062926-marostegui.json

Thu, May 9, 6:29 AM · Schema-change-in-production, DBA
Maintenance_bot moved T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis from In progress to Done on the DBA board.
Thu, May 9, 6:29 AM · CheckUser, Schema-change-in-production, DBA
Marostegui moved T364299: Make rc_id a bigint from Ready to In progress on the DBA board.
Thu, May 9, 5:57 AM · Schema-change-in-production, DBA
Marostegui updated the task description for T364299: Make rc_id a bigint.
Thu, May 9, 5:56 AM · Schema-change-in-production, DBA
Marostegui updated the task description for T364299: Make rc_id a bigint.
Thu, May 9, 5:55 AM · Schema-change-in-production, DBA
Stashbot added a comment to T364299: Make rc_id a bigint.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T05:54:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2123 (T364299)', diff saved to https://phabricator.wikimedia.org/P62168 and previous config saved to /var/cache/conftool/dbconfig/20240509-055429-marostegui.json

Thu, May 9, 5:54 AM · Schema-change-in-production, DBA
Marostegui claimed T364299: Make rc_id a bigint.
Thu, May 9, 5:54 AM · Schema-change-in-production, DBA
Marostegui closed T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis as Resolved.

This is completed

Thu, May 9, 5:51 AM · CheckUser, Schema-change-in-production, DBA
Marostegui updated the task description for T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.
Thu, May 9, 5:51 AM · CheckUser, Schema-change-in-production, DBA
Marostegui closed T364067: Switchover s6 master (db1173 -> db1231), a subtask of T352010: Gradually drop old pagelinks columns, as Declined.
Thu, May 9, 5:30 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Marostegui closed T364067: Switchover s6 master (db1173 -> db1231), a subtask of T355609: Make cuc_id a bigint, as Declined.
Thu, May 9, 5:30 AM · Schema-change-in-production, DBA
Marostegui closed T364067: Switchover s6 master (db1173 -> db1231), a subtask of T356166: Drop cl_collation_ext index from categorylinks in production, as Declined.
Thu, May 9, 5:30 AM · Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T04:39:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1235 (T361627)', diff saved to https://phabricator.wikimedia.org/P62161 and previous config saved to /var/cache/conftool/dbconfig/20240509-043908-marostegui.json

Thu, May 9, 4:39 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T04:38:45Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T361627)', diff saved to https://phabricator.wikimedia.org/P62160 and previous config saved to /var/cache/conftool/dbconfig/20240509-043845-marostegui.json

Thu, May 9, 4:38 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T03:53:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T361627)', diff saved to https://phabricator.wikimedia.org/P62157 and previous config saved to /var/cache/conftool/dbconfig/20240509-035320-marostegui.json

Thu, May 9, 3:53 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T03:41:31Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1234 (T361627)', diff saved to https://phabricator.wikimedia.org/P62156 and previous config saved to /var/cache/conftool/dbconfig/20240509-034128-marostegui.json

Thu, May 9, 3:41 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T03:41:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T361627)', diff saved to https://phabricator.wikimedia.org/P62155 and previous config saved to /var/cache/conftool/dbconfig/20240509-034105-marostegui.json

Thu, May 9, 3:41 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T02:55:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T361627)', diff saved to https://phabricator.wikimedia.org/P62152 and previous config saved to /var/cache/conftool/dbconfig/20240509-025537-marostegui.json

Thu, May 9, 2:55 AM · CheckUser, Schema-change-in-production, DBA
Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T02:45:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1175 (T352010)', diff saved to https://phabricator.wikimedia.org/P62151 and previous config saved to /var/cache/conftool/dbconfig/20240509-024531-ladsgroup.json

Thu, May 9, 2:45 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T352010: Gradually drop old pagelinks columns.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T02:45:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T352010)', diff saved to https://phabricator.wikimedia.org/P62150 and previous config saved to /var/cache/conftool/dbconfig/20240509-024508-ladsgroup.json

Thu, May 9, 2:45 AM · Schema-change-in-production, DBA, MediaWiki-Page-derived-data
Stashbot added a comment to T361627: Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis.

Mentioned in SAL (#wikimedia-operations) [2024-05-09T02:44:56Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1232 (T361627)', diff saved to https://phabricator.wikimedia.org/P62149 and previous config saved to /var/cache/conftool/dbconfig/20240509-024455-marostegui.json

Thu, May 9, 2:45 AM · CheckUser, Schema-change-in-production, DBA
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