Page MenuHomePhabricator
Create Task
Maniphest T373847

IP addresses at dewiki that cannot be unblocked
Closed, ResolvedPublicBUG REPORT
Actions

Description

The following four IP-adresses were blocked more than 15 years ago for a long time. After that, multiple admins tried to lift the block. Nevertheless, the three IPs still appear as blocked and are listed at Special:BlockList. I honestly don't know if the IP-adresses are able to edit right now, but even if they can, these blocks are really confusing and shouldn't be there anymore.

It would be nice if you could fix that. Thanks!

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
block: Clean up non-normalized IP blocksmediawiki/coremaster+126 -0
Customize query in gerrit

Related Objects

Event Timeline

TenWhile6 created this task.Sep 3 2024, 9:27 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 3 2024, 9:27 AM
TenWhile6 triaged this task as Low priority.Sep 3 2024, 9:28 AM
TenWhile6 added a project: MediaWiki-Blocks.Sep 3 2024, 9:42 AM
TenWhile6 updated the task description. (Show Details)Feb 10 2025, 11:02 PM
Restricted Application added a project: Trust and Safety Product Team. · View Herald TranscriptFeb 10 2025, 11:02 PM
Dreamy_Jazz subscribed.EditedFeb 11 2025, 1:30 PM

In the database the IPs seem to be formatted incorrectly:

  • The first IP has their bt_address column in the block_target table is 203.160.001.146.
  • The second IP in the database has three different block_target rows with a bt_address of 195.175.037.008, 195.175.037.8, and 195.175.037.08. The IP has three different block rows too (one for each block_target row)
  • The third IP has bt_address as 195.175.037.6.
  • The fourth IP has bt_address as 61.220.150.002.

This is probably what is causing the issues here.

We probably need to fix the invalid block_target rows in the database using a maintenance script, and that should allow modification of the blocks on-wiki.

Dreamy_Jazz renamed this task from unblockable IP-adresses at dewiki to IP addresses at dewiki that cannot be unblocked.Feb 11 2025, 1:34 PM
Dreamy_Jazz raised the priority of this task from Low to Medium.
Dreamy_Jazz moved this task from Inbox to Needs Triage on the Trust and Safety Product Team board.Feb 28 2025, 6:09 PM
A_smart_kitten subscribed.Mar 3 2025, 12:29 PM
Dreamy_Jazz mentioned this in T389350: Sporadic issues with IP blocks on Russian Wikipedia - issue 1.Mar 19 2025, 1:58 PM
gerritbot added a comment.Apr 24 2025, 3:26 AM

Change #1138513 had a related patch set uploaded (by Tim Starling; author: Tim Starling):

[mediawiki/core@master] block: Clean up non-normalized IP blocks

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

gerritbot added a project: Patch-For-Review.Apr 24 2025, 3:26 AM
Dreamy_Jazz assigned this task to tstarling.Apr 28 2025, 2:53 PM

Assigning per patch author.

Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Cozonac (April 14 - May 2)).Apr 28 2025, 2:54 PM

Providing code review from Trust and Safety Product Team, so added to our sprint.

Dreamy_Jazz moved this task from Priority Backlog to Needs QA on the Trust and Safety Product Sprint (Sprint Cozonac (April 14 - May 2)) board.EditedApr 28 2025, 2:54 PM

+2'd the patch. QA will be checking that the listed IPs can be unblocked once the maintenance script is run.

Dreamy_Jazz moved this task from Needs QA to In Progress on the Trust and Safety Product Sprint (Sprint Cozonac (April 14 - May 2)) board.Apr 28 2025, 2:55 PM

