Page MenuHomePhabricator
Create Task
Maniphest T112369

Revisions where rev_user_text differs from user_name
Closed, InvalidPublic
Actions

Description

While looking into T111605 I saw that, at least on de.wiki, there are multiple revisions where rev_user_text doesn't agree with user_name. They seem to be renamed users, no idea whether it has to do with import or not.

Cf. T47746: Partial rename for specific user on collabwiki

MariaDB [dewiki_p]> SELECT rev_id, rev_user_text, user_name FROM revision JOIN logging ON rev_page = log_page AND log_type = 'import' JOIN user ON user_id = rev_user AND user_name <> rev_user_text WHERE rev_user > 0 AND rev_user_text NOT RLIKE '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})' AND rev_page > 0 AND rev_timestamp < log_timestamp;
+----------+------------------+----------------+
| rev_id   | rev_user_text    | user_name      |
+----------+------------------+----------------+
| 65704381 | Justbridge       | Justus Brücke  |
| 65704381 | Justbridge       | Justus Brücke  |
| 70359432 | Daniele Pugliesi | Aushulz        |
| 71300545 | Justbridge       | Justus Brücke  |
| 71055673 | Onee             | O.Koslowski    |
| 71552070 | Wolf32at         | DerGraueWolf   |
| 71565974 | Justbridge       | Justus Brücke  |
| 72031462 | Schomynv         | Mme Mim        |
| 71521249 | Wolf32at         | DerGraueWolf   |
| 72188986 | Justbridge       | Justus Brücke  |
| 72189041 | Justbridge       | Justus Brücke  |
| 76268012 | Daniele Pugliesi | Aushulz        |
| 80066897 | Wolf32at         | DerGraueWolf   |
| 80104475 | Wolf32at         | DerGraueWolf   |
| 80104490 | Wolf32at         | DerGraueWolf   |
| 80275224 | Wolf32at         | DerGraueWolf   |
| 81711131 | Schomynv         | Mme Mim        |
| 82198242 | Wolf32at         | DerGraueWolf   |
| 82696379 | Onee             | O.Koslowski    |
| 82161477 | Wolf32at         | DerGraueWolf   |
| 83372859 | Schomynv         | Mme Mim        |
| 84881377 | Daniele Pugliesi | Aushulz        |
| 84881378 | Daniele Pugliesi | Aushulz        |
| 71243433 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88838955 | Wolf32at         | DerGraueWolf   |
| 88838955 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90470725 | Wolf32at         | DerGraueWolf   |
| 90470725 | Wolf32at         | DerGraueWolf   |
| 71309622 | Justbridge       | Justus Brücke  |
| 94168877 | Wolf32at         | DerGraueWolf   |
| 94168879 | Wolf32at         | DerGraueWolf   |
| 94169816 | Wolf32at         | DerGraueWolf   |
| 94169818 | Wolf32at         | DerGraueWolf   |
| 94751417 | Wolf32at         | DerGraueWolf   |
| 95715586 | GoAvs            | Avaholic       |
| 98491034 | Schomynv         | Mme Mim        |
| 99800361 | Daniele Pugliesi | Aushulz        |
| 99800362 | Daniele Pugliesi | Aushulz        |
| 99800365 | Daniele Pugliesi | Aushulz        |
| 70093631 | Justbridge       | Justus Brücke  |
| 70093644 | Justbridge       | Justus Brücke  |
| 70093693 | Justbridge       | Justus Brücke  |
| 70093739 | Justbridge       | Justus Brücke  |
| 80124540 | Wolf32at         | DerGraueWolf   |
+----------+------------------+----------------+
102 rows in set (1 min 3.93 sec)

Query too slow to run:

SELECT rev_id, rev_user_text, user_name
    -> FROM revision
    -> JOIN user
    -> ON user_id = rev_user
    -> AND user_name <> rev_user_text;

Related Objects
Search...

Event Timeline

Nemo_bis created this task.Sep 12 2015, 10:34 AM
Nemo_bis raised the priority of this task from to Needs Triage.
Nemo_bis updated the task description. (Show Details)
Nemo_bis added a project: Wikimedia-Site-requests.
Nemo_bis subscribed.
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptSep 12 2015, 10:34 AM
Nemo_bis renamed this task from Revisions where rev_user_text doesn't differs from user_name to Revisions where rev_user_text differs from user_name.Sep 12 2015, 10:35 AM
Nemo_bis added a parent task: T18660: Database table cleanup (tracking).
Nemo_bis set Security to None.
Scott subscribed.Sep 12 2015, 1:05 PM
Nemo_bis added subtasks: T47746: Partial rename for specific user on collabwiki, T24907: Inconsistent values of rev_user_text on pl.wikipedia due to incomplete renames (apparently).Sep 12 2015, 2:52 PM
Krenair added subscribers: Krenair, Legoktm.Nov 8 2015, 10:15 PM
Restricted Application added a subscriber: StudiesWorld. · View Herald TranscriptNov 8 2015, 10:15 PM
Akeron subscribed.Jun 16 2016, 9:27 AM
Restricted Application added a subscriber: JEumerus. · View Herald TranscriptJun 16 2016, 9:27 AM
Reedy changed the status of subtask T47746: Partial rename for specific user on collabwiki from Open to Stalled.Jul 31 2017, 11:54 PM
Reedy closed subtask T47746: Partial rename for specific user on collabwiki as Declined.Aug 1 2017, 12:03 AM
matej_suchanek mentioned this in T31757: Incomplete user renames (and other username discrepancies) (tracking).Aug 21 2019, 1:54 PM
matej_suchanek added a project: TestMe.Feb 5 2020, 8:49 AM
DannyS712 subscribed.Apr 24 2020, 1:50 AM

This may be moot, now that rev_actor is used to refer to an actor, instead of having rev_user and rev_user_text. Suggest closing an declined or invalid

DannyS712 closed this task as Invalid.Jun 10 2020, 11:36 PM
In T112369#6080066, @DannyS712 wrote:

This may be moot, now that rev_actor is used to refer to an actor, instead of having rev_user and rev_user_text. Suggest closing an declined or invalid

rev_user and rev_user_text are being removed in T238966: Apply updates for MCR, actor migration, and content migration, to production wikis.

matmarex closed subtask T24907: Inconsistent values of rev_user_text on pl.wikipedia due to incomplete renames (apparently) as Resolved.Mar 1 2021, 8:20 PM
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