Page MenuHomePhabricator

Duplicate rows in ipblocks table causing exceptions from ApiQueryAllUsers
Closed, ResolvedPublic

Description

Example query: https://en.wikipedia.org/w/api.php?action=query&list=allusers&aufrom=!!!%20Professional%20&aulimit=1

This is being caused by ipblocks having multiple rows with the same ipb_user.


Version: unspecified
Severity: normal

Details

Reference
bz72560

Event Timeline

bzimport raised the priority of this task from to Needs Triage.
bzimport set Reference to bz72560.
bzimport added a subscriber: Unknown Object (MLST).
Anomie created this task.Oct 27 2014, 2:47 PM

Change 168965 had a related patch set uploaded by Anomie:
Maintenance script to clean up mismatched user names in ipblocks

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

Change 168965 merged by jenkins-bot:
Maintenance script to clean up mismatched user names in ipblocks

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

Maintenance script is created, now it needs to be run.

Change 169231 had a related patch set uploaded by Aaron Schulz:
Maintenance script to clean up mismatched user names in ipblocks

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

Change 169231 merged by jenkins-bot:
Maintenance script to clean up mismatched user names in ipblocks

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