Page MenuHomePhabricator

Partially failed user suppression left revisions visible, with rev_deleted=0
Open, LowPublic

Description

I've recently seen this Contributions page, and seems like the contributions page shouldn't be exist because there's not a user named as that (I've also checked from CentralAuth). I think that is a bug related with contributions page in MediaWiki software.

Event Timeline

Daimona added a subscriber: Daimona.
use enwiki_p;

select * from user where user_name like 'Keshav Malik has%'

No data available in table


select * from actor where actor_name like 'Keshav Malik has%'
actor_id	actor_user	actor_name
10494279	9300139		Keshav Malik has a Wikipēdia article.
10501654	9307510		Keshav Malik has a wiki article
10493217	9299073		Keshav Malik has a wiki article.

select * from user where user_id in ( 9300139, 9307510, 9299073 )

No data available in table


WTF???

Not sure what might have caused it, if there's something with the actor migration or a pre-existing issue. It's also unclear why we're seeing the same problem for these 3 specific, similar accounts.

At least the usernames seemingly can't be registered.

Can some steward confirm that whether account is globally hidden or oversighted?

actor_id	actor_user	actor_name
10494279	9300139		Keshav Malik has a Wikipēdia article.
10501654	9307510		Keshav Malik has a wiki article
10493217	9299073		Keshav Malik has a wiki article.

All three are locked and hidden.

I'm pretty sure this is not expected behaviour. I've seen a user (not mentioning his username as it is highly abusive) that was hidden, and while his central auth showed that "there is no global account", the local contributions page didn't and only presented the block notice.

User suppression is supposed to set the DELETED_RESTRICTED bit in rev_deleted, but rev_deleted is 0 in this case. But are we really talking about a suppression from 2009? The logs have been purged, I can't investigate a possible failed suppression from 2009. If there's not a lot of affected revisions, you can just suppress them manually.

tstarling renamed this task from User contributions with a non-existent user to Partially failed user suppression left some revisions visible, with rev_deleted=0.Mar 9 2021, 10:35 PM
tstarling renamed this task from Partially failed user suppression left some revisions visible, with rev_deleted=0 to Partially failed user suppression left revisions visible, with rev_deleted=0.

The relevant user (user_id=9299073) only has the one revision, there are no suppressed revisions for that user. I'm not sure how the transaction got split up, since neither the current code nor the code in MW 1.15 seems to have explicit transactions, so you would think there would be one transaction covering both the ipblocks insertion and the revision update. It wasn't a race between a new edit and a suppression: the edit occurred at 04:56 and the suppression was at 10:46.

There is something similar at https://en.wikipedia.org/wiki/Wikipedia:Village_pump_(technical)#Account_not_registered? - one is the username at https://en.wikipedia.org/w/index.php?title=Cinema_Center_Films&diff=1014954537&oldid=1014951850 which still has contributions but is hidden, the other is the same username with three additional L's on the end, where it shows the account as existing and blocked (it has no edits) but there is no global account. User IDs are 41529844 and 41530100.