Make page_restrictions.pr_page unsigned on wmf wikis
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Jan 28 2022, 4:22 PM

Description

Apply T297212 to wmf wikis

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/742820/10/maintenance/archives/patch-page_restrictions-pr_page.sql
Where to run those changes: all.dblist
When to run those changes: any time
If the schema change is backwards compatible: Yes
If the schema change has been tested already on some of the test/beta wikis: Tested in beta cluster.
if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress:

Details

	Subject	Repo	Branch	Lines +/-
	change_pr_page_T300380.py: New schema change	operations/software/schema-changes	master	+41 -0

Customize query in gerrit

Related Objects

Mentioned In: rSCHCH8127d0f1538e: change_pr_page_T300380.py: New schema change
Mentioned Here: T297212: Make core database fields which references to page_id unsigned in mysql and sqlite

Event Timeline

Umherirrender created this task.Jan 28 2022, 4:22 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 28 2022, 4:22 PM

Umherirrender triaged this task as Lowest priority.Jan 28 2022, 4:24 PM

• Marostegui moved this task from Triage to Ready on the DBA board.Jan 31 2022, 5:52 AM

Change 769384 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software/schema-changes@master] change_page_id_T300380.py: New schema change

https://gerrit.wikimedia.org/r/769384

• Marostegui claimed this task.Mar 9 2022, 7:29 AM

gerritbot added a project: Patch-For-Review.Mar 9 2022, 7:29 AM

• Marostegui updated the task description. (Show Details)Mar 9 2022, 7:32 AM

• Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.

• Marostegui moved this task from Ready to In progress on the DBA board.

• Marostegui updated the task description. (Show Details)Mar 9 2022, 7:37 AM

• Marostegui updated the task description. (Show Details)Mar 9 2022, 7:41 AM

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:41:57Z] <marostegui> dbmaint on s1 T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:42:07Z] <marostegui> dbmaint on s6 T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:42:10Z] <marostegui> dbmaint on s5 T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:42:26Z] <marostegui> dbmaint on s5@eqiad T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:42:29Z] <marostegui> dbmaint on s6@eqiad T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:42:31Z] <marostegui> dbmaint on s1@eqiad T300380

• Marostegui updated the task description. (Show Details)Mar 9 2022, 7:46 AM

• Marostegui updated the task description. (Show Details)Mar 9 2022, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:49:52Z] <marostegui> dbmaint on s4@eqiad T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:49:55Z] <marostegui> dbmaint on s8@eqiad T300380

Mentioned in SAL (#wikimedia-operations) [2022-03-09T07:55:27Z] <marostegui> dbmaint on s2@eqiad T300380

• Marostegui updated the task description. (Show Details)Mar 9 2022, 8:11 AM

Mentioned in SAL (#wikimedia-operations) [2022-03-09T08:11:52Z] <marostegui> dbmaint on s7@eqiad T300380

• Marostegui updated the task description. (Show Details)Mar 9 2022, 8:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-03-09T08:21:02Z] <marostegui> dbmaint on s3@eqiad T300380

• Marostegui updated the task description. (Show Details)Mar 9 2022, 8:27 AM

Change 769384 merged by jenkins-bot:

[operations/software/schema-changes@master] change_pr_page_T300380.py: New schema change

https://gerrit.wikimedia.org/r/769384

• Marostegui mentioned this in rSCHCH8127d0f1538e: change_pr_page_T300380.py: New schema change.Mar 9 2022, 10:42 AM

Maintenance_bot removed a project: Patch-For-Review.Mar 9 2022, 11:10 AM

All done

Maintenance_bot moved this task from In progress to Done on the DBA board.Mar 9 2022, 2:15 PM

Make page_restrictions.pr_page unsigned on wmf wikisClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Make page_restrictions.pr_page unsigned on wmf wikis
Closed, ResolvedPublic
Actions