(Not sure which column to put it in because it's not in progress by our team specifically, though that seems the best fit given the script needs to be run before QA can happen).

gerritbot added a comment.Apr 29 2025, 9:16 AM

Change #1138513 merged by jenkins-bot:

[mediawiki/core@master] block: Clean up non-normalized IP blocks

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

Maintenance_bot removed a project: Patch-For-Review.Apr 29 2025, 9:30 AM
ReleaseTaggerBot added a project: MW-1.44-notes (1.44.0-wmf.28; 2025-05-06).Apr 29 2025, 10:00 AM
kostajh edited projects, added Trust and Safety Product Sprint (Sprint Key Lime Pie (May 5 - May 23)); removed Trust and Safety Product Sprint (Sprint Cozonac (April 14 - May 2)).May 5 2025, 6:50 AM
kostajh moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Key Lime Pie (May 5 - May 23)) board.
Dreamy_Jazz moved this task from Needs Triage to Tracking work by others on the Trust and Safety Product Team board.May 14 2025, 9:01 PM
Dreamy_Jazz removed a project: Trust and Safety Product Sprint (Sprint Key Lime Pie (May 5 - May 23)).
Stashbot added a comment.Jun 12 2025, 4:27 AM

Mentioned in SAL (#wikimedia-operations) [2025-06-12T04:27:00Z] <TimStarling> ran cleanupBlocks.php on all wikis for T373847 and T389301

Stashbot mentioned this in T389301: Clean up duplicate block_target rows in production.Jun 12 2025, 4:27 AM
tstarling added a comment.Jun 12 2025, 4:27 AM
$ mwscript-k8s --dblist=all --follow -- cleanupBlocks.php
bewiki Normalizing bt_id=310 2a00:1370:818a:bfab:718d:6e39:31d5:54d8 -> 2A00:1370:818A:BFAB:718D:6E39:31D5:54D8: done
dewiki Normalizing bt_id=20680 203.160.001.146 -> 203.160.1.146: done
dewiki Normalizing bt_id=23480 195.175.037.008 -> 195.175.37.8: done
dewiki Normalizing bt_id=23481 195.175.037.8 -> 195.175.37.8: done
dewiki Normalizing bt_id=23482 195.175.037.6 -> 195.175.37.6: done
dewiki Normalizing bt_id=23483 195.175.037.08 -> 195.175.37.8: done
dewiki Normalizing bt_id=23705 61.220.150.002 -> 61.220.150.2: done
dewiki Merging bt_id 23481,23483 into 23480: done
fawikibooks Normalizing bt_id=59 2a01:5ec0:c803:59b2:c96d:e325:48be:3936 -> 2A01:5EC0:C803:59B2:C96D:E325:48BE:3936: done
jawiki Normalizing bt_id=36971 222.165.130.082 -> 222.165.130.82: done
jawiki Normalizing bt_id=37032 210.123.039.102 -> 210.123.39.102: done
jawiki Merging bt_id 36979 into 36971: done
mlwiki Normalizing bt_id=3721 195.175.037.08 -> 195.175.37.8: done
mlwiki Normalizing bt_id=3726 195.175.037.8 -> 195.175.37.8: done
mlwiki Normalizing bt_id=3728 195.175.037.6 -> 195.175.37.6: done
mlwiki Normalizing bt_id=3742 195.175.037.008 -> 195.175.37.8: done
mlwiki Normalizing bt_id=7388 203.160.001.146 -> 203.160.1.146: done
mlwiki Normalizing bt_id=15637 61.220.150.002 -> 61.220.150.2: done
mlwiki Normalizing bt_id=25214 192.197.121.002 -> 192.197.121.2: done
mlwiki Merging bt_id 25214 into 2966: done
mlwiki Merging bt_id 3792 into 3728: done
mlwiki Merging bt_id 3726,3742,3756 into 3721: done
mlwiki Merging bt_id 25292 into 7388: done
mlwiki Merging bt_id 15641 into 15637: done
mswiki Normalizing bt_id=3992 195.175.037.008 -> 195.175.37.8: done
mswiki Normalizing bt_id=3993 195.175.037.08 -> 195.175.37.8: done
mswiki Normalizing bt_id=3998 195.175.037.6 -> 195.175.37.6: done
mswiki Normalizing bt_id=3999 195.175.037.8 -> 195.175.37.8: done
mswiki Normalizing bt_id=7774 203.160.001.146 -> 203.160.1.146: done
mswiki Normalizing bt_id=15880 61.220.150.002 -> 61.220.150.2: done
mswiki Merging bt_id 4026 into 3998: done
mswiki Merging bt_id 3993,3999,4029 into 3992: done
mswiki Merging bt_id 15881 into 15880: done
ptwiki Normalizing bt_id=17279 195.175.037.008 -> 195.175.37.8: done
ptwiki Normalizing bt_id=17301 195.175.037.8 -> 195.175.37.8: done
ptwiki Normalizing bt_id=17304 195.175.037.08 -> 195.175.37.8: done
ptwiki Normalizing bt_id=17305 195.175.037.6 -> 195.175.37.6: done
ptwiki Normalizing bt_id=18424 203.160.001.146 -> 203.160.1.146: done
ptwiki Normalizing bt_id=22404 61.220.150.002 -> 61.220.150.2: done
ptwiki Merging bt_id 17305 into 858: done
ptwiki Merging bt_id 17279,17301,17304 into 3509: done
ptwiki Merging bt_id 22404 into 11096: done
viwiki Normalizing bt_id=375 128.208.004.199 -> 128.208.4.199: done
viwiki Normalizing bt_id=558 128.208.004.197 -> 128.208.4.197: done
viwiki Normalizing bt_id=630 211.138.198.006 -> 211.138.198.6: done
viwiki Normalizing bt_id=4337 195.175.037.008 -> 195.175.37.8: done
viwiki Normalizing bt_id=4338 195.175.037.08 -> 195.175.37.8: done
viwiki Normalizing bt_id=4343 195.175.037.6 -> 195.175.37.6: done
viwiki Normalizing bt_id=4344 195.175.037.8 -> 195.175.37.8: done
viwiki Normalizing bt_id=16406 61.220.150.002 -> 61.220.150.2: done
viwiki Normalizing bt_id=27755 000.000.000.000 -> 0.0.0.0: done
viwiki Normalizing bt_id=27756 008.7.216.68 -> 8.7.216.68: done
viwiki Normalizing bt_id=27757 038.113.24.205 -> 38.113.24.205: done
viwiki Normalizing bt_id=27758 058.221.249.34 -> 58.221.249.34: done
viwiki Normalizing bt_id=27759 058.56.87.2 -> 58.56.87.2: done
viwiki Normalizing bt_id=27760 059.124.6.116 -> 59.124.6.116: done
viwiki Normalizing bt_id=27761 059.173.7.94 -> 59.173.7.94: done
viwiki Normalizing bt_id=27762 066.163.38.078 -> 66.163.38.78: done
viwiki Normalizing bt_id=27763 066.163.38.079 -> 66.163.38.79: done
viwiki Normalizing bt_id=27764 066.163.38.080 -> 66.163.38.80: done
viwiki Normalizing bt_id=27765 080.32.192.176 -> 80.32.192.176: done
viwiki Normalizing bt_id=27766 080.73.204.28 -> 80.73.204.28: done
viwiki Normalizing bt_id=27767 084.12.12.71 -> 84.12.12.71: done
viwiki Normalizing bt_id=27768 08.7.216.68 -> 8.7.216.68: done
viwiki Normalizing bt_id=28336 128.220.231.002 -> 128.220.231.2: done
viwiki Normalizing bt_id=28585 142.103.002.002 -> 142.103.2.2: done
viwiki Normalizing bt_id=28586 142.103.02.1 -> 142.103.2.1: done
viwiki Normalizing bt_id=29601 195.205.240.004 -> 195.205.240.4: done
viwiki Normalizing bt_id=36939 66.163.38.078 -> 66.163.38.78: done
viwiki Normalizing bt_id=36940 66.163.38.079 -> 66.163.38.79: done
viwiki Normalizing bt_id=36941 66.163.38.080 -> 66.163.38.80: done
viwiki Normalizing bt_id=47247 128.208.004.198 -> 128.208.4.198: done
viwiki Normalizing bt_id=47248 128.208.04.197 -> 128.208.4.197: done
viwiki Normalizing bt_id=47249 128.208.04.198 -> 128.208.4.198: done
viwiki Normalizing bt_id=47251 128.220.231.03 -> 128.220.231.3: done
viwiki Normalizing bt_id=47285 131.247.002.242 -> 131.247.2.242: done
viwiki Normalizing bt_id=47291 134.002.172.252 -> 134.2.172.252: done
viwiki Normalizing bt_id=47292 134.02.172.252 -> 134.2.172.252: done
viwiki Normalizing bt_id=47328 141.213.04.202 -> 141.213.4.202: done
viwiki Normalizing bt_id=47362 147.102.003.101 -> 147.102.3.101: done
viwiki Normalizing bt_id=47411 152.003.138.002 -> 152.3.138.2: done
viwiki Normalizing bt_id=47412 152.003.138.004 -> 152.3.138.4: done
viwiki Normalizing bt_id=47413 152.003.138.005 -> 152.3.138.5: done
viwiki Normalizing bt_id=47414 152.03.138.02 -> 152.3.138.2: done
viwiki Normalizing bt_id=47415 152.03.138.05 -> 152.3.138.5: done
viwiki Normalizing bt_id=47416 152.03.138.2 -> 152.3.138.2: done
viwiki Normalizing bt_id=48683 201.229.208.002 -> 201.229.208.2: done
viwiki Normalizing bt_id=48684 201.229.208.003 -> 201.229.208.3: done
viwiki Normalizing bt_id=49123 203.178.133.002 -> 203.178.133.2: done
viwiki Normalizing bt_id=49124 203.178.133.003 -> 203.178.133.3: done
viwiki Normalizing bt_id=49125 203.178.133.02 -> 203.178.133.2: done
viwiki Normalizing bt_id=49999 216.194.70.03 -> 216.194.70.3: done
viwiki Merging bt_id 558,47248 into 391: done
viwiki Merging bt_id 47247,47249 into 330: done
viwiki Merging bt_id 375 into 261: done
viwiki Merging bt_id 28336 into 405: done
viwiki Merging bt_id 47251 into 257: done
viwiki Merging bt_id 47285 into 453: done
viwiki Merging bt_id 47291,47292 into 452: done
viwiki Merging bt_id 47328 into 402: done
viwiki Merging bt_id 28586 into 2814: done
viwiki Merging bt_id 28585 into 2815: done
viwiki Merging bt_id 47362 into 2899: done
viwiki Merging bt_id 47411,47414,47416 into 419: done
viwiki Merging bt_id 47412 into 297: done
viwiki Merging bt_id 47413,47415 into 462: done
viwiki Merging bt_id 4380 into 4343: done
viwiki Merging bt_id 4338,4344,4383 into 4337: done
viwiki Merging bt_id 29601 into 4419: done
viwiki Merging bt_id 48685 into 48683: done
viwiki Merging bt_id 48686 into 48684: done
viwiki Merging bt_id 49123,49125 into 390: done
viwiki Merging bt_id 49124 into 342: done
viwiki Merging bt_id 32546 into 630: done
viwiki Merging bt_id 49999 into 11772: done
viwiki Merging bt_id 35656 into 27757: done
viwiki Merging bt_id 35740 into 27758: done
viwiki Merging bt_id 35779 into 27759: done
viwiki Merging bt_id 35821 into 27760: done
viwiki Merging bt_id 35873 into 27761: done
viwiki Merging bt_id 16407 into 16406: done
viwiki Merging bt_id 36939,36947 into 27762: done
viwiki Merging bt_id 36940,36948 into 27763: done
viwiki Merging bt_id 36941,36949 into 27764: done
viwiki Merging bt_id 27768,43382 into 27756: done
viwiki Merging bt_id 40359 into 27765: done
viwiki Merging bt_id 40444 into 27766: done
viwiki Merging bt_id 42804 into 27767: done
tstarling closed this task as Resolved.Jun 12 2025, 4:27 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits