Last modified: 2014-06-05 10:22:52 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 T66812, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 64812 - RecentChanges: rc_ip needs to be resized to 'varbinary(255)' for IPv6
RecentChanges: rc_ip needs to be resized to 'varbinary(255)' for IPv6
Status: NEW
Product: MediaWiki
Classification: Unclassified
Recent changes (Other open bugs)
1.24rc
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
: ipv6, schema-change
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2014-05-04 04:00 UTC by Oliver Keyes
Modified: 2014-06-05 10:22 UTC (History)
6 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Oliver Keyes 2014-05-04 04:00:57 UTC 
Or, at least, more than a 15-character varbinary. At the moment, there is a hard 15-character limit on the contents of the rc_ip field in the recentchanges table. This was fine when we were on IPv4, but IPv6 has a maximum length of 39 characters.

The result is IPv6 entries in the rc_ip field is currently being truncated, making them of little use to anyone. While the field isn't used for anything on production, it's a pretty common researcher/analyst resource.

Thankfully cu_changes.cuc_ip is a 255-char varbinary, and so the same problem is not present there.
Comment 1 Alex Monk 2014-05-04 04:04:28 UTC 
Autoblocks should also be checked, see Block::defaultRetroactiveAutoblock
Comment 2 Umherirrender 2014-05-04 18:56:35 UTC 
For mysql the field is varbinary 40, so it is okay.

Only for Oracle the field is still varchar2(15), which seems a problem.

If you are looking at wmf tables than you should fill a site request to let a database admin alter all the wikis (Check one of the newer wikis first - all after r23239, if it okay there).
Comment 3 Krinkle 2014-06-05 10:22:52 UTC 
Raising priority. Data is being truncated.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links