Create a maintenance script for populating the local_user_id and global_user_id fields in the centralauth localuser table
Closed, ResolvedPublic5 Estimated Story Points
Actions

Assigned To

Authored By

	kaldari
	Aug 9 2016, 5:40 PM

Description

Once T141951 is done, we'll need to run a maintenance script to fill in the data for the existing users in the centralauth database.

This task is to write a batched maintenance script for that purpose.

Details

	Subject	Repo	Branch	Lines +/-
	Populate local and global ids in localuser table	mediawiki/extensions/CentralAuth	master	+62 -0

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Open	Feature	None	T66475 Make crosswiki bits and pieces truly global (tracking)
Open	Feature	None	T5525 Cross-wiki watchlists
Open		None	T148243 Add indices for local_user_id and global_user_id in production
Resolved		Niharika	T148242 Fully populate local_user_id and global_user_id fields in production
Declined		None	T148239 Add indices for local_user_id and global_user_id in Beta
Resolved		Niharika	T148241 Fully populate local_user_id and global_user_id fields in Beta
Resolved		Niharika	T142503 Create a maintenance script for populating the local_user_id and global_user_id fields in the centralauth localuser table
Resolved		Marostegui	T141951 Add local_user_id and global_user_id fields to localuser table in centralauth database

Event Timeline

kaldari created this task.Aug 9 2016, 5:40 PM

• DannyH triaged this task as Medium priority.Aug 9 2016, 5:40 PM

• DannyH moved this task from New & TBD Tickets to Needs Discussion on the Community-Tech board.

• DannyH set the point value for this task to 5.Aug 9 2016, 5:43 PM

• DannyH moved this task from Needs Discussion to Up Next (June 3-21) on the Community-Tech board.

bd808 edited parent tasks, added: T126641: [RFC] Devise plan for a cross-wiki watchlist back-end; removed: T141951: Add local_user_id and global_user_id fields to localuser table in centralauth database.Aug 15 2016, 3:25 PM

bd808 added a subtask: T141951: Add local_user_id and global_user_id fields to localuser table in centralauth database.

kaldari edited parent tasks, added: T5525: Cross-wiki watchlists; removed: T126641: [RFC] Devise plan for a cross-wiki watchlist back-end.Aug 15 2016, 6:51 PM

kaldari edited projects, added Community-Tech-Sprint; removed Community-Tech.Aug 30 2016, 5:18 PM

Niharika claimed this task.Sep 2 2016, 1:37 PM

Niharika moved this task from Ready to In Development on the Community-Tech-Sprint board.

Niharika mentioned this in T141951: Add local_user_id and global_user_id fields to localuser table in centralauth database.Sep 8 2016, 5:31 PM

Moving this to Ready and working on T142507: Have CentralAuth populate the local_user_id and global_user_id columns as new users are attached first per Legoktm's code review:

I would suggest 3 patches: 1) schema change 2) update code to populate the fields whenever it writes those rows (account creation) 3) a maintenance script to back-populate everything that already exists.

Marostegui closed subtask T141951: Add local_user_id and global_user_id fields to localuser table in centralauth database as Resolved.Sep 23 2016, 7:10 AM

• Lea_WMDE mentioned this in T140462: Correctly move files from Wikipedia to Commons (2013).Oct 7 2016, 2:02 PM

• Mattflaschen-WMF mentioned this in T148241: Fully populate local_user_id and global_user_id fields in Beta.Oct 14 2016, 8:17 PM

• Mattflaschen-WMF mentioned this in T148242: Fully populate local_user_id and global_user_id fields in production.

• Mattflaschen-WMF added a parent task: T148241: Fully populate local_user_id and global_user_id fields in Beta.

• Mattflaschen-WMF added a parent task: T148242: Fully populate local_user_id and global_user_id fields in production.Oct 14 2016, 8:19 PM

Niharika moved this task from Ready to In Development on the Community-Tech-Sprint board.Oct 17 2016, 1:15 PM

Change 316375 had a related patch set uploaded (by Niharika29):
[WIP] Populate local and global ids in localuser table

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

gerritbot added a project: Patch-For-Review.Oct 17 2016, 4:22 PM

Niharika moved this task from In Development to Needs Review/Feedback on the Community-Tech-Sprint board.Oct 21 2016, 1:21 PM

kaldari closed this task as Resolved.Oct 27 2016, 4:38 AM