translate_reviews unsigned and revision big int
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Reedy
	Tue, May 21, 11:53 AM

Description

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Translate/+/1034471/5/sql/mysql/patch-translate_reviews-unsigned.sql
Where to run those changes: All wikis with Translate extension
When to run those changes: At any time, wikidatawiki is urgent
If the schema change is backwards compatible: Yes.
If the schema change has been tested already on some of the test/beta wikis: Not merged yet
If the data should be made available on the labs replicas and/or dumps: No changes needed

Progress

Status	Subtype	Assigned	Task
Open	Feature	None	T63111 Convert primary key integers and references thereto from int to bigint (unsigned)
Resolved	BUG REPORT	abi_	T364681 Issues with translatable pages on Wikidata due to revision id overflow
Open		None	T365445 Investigate potential signed int references to rev_id
Resolved		Marostegui	T365465 translate_reviews unsigned and revision big int

Once reviewed I will get this deployed probably directly on masters with replication as the table is small.

Mentioned in SAL (#wikimedia-operations) [2024-05-21T13:05:59Z] <marostegui> Deploy schema change on s8 eqiad with replication dbmaint T365465

Mentioned in SAL (#wikimedia-operations) [2024-05-21T13:07:18Z] <marostegui> Deploy schema change on s4 eqiad with replication dbmaint T365465

Mentioned in SAL (#wikimedia-operations) [2024-05-21T13:08:42Z] <marostegui> Deploy schema change on s7 (metawiki and frwiktionary ) eqiad with replication dbmaint T365465

Mentioned in SAL (#wikimedia-operations) [2024-05-21T13:09:39Z] <marostegui> Deploy schema change on s5 (azwikimedia wikifunctionswiki vewikimedia) eqiad with replication dbmaint T365465

Mentioned in SAL (#wikimedia-operations) [2024-05-21T13:13:01Z] <marostegui> Deploy schema change on s3 eqiad with replication dbmaint T365465

Completed