Last modified: 2014-10-28 13:23:19 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T74560, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 72560 - Duplicate rows in ipblocks table causing exceptions from ApiQueryAllUsers
Duplicate rows in ipblocks table causing exceptions from ApiQueryAllUsers
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
unspecified
All All
: Unprioritized normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-10-27 14:47 UTC by Brad Jorsch
Modified: 2014-10-28 13:23 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Brad Jorsch 2014-10-27 14:47:51 UTC
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.
Comment 1 Gerrit Notification Bot 2014-10-27 14:48:36 UTC
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
Comment 2 Gerrit Notification Bot 2014-10-27 21:00:53 UTC
Change 168965 merged by jenkins-bot:
Maintenance script to clean up mismatched user names in ipblocks

https://gerrit.wikimedia.org/r/168965
Comment 3 Brad Jorsch 2014-10-27 21:02:57 UTC
Maintenance script is created, now it needs to be run.
Comment 4 Gerrit Notification Bot 2014-10-27 22:09:17 UTC
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
Comment 5 Gerrit Notification Bot 2014-10-27 22:16:45 UTC
Change 169231 merged by jenkins-bot:
Maintenance script to clean up mismatched user names in ipblocks

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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links